Re: Microsoft JDBC driver support connection pooling out of the box
From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 04/01/04
- Next message: John Harkin: "Jdbc connection pooling without app/J2ee server"
- Previous message: John Harkin: "Microsoft JDBC driver support connection pooling out of the box"
- In reply to: John Harkin: "Microsoft JDBC driver support connection pooling out of the box"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 01 Apr 2004 09:24:58 -0800 To: John Harkin <john.harkin@singularity.co.uk>
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
- Next message: John Harkin: "Jdbc connection pooling without app/J2ee server"
- Previous message: John Harkin: "Microsoft JDBC driver support connection pooling out of the box"
- In reply to: John Harkin: "Microsoft JDBC driver support connection pooling out of the box"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
