I am not sure what you mean my 'displaytag' -- could explain that more? I am curious how that limits the resultset returned from the database.
As for the driver, here it is: http://www.inetsoftware.de/English/produkte/JDBC_Overview/ms.htm -Andrew -----Original Message----- From: Robert S. Sfeir [mailto:[EMAIL PROTECTED] Sent: Thursday, February 26, 2004 10:10 AM To: OJB Users List Subject: Re: OJB + MSSQL sp_executesql problem Clute, Andrew wrote: >We were using the jTDS driver for awhile to, with decent results -- >except that it is not JDBC 2.0 compliant. It states that it is, but it >is missing quite a few features -- mostly notably scrollable resultsets. >So, if you do any paging work at all, I have found the jTDS driver to >be orders of magnitude slower because it has to iterate though the >entire result set. > >We are now using the Merila driver from i-net, to much success. > > I do most of my paging stuff using displaytag, no need for scrollable resultsets. That said I would love to get a link to that driver to evaluate it. MSSQL is not my favorite DB, but hey people use it, and who am I to tell them not to. R --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
