Followed your suggestion, but still not working.
Thnx,
--Kawthar
>>> [EMAIL PROTECTED] 18/03/2004 12:18:00 PM >>>
Kawthar,
Change:
<Resource auth="Container" description="JDBC Connection to
MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
type="javax.sql.DataSource"/>
<Resource name="jdbc/mySQLDatabase" auth="Container"
type="javax.sql.DataSource"/>
To:
<Resource auth="Container" description="JDBC Connection to
MySQL v4.0.18" name="jdbc/mySQLDatabase" scope="Shareable"
type="javax.sql.DataSource"/>
Should work either way, mine did, just cleaner and proper.
Note name is changed in second entry, added jdbc/ .
Doug
----- Original Message -----
From: "Parsons Technical Services" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, March 17, 2004 11:02 PM
Subject: Re: JDBC/mySQL problem.
> Kawthar,
>
> Try this context in place of yours.
>
> <Context path="/db" docBase ="ROOT" debug="9" reloadable="true">
> <Resource auth="Container" description="JDBC Connection to
> MySQL v4.0.18" name="mySQLDatabase" scope="Shareable"
> type="javax.sql.DataSource"/>
>
> <Resource name="jdbc/mySQLDatabase" auth="Container"
> type="javax.sql.DataSource"/>
>
> <ResourceParams name="jdbc/mySQLDatabase">
> <parameter>
> <name>factory</name>
>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>xxxx</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>xxxx</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>100</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>5</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
>
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <name>url</name>
> <value>jdbc:mysql://localhost:3306/ecpa?autoReconnect=true</value>
> </parameter>
> </ResourceParams>
>
> <Logger className="org.apache.catalina.logger.FileLogger"
> prefix="DBlog." suffix=".txt"
> timestamp="true"/>
> </Context>
>
> Don't forget to close the statement and the result set.
> I do mine in a finally block along with the conn.close() and each one
is
> wrapped in a try / catch.
>
> Make sure to restart Tomcat after you make changes to the
server.xml.
>
> Doug
>
>
>
>
---------------------------------------------------------------------
> 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]
Confidential information may be contained in this e-mail and any files transmitted
with it ('Message'). If you are not the addressee indicated in this Message (or
responsible for delivery of this Message to such person), you are hereby notified that
any dissemination, distribution, printing or copying of this Message or any part
thereof is strictly prohibited. In such a case, you should delete this Message
immediately and advise the sender by return e-mail. Opinions, conclusions and other
information in this Message that do not relate to the official business of Maxis shall
be understood as neither given nor endorsed by Maxis.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
