Re: JDBC Connection question

Which server do you use? Weblogic, Websphere, ... support connection pooling. (Caroline Jen) Oracle 9iAS Supports DataSources with pooling as well. (Wade Chandler) Thats not the issue. Whatever server i use, i'll have to deploy the application somewhere. My company does not have any servers,

Re: JDBC Connection question

You can only run one transaction per connection. Also, your DBMS may support a limited number of threads per connection. (Wade Chandler) Ok. So, using one connection for the whole application is out of question. My other alternatives are connection pooling and using one connection per user.

Re: JDBC Connection question

Which server do you use? Weblogic, Websphere, ... support connection pooling. --- Carlos Pereira [EMAIL PROTECTED] wrote: You can only run one transaction per connection. Also, your DBMS may support a limited number of threads per connection. (Wade Chandler) Ok. So, using one connection

RE: JDBC Connection question

Oracle 9iAS Supports DataSources with pooling as well. Wade -Original Message- From: Caroline Jen [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 2:25 PM To: Tomcat Users List Subject: Re: JDBC Connection question Which server do you use? Weblogic, Websphere, ... support

JDBC Connection question

Hi list, my application currently uses ONE connection object to communicate with the database. The connection is set with an initializer servlet (load_on_stratup=0), and all users use that connection to retrieve data. Is this the best approach, or should i create a connection per user? Why?

Re: JDBC Connection question

Please use a connection pool. For Instruction: http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html and http://www.mysql.com/articles/connection_pooling_with_connectorj.html --- Carlos Pereira [EMAIL PROTECTED] wrote: Hi list, my application currently uses ONE

RE: JDBC Connection question

and another is performing work, or threads change some non-protected(non thread safe) variables, then you'll have issues. Wade -Original Message- From: Carlos Pereira [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 12:46 PM To: Tomcat Users List Subject: JDBC Connection question Hi list

RE: JDBC Connection question

Best to use a connection pool. Look at the Data Sources in Tomcat. Wade -Original Message- From: Carlos Pereira [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 12:46 PM To: Tomcat Users List Subject: JDBC Connection question Hi list, my application currently uses ONE