tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gregory, Carlton" <cgreg...@scn.spawar.navy.mil>
Subject RE: JDBC Pooling Clarification
Date Mon, 30 Jun 2003 14:54:08 GMT
Thank you Mike I appreciate the feedback on your experience.
Now you know I was going to ask.
How did you get around the "native" issue in poolman?
And do you know of another tool(s) that does not have this issue? (with
Oracle 8.1.7)
I would like to go "generic" but I  have not seen any third party
implementations of the
Oracle ConnectionCache (pooling physical connections).

-----Original Message-----
From: mike jackson [mailto:mjackson@cdi-hq.com]
Sent: Friday, June 27, 2003 5:05 PM
To: 'Tomcat Users List'
Subject: RE: JDBC Pooling Clarification


Personally I've had problems with Oracle's connection pooling (didn't
cleanup the connections before handing them out, the connects were
arriving dirty to begin with).  But, barring those issues, if you use a
"generic" connection pooling system, rather than the oracle one, it'll
make it easier to move from one database vendor to other in the future.
If you're going to do this you're going to want to find one that returns
"native" statements rather than wrapped statements, some oracle things
need the native oracle statement, and won't work with a wrapped
connection (the xsql tools come to mind).  Also, you're probably going
to want one that'll tell you what's going on in the pool.  Personally I
use poolman, which is missing the native statements issue, but its easy
to work around it.  Your mileage may vary, batteries not include, some
assembly required.

--mikej
-=------
mike jackson
mjackson@cdi-hq.com

> -----Original Message-----
> From: Gregory, Carlton [mailto:cgregory@scn.spawar.navy.mil]
> Sent: Friday, June 27, 2003 12:54 PM
> To: 'Tomcat Users List'
> Subject: RE: JDBC Pooling Clarification
> 
> thanks Yoav,
> 
> Oracle has some good example on there technet.oracle.com site but the
use
> 
> OC4J instead of Tomcat.
> 
> With the many docs I was coming across on the web it became confusing
as
> to
> what is a MUST and what is a CHOICE.
> 
> -----Original Message-----
> From: Shapira, Yoav [mailto:Yoav.Shapira@mpi.com]
> Sent: Friday, June 27, 2003 4:44 PM
> To: Tomcat Users List
> Subject: RE: JDBC Pooling Clarification
> 
> 
> 
> Howdy,
> 
> >         Question 1. This package is used REGARDLESS of what database
> you
> >are using?
> 
> You can configure what package is used by altering the factory setting
> in the <ResourceParams> section for your data source.
> 
> >         Question 2. If DBCP does not have to be used then I could
use
> >Oracles connection pooling AND connection cache?
> 
> By definition, yes.
> 
> >         Question 3. Is DBCP apart of JNDI?
> 
> No, it's a jakarta-commons project:
> http://jakarta.apache.org/commons/dbcp/
> 
> >         Question 4. Is it possible to have multiple users use the
SAME
> >connection pool, and in my respect with Oracle a connection cache?
> 
> Why not?  What's the difference between one or N users?  It all comes
> from your servlets anyways.
> 
> Yoav Shapira
> 
> 
> 
> This e-mail, including any attachments, is a confidential business
> communication, and may contain information that is confidential,
> proprietary
> and/or privileged.  This e-mail is intended only for the individual(s)
to
> whom it is addressed, and may not be saved, copied, printed, disclosed
or
> used by anyone else.  If you are not the(an) intended recipient,
please
> immediately delete this e-mail from your computer system and notify
the
> sender.  Thank you.
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message