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 14:38:41 GMT
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 <
abdulkadiryaman@gmail.com> 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, 王雷 <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