You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ode.apache.org by José Antonio Sánchez <ge...@gmail.com> on 2007/10/26 17:07:26 UTC

Problem in Ode deployment

I've downloaded the war distribution of Ode and I've deployed it to
Tomcat 6.0 but when I start Tomcat I get the following output in the
log:

DEBUG - GeronimoLog.debug(66) | Loading properties
WARN - GeronimoLog.warn(92) | Config file
/local/jasanchez/apache-tomcat-6.0.13/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
'/local/jasanchez/apache-tomcat-6.0.13/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:4042)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
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
'/local/jasanchez/apache-tomcat-6.0.13/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:4042)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: SQL Exception: Failed to start database
'/local/jasanchez/apache-tomcat-6.0.13/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)
        ... 33 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:4042)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4348)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
        at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL
Exception: Failed to start database
'/local/jasanchez/apache-tomcat-6.0.13/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)
        ... 29 more
Caused by: SQL Exception: Failed to start database
'/local/jasanchez/apache-tomcat-6.0.13/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)
        ... 33 more
26-oct-2007 13:56:08 org.apache.coyote.http11.Http11Protocol start
INFO: Arrancando Coyote HTTP/1.1 en puerto http-9090
26-oct-2007 13:56:08 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
26-oct-2007 13:56:08 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/89  config=null
26-oct-2007 13:56:08 org.apache.catalina.startup.Catalina start
INFO: Server startup in 22987 ms

I can access the Ode site at http://localhost:9090/ode but I don't
know if it's going to work due to that message:

ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.

Is it normal to have that exception?
-- 
Saludos

José Antonio Sánchez

Re: Problem in Ode deployment

Posted by José Antonio Sánchez <ge...@gmail.com>.

I think that the problem was that I deleted the ode.war file once it
was uncompressed. I copied it back to the webapps directory and now it
starts normally.

