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:[EMAIL PROTECTED] > Sent: 30 November 2004 09:26 > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > <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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
