JBOSSESB not creating JUDDI tables on start up with MSSQL

[vanithap]

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

[tcunning]

Make sure you edit jbossesb.sar/esb.juddi.xml and point to the correct location of your create_database.sql file - it may be pointing towards one for another database.