OpenJPA
  1. OpenJPA
  2. OPENJPA-917

stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.0.4, 1.2.1, 1.3.0, 2.0.0-M2
    • Component/s: query
    • Labels:
      None

      Description

      Currently, org.apache.openjpa.persistence.QueryImpl throws an InvalidStateException when any stored procedure is called. The code needs to be updated to allow native queries to continue without the exception.

        Activity

        Hide
        Michael Dick added a comment -

        Thanks for the patch B.J!

        Show
        Michael Dick added a comment - Thanks for the patch B.J!
        Hide
        B.J. Reed added a comment -

        This patch updates QueryImpl.java to bypass the InvalidStateException when a native query is used. Also included is a JUnit test case that creates / loads / uses / drops a Derby stored procedure. This patch was created on the openjpa 1.2.x branch and should also be applied and verified on trunk.

        This fix does not fix the case where returning objects from stored procedures is not working properly - a new JIRA will be opened for this improvement

        Show
        B.J. Reed added a comment - This patch updates QueryImpl.java to bypass the InvalidStateException when a native query is used. Also included is a JUnit test case that creates / loads / uses / drops a Derby stored procedure. This patch was created on the openjpa 1.2.x branch and should also be applied and verified on trunk. This fix does not fix the case where returning objects from stored procedures is not working properly - a new JIRA will be opened for this improvement

          People

          • Assignee:
            B.J. Reed
            Reporter:
            B.J. Reed
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development