Hey there Isaac, Been there done that before. Here is a post I sent to someone else a month or so ago who had similar issues ...see if this helps. Let me know.
Mark -----Original Message----- From: Mark Streit [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 8:32 PM To: '[email protected]' Subject: RE: Deployed jUDDI with Tomcat 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: iamundson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 3:36 PM To: [email protected] Subject: Problem setting up jUDDI, MySQL, Tomcat Hi all, Web services, data bases, and servers are not my area, but I'm trying to set up jUDDI as part of an exploratory research project, I'm running into problems, and I'm starting to pull my hair out. Here's what I'm using: jUDDI 0.9rc4 axis 1.2.1 OS: Windows XP Server: Tomcat 5.5 Database: MySQL Server 5.0 Here's my problem: I tried setting everything up to the best of my ability. When I validate on the jUDDI happiness page I get the following: jUDDI DataSource Validation + Got a JNDI Context! - No 'java:comp/env/jdbc/juddiDB' DataSource Located(Could not load resource factory class) - DB connection was not aquired. (null) - SELECT COUNT(*) FROM PUBLISHER failed (null) I removed the <Resource> element from server.xml and got this: jUDDI DataSource Validation + Got a JNDI Context! + Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB) - DB connection was not aquired. (Cannot create JDBC driver of class '' for connect URL 'null') - SELECT COUNT(*) FROM PUBLISHER failed (null) I noticed others have had this error, but all suggestions didn't help me. I've modified so many files at this point, I'm not even sure what is right and what is wrong. >From the command line I was able to execute the SELECT statement in MySQL, so I know the database is up and running. Can anyone help me? Thanks in advance, Isaac -- View this message in context: http://www.nabble.com/Problem-setting-up-jUDDI%2C-MySQL%2C-Tomcat-t1552251.h tml#a4216964 Sent from the jUDDI - User forum at Nabble.com.
