tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bEn Fries <Deve...@gmx.de>
Subject Problems with datasource/DB Connection
Date Tue, 30 Nov 2004 09:25:55 GMT
Hi!

I tried to install jUDDI on my Tomcat some weird error appeared as the 
jUDDY Happyness page showed:

+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)
- DB connection was not aquired. (Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver')
- SELECT COUNT(*) FROM PUBLISHER failed (null)

As this is the first time I work with tomcat I really don't know how to solve this issue so
I'd be really happy if one of you could
 help.


Thanx in advance!!!!


ben



My server XML looks as follows (it's entirely taken from the jUDDI deployment manual).



<Context path="/juddi" docBase="juddi" debug="5" reloadable="true" 
crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger" 
prefix="localhost_juddiDB_log" suffix=".txt" timestamp="true"/>
<Resource name="jdbc/juddiDB" auth="Container" type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/juddiDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>

<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>

<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
-
    <parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>

<parameter>
<name>username</name>
<value>juddi</value>
</parameter>

<parameter>
<name>password</name>
<value>123456</value>
</parameter>

<parameter>
<name>driverClassName</name>
<value>org.gjt.mm.mysql.Driver</value>
</parameter>


<parameter>
<name>url</name>
<value>
jdbc:mysql://localhost:3306/jUDDI?autoReconnect=true
</value>
</parameter>

<parameter>
<name>validationQuery</name>
<value>select count(*) from PUBLISHER</value>
</parameter>
</ResourceParams>
</Context>

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message