Uploaded image for project: 'ODE'
  1. ODE
  2. ODE-975

there are no sql script for mysql at version 1.3.5

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Cannot Reproduce
    • 1.3.5
    • None
    • JBI Integration
    • None

    Description

      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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            jpqiao jack.qiao
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: