update jtds.jar

Questions and answers for all installation-related topics for Servoy products

update jtds.jar

Postby Janssenjos » Mon Apr 08, 2013 1:10 pm

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?
Jos Janssen
Software Developer
Axerrio
http://www.axerrio.com
Janssenjos
 
Posts: 148
Joined: Thu Aug 13, 2009 3:55 pm
Location: Bergen op Zoom

Re: update jtds.jar

Postby ptalbot » Mon Apr 08, 2013 1:37 pm

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.
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
https://www.servoyforge.net
Velocity rules! If you don't use it, you don't know what you're missing!
User avatar
ptalbot
 
Posts: 1654
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: update jtds.jar

Postby Janssenjos » Mon Apr 08, 2013 1:57 pm

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
Jos Janssen
Software Developer
Axerrio
http://www.axerrio.com
Janssenjos
 
Posts: 148
Joined: Thu Aug 13, 2009 3:55 pm
Location: Bergen op Zoom

Re: update jtds.jar

Postby ROCLASI » Mon Apr 08, 2013 2:06 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: update jtds.jar

Postby Janssenjos » Mon Apr 08, 2013 2:16 pm

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 Janssen
Software Developer
Axerrio
http://www.axerrio.com
Janssenjos
 
Posts: 148
Joined: Thu Aug 13, 2009 3:55 pm
Location: Bergen op Zoom

Re: update jtds.jar

Postby rgansevles » Mon Apr 15, 2013 10:57 am

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
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL


Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests