1 Reply Latest reply on Sep 17, 2008 2:33 PM by ryan chambers

    having problems with JBossESB db table auto creation

    ryan chambers Newbie

      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


      What is the name of the table that the persistence manager creates? I'd like to check it against what tables have already been created.

      Second of all:

      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)


      I use the management-ds.xml generated by the ant build task provided in the JBoss ESB package. It has the correct oracle settings. If nothing else, how can I get JBoss to output the SQL it's using, so I can at least see it and try to figure out what's going on?