connecting to JChem

Hello,


I am trying to connect to Jchem through JChem manager,


my serveur runs SQL server 2000


Here is the parameter I found in a web.config file of the application that uses Jchem :


dd key="ClassPath" value="D:\A3IS\BackOfficeComposants\CYTOMICS\CytoGest\ProcessAssemblies\CytoGestMarvinJChem.jar;C:\Program Files\ChemAxon\MarvinBeans\lib\MarvinBeans.jar;C:\Program Files\ChemAxon\JChem\lib\jchem.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\JNBridge\JNBridgePro v3.1\jnbcore\jnbcore.jar;C:\Program Files\JNBridge\JNBridgePro v3.1\jnbcore\bcel-5.1-jnbridge.jar" />





<!-- Paramètres de connection pour Java -->


<add key="JDBCDriverString" value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />


<add key="DataBaseURL" value="jdbc:microsoft:sqlserver://LOCALHOST:1433;DatabaseName=CYTO;SelectMethod=cursor" />


<add key="DataBaseLoginName" value="CYTO" />


<add key="DataBasePassword" value="PWD" />


<add key="MoleculeTableName" value="JChemTable" />








then to connect I used :


as JDBC server: com.microsoft.jdbc.sqlserver.SQLServerDriver


as URL : jdbc:microsoft:sqlserver://LOCALHOST:1433;DatabaseName=CYTO;SelectMethod=cursor or jdbc:sqlserver://LOCALHOST:1433;DatabaseName=CYTO;SelectMethod=cursor as previouolsy adviced by Szilard Dorant





and it does not work, and I get the following error message :


java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver


at java.net.URLClassLoader$1.run(Unknown Source)


at java.security.AccessController.doPrivileged(Native Method)


at java.net.URLClassLoader.findClass(Unknown Source)


at java.lang.ClassLoader.loadClass(Unknown Source)


at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)


at java.lang.ClassLoader.loadClass(Unknown Source)


at java.lang.ClassLoader.loadClassInternal(Unknown Source)


at java.lang.Class.forName0(Native Method)


at java.lang.Class.forName(Unknown Source)


at chemaxon.util.ConnectionHandler.setConnected(ConnectionHandler.java:205)


at chemaxon.util.ConnectionHandler.connect(ConnectionHandler.java:246)


at chemaxon.jchem.gui.Connector.go(Connector.java:63)


at chemaxon.jchem.gui.JChemFrame.connect(JChemFrame.java:561)


at chemaxon.jchem.JChemManager.init(JChemManager.java:89)


at chemaxon.jchem.JChemManager.main(JChemManager.java:106)





coul you please let me know how to do it correctly


thanks in advance,


Regards





Bruno Sargueil


cytomics systems

I have moved this topic to 'Structure search and chemical database' forum.


We will answer soon.

Hi Bruno,





The JDBC driver files (3 files in this case: msbase.jar, mssqlserver.jar and msutil.jar) should be listed in your CLASSPATH system environment variable.


Please see the installation instructions on how to set it:





http://www.chemaxon.com/jchem/doc/admin/prepscripts.html





This is unrelated, but there is a possible problem with your server configuration too:

Quote:

C:\Program Files\ChemAxon\MarvinBeans\lib\MarvinBeans.jar;C:\Program Files\ChemAxon\JChem\lib\jchem.jar;

Only either MarvinBeans.jar OR jchem.jar should be present in the classpath, but not both. Otherwise this can lead to strange problems. Please not that jchem.jar also contains all MarvinBeans class files.





Best regards,





Szilard