On 10/29/07, Matthieu Riou <ma...@offthelip.org> wrote:
> Hi,
>
> Did you check that the directory
> /local/jasanchez/apache-tomcat-6.0.13/webapps/ode/WEB-INF/jpadb
> existed? Could you compare its content to the original WAR to make sure it's
> been unpacked correctly? Could be a simple unzip issue.
>
> Cheers,
> Matthieu
>
> On 10/29/07, José Antonio Sánchez <ge...@gmail.com> wrote:
> >
> > Well, the only thing different in my setup is that I'm using Tomcat
> > 6.0.13 and that it's listening on port 9090 instead of the standard
> > 8080 port. Could that be the problem?
> >
> > On 10/26/07, Alex Boisvert <bo...@intalio.com> wrote:
> > > I just tried the following,
> > >
> > > 1) unzip tomcat-6.0.14
> > > 2) copy ode-1.1.war under tomcat/webapps
> > > 3) start tomcat
> > >
> > > and it worked.   did you do something different?
> > >
> > > alex
> > >
> > >
> > > On 10/26/07, José Antonio Sánchez <ge...@gmail.com> wrote:
> > > >
> > > > I've downloaded the war distribution of Ode and I've deployed it to
> > > > Tomcat 6.0 but when I start Tomcat I get the following output in the
> > > > log:
> > > >
> > > > DEBUG - GeronimoLog.debug(66) | Loading properties
> > > > WARN - GeronimoLog.warn(92) | Config file
> > > > /local/jasanchez/apache-tomcat-6.0.13/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
> > > > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> > > >         at org.apache.catalina.core.StandardContext.start(
> > > > StandardContext.java:4348)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > > ContainerBase.java:791)
> > > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > > ContainerBase.java:771)
> > > >         at org.apache.catalina.core.StandardHost.addChild(
> > > > StandardHost.java:525)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > > HostConfig.java:920)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > > HostConfig.java:883)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > > HostConfig.java:492)
> > > >         at org.apache.catalina.startup.HostConfig.start(
> > HostConfig.java
> > > > :1138)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > > HostConfig.java:311)
> > > >         at
> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > > LifecycleSupport.java:117)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1053)
> > > >         at org.apache.catalina.core.StandardHost.start(
> > StandardHost.java
> > > > :719)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1045)
> > > >         at org.apache.catalina.core.StandardEngine.start(
> > > > StandardEngine.java:443)
> > > >         at org.apache.catalina.core.StandardService.start(
> > > > StandardService.java:516)
> > > >         at org.apache.catalina.core.StandardServer.start(
> > > > StandardServer.java:710)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> > :566)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > NativeMethodAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > DelegatingMethodAccessorImpl.java:25)
> > > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> > :288)
> > > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> > :413)
> > > > 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
> > > > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> > > >         at org.apache.catalina.core.StandardContext.start(
> > > > StandardContext.java:4348)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > > ContainerBase.java:791)
> > > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > > ContainerBase.java:771)
> > > >         at org.apache.catalina.core.StandardHost.addChild(
> > > > StandardHost.java:525)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > > HostConfig.java:920)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > > HostConfig.java:883)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > > HostConfig.java:492)
> > > >         at org.apache.catalina.startup.HostConfig.start(
> > HostConfig.java
> > > > :1138)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > > HostConfig.java:311)
> > > >         at
> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > > LifecycleSupport.java:117)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1053)
> > > >         at org.apache.catalina.core.StandardHost.start(
> > StandardHost.java
> > > > :719)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1045)
> > > >         at org.apache.catalina.core.StandardEngine.start(
> > > > StandardEngine.java:443)
> > > >         at org.apache.catalina.core.StandardService.start(
> > > > StandardService.java:516)
> > > >         at org.apache.catalina.core.StandardServer.start(
> > > > StandardServer.java:710)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> > :566)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > NativeMethodAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > DelegatingMethodAccessorImpl.java:25)
> > > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> > :288)
> > > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> > :413)
> > > > Caused by: SQL Exception: Failed to start database
> > > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > > >         ... 33 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:4042)
> > > >         at org.apache.catalina.core.StandardContext.start(
> > > > StandardContext.java:4348)
> > > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > > ContainerBase.java:791)
> > > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > > ContainerBase.java:771)
> > > >         at org.apache.catalina.core.StandardHost.addChild(
> > > > StandardHost.java:525)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > > HostConfig.java:920)
> > > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > > HostConfig.java:883)
> > > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > > HostConfig.java:492)
> > > >         at org.apache.catalina.startup.HostConfig.start(
> > HostConfig.java
> > > > :1138)
> > > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > > HostConfig.java:311)
> > > >         at
> > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > > LifecycleSupport.java:117)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1053)
> > > >         at org.apache.catalina.core.StandardHost.start(
> > StandardHost.java
> > > > :719)
> > > >         at org.apache.catalina.core.ContainerBase.start(
> > ContainerBase.java
> > > > :1045)
> > > >         at org.apache.catalina.core.StandardEngine.start(
> > > > StandardEngine.java:443)
> > > >         at org.apache.catalina.core.StandardService.start(
> > > > StandardService.java:516)
> > > >         at org.apache.catalina.core.StandardServer.start(
> > > > StandardServer.java:710)
> > > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> > :566)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > > NativeMethodAccessorImpl.java:39)
> > > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > > DelegatingMethodAccessorImpl.java:25)
> > > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> > :288)
> > > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> > :413)
> > > > Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL
> > > > Exception: Failed to start database
> > > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > > >         ... 29 more
> > > > Caused by: SQL Exception: Failed to start database
> > > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > > >         ... 33 more
> > > > 26-oct-2007 13:56:08 org.apache.coyote.http11.Http11Protocol start
> > > > INFO: Arrancando Coyote HTTP/1.1 en puerto http-9090
> > > > 26-oct-2007 13:56:08 org.apache.jk.common.ChannelSocket init
> > > > INFO: JK: ajp13 listening on /0.0.0.0:8009
> > > > 26-oct-2007 13:56:08 org.apache.jk.server.JkMain start
> > > > INFO: Jk running ID=0 time=0/89  config=null
> > > > 26-oct-2007 13:56:08 org.apache.catalina.startup.Catalina start
> > > > INFO: Server startup in 22987 ms
> > > >
> > > > I can access the Ode site at http://localhost:9090/ode but I don't
> > > > know if it's going to work due to that message:
> > > >
> > > > ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.
> > > >
> > > > Is it normal to have that exception?
> > > > --
> > > > Saludos
> > > >
> > > > José Antonio Sánchez
> > > >
> > >
> >
> >
> > --
> > Saludos
> >
> > José Antonio Sánchez
> >
>


