WCS7 Migration tips -

By default, the massload utility uses the Oracle thick JDBC client. To change the massload utility to use the Oracle thin JDBC client:

Note: The massload utility must be using the thick client during instance creation and the migration process. The bootstrap data gets processed during these processes.

•     Extract DbConnectionImplIDProperty.properties from the following file:
•         WC_installdir/lib/loader/oracle/dbconnect.zip
•         WebSphere Commerce Developer - WCDE_installdir\workspace\wc\lib\loader\dbconnect.zip
•     Open DbConnectionImplIDProperty.properties in a text editor.
•     Locate the following text: ConnectStringID = jdbc:oracle:oci8:@
•     Note: By default, the dbconnect.zip compressed file does not contain this text string. When the setdbtype utility script runs to switch the database type to an Oracle database, this compressed file is replaced. The compressed file is replaced with a version that contains the property information for Oracle databases. When this script runs, the dbconnect.zip compressed file with the Oracle information is copied from the following directory:
•         WC_installdir/wc.ear.ext/oracle/loader
•         WCDE_installdir\wc.modules\loader\oracle
•     Change the text to match the following text: ConnectStringID = jdbc:oracle:thin:@ If you are using the massload stand-alone utility use: jdbc:oracle:thin:@hostname:port:SID.
•     Save your changes.
•     Add the updated DbConnectionImplIDProperty.properties file to the WC_installdir/lib/loader/oracle/dbconnect.zip file. Overwrite the existing file in the archive.
•     Copy dbconnect.zip and paste it one directory level higher. For example, in this example, it would go in the WC_installdir/lib/loader folder.