Upgrading from JChem cartridge 3.1.5

Good afternoon

I am planning to upgrade the jchem cartridge in one of our databases from 3.1.5 to the latest version 5.5.1 and have the following questions.

Is the upgrade path going to work with such an old version?

Would it be better to un-install the cartridge and try a fresh install ?

In the second scenario, what steps would be required ?

I have identified all the indexes which would need to be re-created.

Which tables/user should be dropped ?

Let me know if you need more details

Thanks

Catherine

 

PS The current environment is

Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0    Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
JChem version in the database: 3.1.5
JChem version in the Tomcat server: 3.1.5
java.vm.version: 1.5.0_03-b07
java.vm.vendor: Sun Microsystems Inc.
Apache Tomcat/4.1.31
Major JDBC version in Tomcat: 10
Minor JDBC version in Tomcat: 2

 

 

Good morning Catherine,

The replacement of Tomcat with an RMI-based server as the JCC computation server in 5.0 makes the upgrade program of the 5.x versions basically incompatible with pre-5.0 versions, I am afraid. The least expensive method is probably to remove the old version and install the new one:

1. Make sure the settings of the 3.1.5 version JCC instance are recorded

1.1 Note the parameters with which indexes were created (you optimally have a script which was used to create the indexes)

1.2 Note the object privileges and roles granted to users of this JCC instance.

1.3 Note the default properties set in JC_IDX_PROPERTY tables (both in the JCC-owner's schema and in users' schema)

1.4 Note/back-up the settings in JCHEMPROPERTIES tables.

2. Back-up the relevant schemas

3. Remove the 3.1.5 version JCC instance

3.1 Drop the JChem indexes associated with this JCC instance

3.2 Drop the JCC-owner schema

3.3. Remove the jchemstreams web-application from Tomcat (or remove Tomcat altogether)

4. Install the new JCC version

5. Recreate indexes

6. Regrant privileges on indexes where applicable

Peter

Hi Peter

We have succesfully upgraded our test system

Thanks a lot for your help

Catherine