You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Tammo van Lessen (JIRA)" <ji...@apache.org> on 2012/11/15 00:42:12 UTC
[jira] [Resolved] (ODE-975) there are no sql script for mysql at
version 1.3.5
[ https://issues.apache.org/jira/browse/ODE-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tammo van Lessen resolved ODE-975.
----------------------------------
Resolution: Cannot Reproduce
Just downloaded the 1.3.5 war distro from the Apache mirrors. It contains a sql folder with DDLs for derby, MySQL and Oracle, and they contain a ODE_PROCESS_INSTANCE create table statement as well. So I cannot reproduce.
> 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