two points:
1) in juddi-2.0rc5.jar, you get a create-database.sql under mysql directory. make sure you run that. I assume this is the case for version 2 and 3 beta 2) be careful with the prefix. there is a default prefix juddi.tablePrefix=JUDDI_ and this is in juddi.properties under the deployed war file. this prefix will be used when creating the tables. by default it is commented which means PUBLISHER table has to be created with no prefix. S. ________________________________ From: SARA1232007 <[email protected]> To: [email protected] Sent: Wednesday, June 17, 2009 2:01:39 AM Subject: Urgent: database for juddi is not created successfully Hi, I jhave deployed juddi on tomcat using following software: tomcat-5.5.23 + juddi-tomcat-2.0rc7 + MySql server 5.0 But it seems that the database for juddi is not created successfully. after I startup tomcat server, I open the url "http://localhost:8086/juddi/happyjuddi.jsp";, and get the information is as following: jUDDI DataSource Validation - No JNDI Context (null) - No 'null' DataSource Located(null) - DB connection was not acquired. (null) - SELECT COUNT(*) FROM PUBLISHER failed (null) It seems that the table for juddi publisher is not created. Could anyone tell me what's wrong? Also, what should I do if I want create the juddi inquery table? Thanks. Sara -- View this message in context: http://www.nabble.com/Urgent%3A-database-for-juddi-is-not-created-successfully-tp24065373p24065373.html Sent from the jUDDI - User mailing list archive at Nabble.com.
