JChem Cartridge - Installation Problem

I have an installation problem with JChem Cartridge. I have followed the instructions in your Installation Guide. Things run fine until it reaches the "Create the SQL script used to register the JChem service URLs..." part.





The output from the failure is below:

Quote:

Create the SQL script used to register the JChem service URLs... C:\Program Files\ChemAxon\JChem\cartridge>"C:\j2sdk1.4.2_13\bin\java.exe" -cp ". ./lib/jchem.jar;C:\oracle\ora92\jdbc\lib\ojdbc14.jar" chemaxon.jchem.cartridge.i nstall.ChUrl register-urls jchem/jchem@histon http://localhost:8080/jchemstreams / java.io.IOException: Server returned HTTP response code: 401 for URL: http://loc alhost:8080/jchemstreams//misc at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLCon nection.java:794) at chemaxon.jchem.cartridge.jcservcli.JcsClientBase.getInputStream(JcsCl ientBase.java:126) at chemaxon.jchem.cartridge.jcservcli.BlockingClient.callService(Blockin gClient.java:163) at chemaxon.jchem.cartridge.jcservcli.BlockingClient.callService(Blockin gClient.java:38) at chemaxon.jchem.cartridge.install.ChUrl.checkEndPoint(ChUrl.java:117) at chemaxon.jchem.cartridge.install.ChUrl.getServiceEndPoints(ChUrl.java :60) at chemaxon.jchem.cartridge.install.ChUrl.main(ChUrl.java:183) SQL*Plus: Release 9.2.0.1.0 - Production on Thu Feb 8 16:01:15 2007 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SP2-0310: unable to open file "register-urls.sql"

I wondered if somebody might have an idea why it isn't installing?





Many thanks in advance....


FTM

1) Open a WEB browser on the host where Oracle is installed.


2) Point open the http://localhost:8080/jchemstreams URL


Can you see it without problem?





If not, either


a) JChemStreams is not properly installed or


b) some (security?) setting of Tomcat is interfering or


c) there is some network problem between the Tomcat and Oracle host.





Hm, I see now that "localhost" is in the URL -- implying that Oracle and Tomcat are on the same machine. In this case (c) can probably be ruled out.





P

pkovacs wrote:

1) Open a WEB browser on the host where Oracle is installed. 2) Point open the http://localhost:8080/jchemstreams URL Can you see it without problem? If not, either a) JChemStreams is not properly installed or b) some (security?) setting of Tomcat is interfering or c) there is some network problem between the Tomcat and Oracle host. Hm, I see now that "localhost" is in the URL -- implying that Oracle and Tomcat are on the same machine. In this case (c) can probably be ruled out. P

Hi P





Many thanks for the quick reply.





Actually I changed the port number to 8088 as I also have Oracle on the same machine. However http://localhost:8088/jchemstreams comes up OK.





All of the other parts of the installation script seem to work fine until it gets to the point listed above.

Quote:

Actually I changed the port number to 8088

You've also changed the URL parameter for the JChem Cartridge I presume.





Set socketTime to zero in <tomcat-home>/conf/server.xml and restart Tomcat. Then start the install script again.





P

pkovacs wrote:

Quote: Actually I changed the port number to 8088 You've also changed the URL parameter for the JChem Cartridge I presume. Set socketTime to zero in <tomcat-home>/conf/server.xml and restart Tomcat. Then start the install script again. P

I do not find a socketTime parameter in <tomcat-home>/conf/server.xml.





Please could you also let me know where I change the URL parameter for the JChem Cartridge? I guess that might be why I am getting the following error:

Quote:

:\Program Files\ChemAxon\JChem\cartridge>"C:\j2sdk1.4.2_13\bin\java.exe" -cp ". ./lib/jchem.jar;C:\oracle\ora92\jdbc\lib\ojdbc14.jar" chemaxon.jchem.cartridge.i nstall.ChUrl register-urls jchem/jchem@histon http://localhost:8080/jchemstreams / java.io.IOException: Server returned HTTP response code: 401 for URL: http://loc alhost:8080/jchemstreams//misc at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLCon nection.java:794) at chemaxon.jchem.cartridge.jcservcli.JcsClientBase.getInputStream(JcsCl ientBase.java:126) at chemaxon.jchem.cartridge.jcservcli.BlockingClient.callService(Blockin gClient.java:163) at chemaxon.jchem.cartridge.jcservcli.BlockingClient.callService(Blockin gClient.java:38) at chemaxon.jchem.cartridge.install.ChUrl.checkEndPoint(ChUrl.java:117) at chemaxon.jchem.cartridge.install.ChUrl.getServiceEndPoints(ChUrl.java :60) at chemaxon.jchem.cartridge.install.ChUrl.main(ChUrl.java:183)

Many thanks


FTM

Quote:

I do not find a socketTime parameter

Sorry, it is connectionTimeout.

Quote:

where I change the URL parameter for the JChem Cartridge?

By specifying the second parameter of the install script. Please, see the last paragraph of step 10. in http://www.chemaxon.com/jchem/doc/admin/cartridge.html#icart .





P

PS:


The connectionTimeout for Tomcat is probably not related to this problem, but you need to change it with Oracle 9i on Windows.





Also, I strongly suggest to upgrade to at least Oracle 9.2.0.6.

pkovacs wrote:

Quote: I do not find a socketTime parameter Sorry, it is connectionTimeout. Quote: where I change the URL parameter for the JChem Cartridge? By specifying the second parameter of the install script. Please, see the last paragraph of step 10. in http://www.chemaxon.com/jchem/doc/admin/cartridge.html#icart . P

Perfect! All working.


Many thanks for your help and have a good evening.





FTM