--------------------------------------------------
From: "Pid" <p...@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-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
