Is this a direct cut and paste? If yes you are missing a > at the end of the
Logger. Otherwise watch the order of the elements in the Resource. It can
make a difference in some cases.
What are the errors?
What does the web.xml look like?
Doug
www.parsonstechnical.com
----- Original Message -----
From: "Masood Reyhanei Hamedani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 8:01 AM
Subject: Connection pooling
> Dear all
>
> I have a problem in using Connection Pooling with Tomcat 5.0.19, that is
working in version 4.1.18 so good.I am using that configuration with 5.0.19
but it doesn't work att all.
>
>
> I configure the ROOT.xml in this way:
>
> <?xml version='1.0' encoding='utf-8'?>
> <Context cachingAllowed="true" crossContext="true" debug="0"
docBase="/ROOT" path="" privileged="false" reloadable="true"
swallowOutput="false" useNaming="true">
> <Logger className="org.apache.catalina.logger.FileLogger" debug="0"
directory="logs" prefix="localhost_ROOT_log." suffix=".txt" timestamp="true"
verbosity="1"/
> <Resource auth="Container" name="jdbc/UKwebpooling" scope="Shareable"
type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/UKwebpooling">
> <parameter>
> <name>url</name>
>
<value>jdbc:mysql://localhost/university?autoReconnect=true</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>com.mysql.jdbc.Driver</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>myusername</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>mypassword</value>
> </parameter>
>
> <parameter>
> <name>maxIdle</name>
> <value>0</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>100</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>-1</value>
> </parameter>
> <parameter>
> <name>removeAbandoned</name>
> <value>true</value>
> </parameter>
>
> <parameter>
> <name>logAbandoned</name>
> <value>true</value>
> </parameter>
> <parameter>
> <name>removeAbandonedTimeout</name>
> <value>60</value>
> </parameter>
> <parameter>
> <name>factory</name>
>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> </ResourceParams>
> </Context>
>
> and create a java class such as this:
>
> package pooling;
> import javax.sql.*;
> import javax.naming.*;
> import java.sql.*;
> public class webPooling
> {
> Connection mySqlConnection = null;
> public webPooling() //Class constructor
> {
> }
> public void init() //Connection Creator
> {
> try
> {
> Context ctx = new InitialContext();
> if(ctx == null )
> throw new Exception("ERROR IN CONTEXT INITIALIZATION!!?");
> DataSource mySqlDatasource =
(DataSource)ctx.lookup("java:comp/env/jdbc/UKwebpooling");
> if(mySqlDatasource == null)
> throw new Exception ("ERROR IN DATASOURCE CREATING");
> else
> mySqlConnection = mySqlDatasource.getConnection();
> }//try
> catch(Exception e)
> {
> e.printStackTrace();
> }
> }
> public Connection getConnection()
> {
> return mySqlConnection;
> }
> }
>
> I guess the problem is in common-dbcp-1.1 and common-pool-1.1 .jar files
.
> Is there any one that know about this problem?
>
> With Thanks.
> Masood.
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Photos: High-quality 4x6 digital prints for 25�
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
