Microsoft JDBC driver support connection pooling out of the box

Hi,
I'm pretty new to JDBC so bare with me.
If using Jdbc outside of an application/J2ee server with the Microsoft
Jdbc driver what is teh correct procedure/code for ensuring
connections are pooled.
I've seen quite a few posts about this but to be honest mostly of
little use.
A code snippet would be great.
Some of my colleagues have saud you don't get pooling without a
application/J2ee server , is this correct?
Regards
John Harkin wrote:

> Hi,
> I'm pretty new to JDBC so bare with me.
> If using Jdbc outside of an application/J2ee server with the Microsoft
> Jdbc driver what is teh correct procedure/code for ensuring
> connections are pooled.
> I've seen quite a few posts about this but to be honest mostly of
> little use.
> A code snippet would be great.
> Some of my colleagues have saud you don't get pooling without a
> application/J2ee server , is this correct?
> Regards
Some drivers will offer an internal poooing feature, which can be
useful for long-running applications that use lots of connections,
opening and closing them frequently. If the app is short-lived,
or just opens connections and keeps them until it exits, then
pooling won't help.
In any case, the free MS driver has no internal connection pooling.
Joe Weinstein at BEA