RE: JDBC Pooling Clarification
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:[EMAIL PROTECTED] 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 [EMAIL PROTECTED] > -Original Message- > From: Gregory, Carlton [mailto:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > 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 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 [EMAIL PROTECTED] > -Original Message- > From: Gregory, Carlton [mailto:[EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > 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 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED] 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 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
JDBC Pooling Clarification
After googling to countless pages on connection pooling I figured I should ask the list for some clarification. According to this doc: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-how to.html DBCP is what Tomcat uses to perform connection pooling. Question 1. This package is used REGARDLESS of what database you are using? Question 2. If DBCP does not have to be used then I could use Oracles connection pooling AND connection cache? Question 3. Is DBCP apart of JNDI? Question 4. Is it possible to have multiple users use the SAME connection pool, and in my respect with Oracle a connection cache? Im using Oracel 8.1.7.4.10 omcat 4.1.24 Apache 2.0.45 Win2k Pro JDK 1.4 Thank you for your time in advance Carlton G - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
