TOMCAT + DATASOURCE + CONNECTION POOL
Hi I have sucessfully created a JDBC connection using DataSource and JNDI on Tomcat5.x Is it necessary for create a Connection POOL using this DataSource based Jdbc Connnection or will the DataSource itself provides the Connection POOL for managing the JDBC connections on startup ,if so what needs to be done to increase the size of the connection pool size. with regards Karthik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: TOMCAT + DATASOURCE + CONNECTION POOL
Hey, I think though I'm not 100% When you declare the datasource in web.xml (or is Server.xml?) it creates a pool factory for you under the covers (I think using Jakarta DBCP). When you use JNDI look-up it asks the factory for a pool. You are then magically using a pool. You specify the pool details in the declaration in web.xml. Gluck. Karthik [EMAIL PROTECTED] wrote: Hi I have sucessfully created a JDBC connection using DataSource and JNDI on Tomcat5.x Is it necessary for create a Connection POOL using this DataSource based Jdbc Connnection or will the DataSource itself provides the Connection POOL for managing the JDBC connections on startup ,if so what needs to be done to increase the size of the connection pool size. with regards Karthik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - Play Santa's Celebrity Xmas Party, an exclusive game from Yahoo!
RE: TOMCAT + DATASOURCE + CONNECTION POOL
Hi Karthik, Context path=/servlets-examples debug=5 reloadable=true crossContext=true Resource name=jdbc/datasource_test auth=Container type=javax.sql.DataSource maxActive=100 maxIdle=30 maxWait=1 username=root password=admin driverClassName=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/test?autoReconnect=true/ /Context U must have done some thing like this while configuring the Datasource (in ur server.xml ) right? !-- maxActive: Maximum number of dB connections in pool. Make sure you configure your mysqld max_connections large enough to handle all of your db connections. Set to 0 for no limit. -- Hope this helps, Regards, Prathibha. -Original Message- From: Karthik [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 4:36 PM To: TOMCAT Subject: TOMCAT + DATASOURCE + CONNECTION POOL Hi I have sucessfully created a JDBC connection using DataSource and JNDI on Tomcat5.x Is it necessary for create a Connection POOL using this DataSource based Jdbc Connnection or will the DataSource itself provides the Connection POOL for managing the JDBC connections on startup ,if so what needs to be done to increase the size of the connection pool size. with regards Karthik - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]