-- 
Saludos

José Antonio Sánchez

Re: Problem in Ode deployment

Posted by Matthieu Riou <ma...@offthelip.org>.

Hi,

Did you check that the directory
/local/jasanchez/apache-tomcat-6.0.13/webapps/ode/WEB-INF/jpadb
existed? Could you compare its content to the original WAR to make sure it's
been unpacked correctly? Could be a simple unzip issue.

Cheers,
Matthieu

On 10/29/07, José Antonio Sánchez <ge...@gmail.com> wrote:
>
> Well, the only thing different in my setup is that I'm using Tomcat
> 6.0.13 and that it's listening on port 9090 instead of the standard
> 8080 port. Could that be the problem?
>
> On 10/26/07, Alex Boisvert <bo...@intalio.com> wrote:
> > I just tried the following,
> >
> > 1) unzip tomcat-6.0.14
> > 2) copy ode-1.1.war under tomcat/webapps
> > 3) start tomcat
> >
> > and it worked.   did you do something different?
> >
> > alex
> >
> >
> > On 10/26/07, José Antonio Sánchez <ge...@gmail.com> wrote:
> > >
> > > I've downloaded the war distribution of Ode and I've deployed it to
> > > Tomcat 6.0 but when I start Tomcat I get the following output in the
> > > log:
> > >
> > > DEBUG - GeronimoLog.debug(66) | Loading properties
> > > WARN - GeronimoLog.warn(92) | Config file
> > > /local/jasanchez/apache-tomcat-6.0.13/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
> > > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> > >         at org.apache.catalina.core.StandardContext.start(
> > > StandardContext.java:4348)
> > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > ContainerBase.java:791)
> > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > ContainerBase.java:771)
> > >         at org.apache.catalina.core.StandardHost.addChild(
> > > StandardHost.java:525)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > HostConfig.java:920)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > HostConfig.java:883)
> > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > HostConfig.java:492)
> > >         at org.apache.catalina.startup.HostConfig.start(
> HostConfig.java
> > > :1138)
> > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > HostConfig.java:311)
> > >         at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > LifecycleSupport.java:117)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1053)
> > >         at org.apache.catalina.core.StandardHost.start(
> StandardHost.java
> > > :719)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1045)
> > >         at org.apache.catalina.core.StandardEngine.start(
> > > StandardEngine.java:443)
> > >         at org.apache.catalina.core.StandardService.start(
> > > StandardService.java:516)
> > >         at org.apache.catalina.core.StandardServer.start(
> > > StandardServer.java:710)
> > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> :566)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> :288)
> > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> :413)
> > > 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
> > > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> > >         at org.apache.catalina.core.StandardContext.start(
> > > StandardContext.java:4348)
> > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > ContainerBase.java:791)
> > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > ContainerBase.java:771)
> > >         at org.apache.catalina.core.StandardHost.addChild(
> > > StandardHost.java:525)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > HostConfig.java:920)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > HostConfig.java:883)
> > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > HostConfig.java:492)
> > >         at org.apache.catalina.startup.HostConfig.start(
> HostConfig.java
> > > :1138)
> > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > HostConfig.java:311)
> > >         at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > LifecycleSupport.java:117)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1053)
> > >         at org.apache.catalina.core.StandardHost.start(
> StandardHost.java
> > > :719)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1045)
> > >         at org.apache.catalina.core.StandardEngine.start(
> > > StandardEngine.java:443)
> > >         at org.apache.catalina.core.StandardService.start(
> > > StandardService.java:516)
> > >         at org.apache.catalina.core.StandardServer.start(
> > > StandardServer.java:710)
> > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> :566)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> :288)
> > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> :413)
> > > Caused by: SQL Exception: Failed to start database
> > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > >         ... 33 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:4042)
> > >         at org.apache.catalina.core.StandardContext.start(
> > > StandardContext.java:4348)
> > >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > > ContainerBase.java:791)
> > >         at org.apache.catalina.core.ContainerBase.addChild(
> > > ContainerBase.java:771)
> > >         at org.apache.catalina.core.StandardHost.addChild(
> > > StandardHost.java:525)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > > HostConfig.java:920)
> > >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > > HostConfig.java:883)
> > >         at org.apache.catalina.startup.HostConfig.deployApps(
> > > HostConfig.java:492)
> > >         at org.apache.catalina.startup.HostConfig.start(
> HostConfig.java
> > > :1138)
> > >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > > HostConfig.java:311)
> > >         at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > > LifecycleSupport.java:117)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1053)
> > >         at org.apache.catalina.core.StandardHost.start(
> StandardHost.java
> > > :719)
> > >         at org.apache.catalina.core.ContainerBase.start(
> ContainerBase.java
> > > :1045)
> > >         at org.apache.catalina.core.StandardEngine.start(
> > > StandardEngine.java:443)
> > >         at org.apache.catalina.core.StandardService.start(
> > > StandardService.java:516)
> > >         at org.apache.catalina.core.StandardServer.start(
> > > StandardServer.java:710)
> > >         at org.apache.catalina.startup.Catalina.start(Catalina.java
> :566)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > > NativeMethodAccessorImpl.java:39)
> > >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > > DelegatingMethodAccessorImpl.java:25)
> > >         at java.lang.reflect.Method.invoke(Method.java:597)
> > >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java
> :288)
> > >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java
> :413)
> > > Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL
> > > Exception: Failed to start database
> > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > >         ... 29 more
> > > Caused by: SQL Exception: Failed to start database
> > > '/local/jasanchez/apache-tomcat-6.0.13/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)
> > >         ... 33 more
> > > 26-oct-2007 13:56:08 org.apache.coyote.http11.Http11Protocol start
> > > INFO: Arrancando Coyote HTTP/1.1 en puerto http-9090
> > > 26-oct-2007 13:56:08 org.apache.jk.common.ChannelSocket init
> > > INFO: JK: ajp13 listening on /0.0.0.0:8009
> > > 26-oct-2007 13:56:08 org.apache.jk.server.JkMain start
> > > INFO: Jk running ID=0 time=0/89  config=null
> > > 26-oct-2007 13:56:08 org.apache.catalina.startup.Catalina start
> > > INFO: Server startup in 22987 ms
> > >
> > > I can access the Ode site at http://localhost:9090/ode but I don't
> > > know if it's going to work due to that message:
> > >
> > > ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.
> > >
> > > Is it normal to have that exception?
> > > --
> > > Saludos
> > >
> > > José Antonio Sánchez
> > >
> >
>
>
> --
> Saludos
>
> José Antonio Sánchez
>

