ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abdulkadir yaman <abdulkadirya...@gmail.com>
Subject Re: About Using Mysql Together with ODE
Date Wed, 23 Nov 2011 15:43:09 GMT
Yeah i meant it :)

On Wed, Nov 23, 2011 at 6:56 PM, 王雷 <mail.lei.wang@gmail.com> wrote:

> 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