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.