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 >> > > >> > >> > >
