add JDBC driver for MySQL to apache-tomcat-5.5.17

Thread view:

banq_man - 07 Jul 2006 19:11 GMT

Dudes,
I have tried to add JDBC driver for MySQL to apache-tomcat-5.5.17,but
unsuccesfully.
In the materials i have read , it was adviced to add a Resource tag in
$CATALINA_HOME/conf/server.xml.
Database i want to access is called "staj "
So here are the tags i added to $CATALINA_HOME/conf/server.xml:

<Context path="/staj" docBase="staj"
debug="5" reloadable="true" crossContext="true">
</Context>

<Resource name="jdbc/staj" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="root" password=""
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql:///staj?autoReconnect=true"/>

Could you tell me where i get wrong!?

Reply to this Message

cp - 07 Jul 2006 23:00 GMT

Well if you follow java protocol with the JDBC driver (assuming MySQL
Connector/J) then your URL should be:
url="jdbc:mysql://staj?autoReconnect=true"/>

> Dudes,
> I have tried to add JDBC driver for MySQL to apache-tomcat-5.5.17,but
[quoted text clipped - 16 lines]
>
> Could you tell me where i get wrong!?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...