I installed mysql and then ran the .ddl mysql scripts .But when I try to run juddi happiness page it gives an output like below:
it cant find the publisher table. But if i execute the same query in mysql it works.
Could anyone help me please.
Thanx
Ankit Mehta
------------------------------------------------------------------------------------
jUDDI Version & Build Date
Version: 0.9rc3
Build Date: May 2, 2005 8:27:08 PM GMT+05:30
jUDDI Dependencies: Class Files & Libraries
Looking for: org.apache.juddi.IRegistry
+Found in: C:\jboss-4.0.2\server\all\deploy\juddi-service.sar\juddi.war\WEB-INF\lib\juddi.jar
Looking for: org.apache.axis.transport.http.AxisServlet
+Found in: C:\jboss-4.0.2\server\all\tmp\deploy\tmp39575axis.jar
Looking for: org.apache.commons.discovery.Resource
+Found in: C:\jboss-4.0.2\server\all\tmp\deploy\tmp39518commons-discovery.jar
Looking for: org.apache.commons.logging.Log
+Found in: C:\jboss-4.0.2\server\all\lib\commons-logging.jar
Looking for: org.apache.log4j.Layout
+Found in: C:\jboss-4.0.2\lib\log4j-boot.jar
Looking for: javax.xml.soap.SOAPMessage
+Found in: C:\jboss-4.0.2\server\all\lib\jboss-saaj.jar
Looking for: javax.xml.rpc.Service
+Found in: C:\jboss-4.0.2\server\all\lib\jboss-jaxrpc.jar
Looking for: com.ibm.wsdl.factory.WSDLFactoryImpl
+Found in: C:\jboss-4.0.2\server\all\tmp\deploy\tmp39520wsdl4j.jar
Looking for: javax.xml.parsers.SAXParserFactory
+Found in an unknown location
jUDDI Dependencies: Resource & Properties Files
Looking for: log4j.properties
+Found in: C:\jboss-4.0.2\server\all\deploy\juddi-service.sar\juddi.war\WEB-INF\classes\log4j.properties
jUDDI DataSource Validation //----------- error in this part---//
+ Got a JNDI Context!
+ Got a JDBC DataSource (dsname=java:/DefaultDS)
+ Got a JDBC Connection!
- SELECT count(*) FROM PUBLISHER failed (Table not found: PUBLISHER in statement [SELECT count(*) FROM PUBLISHER])