Error connecting to Tomcat

Hi all,





when I run test.sql for Jchem cartridge I get the following error:





select jchem_core_pkg.getenvironment() from dual


*


ERROR at line 1:


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.Exception: There is a problem with the connection with Tomcat.


Please, check if Tomcat is running


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 108





Tomcat is up and running, as well as jchemstreams application.





I granted socket premissions with this command:





call dbms_java.grant_permission( 'XXXX', 'SYS:java.net.SocketPermission', 'xxx.xxx.xxx.xxxx:yyyy', 'connect,resolve' );





where XXXX is username, and xxx.xxx.xxx.xxxx:yyyy is ip and port to access tomcat.





Tomcat is in a different machine, but it can be seen from the database machine.





I don't have any problem with a database which is installed in the same machine as Tomcat is.





Thanks.

Found the solution.





I installed the cartridge without indicating the url for jchemstreams application so the installer assumed it was localhost.





Thanks.

You should be able to use JChem Cartridge with Oracle and Tomcat installed on different machines. The most probable source of the problem is that you misspelled the JChem Streams URL during installation. The best way to check this is to open on the Oracle machine a WEB-browser and point to the exact URL you specified during installation. If your Tomcat is running and is correctly configured on the other machine, you should see the JChem Streams WEB-page in your browser. If you can successfully call up the JChem Streams WEB-page with your browser on the Oracle machine, JChem Cartridge will also find it.