Hazem,
You need to check that the JDBC datasource name specified in the Tomcat
setup matches that specified in the juddi/WEB-INF/juddi.properties file
(this is all under the webapps folder of Tomcat). I had this exact same
issue.
First...
In juddi/WEB-INF/juddi.properties file you need:
# jUDDI DataSource to use
juddi.dataSource=java:comp/env/jdbc/juddiDB
Next...
In the file /WEB-INF/web.xml of the juddi context, there should be a
Resource configuration entry:
<resource-ref>
<description>jUDDI DataSource</description>
<res-ref-name>jdbc/juddiDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Finally...
This all then has to match the server.xml file under the Tomcat installation
folder in /conf.
<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"/>
<!-- the Resource element will
probably work better for
you on Tomcat 5+ if
you simply use a Resource only tag
with xml attributes
as opposed to the nested ResourceParams and
parameter elements
-->
<Resource name="jdbc/juddiDB" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="juddi" password="juddi"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/>
<!--
<Resource name="jdbc/juddi" auth="Container"
type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="juddi" password="juddi" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/juddi?autoReconnect=true"/>
-->
</Context>
Note in all of these 3 locations the use of the String "jdbc/juddiDB". I
believe the issue was that these are not consistent in the download package
and instructions.
Hope this helps...
Mark
-----Original Message-----
From: Hazem [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 11:39 PM
To: [email protected]
Subject: Deployed jUDDI with Tomcat
Greetings,
I've been struggling to deploy jUDDI with Tomcat. I have installed juddi on
a XP machine with MySQL5.0 and Tomcat 5.5.15. The database user, tables, and
security are all set up in MySQL and accessible with the 'juddi' userid.
However, I am unable to resolve the following error reported by
happyjuddi.jsp:
- DB connection was not aquired. (Cannot create JDBC driver of class '' for
connect URL 'null')
- SELECT COUNT(*) FROM PUBLISHER failed (null)
Any help on this guys?
Cheers,
Hazem
Dr. Hazem El Khatib
Assistant Professor of Information Systems Tel (++971) 3 7051827 Fax (++971)
3 7626309 [EMAIL PROTECTED] http://faculty.uaeu.ac.ae/~hazem College of
Information Technology United Arab Emirates University Al Ain, P.O.Box 17555
United Arab Emirates
