Yeah i meant it :) On Wed, Nov 23, 2011 at 6:56 PM, 王雷 <[email protected]> wrote:
> Got that sql, thanks, I will try. : ) > > On Wed, Nov 23, 2011 at 10:38 PM, 王雷 <[email protected]> wrote: > > > Hi, > > > > Do you mean the follwoing scripts which is available in the url > > http://ode.apache.org/war-deployment.data/ode_openjpa_mysql-1.3.2.sql? > > > > -- > > -- Licensed to the Apache Software Foundation (ASF) under one > > -- or more contributor license agreements. See the NOTICE file > > -- distributed with this work for additional information > > -- regarding copyright ownership. The ASF licenses this file > > -- to you under the Apache License, Version 2.0 (the > > -- "License"); you may not use this file except in compliance > > -- with the License. You may obtain a copy of the License at > > -- > > -- http://www.apache.org/licenses/LICENSE-2.0 > > -- > > -- Unless required by applicable law or agreed to in writing, > > -- software distributed under the License is distributed on an > > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > > -- KIND, either express or implied. See the License for the > > -- specific language governing permissions and limitations > > -- under the License. > > -- > > > > create table ODE_SCHEMA_VERSION (VERSION integer); > > insert into ODE_SCHEMA_VERSION values (5); > > CREATE TABLE ODE_ACTIVITY_RECOVERY (ID BIGINT NOT NULL, ACTIONS > VARCHAR(255), ACTIVITY_ID BIGINT, CHANNEL VARCHAR(255), DATE_TIME DATETIME, > DETAILS TEXT, INSTANCE_ID BIGINT, REASON VARCHAR(255), RETRIES INTEGER, > PRIMARY KEY (ID)) TYPE = innodb; > > CREATE TABLE ODE_CORRELATION_SET (CORRELATION_SET_ID BIGINT NOT NULL, > CORRELATION_KEY VARCHAR(255), NAME VARCHAR(255), SCOPE_ID BIGINT, PRIMARY > KEY (CORRELATION_SET_ID)) TYPE = innodb; > > CREATE TABLE ODE_CORRELATOR (CORRELATOR_ID BIGINT NOT NULL, > CORRELATOR_KEY VARCHAR(255), PROC_ID BIGINT, PRIMARY KEY (CORRELATOR_ID)) > TYPE = innodb; > > CREATE TABLE ODE_CORSET_PROP (ID BIGINT NOT NULL, CORRSET_ID BIGINT, > PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(255), PRIMARY KEY (ID)) TYPE = > innodb; > > CREATE TABLE ODE_EVENT (EVENT_ID BIGINT NOT NULL, DETAIL VARCHAR(255), > DATA BLOB, SCOPE_ID BIGINT, TSTAMP DATETIME, TYPE VARCHAR(255), INSTANCE_ID > BIGINT, PROCESS_ID BIGINT, PRIMARY KEY (EVENT_ID)) TYPE = innodb; > > CREATE TABLE ODE_FAULT (FAULT_ID BIGINT NOT NULL, ACTIVITY_ID INTEGER, > DATA TEXT, MESSAGE VARCHAR(4000), LINE_NUMBER INTEGER, NAME VARCHAR(255), > PRIMARY KEY (FAULT_ID)) TYPE = innodb; > > CREATE TABLE ODE_MESSAGE (MESSAGE_ID BIGINT NOT NULL, DATA TEXT, HEADER > TEXT, TYPE VARCHAR(255), MESSAGE_EXCHANGE_ID VARCHAR(255), PRIMARY KEY > (MESSAGE_ID)) TYPE = innodb; > > CREATE TABLE ODE_MESSAGE_EXCHANGE (MESSAGE_EXCHANGE_ID VARCHAR(255) NOT > NULL, CALLEE VARCHAR(255), CHANNEL VARCHAR(255), CORRELATION_ID > VARCHAR(255), CORRELATION_KEYS VARCHAR(255), CORRELATION_STATUS > VARCHAR(255), CREATE_TIME DATETIME, DIRECTION INTEGER, EPR TEXT, FAULT > VARCHAR(255), FAULT_EXPLANATION VARCHAR(255), OPERATION VARCHAR(255), > PARTNER_LINK_MODEL_ID INTEGER, PATTERN VARCHAR(255), PIPED_ID VARCHAR(255), > PORT_TYPE VARCHAR(255), PROPAGATE_TRANS BIT, STATUS VARCHAR(255), > SUBSCRIBER_COUNT INTEGER, PROCESS_INSTANCE_ID BIGINT, CORR_ID BIGINT, > PARTNER_LINK_ID BIGINT, PROCESS_ID BIGINT, REQUEST_MESSAGE_ID BIGINT, > RESPONSE_MESSAGE_ID BIGINT, PRIMARY KEY (MESSAGE_EXCHANGE_ID)) TYPE = > innodb; > > CREATE TABLE ODE_MESSAGE_ROUTE (MESSAGE_ROUTE_ID BIGINT NOT NULL, > CORRELATION_KEY VARCHAR(255), GROUP_ID VARCHAR(255), ROUTE_INDEX INTEGER, > PROCESS_INSTANCE_ID INTEGER, ROUTE_POLICY VARCHAR(16), CORR_ID BIGINT, > PRIMARY KEY (MESSAGE_ROUTE_ID)) TYPE = innodb; > > CREATE TABLE ODE_MEX_PROP (ID BIGINT NOT NULL, MEX_ID VARCHAR(255), > PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(2000), PRIMARY KEY (ID)) TYPE = > innodb; > > CREATE TABLE ODE_PARTNER_LINK (PARTNER_LINK_ID BIGINT NOT NULL, MY_EPR > TEXT, MY_ROLE_NAME VARCHAR(255), MY_ROLE_SERVICE_NAME VARCHAR(255), > MY_SESSION_ID VARCHAR(255), PARTNER_EPR TEXT, PARTNER_LINK_MODEL_ID > INTEGER, PARTNER_LINK_NAME VARCHAR(255), PARTNER_ROLE_NAME VARCHAR(255), > PARTNER_SESSION_ID VARCHAR(255), SCOPE_ID BIGINT, PRIMARY KEY > (PARTNER_LINK_ID)) TYPE = innodb; > > CREATE TABLE ODE_PROCESS (ID BIGINT NOT NULL, GUID VARCHAR(255), > PROCESS_ID VARCHAR(255), PROCESS_TYPE VARCHAR(255), VERSION BIGINT, PRIMARY > KEY (ID)) TYPE = innodb; > > CREATE TABLE ODE_PROCESS_INSTANCE (ID BIGINT NOT NULL, DATE_CREATED > DATETIME, EXECUTION_STATE BLOB, FAULT_ID BIGINT, LAST_ACTIVE_TIME DATETIME, > LAST_RECOVERY_DATE DATETIME, PREVIOUS_STATE SMALLINT, SEQUENCE BIGINT, > INSTANCE_STATE SMALLINT, INSTANTIATING_CORRELATOR_ID BIGINT, PROCESS_ID > BIGINT, ROOT_SCOPE_ID BIGINT, PRIMARY KEY (ID)) TYPE = innodb; > > CREATE TABLE ODE_SCOPE (SCOPE_ID BIGINT NOT NULL, MODEL_ID INTEGER, > SCOPE_NAME VARCHAR(255), SCOPE_STATE VARCHAR(255), PARENT_SCOPE_ID BIGINT, > PROCESS_INSTANCE_ID BIGINT, PRIMARY KEY (SCOPE_ID)) TYPE = innodb; > > CREATE TABLE ODE_XML_DATA (XML_DATA_ID BIGINT NOT NULL, DATA TEXT, > IS_SIMPLE_TYPE BIT, NAME VARCHAR(255), SCOPE_ID BIGINT, PRIMARY KEY > (XML_DATA_ID)) TYPE = innodb; > > CREATE TABLE ODE_XML_DATA_PROP (ID BIGINT NOT NULL, XML_DATA_ID BIGINT, > PROP_KEY VARCHAR(255), PROP_VALUE VARCHAR(255), PRIMARY KEY (ID)) TYPE = > innodb; > > CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID TINYINT NOT NULL, SEQUENCE_VALUE > BIGINT, PRIMARY KEY (ID)) TYPE = innodb; > > CREATE TABLE STORE_DU (NAME VARCHAR(255) NOT NULL, DEPLOYDT DATETIME, > DEPLOYER VARCHAR(255), DIR VARCHAR(255), PRIMARY KEY (NAME)) TYPE = innodb; > > CREATE TABLE STORE_PROCESS (PID VARCHAR(255) NOT NULL, STATE > VARCHAR(255), TYPE VARCHAR(255), VERSION BIGINT, DU VARCHAR(255), PRIMARY > KEY (PID)) TYPE = innodb; > > CREATE TABLE STORE_PROCESS_PROP (id BIGINT NOT NULL, PROP_KEY > VARCHAR(255), PROP_VAL VARCHAR(255), PRIMARY KEY (id)) TYPE = innodb; > > CREATE TABLE STORE_PROC_TO_PROP (ProcessConfDaoImpl_PID VARCHAR(255), > element_id BIGINT) TYPE = innodb; > > CREATE TABLE STORE_VERSIONS (id BIGINT NOT NULL, VERSION BIGINT, PRIMARY > KEY (id)) TYPE = innodb; > > CREATE INDEX I_D_CTVRY_INSTANCE ON ODE_ACTIVITY_RECOVERY (INSTANCE_ID); > > CREATE INDEX I_D_CR_ST_SCOPE ON ODE_CORRELATION_SET (SCOPE_ID); > > CREATE INDEX I_D_CRLTR_PROCESS ON ODE_CORRELATOR (PROC_ID); > > CREATE INDEX I_D_CRPRP_CORRSET ON ODE_CORSET_PROP (CORRSET_ID); > > CREATE INDEX I_OD_VENT_INSTANCE ON ODE_EVENT (INSTANCE_ID); > > CREATE INDEX I_OD_VENT_PROCESS ON ODE_EVENT (PROCESS_ID); > > CREATE INDEX I_OD_MSSG_MESSAGEEXCHANGE ON ODE_MESSAGE > (MESSAGE_EXCHANGE_ID); > > CREATE INDEX I_D_MSHNG_CORRELATOR ON ODE_MESSAGE_EXCHANGE (CORR_ID); > > CREATE INDEX I_D_MSHNG_PARTNERLINK ON ODE_MESSAGE_EXCHANGE > (PARTNER_LINK_ID); > > CREATE INDEX I_D_MSHNG_PROCESS ON ODE_MESSAGE_EXCHANGE (PROCESS_ID); > > CREATE INDEX I_D_MSHNG_PROCESSINST ON ODE_MESSAGE_EXCHANGE > (PROCESS_INSTANCE_ID); > > CREATE INDEX I_D_MSHNG_REQUEST ON ODE_MESSAGE_EXCHANGE > (REQUEST_MESSAGE_ID); > > CREATE INDEX I_D_MSHNG_RESPONSE ON ODE_MESSAGE_EXCHANGE > (RESPONSE_MESSAGE_ID); > > CREATE INDEX I_D_MS_RT_CORRELATOR ON ODE_MESSAGE_ROUTE (CORR_ID); > > CREATE INDEX I_D_MS_RT_PROCESSINST ON ODE_MESSAGE_ROUTE > (PROCESS_INSTANCE_ID); > > CREATE INDEX I_D_MXPRP_MEX ON ODE_MEX_PROP (MEX_ID); > > CREATE INDEX I_D_PRLNK_SCOPE ON ODE_PARTNER_LINK (SCOPE_ID); > > CREATE INDEX I_D_PRTNC_FAULT ON ODE_PROCESS_INSTANCE (FAULT_ID); > > CREATE INDEX I_D_PRTNC_INSTANTIATINGCORRELATOR ON ODE_PROCESS_INSTANCE > (INSTANTIATING_CORRELATOR_ID); > > CREATE INDEX I_D_PRTNC_PROCESS ON ODE_PROCESS_INSTANCE (PROCESS_ID); > > CREATE INDEX I_D_PRTNC_ROOTSCOPE ON ODE_PROCESS_INSTANCE (ROOT_SCOPE_ID); > > CREATE INDEX I_OD_SCOP_PARENTSCOPE ON ODE_SCOPE (PARENT_SCOPE_ID); > > CREATE INDEX I_OD_SCOP_PROCESSINSTANCE ON ODE_SCOPE > (PROCESS_INSTANCE_ID); > > CREATE INDEX I_D_XM_DT_SCOPE ON ODE_XML_DATA (SCOPE_ID); > > CREATE INDEX I_D_XMPRP_XMLDATA ON ODE_XML_DATA_PROP (XML_DATA_ID); > > CREATE INDEX I_STR_CSS_DU ON STORE_PROCESS (DU); > > CREATE INDEX I_STR_PRP_ELEMENT ON STORE_PROC_TO_PROP (element_id); > > CREATE INDEX I_STR_PRP_PROCESSCONFDAOIMPL_PID ON STORE_PROC_TO_PROP > (ProcessConfDaoImpl_PID); > > -- Apache ODE - SimpleScheduler Database Schema > > -- > > -- MySQL scripts by Maciej Szefler. > > -- > > -- > > DROP TABLE IF EXISTS ODE_JOB; > > > > CREATE TABLE ODE_JOB ( > > jobid CHAR(64) NOT NULL DEFAULT '', > > ts BIGINT NOT NULL DEFAULT 0, > > nodeid char(64) NULL, > > scheduled int NOT NULL DEFAULT 0, > > transacted int NOT NULL DEFAULT 0, > > details blob(4096) NULL, > > PRIMARY KEY(jobid), > > INDEX IDX_ODE_JOB_TS(ts), > > INDEX IDX_ODE_JOB_NODEID(nodeid) > > ) > > TYPE=InnoDB; > > > > COMMIT; > > > > > > > > > > On Wed, Nov 23, 2011 at 10:09 PM, abdulkadir yaman < > > [email protected]> wrote: > > > >> 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 > >> > > > >> > > >> > > > > >
