ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abdulkadir yaman <abdulkadirya...@gmail.com>
Subject Re: About Using Mysql Together with ODE
Date Wed, 23 Nov 2011 14:09:02 GMT
Have you imported the mysql.sql dump into the server which is inside the
ode zip distribution?

On Wed, Nov 23, 2011 at 5:52 PM, 王雷 <mail.lei.wang@gmail.com> wrote:

> 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