change IP address for Jchem Base server

We have a question on jchem Base install.


When we install, the IP address of the machine where jchem Base is installed is hardcoded in all the database functions, procedures, types and packages. When we want


to change the IP address of the machine where jchem is installed, how do we change this information in all the above mentioned pl/sql modules. It is very cumbersome to search manually and replace. Do you have a standard procedure to do this task?





Thank you

Presumably, you mean the JChem Cartridge PL/SQL stored procedures and the IP address of the Tomcat machine. (JChem Base is the product with a Java API whereas JChem Cartridge is a product with a SQL interface.)





Starting with JChem version 3.1, the URL of JChem Streams (which includes the IP address of the machine hosting Tomcat) is stored in the jc_idx_property table of the cartridge owner's schema (the schema where JChem cartridge has been install). With these newer JChem versions, it is sufficient to replace the URL found in the table. With earlier versions the recommended method is to reinstall JChem Cartridge using a new URL for JChem Streams with the new IP address.





Peter

Basically in version 3.1 we just need to change only jc_idx_property table. Am i understood correctly?


In this case, how can we migrate from JChem version 3.0.13 (3.0.12) to 3.1 without uninstall?

Quote:

Basically in version 3.1 we just need to change only jc_idx_property table. Am i understood correctly?

Yes

Quote:

In this case, how can we migrate from JChem version 3.0.13 (3.0.12) to 3.1 without uninstall?

Currently, you have to uninstall JChem Cartridge with all JChem versions in order to upgrade to a newer JChem Cartridge version.





Peter