I'm having problems with the oracle tables that JBoss ESB is trying to create. First of all, I get:
2008-09-10 14:51:00,369 DEBUG [org.jboss.messaging.core.jmx.JDBCPersistenceManagerService] Starting failed jboss.messaging:service=PersistenceManager java.sql.SQLException: ORA-00942: table or view does not exist
2008-09-10 14:51:41,158 INFO [org.jboss.internal.soa.esb.dependencies.DatabaseI nitializer] Initializing java:/ManagementDS from listed sql files 2008-09-10 14:51:41,175 DEBUG [org.jboss.internal.soa.esb.dependencies.DatabaseI nitializer] Starting failed jboss.esb:service=ManagementDatabaseInitializer java.sql.SQLException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112)
For the record, there are several files that have the requisite DDLs and create statements. I don't have the time to enumerate them here, but just search for sql files in your deploy directory. There is also a set of tables in the juddi.jar file.