FreeTDS Development Group

[Jez Humble <jez AT whatsonwhen.com>]

> How is connection pooling established in JBoss using the freetds driver? 

In principle, for a J2EE container to support connection pooling, the JDBC
driver needs to comply with the JDBC 2.0 Optional Package (aka the JDBC 2.0
Standard Extension), which the FreeTDS JDBC driver doesn't. However, JBoss
claims to be able to emulate this behaviour: take a look at the
configuration files I just posted and the JBoss manual (which is actually
reasonably comprehensive).

I've got the system to work, but it's only a development setup and not a
production one. I haven't got round to load testing it yet, so I can't say
if the emulation's any good or not.

Cheers,

Jez Humble
Senior developer and network administrator
Whatsonwhen Ltd
http://whatsonwhen.com/