I'm not running jBoss so am not sure what requirements
it makes of the driver, but the freetds driver doesn't
support full jdbc 2 methods.  If I recall the Database
MetaData calls fail.  You'll also have trouble (I believe)
with arbitrarily large result sets (i.e. result sets 
larger than avail memory).  The better commercial drivers
provide full jdbc 2 compliance as well as a mechanism 
to either handle result sets in memory or using server
side cursors (which should be settable via hint jdbc2
method call).

Heitzso

-----Original Message-----
From: Amund Solvi Bremer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:38 PM
To: [EMAIL PROTECTED]
Subject: Re: Have you tried JDBC tag library with JDBC-ODBC bridge


Olivier Poppon wrote:

> Hi,
> 
> I don't think there is such thing...
> 
> You have to try www.inetsoftware.de
> They sell JDBC drivers(Type 4 - JDBC2.0 compliant) for sql server 
> 
> Olivier
> 
> -----Original Message-----
> From: Daljeet [mailto:[EMAIL PROTECTED]]
> Sent: 22 February 2001 14:11
> To: [EMAIL PROTECTED]
> Subject: Have you tried JDBC tag library with JDBC-ODBC bridge
> 
> 
> Hello
> 
> Has anybody tried the JDBC tag library with JDBC-ODBC bridge to connect
> to MS Sql Server. I am using it on Tomcat 3.2 and keep getting
> UnsupportedOperationException.
> 
> Does anybody know of a free JDBC driver for MS SqlServer 7.0

Sure, go to www.freetds.org and grab latest snapshot 
freetds_jdbc.snapshot.jar.2_0

Works wery well for me. Be sure to read the readme file.

cheers, a.



Reply via email to