Would you please be more specific? which file you mean? I have created Oracel connection Pool as the stated way above, and it's worked fine, shall i put resource defeninitoin in context.xml only?
On 7/22/07, Pid <[EMAIL PROTECTED]> wrote:
You only need one resource definition. You only need a resource link definition if your resource is a global one. Simplify your configuration and then post the error message from the logs so we can see Tomcat says is wrong. p Mohammed Zabin wrote: > Hi All > > I have confiured oracle connection pool on my tomacat 6, and it worked > fine. > When i came to configure MySql, I repeated the same steps for Oracle > databse, with considering the specfication of MySql database. But it's > didn't work. Any Help please about configuring MySql, > I downloaded MySql connector from mysql website and place it in > CATALINA_HOME/lib directory, and i put the following: > > 1. in server.xml file: > <Resource name="jdbc/TestMySql" auth="Container" > type="javax.sql.DataSource" > maxActive="100" maxIdle="30" maxWait="10000" > username="*" password="*" driverClassName=" > com.mysql.jdbc.Driver" > > url="jdbc:mysql://localhost:3306/exam?autoReconnect=true"/> > > 2. in web.xml file > <resource-ref> > <description>Oracle Datasource example</description> > <res-ref-name>jdbc/TestMySql</res-ref-name> > <res-type>javax.sql.DataSource</res-type> > <res-auth>Container</res-auth> > </resource-ref> > > 3. in context.xml file (on server's context.xml file): > <Resource name="jdbc/TestMySql" auth="Container" > type="javax.sql.DataSource" > maxActive="100" maxIdle="30" maxWait="10000" > username="*" password="*" driverClassName=" > com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/exam"/> > > 4. in cotext.xml file ( In my web application's context.xml file): > <ResourceLink global="jdbc/TestMySql" name="jdbc/TestMySql" type=" > javax.sql.DataSource"/> > > Any Help please? >
