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

[Carey E. (JIRA) <no...@at...>]

Sequence support for DB2400Dialect
----------------------------------

         Key: HHH-1754
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1754
     Project: Hibernate3
        Type: Improvement

  Components: core  
    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