Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Moving from InstantDB to Oracle

0 views
Skip to first unread message

Iain Crawford

unread,
Sep 28, 2001, 3:02:56 PM9/28/01
to
Having been attempting move the admin database from instantdb to Oracle9i.

The Oracle Database is setup on a separate server from the WebSphere 3.5.4
Application - both are running
on SUN boxes.

Using both the DBUpgrade utility and doing the steps by hand I arrive at the
same point. When I startup the WebSphere Server it creates the database on
the Oracle Server and starts creating tables - in fact it manages to create
3 tables and then throws an exception which I have pasted below.

Does anybody know why it would fall over at this point and how to get past
it - we appear close - though this is an IBM product.

Thanks in advance

Iain Crawford
Lead Developer
Dataskill

Exception Generated:

01.09.28 09:07:19:594 PDT] 7f8847 DrAdminServer A SMTL0018I: DrAdmin
available on port 35,819
[01.09.28 09:07:19:705 PDT] 140356e AdminServer A ADMS0002I: Initializing
WebSphere Administration server
[01.09.28 09:07:19:886 PDT] 140356e DBMgr F Failed to create a data
source: java.sql.SQLException: ORA-00903: invalid table name

at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java)
at
com.ibm.ejs.cm.portability.PortabilityLayerImpl.createTable(PortabilityLayer
Impl.java:185)
at com.ibm.ejs.cm.pool.ConnectO.createTable(ConnectO.java:1029)
at
com.ibm.ejs.cm.proxy.ConnectionProxy.createTable(ConnectionProxy.java:128)
at com.ibm.ejs.cm.lock.TableLockLock.<init>(TableLockLock.java:26)
at
com.ibm.ejs.cm.portability.OraclePortabilityLayer.createLock(OraclePortabili
tyLayer.java:97)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:211)
at
com.ibm.ejs.sm.server.AdminServer.startConnectionMgr(AdminServer.java:1280)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime(AdminServer.java:1043)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:365)

FATAL Failed to create a data source: {0} java.sql.SQLException: ORA-00903:
invalid table name

at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Exception.java:42)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(Compiled Code)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(Compiled Code)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java)
at
com.ibm.ejs.cm.portability.PortabilityLayerImpl.createTable(PortabilityLayer
Impl.java:185)
at com.ibm.ejs.cm.pool.ConnectO.createTable(ConnectO.java:1029)
at
com.ibm.ejs.cm.proxy.ConnectionProxy.createTable(ConnectionProxy.java:128)
at com.ibm.ejs.cm.lock.TableLockLock.<init>(TableLockLock.java:26)
at
com.ibm.ejs.cm.portability.OraclePortabilityLayer.createLock(OraclePortabili
tyLayer.java:97)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:211)
at
com.ibm.ejs.sm.server.AdminServer.startConnectionMgr(AdminServer.java:1280)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime(AdminServer.java:1043)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:365)

java.lang.Throwable
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at com.ibm.ejs.ras.CBuffLogger.fatalEvent(Compiled Code)
at com.ibm.ejs.ras.Tr.fireTraceEvent(Compiled Code)
at com.ibm.ejs.ras.Tr.fatal(Tr.java:685)
at com.ibm.ejs.sm.util.db.DBMgr.initialize(DBMgr.java:218)
at
com.ibm.ejs.sm.server.AdminServer.startConnectionMgr(AdminServer.java:1280)
at
com.ibm.ejs.sm.server.AdminServer.initializeRuntime(AdminServer.java:1043)
at com.ibm.ejs.sm.server.AdminServer.main(AdminServer.java:365)
[01.09.28 09:08:57:920 PDT] 1b71514 DrAdminServer A SMTL0018I: DrAdmin
available on port 35,824
[01.09.28 09:08:58:060 PDT] 10fd5d9 AdminServer A ADMS0002I: Initializing
WebSphere Administration server
[01.09.28 09:08:58:155 PDT] 10fd5d9 DBMgr F Failed to create a data
source: java.sql.SQLException: ORA-00903: invalid table name


0 new messages