0 Replies Latest reply on Jun 20, 2005 6:20 PM by ankit mehta

    mysql jboss connection problem

    ankit mehta Newbie

      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])