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="10000" 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]