jchem-5_3_3-windows_with_jre connection to SQLServerDB error

User 2c6aa21beb

08-06-2010 14:02:47

Hi;


 After
installing jchem-5_3_3-windows_with_jre on a 64bit 2008 Windows server,


 I’m having
difficulties connecting to the SQlServer database which is on a 32bit machine.


I’m getting
driver not found


 Is there
something missing, or not configured for the basic install?


 


Please find
attached screenshots,


Karl

ChemAxon fa971619eb

08-06-2010 14:06:10

I moved this topic to the JChem forum where it should get answered.


Tim

User 2c6aa21beb

08-06-2010 14:21:01

I got it working by installing the driver sqljdbc_2.0.1803.100_enu.exe


 


Karl

User 2c6aa21beb

08-06-2010 15:33:42

I'm getting the following error when I try to connect to the web service


 


<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope"><soapenv:Body><soapenv:Fault><soapenv:Code><soapenv:Value>soapenv:Receiver</soapenv:Value></soapenv:Code><soapenv:Reason><soapenv:Text xml:lang="en-US">Class Not found : com.microsoft.jdbc.sqlserver.SQLServerDriver</soapenv:Text></soapenv:Reason><soapenv:Detail /></soapenv:Fault></soapenv:Body></soapenv:Envelope>


 


for the following soap message


<getConnectionAndTableInfo xmlns="http://webservice.jchem.chemaxon"><driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver><url>jdbc:sqlserver://********:1433;DatabaseName=dev971;SelectMethod=cursor</url><username>*****</username><password>*****</password><propertyTable>JChemProperties</propertyTable></getConnectionAndTableInfo>


 


I cant get the WebService to recognise the SQLServer jar file.


Where so I place this sqljdbc4.jar file so that Tomcat finds the jar. I have placed in all the lib directory and a few others without luck.


Any help will be appreciated,


 


Kind Regards


Karl


 


Note:


I have noticed that the oracle, mysql and postgres drivers are copied to the work directory, see attached screen shot, how is this done? and how can I add my driver to this list so that it is included in the tomcat work directory

ChemAxon e274e1bada

08-06-2010 16:17:30

Hi Karl,



thank you for the error report, we are investigating
the problem and fix it ASAP. Maybe the bundled driver is not applicable for your server. Could you specify your SQL server version?


Thanks, Edvard

User 2c6aa21beb

08-06-2010 16:28:17

Hi, its SQL Server 2005. The driver works fine for JCMAN because it created the tables perfectly,


 


Kind Regards


Karl

User 2c6aa21beb

08-06-2010 17:06:31

I removed the jars from the directories and did a system restart and now its finding the driver.


 


Thanks for your help but it seems to be sorted,