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, 王雷 <[email protected]> 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 <[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 > > >
