[OS-JIRA] Created: (CAY-299) PostgreSQL selecting procedure results are processed incorrectly

From: jira-norepl..bjectstyle.org
Date: Sun Apr 03 2005 - 00:18:21 EST

  • Next message: Dan Hennes: "Preclick Corp - Job Posting - Java/Tapestry/cayenne"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-299

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-299
        Summary: PostgreSQL selecting procedure results are processed incorrectly
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Fix Fors:
                 1.2 [DEV]
       Versions:
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Sun, 3 Apr 2005 12:18 AM
        Updated: Sun, 3 Apr 2005 12:18 AM
    Environment: PostgreSQL 8.0.1, Mac OS X

    Description:
    We haven't tested PostgreSQL procedure (called "functions" in PGSQL) support... Now that I am doing that, I discovered that result sets are not processed correctly - the first result set is skipped.

    Looks like the problem is that CallableStatement.execute() rewinds the ResultSet pointer, so we can't call getMoreResults() until the first result set is read... I will plug a ProcedureAction used by SQLServer to Postgres adapter. It seems to fix it..

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Sun Apr 03 2005 - 00:18:23 EST