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:56:08 GMT
Got that sql, thanks, I will try. : )

On Wed, Nov 23, 2011 at 10:38 PM, 王雷 <mail.lei.wang@gmail.com> 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 <
> 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