Thank you, what about testing the connection, i am afraid that the test code
is the reason:

Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/TestMySql");
Connection conn = ds.getConnection();

out.println("Connection Established");

what is "java:/comp/env"??

On 7/22/07, Pid <p@(protected):
>
> You can define either:
>
> a) Resource inside a Context - either in META-INF/context.xml or
> host/<appname>.xml
>
> b) ResourceLink inside a Context (as above) referring to a global
> Resource defined in server.xml.
>
> You're doing both at the moment, so one of them isn't being used,
> depending on where you placed the Resource in server.xml.
>
> Just defining a Resource inside your META-INF/context.xml and the
> corresponding WEB-INF/web.xml reference should be sufficient.
>
>
>
> p
>
>
>
>
> Mohammed Zabin wrote:
> > 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 <p@(protected):
> >>
> >> 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?
> >> >
> >>
> >>
> >>
> >
>
>
>