Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Mobile Server JavaDB sync exception

user10876847Feb 23 2020 — edited Feb 24 2020

we are trying to migrate old olite mobile server to new DMS by using JavaDB. got exceptions when use pure java sync as following:

it appears to me one internal meta table failed to create which is called  "OSE$ITR001"."OSE$TABLES"  which ITR001 was the mobile user.

but strange thing was I found the table "OSE$TABLES" in user schema which is "ITR001"

Did someone ever use opensync before? can help me out. thank you

24-02-2020 14:55:35.403    FINE T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Creating 'default'

24-02-2020 14:55:35.418    INFO T01 oracle.opensync.plugins.javadb.JavadbPlugin.getDBParameters(Unknown Source) Attempting to connect with user='ITR001' pwd='*'

24-02-2020 14:55:35.418  FINEST T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCFactory.<init>(Unknown Source) enter...

24-02-2020 14:55:35.653    INFO T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Creating connection to jdbc:derby:javadb\ITR00*

24-02-2020 14:55:36.684    INFO T01 oracle.opensync.plugins.javadb.JavadbDB.recover(Unknown Source) Initial boot of database 'default'

24-02-2020 14:55:36.684  FINEST T01 oracle.opensync.plugins.javadb.JavadbDB.recover(Unknown Source) loadSnapshots() failed with Schema 'OSE$ITR001' does not exist

24-02-2020 14:55:36.715    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.beginTransaction(Unknown Source) mode=EXCLUSIVE on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.715    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.executeUpdate(Unknown Source) ac:CREATE TABLE "OSE$TRSEQ" (PUBID INTEGER PRIMARY KEY, TRSEQ INTEGER) false on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.762    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.commit(Unknown Source) on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.762    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.beginTransaction(Unknown Source) mode=EXCLUSIVE on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.762    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.executeUpdate(Unknown Source) ac:CREATE TABLE "OSE$ITR001"."OSE$TABLES" (ID INTEGER PRIMARY KEY, PUBID INTEGER, NAME VARCHAR(32672), COLS VARCHAR(32672), ATTRS BLOB, FLAGS INTEGER, CREATE_CC BLOB, DROP_CC BLOB, DIRTY_STATE VARCHAR(32672)) false on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.809    FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.commit(Unknown Source) on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)

24-02-2020 14:55:36.950  SEVERE T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Exception in JavadbDB construction: java.sql.SQLSyntaxErrorException: Table/View 'OSE$ITR001.OSE$TRSEQ' does not exist.

Comments
Post Details