RE: [cinjug-users] Seeking A Recommendation For A SQL Server 2000 jdbc Driver

["Broyles, Eric" <eric.broyles@xxxxxxx>]

John,

 

I haven't tried this in Tomcat specifically, but the open source jTDS Type 4 JDBC 2.1 driver has worked very well for me on JBoss and Resin.  This driver implements the full JDBC spec and is very fast (reportedly the fastest -- I haven't done my own tests to confirm).  You can find more at http://jtds.sourceforge.net/.

 

Eric

-----Original Message-----
From: John Olmstead [mailto:jolmstead2k@xxxxxxxxx]
Sent: Friday, June 11, 2004 3:10 PM
To: Houston Java Users Group; Louisville JUG; Cinjug
Subject: [cinjug-users] Seeking A Recommendation For A SQL Server 2000 jdbc Driver

Hello Folks;

 

I've run into a strange problem where my inet opta driver that is being used in Tomcat 4.1.24 container defined connection pool fails to return the correct number of rows from the result set of a procedure call.  It works correctly for about 20 calls , and then it returns about 10% of the rows that should be returned every call thereafter.

 

Is there a specific jdbc driver that will work with Tomcat datasources and stored procedure calls? 

 

Thanks;

 

John Olmstead

DBAdirect 

John Olmstead
jolmstead2k@xxxxxxxxx

---

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger