[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1754) Sequence support for DB2400Dialect

[etienne massip (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28831 ] 

etienne massip commented on HHH-1754:
-------------------------------------

Can't use a 'sequence' generator with i5OS v5r4 (hibernate 3.2.4sp1).

It gives a SQL0029 error (missing INTO clause) as using the "values nextval for <..>" when trying to insert a new record !!

I think this should be defined as a major bug ?


> Sequence support for DB2400Dialect
> ----------------------------------
>
>                 Key: HHH-1754
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1754
>             Project: Hibernate3
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 3.1.3
>         Environment: Hibernate 3.1.3, IBM DB2 UDB for iSeries on i5/OS V5R3
>            Reporter: Carey Evans
>            Priority: Minor
>         Attachments: DB2400Dialect.java
>
>
> As of i5/OS V5R3 (the operating system previously known as OS/400), DB2 supports sequences, but DB2400Dialect doesn't include support for the new functionality.  This support can be modelled on DB2Dialect, except that "values ..." must be written "select ... from sysibm.sysdummy1", and the syssequences view is in the qsys2 schema.
> I don't know what impact this change would have on older versions of OS/400 that don't support sequences.
> The attached DB2400Dialect source includes sequence support, with some additional minor corrections for timestamps on i5/OS.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira