jack.qiao created ODE-975:
-----------------------------
Summary: there are no sql script for mysql at version 1.3.5
Key: ODE-975
URL: https://issues.apache.org/jira/browse/ODE-975
Project: ODE
Issue Type: Improvement
Components: JBI Integration
Affects Versions: 1.3.5
Reporter: jack.qiao
there are no sql script for mysql at version 1.3.5, if I use the 1.3.4 one ,it
throw error with :
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReq
uest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:1
20)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:1813)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
at java.lang.Thread.run(Thread.java:662)
18:01:54,129 ERROR [BpelManagementFacadeImpl] Exception while listing processes
<openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persist
ence.PersistenceException: Table 'ode.ode_process_instance' doesn't exist {preps
tmnt 30857944 SELECT t1.PROCESS_ID, COUNT(t0.ID) FROM ODE_PROCESS_INSTANCE t0 IN
NER JOIN ODE_PROCESS t1 ON t0.PROCESS_ID = t1.ID WHERE (t1.PROCESS_ID IN (?, ?)
AND t0.INSTANCE_STATE IN (?, ?, ?)) GROUP BY t1.PROCESS_ID [params=(String) {htt
p://ode/bpel/unit-test}DynPartnerMain-1, (String) {http://ode/bpel/responder}Dyn
PartnerResponder-1, (short) 0, (short) 20, (short) 10]} [code=1146, state=42S02]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:423
2)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictiona
ry.java:4197)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:102)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:88)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java
:64)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheck
edException(SelectResultObjectProvider.java:155)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:40)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:848)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:779)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.jav
a:525)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:254)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java
:294)
at org.apache.ode.dao.jpa.ProcessManagementDAOImpl.countInstancesSummary
(ProcessManagementDAOImpl.java:94)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.fillProce
ssInfoSummary(ProcessAndInstanceManagementImpl.java:790)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.access$20
0(ProcessAndInstanceManagementImpl.java:152)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl$1.run(Pro
cessAndInstanceManagementImpl.java:193)
at org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl
eScheduler.java:284)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl
eScheduler.java:239)
at org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.listProce
ssesCustom(ProcessAndInstanceManagementImpl.java:181)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.listAllPr
ocesses(ProcessAndInstanceManagementImpl.java:213)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.il.DynamicService.invoke(DynamicService.java:71)
at org.apache.ode.axis2.service.ManagementService$DynamicMessageReceiver
.invokeBusinessLogic(ManagementService.java:126)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMe
ssageReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReq
uest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:1
20)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:1813)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'ode.ode_pro
cess_instance' doesn't exist {prepstmnt 30857944 SELECT t1.PROCESS_ID, COUNT(t0.
ID) FROM ODE_PROCESS_INSTANCE t0 INNER JOIN ODE_PROCESS t1 ON t0.PROCESS_ID = t1
.ID WHERE (t1.PROCESS_ID IN (?, ?) AND t0.INSTANCE_STATE IN (?, ?, ?)) GROUP BY
t1.PROCESS_ID [params=(String) {http://ode/bpel/unit-test}DynPartnerMain-1, (Str
ing) {http://ode/bpel/responder}DynPartnerResponder-1, (short) 0, (short) 20, (s
hort) 10]} [code=1146, state=42S02]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingCo
nnectionDecorator.java:192)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(Log
gingConnectionDecorator.java:57)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:262)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStateme
nt.executeQuery(JDBCStoreManager.java:1595)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:252)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:4
96)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:339)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalU
nion.java:420)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:23
0)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:22
0)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:20
6)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(Select
ResultObjectProvider.java:94)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:34)
... 45 more
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ode.ode_proces
s_instance' doesn't exist
at sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source
)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.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:1053)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2155)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2322)
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.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:264)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnect
ion$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:850)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:262)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStateme
nt.executeQuery(JDBCStoreManager.java:1595)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:252)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:4
96)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:339)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalU
nion.java:420)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:23
0)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:22
0)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:20
6)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(Select
ResultObjectProvider.java:94)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.jav
a:34)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:848)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:779)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.jav
a:525)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:254)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java
:294)
at org.apache.ode.dao.jpa.ProcessManagementDAOImpl.countInstancesSummary
(ProcessManagementDAOImpl.java:94)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.fillProce
ssInfoSummary(ProcessAndInstanceManagementImpl.java:790)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.access$20
0(ProcessAndInstanceManagementImpl.java:152)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl$1.run(Pro
cessAndInstanceManagementImpl.java:193)
at org.apache.ode.bpel.engine.BpelDatabase$1.call(BpelDatabase.java:76)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl
eScheduler.java:284)
at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(Simpl
eScheduler.java:239)
at org.apache.ode.bpel.engine.BpelDatabase.exec(BpelDatabase.java:74)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.listProce
ssesCustom(ProcessAndInstanceManagementImpl.java:181)
at org.apache.ode.bpel.engine.ProcessAndInstanceManagementImpl.listAllPr
ocesses(ProcessAndInstanceManagementImpl.java:213)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.ode.il.DynamicService.invoke(DynamicService.java:71)
at org.apache.ode.axis2.service.ManagementService$DynamicMessageReceiver
.invokeBusinessLogic(ManagementService.java:126)
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMe
ssageReceiver.java:96)
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostReq
uest(HTTPTransportUtils.java:275)
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:1
20)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
929)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1002)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:585)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:1813)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
at java.lang.Thread.run(Thread.java:662)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
