JDBC configuration with JChem Cartridge

ChemAxon aa7c50abf8

12-10-2006 08:42:37

Quote:
Hi,





We have a Windows server that has two Oracle database instances installed.


And we would like to use JChem cartridge in both instances.


Tomcat is also installed in that same Windows server.





We're not sure how to configure JChem's JDBC connection properties.


It seems that our application doesn't work if we use the


jchem_core_pkg.use_password() with the individual user's password. So we're


using the global user credentials set up in the JDBC configuration.


And the JChem installation documentation says that this JDBC configuration


is saved in a file called .cartridge in the directory of the user who


started Tomcat.


We have one instance currently set up and working with the JChem cartridge.





But if we set up the other instance and set up another configuration (which


will have a different JDBC URL and different user and password), will it


save that information in the same .cartridge file and overwrite what we had


saved before which is used for the first instance.


How can we make the two instances work on the same server?


You need to setup a new Tomcat instance and start it with a different user identity (different from the first one). Different users will then have their cartrdige configurations in different places.