Re: Problems with datasource/DB Connection

[parviz <de...@nikasolutions.net>]

You need to download:


http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.0.16-ga.tar.gz/from/http://mysql.mirror.redwire.net/

from:

http://dev.mysql.com/downloads/connector/j/3.0.html

unzip that file somewhere and copy
mysql-connector-java-3.0.16-ga-bin.jar to your
tomcatdirectory/common/lib

restart your tomcat.

Everything should look good, if ACL for your mysql is right ( should be
if you followed the JUDDI install procecure correctly).

Parviz


On Tue, 2004-11-30 at 01:25, bEn Fries wrote:
> 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
> 
>