You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "B.J. Reed (JIRA)" <ji...@apache.org> on 2009/02/10 16:01:01 UTC

[jira] Created: (OPENJPA-917) stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

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

                 Key: OPENJPA-917
                 URL: https://issues.apache.org/jira/browse/OPENJPA-917
             Project: OpenJPA
          Issue Type: Bug
          Components: query
    Affects Versions: 1.2.0
            Reporter: B.J. Reed
             Fix For: 1.2.0


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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Assigned: (OPENJPA-917) stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick reassigned OPENJPA-917:
------------------------------------

    Assignee: B.J. Reed

> stored procedures throw InvalidStateException when using getSingleResult() or getResultList()
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-917
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-917
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.2.0
>            Reporter: B.J. Reed
>            Assignee: B.J. Reed
>             Fix For: 1.0.4, 1.2.1, 1.3.0, 2.0.0
>
>         Attachments: OPENJPA-917.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (OPENJPA-917) stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick resolved OPENJPA-917.
----------------------------------

       Resolution: Fixed
    Fix Version/s:     (was: 1.2.0)
                   2.0.0
                   1.3.0
                   1.2.1

Thanks for the patch B.J!

> stored procedures throw InvalidStateException when using getSingleResult() or getResultList()
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-917
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-917
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.2.0
>            Reporter: B.J. Reed
>             Fix For: 1.2.1, 1.3.0, 2.0.0
>
>         Attachments: OPENJPA-917.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OPENJPA-917) stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

Posted by "B.J. Reed (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

B.J. Reed updated OPENJPA-917:
------------------------------

    Attachment: OPENJPA-917.patch

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

> stored procedures throw InvalidStateException when using getSingleResult() or getResultList()
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-917
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-917
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.2.0
>            Reporter: B.J. Reed
>             Fix For: 1.2.0
>
>         Attachments: OPENJPA-917.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (OPENJPA-917) stored procedures throw InvalidStateException when using getSingleResult() or getResultList()

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick updated OPENJPA-917:
---------------------------------

    Fix Version/s: 1.0.4

> stored procedures throw InvalidStateException when using getSingleResult() or getResultList()
> ---------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-917
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-917
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.2.0
>            Reporter: B.J. Reed
>             Fix For: 1.0.4, 1.2.1, 1.3.0, 2.0.0
>
>         Attachments: OPENJPA-917.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.