inal Message-
> From: Norman Jefferies [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 07, 2000 8:22 PM
> To: Orion-Interest
> Subject: Re: SQL Server DB Pooling
>
>
> Since I'm not using your exact driver, I've used Webogic for SQL Sever7,
and
>
www.redoakcreek.com
-Original Message-
From: Norman Jefferies [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 8:22 PM
To: Orion-Interest
Subject: Re: SQL Server DB Pooling
Since I'm not using your exact driver, I've used Webogic for SQL Sever7, and
others for Sybase and Inf
the above
databases. Hummm, what am I missing.
-Original Message-
From: dan moy <[EMAIL PROTECTED]>
To: Orion-Interest <[EMAIL PROTECTED]>
Date: Thursday, September 07, 2000 6:08 PM
Subject: Re: SQL Server DB Pooling
>Norm, I tried using a simpler name but I am still having p
on-Interest <[EMAIL PROTECTED]>
> Date: Thursday, September 07, 2000 2:51 PM
> Subject: Re: SQL Server DB Pooling
>
>
> >Norman,
> >Thanks for your response, but I did try all of the other JNDI locations
as
> >specified by my data-sources.xml but there was
est <[EMAIL PROTECTED]>
Date: Thursday, September 07, 2000 2:51 PM
Subject: Re: SQL Server DB Pooling
>Norman,
>Thanks for your response, but I did try all of the other JNDI locations as
>specified by my data-sources.xml but there was only one I could get to
work;
>the default locatio
data-sources.xml looks like:
-Original Message-
From: dan moy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 07, 2000 1:25 PM
To: Orion-Interest
Subject: Re: SQL Server DB Pooling
Norman,
Thanks for your response, but I did try all of the other JNDI locations as
specified by my
Norman,
Thanks for your response, but I did try all of the other JNDI locations as
specified by my data-sources.xml but there was only one I could get to work;
the default location "jdbc/MyCoreDS". All other when tried return a class
cast exception error.
Any other ideas?
Thanks,
Dan
On Thu, 7
Orion already pools the connection for you. Just reference the pooled
datasouce:
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup( "jdbc/pooled/MypooledDS" );
Connection conn = ds.getConnection();
This will get you a connection from the pool, and return it when you clos
