[
https://issues.apache.org/jira/browse/ODE-206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matthieu Riou updated ODE-206:
------------------------------
Fix Version/s: 1.3
> Derby fails to start 'Unable to determine database dialect'
> -----------------------------------------------------------
>
> Key: ODE-206
> URL: https://issues.apache.org/jira/browse/ODE-206
> Project: ODE
> Issue Type: Bug
> Components: Deployment
> Affects Versions: 1.1
> Environment: Windows XP, Tomcat 6.0.14, JDK 1.5.0_12-b04
> Reporter: Jan Sandholm
> Priority: Blocker
> Fix For: 1.3
>
>
> 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/[EMAIL
> PROTECTED]
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
