Re: MySql Connector

[Pid]

You can define either:












p




Mohammed Zabin wrote:

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.

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.


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?
>

You only need a resource link definition if your resource is a global one.

smime.p7s
Description: S/MIME Cryptographic Signature