ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 王雷 <mail.lei.w...@gmail.com>
Subject Re: About Using Mysql Together with ODE
Date Wed, 23 Nov 2011 13:52:30 GMT
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 <sajhak@gmail.com>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, 王雷 <mail.lei.wang@gmail.com> 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 <
> > abdulkadiryaman@gmail.com
> > > 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, 王雷 <mail.lei.wang@gmail.com> wrote:
> > >
> > > > Hi,
> > > >
> > > >
> > > >    Is there any documents introducting about using other databases
> like
> > > > mysql together with ODE?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >    Best Regards
> > > >
> > > >
> > > >
> > > >           Lei Wang
> > > >
> > >
> >
>
>
>
> --
> Best Regards
> Sajith
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message