Technote

(FAQ)

Migrate Oracle Database on WebSphere Commerce Developer 5.5 to 6.0

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