JChemStreams not available

User 0908c5ccdd

19-03-2008 11:11:02

Hi





We have upgraded servers and I am trying to install our test JChem database system on the new server. I have followed the same instructions as last time (which was successful) but now I have encountered an error. If I attempt to navigate to http://localhost:8088/jchemstreams I get a 404 Tomcat error saying "The requested resource (/jchemstreams/) is not available."





However, if I navigate to http://localhost:8088 then I see the Tomcat homepage working OK. Please might you have any idea as to what I should check to get JChemStreams to work properly? I have saved the jchemstreams.war file to my Tomcat webapps folder.





Many thanks...

ChemAxon aa7c50abf8

19-03-2008 19:52:45

Hi,





The browser which you are trying to point to http://localhost:8088/jchemstreams is running on the same host where Tomcat is running, correct?





If the browser is running on a different host, the host name "localhost" must be replaced by the name of the Tomcat host.





Thanks


Peter

User 0908c5ccdd

20-03-2008 08:54:39

Hi Peter





Yes, it's on the same host. Tomcat is working because http://localhost:8088 loads up the Tomcat home page.





I have copied the jchemstreams.war file to the Tomcat\webapps folder but I cannot get the JChemStreams page to load successfully.

ChemAxon aa7c50abf8

20-03-2008 10:14:58

I suggest doing the following:





1. Stop Tomcat;


2. Remove the jchemstreams directory in the webapps directory, if present (don't remove the jchemstreams.war file);


3. Remove all content from the <tomcat-home>/work directory;


4. Start Tomcat;


5. After a few seconds, check if your browser can find now the jchemstreams webapp.





Let me know if this helps.





Peter

User 0908c5ccdd

20-03-2008 10:37:35

Hi Peter





Thanks for getting back to me. I tried your suggestion and it JChemStreams still did not work. Then I copied the entire Tomcat folder from the original server into the new server. Now it works - not sure quite why it didn't work with the fresh install but fingers crossed things seem fine now.





many thanks...

User 0908c5ccdd

20-03-2008 12:43:14

Unfortunately I have run into another error. When running the install.bat script as below:





install.bat jchem/password@dbname http://localhost:8088/jchemstreams/





I get an error message part way through the script (although it finishes with a 'Sucessfully Completed' message):





Code:
C:\Program Files\ChemAxon\JChem\cartridge>"C:\Program Files\Java\jdk1.6.0_05\bin\java.exe" -cp "../lib/jchem.jar;D:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.


jar" chemaxon.jchem.cartridge.install.ChUrl register-urls jchem/jchem@sidtest "http://localhost:8088/jchemstreams/"


java.lang.NumberFormatException: For input string: "//localhost:8088/jchemstreams/"


        at java.lang.NumberFormatException.forInputString(NumberFormatException.


java:48)


        at java.lang.Integer.parseInt(Integer.java:447)


        at java.lang.Integer.parseInt(Integer.java:497)


        at chemaxon.jchem.cartridge.rmi.client.RmiServerDesc.<init>(RmiServerDes


c.java:28)


        at chemaxon.jchem.cartridge.install.ChUrl.checkEndPoint(ChUrl.java:120)


        at chemaxon.jchem.cartridge.install.ChUrl.getServiceEndPoints(ChUrl.java


:63)


        at chemaxon.jchem.cartridge.install.ChUrl.main(ChUrl.java:182)





SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 20 12:38:10 2008





Copyright (c) 1982, 2005, Oracle.  All rights reserved.








Connected to:


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production


With the Partitioning, OLAP and Data Mining options





PL/SQL procedure successfully completed.





Call completed.









Afterwards when I attempt to run the test.bat script I get the error:





Code:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 20 12:38:25 2008





Copyright (c) 1982, 2005, Oracle.  All rights reserved.








Connected to:


Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production


With the Partitioning, OLAP and Data Mining options





select jchem_core_pkg.getenvironment() from dual


       *


ERROR at line 1:


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


java.lang.NullPointerException


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


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








Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production


With the Partitioning, OLAP and Data Mining options






Tomcat is running successfully on the same machine as the database. I can connect to the jchem user from SQL*Plus without any problems and the dbms_java.grant_permission proc appeared to work OK. Any ideas would be greatly received... many thanks...

ChemAxon aa7c50abf8

20-03-2008 12:50:36

Which JChem Cartridge version are you trying to install?

User 0908c5ccdd

20-03-2008 12:59:07

I downloaded using the jchem-5_0_02-windows.exe link on your website.

ChemAxon aa7c50abf8

20-03-2008 13:05:59

Please, read the installation instructions. The installation procedure has changed starting with JChem Cartridge 5.0. Tomcat has been replaced by a command-line-startable application, and there is no jchemstreams.war at all.





Thanks


Peter