Servoy Forum

Hi,

I'm trying to use the latest version of the jTDS driver.
So i have downloaded 1.3.0 from http://jtds.sourceforge.net/.
I have replaced the jtds.jar in 'application_server\drivers' with the new version.

But when i try to start the application server, i now get the following message:

Code: Select all

'could not find the main class net.sourceforge.jtds.jdbc.driver

Anyone knows what I'm doing wrong?

The driver should be "net.sourceforge.jtds.jdbc.Driver" (D uppercase), so you might want to check your server connection to make sure it's using the correct driver.

ptalbot wrote:The driver should be "net.sourceforge.jtds.jdbc.Driver" (D uppercase), so you might want to check your server connection to make sure it's using the correct driver.

In the errormessage, it is with Uppercase:

Code: Select all

repository:
com.servoy.j2db.persistence.RepositoryException: Error checking repository
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:1417)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:112)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:1492)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1066)
   at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:66)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
   at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: JDBC Driver 'net.sourceforge.jtds.jdbc.Driver' not found in classpath or drivers directory : java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver net.sourceforge.jtds.jdbc.Driver
   at com.servoy.j2db.server.Za.Zo.getDataSource(Zo.java:1486)
   at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:40)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:914)
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:2157)
   ... 10 more

It's odd...I looked inside the jar and the path is correct.
Try re-downloading it, perhaps it got corrupted somehow ?
Also make sure you only have 1 jtds driver in the drivers directory.

Hope this helps.

Thanks.

I have downloaded it again. (didn't rename it this time). But unfortunately it still gives the same error message.
Next I downloaded the 1.2.7 version, and this one works?

Jos,

The latest jtds driver seems to be compiled using J2SE 7.
I guess you can only use this driver when you are running java 7 in developer / application server.

Rob