You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@openjpa.apache.org by "Catalina Wei (JIRA)" <ji...@apache.org> on 2007/09/08 21:36:29 UTC

[jira] Created: (OPENJPA-360) SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816
----------------------------------------------------------

                 Key: OPENJPA-360
                 URL: https://issues.apache.org/jira/browse/OPENJPA-360
             Project: OpenJPA
          Issue Type: Bug
          Components: sql
    Affects Versions: 1.0.0, 1.0.1, 1.1.0
            Reporter: Catalina Wei
            Assignee: Catalina Wei


"FOR UPDATE OF" string incorrectly generated for DB2 UDB version 8.1 or earlier and DB2 ISeries V5R3 or earlier.
Should generate "FOR UPDATE"

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

Re: [jira] Updated: (OPENJPA-360) SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

Posted by catalina wei <ca...@gmail.com>.

This fix has been tested against DB2 UDB Version 8.1, 8.2 and 9.1, DB2
ISeries V5R4,
 DB2 ZOS Version 8 and 9.

Catalina

On 9/11/07, Catalina Wei (JIRA) <ji...@apache.org> wrote:
>
>
>     [
> https://issues.apache.org/jira/browse/OPENJPA-360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>
> Catalina Wei updated OPENJPA-360:
> ---------------------------------
>
>    Attachment:     (was: OPENJPA-360.patch)
>
> > SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816
> > ----------------------------------------------------------
> >
> >                 Key: OPENJPA-360
> >                 URL: https://issues.apache.org/jira/browse/OPENJPA-360
> >             Project: OpenJPA
> >          Issue Type: Bug
> >          Components: sql
> >    Affects Versions: 1.0.0, 1.0.1, 1.1.0
> >            Reporter: Catalina Wei
> >            Assignee: Catalina Wei
> >             Fix For: 1.0.1, 1.1.0
> >
> >
> > "FOR UPDATE OF" string incorrectly generated for DB2 UDB version 8.1 or
> earlier and DB2 ISeries V5R3 or earlier.
> > Should generate "FOR UPDATE"
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>

Re: [jira] Updated: (OPENJPA-360) SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

Posted by Kevin Sutter <kw...@gmail.com>.

Catalina,
The patch looks good.  Hope your testing goes well..  :-)

Thanks!
Kevin

On 9/8/07, Catalina Wei (JIRA) <ji...@apache.org> wrote:
>
>
>      [
> https://issues.apache.org/jira/browse/OPENJPA-360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel]
>
> Catalina Wei updated OPENJPA-360:
> ---------------------------------
>
>     Attachment: OPENJPA-360.patch
>
> Fix UPDATE OF clause for DB2 UDB Version 8.1 or earlier and DB2 Iseries
> V5R3 or earlier.
>
> > SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816
> > ----------------------------------------------------------
> >
> >                 Key: OPENJPA-360
> >                 URL: https://issues.apache.org/jira/browse/OPENJPA-360
> >             Project: OpenJPA
> >          Issue Type: Bug
> >          Components: sql
> >    Affects Versions: 1.0.0, 1.0.1, 1.1.0
> >            Reporter: Catalina Wei
> >            Assignee: Catalina Wei
> >         Attachments: OPENJPA-360.patch
> >
> >
> > "FOR UPDATE OF" string incorrectly generated for DB2 UDB version 8.1 or
> earlier and DB2 ISeries V5R3 or earlier.
> > Should generate "FOR UPDATE"
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>

[jira] Reopened: (OPENJPA-360) SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816

Posted by "Kevin Sutter (JIRA)" <ji...@apache.org>.

     [ https://issues.apache.org/jira/browse/OPENJPA-360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Sutter reopened OPENJPA-360:
----------------------------------

      Assignee: Kevin Sutter  (was: Catalina Wei)

Temporarily re-opening this issue to clean up the testcases to remove the dependency on DB2 drivers...  Our unit tests need to run with Derby only.  If we want to run with DB2, then a different profile should be defined and specified.   I have made the changes and am currently testing them with Derby.  I'll commit the changes shortly.

> SQL FOR UPDATE OF incorrectly generated for DB2/NT SQL0816
> ----------------------------------------------------------
>
>                 Key: OPENJPA-360
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-360
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 1.0.0, 1.0.1, 1.1.0
>            Reporter: Catalina Wei
>            Assignee: Kevin Sutter
>             Fix For: 1.0.1, 1.1.0
>
>
> "FOR UPDATE OF" string incorrectly generated for DB2 UDB version 8.1 or earlier and DB2 ISeries V5R3 or earlier.
> Should generate "FOR UPDATE"

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