Re: Problem in Ode deployment

Posted by José Antonio Sánchez <ge...@gmail.com>.

Well, the only thing different in my setup is that I'm using Tomcat
6.0.13 and that it's listening on port 9090 instead of the standard
8080 port. Could that be the problem?

On 10/26/07, Alex Boisvert <bo...@intalio.com> wrote:
> I just tried the following,
>
> 1) unzip tomcat-6.0.14
> 2) copy ode-1.1.war under tomcat/webapps
> 3) start tomcat
>
> and it worked.   did you do something different?
>
> alex
>
>
> On 10/26/07, José Antonio Sánchez <ge...@gmail.com> wrote:
> >
> > I've downloaded the war distribution of Ode and I've deployed it to
> > Tomcat 6.0 but when I start Tomcat I get the following output in the
> > log:
> >
> > DEBUG - GeronimoLog.debug(66) | Loading properties
> > WARN - GeronimoLog.warn(92) | Config file
> > /local/jasanchez/apache-tomcat-6.0.13/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
> > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> >         at org.apache.catalina.core.StandardContext.start(
> > StandardContext.java:4348)
> >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > ContainerBase.java:791)
> >         at org.apache.catalina.core.ContainerBase.addChild(
> > ContainerBase.java:771)
> >         at org.apache.catalina.core.StandardHost.addChild(
> > StandardHost.java:525)
> >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > HostConfig.java:920)
> >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > HostConfig.java:883)
> >         at org.apache.catalina.startup.HostConfig.deployApps(
> > HostConfig.java:492)
> >         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> > :1138)
> >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > HostConfig.java:311)
> >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > LifecycleSupport.java:117)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1053)
> >         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> > :719)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1045)
> >         at org.apache.catalina.core.StandardEngine.start(
> > StandardEngine.java:443)
> >         at org.apache.catalina.core.StandardService.start(
> > StandardService.java:516)
> >         at org.apache.catalina.core.StandardServer.start(
> > StandardServer.java:710)
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:597)
> >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> > 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
> > '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
> >         at org.apache.catalina.core.StandardContext.start(
> > StandardContext.java:4348)
> >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > ContainerBase.java:791)
> >         at org.apache.catalina.core.ContainerBase.addChild(
> > ContainerBase.java:771)
> >         at org.apache.catalina.core.StandardHost.addChild(
> > StandardHost.java:525)
> >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > HostConfig.java:920)
> >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > HostConfig.java:883)
> >         at org.apache.catalina.startup.HostConfig.deployApps(
> > HostConfig.java:492)
> >         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> > :1138)
> >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > HostConfig.java:311)
> >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > LifecycleSupport.java:117)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1053)
> >         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> > :719)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1045)
> >         at org.apache.catalina.core.StandardEngine.start(
> > StandardEngine.java:443)
> >         at org.apache.catalina.core.StandardService.start(
> > StandardService.java:516)
> >         at org.apache.catalina.core.StandardServer.start(
> > StandardServer.java:710)
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:597)
> >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> > Caused by: SQL Exception: Failed to start database
> > '/local/jasanchez/apache-tomcat-6.0.13/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)
> >         ... 33 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:4042)
> >         at org.apache.catalina.core.StandardContext.start(
> > StandardContext.java:4348)
> >         at org.apache.catalina.core.ContainerBase.addChildInternal(
> > ContainerBase.java:791)
> >         at org.apache.catalina.core.ContainerBase.addChild(
> > ContainerBase.java:771)
> >         at org.apache.catalina.core.StandardHost.addChild(
> > StandardHost.java:525)
> >         at org.apache.catalina.startup.HostConfig.deployDirectory(
> > HostConfig.java:920)
> >         at org.apache.catalina.startup.HostConfig.deployDirectories(
> > HostConfig.java:883)
> >         at org.apache.catalina.startup.HostConfig.deployApps(
> > HostConfig.java:492)
> >         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> > :1138)
> >         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> > HostConfig.java:311)
> >         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> > LifecycleSupport.java:117)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1053)
> >         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> > :719)
> >         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> > :1045)
> >         at org.apache.catalina.core.StandardEngine.start(
> > StandardEngine.java:443)
> >         at org.apache.catalina.core.StandardService.start(
> > StandardService.java:516)
> >         at org.apache.catalina.core.StandardServer.start(
> > StandardServer.java:710)
> >         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
> > NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java:25)
> >         at java.lang.reflect.Method.invoke(Method.java:597)
> >         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> >         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> > Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL
> > Exception: Failed to start database
> > '/local/jasanchez/apache-tomcat-6.0.13/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)
> >         ... 29 more
> > Caused by: SQL Exception: Failed to start database
> > '/local/jasanchez/apache-tomcat-6.0.13/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)
> >         ... 33 more
> > 26-oct-2007 13:56:08 org.apache.coyote.http11.Http11Protocol start
> > INFO: Arrancando Coyote HTTP/1.1 en puerto http-9090
> > 26-oct-2007 13:56:08 org.apache.jk.common.ChannelSocket init
> > INFO: JK: ajp13 listening on /0.0.0.0:8009
> > 26-oct-2007 13:56:08 org.apache.jk.server.JkMain start
> > INFO: Jk running ID=0 time=0/89  config=null
> > 26-oct-2007 13:56:08 org.apache.catalina.startup.Catalina start
> > INFO: Server startup in 22987 ms
> >
> > I can access the Ode site at http://localhost:9090/ode but I don't
> > know if it's going to work due to that message:
> >
> > ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.
> >
> > Is it normal to have that exception?
> > --
> > Saludos
> >
> > José Antonio Sánchez
> >
>


