Hi,
I have made changes according the following url:
http://ode.apache.org/war-deployment.html.
Then when I start the tomcat server, the following error occur, would
you please give some clue on how to fix this? Thanks.
Regards
Lei Wang
icselab@PAAS08:~/accounting/bin$ ./catalina.sh run
Using CATALINA_BASE: /home/icselab/accounting
Using CATALINA_HOME: /home/icselab/accounting
Using CATALINA_TMPDIR: /home/icselab/accounting/temp
Using JRE_HOME: /usr/lib/jvm/java-6-sun
Using CLASSPATH:
/home/icselab/accounting/bin/bootstrap.jar:/home/icselab/accounting/bin/tomcat-juli.jar
Nov 23, 2011 9:47:47 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal
performance in production environments was not found on the
java.library.path:
/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/i386/server:/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/i386:/usr/lib/jvm/java-6-sun-1.6.0.20/jre/../lib/i386:/home/icselab/stream/borealis/antlr/lib:/home/icselab/stream/borealis/nmstl/lib:/home/icselab/stream/borealis/xerces/lib:/home/icselab/stream/borealis/glpk/lib:/home/icselab/stream/borealis/gsl/lib:/home/icselab/stream/borealis/bdb/lib:/usr/java/packages/lib/i386:/lib:/usr/lib
Nov 23, 2011 9:47:47 PM org.apache.tomcat.util.digester.SetPropertiesRule
begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting
property 'debug' to '5' did not find a matching property.
Nov 23, 2011 9:47:47 PM org.apache.coyote.AbstractProtocolHandler init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Nov 23, 2011 9:47:47 PM org.apache.coyote.AbstractProtocolHandler init
INFO: Initializing ProtocolHandler ["ajp-bio-8009"]
Nov 23, 2011 9:47:47 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1156 ms
Nov 23, 2011 9:47:47 PM org.apache.catalina.core.StandardService
startInternal
INFO: Starting service Catalina
Nov 23, 2011 9:47:47 PM org.apache.catalina.core.StandardEngine
startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.14
21:47:53,504 INFO [ODEServer] Using DAO Connection Factory class
org.apache.ode.dao.jpa.BPELDAOConnectionFactoryImpl.
21:47:55,678 INFO [BpelServerImpl] BPEL Server Started.
21:47:55,684 INFO [SystemSchedulesConfig] SYSTEM CRON configuration:
/home/icselab/accounting/webapps/ode/WEB-INF/conf/schedules.xml
21:47:56,694 INFO [DeploymentPoller] Poller started.
21:47:56,694 INFO [ODEServer] Process deployment polling started on path
/home/icselab/accounting/webapps/ode/WEB-INF/processes.
21:47:56,694 INFO [ODEServer] ODE Service Engine has been started.
Nov 23, 2011 9:47:56 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory docs
Nov 23, 2011 9:47:57 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory host-manager
Nov 23, 2011 9:47:57 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory manager
Nov 23, 2011 9:47:57 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory ROOT
Nov 23, 2011 9:47:57 PM org.apache.catalina.startup.HostConfig
deployDirectory
INFO: Deploying web application directory examples
Nov 23, 2011 9:47:58 PM org.apache.coyote.AbstractProtocolHandler start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Nov 23, 2011 9:47:58 PM org.apache.catalina.connector.CoyoteAdapter service
SEVERE: An exception or error occurred in the container during the request
processing
java.lang.NullPointerException
at
org.apache.catalina.connector.CoyoteAdapter.postParseRequest(CoyoteAdapter.java:642)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:182)
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Nov 23, 2011 9:47:58 PM org.apache.coyote.AbstractProtocolHandler start
INFO: Starting ProtocolHandler ["ajp-bio-8009"]
Nov 23, 2011 9:47:58 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 10413 ms
21:47:59,647 ERROR [SimpleScheduler] Error loading immediate jobs from
database.
org.apache.ode.scheduler.simple.DatabaseException:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'instanceId' in 'field list'
at
org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:349)
at
org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:699)
at
org.apache.ode.scheduler.simple.SimpleScheduler$6.call(SimpleScheduler.java:697)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:284)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239)
at
org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:697)
at
org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:842)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:655)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Unknown column 'instanceId' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2284)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.ode.scheduler.simple.JdbcDelegate.dequeueImmediate(JdbcDelegate.java:286)
... 13 more
^CNov 23, 2011 9:48:00 PM org.apache.coyote.AbstractProtocolHandler pause
INFO: Pausing ProtocolHandler ["http-bio-8080"]
21:48:00,731 INFO [BpelServerImpl] BPEL Server Stopped.
21:48:00,737 ERROR [SimpleScheduler] Error loading immediate jobs from
database.
java.lang.NullPointerException
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:308)
at
org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:239)
at
org.apache.ode.scheduler.simple.SimpleScheduler.doLoadImmediate(SimpleScheduler.java:697)
at
org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:842)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:655)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
21:48:00,738 ERROR [SimpleScheduler] Error during SchedulerTask execution
java.lang.NullPointerException
at
org.apache.ode.scheduler.simple.SimpleScheduler$LoadImmediateTask.run(SimpleScheduler.java:847)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:658)
at
org.apache.ode.scheduler.simple.SimpleScheduler$5.call(SimpleScheduler.java:655)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
21:48:00,737 INFO [ODEServer] Shutdown completed.
Nov 23, 2011 9:48:01 PM org.apache.coyote.AbstractProtocolHandler pause
INFO: Pausing ProtocolHandler ["ajp-bio-8009"]
Nov 23, 2011 9:48:02 PM org.apache.catalina.core.StandardService
stopInternal
INFO: Stopping service Catalina
Nov 23, 2011 9:48:02 PM org.apache.catalina.loader.WebappClassLoader
clearReferencesJdbc
SEVERE: The web application [/ode] registered the JDBC driver
[org.apache.derby.jdbc.AutoloadedDriver] but failed to unregister it when
the web application was stopped. To prevent a memory leak, the JDBC Driver
has been forcibly unregistered.
Nov 23, 2011 9:48:02 PM org.apache.coyote.AbstractProtocolHandler stop
INFO: Stopping ProtocolHandler ["http-bio-8080"]
Nov 23, 2011 9:48:02 PM org.apache.coyote.AbstractProtocolHandler stop
INFO: Stopping ProtocolHandler ["ajp-bio-8009"]
icselab@PAAS08:~/accounting/bin$
On Wed, Nov 23, 2011 at 2:55 PM, Sajith Kariyawasam <[email protected]>wrote:
> Yes, its possible, the required configuration can be found in
> http://ode.apache.org/war-deployment.html
> section " Configuring ODE in Tomcat with a MySQL database "
>
> Regards
> Sajith
>
> On Wed, Nov 23, 2011 at 12:23 PM, 王雷 <[email protected]> wrote:
>
> > Hi,
> >
> >
> > By the way, is it possible to use war package version together with
> > mysql and where can I find some documents about that? Thanks.
> >
> >
> > Regards
> >
> > Lei Wang
> >
> > On Wed, Nov 23, 2011 at 2:45 PM, abdulkadir yaman <
> > [email protected]
> > > wrote:
> >
> > > You could follow
> > >
> > >
> >
> http://abdulkadiryaman.blogspot.com/2011/07/servicemix-43-ode-backed-by-mysql.html
> > >
> > >
> > >
> > > On Wed, Nov 23, 2011 at 10:40 AM, 王雷 <[email protected]> wrote:
> > >
> > > > Hi,
> > > >
> > > >
> > > > Is there any documents introducting about using other databases
> like
> > > > mysql together with ODE?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Best Regards
> > > >
> > > >
> > > >
> > > > Lei Wang
> > > >
> > >
> >
>
>
>
> --
> Best Regards
> Sajith
>
