1 Reply Latest reply on Mar 24, 2009 12:39 PM by Tom Cunningham

    JBOSSESB not creating JUDDI tables on start up with MSSQL

    Vanitha Palanichamy Newbie

      Hi

      I am trying to run JBOSS ESB on MSSQL and I am running into this issue.
      Any help is appreciated.

      I found create_database.sql not in juddi-2.0rc5.aop.jar and I added the create scripts files to this jar as well as deploy\jbossesb.sar\juddi-sql


      2009-03-20 15:39:30,379 WARN [org.apache.juddi.datastore.jdbc.FindTModelByNameQuery] An Exception was encountered while attempting to close the Find TModel ResultSet: null
      java.lang.NullPointerException
      at org.apache.juddi.datastore.jdbc.FindTModelByNameQuery.select(FindTModelByNameQuery.java:94)
      at org.apache.juddi.datastore.jdbc.JDBCDataStore.findTModel(JDBCDataStore.java:1610)
      at org.apache.juddi.function.FindTModelFunction.execute(FindTModelFunction.java:165)
      at org.apache.juddi.registry.RegistryEngine.execute(RegistryEngine.java:234)
      at org.apache.juddi.registry.local.RequestHandler.run(RequestHandler.java:129)
      at java.lang.Thread.run(Thread.java:595)
      2009-03-20 15:39:30,379 ERROR [org.apache.juddi.function.FindTModelFunction] java.sql.SQLException: Invalid object name 'TMODEL'.
      2009-03-20 15:39:30,379 ERROR [org.apache.juddi.registry.local.RequestHandler] java.sql.SQLException: Invalid object name 'TMODEL'.
      2