Forum Stats

  • 3,824,754 Users
  • 2,260,414 Discussions
  • 7,896,306 Comments

Discussions

Oracle Database Mobile Server JavaDB sync exception

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 [email protected] (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 [email protected] (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 [email protected] (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 [email protected] (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 [email protected] (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 [email protected] (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.

Answers