tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allistair Crossley" <Allistair.Cross...@QAS.com>
Subject RE: Problems with datasource/DB Connection
Date Tue, 30 Nov 2004 09:27:31 GMT
Can you supply Tomcat version. Also, have you put your mySQL drivers JAR into tomcat/common/lib?

Cheers, Allistair

> -----Original Message-----
> From: bEn Fries [mailto:Develin@gmx.de]
> Sent: 30 November 2004 09:26
> To: tomcat-user@jakarta.apache.org
> Subject: Problems with datasource/DB Connection
> 
> 
> 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
> 
> 


<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> 
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com">www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


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