Return-Path: 
 <tomcat-user-return-116434-apmail-jakarta-tomcat-user-archive=jakarta.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org
Received: (qmail 65901 invoked from network); 1 Dec 2004 04:29:45 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 1 Dec 2004 04:29:45 -0000
Received: (qmail 48055 invoked by uid 500); 1 Dec 2004 04:29:19 -0000
Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org
Received: (qmail 48037 invoked by uid 500); 1 Dec 2004 04:29:19 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 48022 invoked by uid 99); 1 Dec 2004 04:29:18 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from 208.185.109.159.speedera.net (HELO mail.nikasolutions.net)
 (208.185.109.159)
  by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 30 Nov 2004 20:29:17 -0800
Received: from [192.168.0.2] (adsl-66-124-224-165.dsl.snfc21.pacbell.net
 [66.124.224.165])
	by mail.nikasolutions.net (Postfix) with ESMTP id 41D2270344
	for <tomcat-user@jakarta.apache.org>; Tue, 30 Nov 2004 20:11:01 -0800 (PST)
Subject: Re: Problems with datasource/DB Connection
From: parviz <dev@nikasolutions.net>
To: Tomcat Users List <tomcat-user@jakarta.apache.org>
In-Reply-To: <41AC3CA3.7050205@gmx.de>
References: <41AC3CA3.7050205@gmx.de>
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary="=-hyqF//9dWtrN3uO7t2/g"
Message-Id: <1101875421.4623.8.camel@localhost>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6 
Date: Tue, 30 Nov 2004 20:30:22 -0800
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

--=-hyqF//9dWtrN3uO7t2/g
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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!
>=20
> I tried to install jUDDI on my Tomcat some weird error appeared as the=20
> jUDDY Happyness page showed:
>=20
> + Got a JNDI Context!
> + Got a JDBC DataSource (dsname=3Djava: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)
>=20
> As this is the first time I work with tomcat I really don't know how to s=
olve this issue so I'd be really happy if one of you could
>  help.
>=20
>=20
> Thanx in advance!!!!
>=20
>=20
> ben
>=20
>=20
>=20
> My server XML looks as follows (it's entirely taken from the jUDDI deploy=
ment manual).
>=20
>=20
>=20
> <Context path=3D"/juddi" docBase=3D"juddi" debug=3D"5" reloadable=3D"true=
"=20
> crossContext=3D"true">
> <Logger className=3D"org.apache.catalina.logger.FileLogger"=20
> prefix=3D"localhost_juddiDB_log" suffix=3D".txt" timestamp=3D"true"/>
> <Resource name=3D"jdbc/juddiDB" auth=3D"Container" type=3D"javax.sql.Data=
Source"/>
>=20
> <ResourceParams name=3D"jdbc/juddiDB">
> <parameter>
> <name>factory</name>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
>=20
> <parameter>
> <name>maxActive</name>
> <value>100</value>
> </parameter>
>=20
> <parameter>
> <name>maxIdle</name>
> <value>30</value>
> </parameter>
> -
>     <parameter>
> <name>maxWait</name>
> <value>10000</value>
> </parameter>
>=20
> <parameter>
> <name>username</name>
> <value>juddi</value>
> </parameter>
>=20
> <parameter>
> <name>password</name>
> <value>123456</value>
> </parameter>
>=20
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
>=20
>=20
> <parameter>
> <name>url</name>
> <value>
> jdbc:mysql://localhost:3306/jUDDI?autoReconnect=3Dtrue
> </value>
> </parameter>
>=20
> <parameter>
> <name>validationQuery</name>
> <value>select count(*) from PUBLISHER</value>
> </parameter>
> </ResourceParams>
> </Context>
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>=20
>=20

--=-hyqF//9dWtrN3uO7t2/g
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBBrUjdZx3Cv1FMY2cRApqTAJ4gHfzo41MPci/0+vMiBqyEIZQxTwCbBotu
bO8a5dZyMDmV2OT+cX11vEY=
=4YjX
-----END PGP SIGNATURE-----

--=-hyqF//9dWtrN3uO7t2/g--