Migrate Oracle Database on WebSphere Commerce Developer 5.5 to 6.0 Technote
(FAQ)Migration of the Oracle database on WebSpherece Commerce Developer 5.5 to 6.0 with a javacore. Cause Oracle thick driver does not work in a cross platform environment.
Answer
A javacore similar to the following is produced when the MassLoaderCommand is executed from within WCIM:
4XESTACKTRACE at oracle.jdbc.driver.T2CStatement.t2cParseExecuteDescribe(Native Method)
4XESTACKTRACE at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:518)
4XESTACKTRACE at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
4XESTACKTRACE at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code))
4XESTACKTRACE at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
4XESTACKTRACE at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
4XESTACKTRACE at oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:262)
4XESTACKTRACE at com.ibm.wca.MassLoader.Validator.DefaultValidator.event(DefaultValidator.java:1193)
4XESTACKTRACE at com.ibm.wca.MassLoader.Events.MassLoaderEventHandler.notifyListners(MassLoaderEventHandler.java:205)
4XESTACKTRACE at com.ibm.wca.MassLoader.Parser.ParserHandler.startElement(ParserHandler.java:450)
To resolve this problem, configure MassLoader to use the Oracle thin driver as per the following:
- Open DbConnectionImplIDProperty.properties in <WCToolkit>/workspace/WC/lib/loader/oracle/dbconnect.zip
- Edit the ConnectStringID so that it looks similar to the following:
ConnectStringID = jdbc:oracle:thin:@<host>:<port>:
Replace <host> and <port> with the hostname and port number of your Oracle database.
Note that the ":" at the end of the ConnectStringID.- Restore the database and run the database migration wizard again.
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21269609