-- 
Saludos

José Antonio Sánchez

Re: Problem in Ode deployment

Posted by Alex Boisvert <bo...@intalio.com>.

I just tried the following,

1) unzip tomcat-6.0.14
2) copy ode-1.1.war under tomcat/webapps
3) start tomcat

and it worked.   did you do something different?

alex


On 10/26/07, José Antonio Sánchez <ge...@gmail.com> wrote:
>
> I've downloaded the war distribution of Ode and I've deployed it to
> Tomcat 6.0 but when I start Tomcat I get the following output in the
> log:
>
> DEBUG - GeronimoLog.debug(66) | Loading properties
> WARN - GeronimoLog.warn(92) | Config file
> /local/jasanchez/apache-tomcat-6.0.13/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
> '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
>         at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:4348)
>         at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:791)
>         at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:771)
>         at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:525)
>         at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:920)
>         at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:883)
>         at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:492)
>         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :1138)
>         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:311)
>         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:117)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1053)
>         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :719)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1045)
>         at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:443)
>         at org.apache.catalina.core.StandardService.start(
> StandardService.java:516)
>         at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:710)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> 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
> '/local/jasanchez/apache-tomcat-6.0.13/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:4042)
>         at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:4348)
>         at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:791)
>         at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:771)
>         at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:525)
>         at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:920)
>         at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:883)
>         at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:492)
>         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :1138)
>         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:311)
>         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:117)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1053)
>         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :719)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1045)
>         at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:443)
>         at org.apache.catalina.core.StandardService.start(
> StandardService.java:516)
>         at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:710)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: SQL Exception: Failed to start database
> '/local/jasanchez/apache-tomcat-6.0.13/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)
>         ... 33 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:4042)
>         at org.apache.catalina.core.StandardContext.start(
> StandardContext.java:4348)
>         at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:791)
>         at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:771)
>         at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:525)
>         at org.apache.catalina.startup.HostConfig.deployDirectory(
> HostConfig.java:920)
>         at org.apache.catalina.startup.HostConfig.deployDirectories(
> HostConfig.java:883)
>         at org.apache.catalina.startup.HostConfig.deployApps(
> HostConfig.java:492)
>         at org.apache.catalina.startup.HostConfig.start(HostConfig.java
> :1138)
>         at org.apache.catalina.startup.HostConfig.lifecycleEvent(
> HostConfig.java:311)
>         at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(
> LifecycleSupport.java:117)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1053)
>         at org.apache.catalina.core.StandardHost.start(StandardHost.java
> :719)
>         at org.apache.catalina.core.ContainerBase.start(ContainerBase.java
> :1045)
>         at org.apache.catalina.core.StandardEngine.start(
> StandardEngine.java:443)
>         at org.apache.catalina.core.StandardService.start(
> StandardService.java:516)
>         at org.apache.catalina.core.StandardServer.start(
> StandardServer.java:710)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:597)
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: org.apache.ode.scheduler.simple.DatabaseException: SQL
> Exception: Failed to start database
> '/local/jasanchez/apache-tomcat-6.0.13/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)
>         ... 29 more
> Caused by: SQL Exception: Failed to start database
> '/local/jasanchez/apache-tomcat-6.0.13/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)
>         ... 33 more
> 26-oct-2007 13:56:08 org.apache.coyote.http11.Http11Protocol start
> INFO: Arrancando Coyote HTTP/1.1 en puerto http-9090
> 26-oct-2007 13:56:08 org.apache.jk.common.ChannelSocket init
> INFO: JK: ajp13 listening on /0.0.0.0:8009
> 26-oct-2007 13:56:08 org.apache.jk.server.JkMain start
> INFO: Jk running ID=0 time=0/89  config=null
> 26-oct-2007 13:56:08 org.apache.catalina.startup.Catalina start
> INFO: Server startup in 22987 ms
>
> I can access the Ode site at http://localhost:9090/ode but I don't
> know if it's going to work due to that message:
>
> ERROR - GeronimoLog.error(108) | ODE BPEL Server failed to start.
>
> Is it normal to have that exception?
> --
> Saludos
>
> José Antonio Sánchez
>