tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ULS Tech Support <tech_supp...@uls.com>
Subject Re: Tomcat 5.59 with jTDS, and SQL Server 2005
Date Tue, 20 Oct 2009 19:34:48 GMT


--------------------------------------------------
From: "Pid" <pid@pidster.com>
Sent: Tuesday, October 20, 2009 1:19 PM
To: "Tomcat Users List" <users@tomcat.apache.org>
Subject: Re: Tomcat 5.59 with jTDS, and SQL Server 2005



>
> 1. Is there a particular barrier to using the official MS driver?  (I am
> wincing as I ask).
http://jtds.sourceforge.net/index.html
As quoted:

Why use jTDS?

jTDS is free software. jTDS is released under the terms of the GNU LGPL, 
giving you not only the posibility to debug and tweak it to your own liking 
but also to use it in and distribute it with your free or commercial 
applications.

The other "free" choices, the JDBC-ODBC bridge and Microsoft's own JDBC 
driver are not actually free. If you encounter an issue with any of them you 
won't be able to fix it yourself and response times from both Microsoft and 
Sun are anything but short. Also, both of them lack functionality (the 
Microsoft driver implements JDBC 2.0, while the bridge is just a JDBC 1.0 
implementation) and have serious stability problems: the bridge crashes the 
JVM if the ODBC driver has any problem and Microsoft just has no intention 
of really supporting Java/JDBC.


>
> 2. What is the full stack trace you referred to earlier, does it have a
> separate root cause?
There was a stack trace, but that was because i hadn't captured the error 
correctly.
This is all i get now..

SQLException: java.sql.SQLException: No current row in the ResultSet.
SQLException Message: No current row in the ResultSet.

>
> 3. Is TWFreeTDS a drop-in replacement?
I`ve been using TWFreeTDS because it did support the multiple resultsets.
>
> 4. Are there any known bugs in jTDS for the combination of circumstances
> you're testing against?
None that i`m aware of.
>
> 5. Does the procedure definitely return data in each of the result sets?
When i used the twfreetds... and yes it does return data.. i re-ran the sql 
procedure to make sure...
I used twfreetds originally instead of jtds, the entire thing worked fine... 
But i wanted to implement the pooling with jtds (and probably can with 
twfreetds, but wanted an alternative).
>
>
> p
 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message