Re: Jdbc connection pooling without app/J2ee server

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 04/02/04 

Date: Fri, 02 Apr 2004 07:00:07 -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

Hi.
Some drivers will offer an internal pooling feature, which can be
useful for long-running applications that use lots of connections,
opening and closing them frequently. If the app's JVM process is
short-lived, or just opens connections and keeps them until it exits,
then pooling in the driver won't be able to help.
    In any case, the free MS driver has no internal connection pooling.
Joe Weinstein at BEA

Relevant Pages

  • Re: Microsoft JDBC driver support connection pooling out of the box
    ... > If using Jdbc outside of an application/J2ee server with the Microsoft ... useful for long-running applications that use lots of connections, ... pooling won't help. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Tomcat 5.5.9, correct directory for DB driver?
    ... Read, and re-read, the Tomcat classloading documentation. ... if you create the database connections as you should (i.e. ... by using the jdbc connection pooling support provided by Tomcat, ... >Cannot create JDBC driver of class '' for connect URL 'null' ...
    (comp.lang.java.programmer)
  • Re: Possible Type Conversion Defect
    ... Specifically we are breaking due to the lack of conversion from BIGINT to ... Microsoft SQL Server 2000 JDBC driver. ... I'll agree that the JDBC API specifications could be a bit more precise. ... a JDBC driver attempts to convert the underlying data to the Java ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Ora10 JDBC Driver with TIMESTAMP WITH LOCAL TIME ZONE
    ... >> Robert Klemme wrote: ... >>> driver is the newest driver for Ora 10.2. ... >>> JDBC driver I suspect it's a JDBC driver issue. ... > sets the session time zone of the connection and saves the session ...
    (comp.databases.oracle.misc)
  • Re: federate several datasources
    ... >>I want to federate several physical datasources, ... >>its JDBC driver. ... >>My idea is that this aggregator could be implemented as a special JDBC ... open-source databases such as MySQL, PostGreSQL, but this is outside the ...
    (comp.lang.java.databases)