ODE
  1. ODE
  2. ODE-206

Derby fails to start 'Unable to determine database dialect'

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Blocker Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.1
    • Fix Version/s: 1.1.1
    • Component/s: Deployment
    • Labels:
      None
    • Environment:
      Windows XP, Tomcat 6.0.14, JDK 1.5.0_12-b04

      Description

      Here's what I've done:

      1. Installed Tomcat
      2. Downloaded ODE 1.1 (http://www.apache.org/dyn/closer.cgi/ode/apache-ode-war-1.1.zip)
      3. Dropped ode.war from the zip to webapps
      4. Started Tomcat

      Errors / messages:

      1) Selecting "Validate" returns:

      "Examining Version Service

      There was a problem in Axis2 version service , may be the service not available or some thing has gone wrong. But this does not mean system is not working ! Try to upload some other service and check to see whether it is working."

      2) Selecting "Administration" returns:

      "Internal server error"

      3) Log excerpt (stdout):

      DEBUG - GeronimoLog.debug(66) | Loading properties
      WARN - GeronimoLog.warn(92) | Config file C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF\conf\ode-axis2.properties not found, default values will be used.
      DEBUG - GeronimoLog.debug(66) | Initializing transaction manager
      DEBUG - GeronimoLog.debug(66) | Initializing transaction manager using org.apache.ode.il.EmbeddedGeronimoFactory
      DEBUG - GeronimoLog.debug(66) | Creating data source.
      DEBUG - GeronimoLog.debug(66) | Starting DAO.
      INFO - GeronimoLog.info(79) | Using DAO Connection Factory class org.apache.ode.dao.jpa.BPELDAOConnectionFactoryImpl.
      DEBUG - GeronimoLog.debug(66) | DAO started.
      DEBUG - GeronimoLog.debug(66) | Initializing BPEL process store.
      DEBUG - GeronimoLog.debug(66) | Initializing BPEL server.
      DEBUG - GeronimoLog.debug(66) | ODE initializing
      WARN - GeronimoLog.warn(96) | Unable to determine database dialect
      SQL Exception: Failed to start database 'C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF/jpadb', see the next exception for details.
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
      at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
      at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
      at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
      at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:96)
      at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:73)
      at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:66)
      at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
      at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
      at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:95)
      at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
      at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
      at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:61)
      at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
      at org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:254)
      at org.apache.ode.scheduler.simple.JdbcDelegate.guessDialect(JdbcDelegate.java:289)
      at org.apache.ode.scheduler.simple.JdbcDelegate.<init>(JdbcDelegate.java:78)
      at org.apache.ode.axis2.ODEServer.createScheduler(ODEServer.java:434)
      at org.apache.ode.axis2.ODEServer.initBpelServer(ODEServer.java:450)
      at org.apache.ode.axis2.ODEServer.init(ODEServer.java:155)
      at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:47)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4045)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4351)
      at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1237)
      at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:591)
      at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:128)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
      at java.lang.Thread.run(Thread.java:595)
      DEBUG - GeronimoLog.debug(66) | BPEL SERVER initializing
      DEBUG - GeronimoLog.debug(66) | BPEL SERVER starting.
      ERROR - GeronimoLog.error(108) | Error retrieving node list.
      org.apache.ode.scheduler.simple.DatabaseException: SQL Exception: Failed to start database 'C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF/jpadb', see the next exception for details.
      at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:118)
      at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:282)
      at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:281)
      at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
      at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:279)
      at org.apache.ode.bpel.engine.BpelServerImpl.start(BpelServerImpl.java:135)
      at org.apache.ode.axis2.ODEServer.init(ODEServer.java:163)
      at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:47)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4045)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4351)
      at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1237)
      at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:591)
      at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:128)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: SQL Exception: Failed to start database 'C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF/jpadb', see the next exception for details.
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
      at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
      at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
      at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
      at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:96)
      at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:73)
      at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:66)
      at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
      at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
      at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:87)
      at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
      at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
      at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:61)
      at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
      at org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:254)
      at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:105)
      ... 29 more
      ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.
      org.apache.ode.bpel.iapi.ContextException: Error retrieving node list.
      at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:289)
      at org.apache.ode.bpel.engine.BpelServerImpl.start(BpelServerImpl.java:135)
      at org.apache.ode.axis2.ODEServer.init(ODEServer.java:163)
      at org.apache.ode.axis2.hooks.ODEAxisServlet.init(ODEAxisServlet.java:47)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:981)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4045)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4351)
      at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1237)
      at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:591)
      at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:128)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL Exception: Failed to start database 'C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF/jpadb', see the next exception for details.
      at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:118)
      at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:282)
      at org.apache.ode.scheduler.simple.SimpleScheduler$3.call(SimpleScheduler.java:281)
      at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:173)
      at org.apache.ode.scheduler.simple.SimpleScheduler.start(SimpleScheduler.java:279)
      ... 25 more
      Caused by: SQL Exception: Failed to start database 'C:\Program Files\Apache\Tomcat 6.0\webapps\ode\WEB-INF/jpadb', see the next exception for details.
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
      at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
      at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
      at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
      at org.tranql.connector.jdbc.JDBCDriverMCF.getPhysicalConnection(JDBCDriverMCF.java:96)
      at org.tranql.connector.jdbc.JDBCDriverMCF.createManagedConnection(JDBCDriverMCF.java:73)
      at org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
      at org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:66)
      at org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
      at org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
      at org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:87)
      at org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
      at org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
      at org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:61)
      at org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
      at org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:254)
      at org.apache.ode.scheduler.simple.JdbcDelegate.getNodeIds(JdbcDelegate.java:105)
      ... 29 more

      I saw a similar problem discussed in the mailing list but it didn't help me:

      Jose Antonio Sanchez / Problem in Ode deployment / Fri, 26 Oct, 15:07
      http://mail-archives.apache.org/mod_mbox/ode-user/200710.mbox/ajax/%3ca15f6440710260807y4dcaa28cp1308e6c3a0f74582@mail.gmail.com%3e

        Activity

          People

          • Assignee:
            Matthieu Riou
            Reporter:
            Jan Sandholm
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development