[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2897) Adding support for use of sequence objects in DB2 V8 OS390

[Tobias Sternvik (JIRA)]

Adding support for use of sequence objects in DB2 V8 OS390
----------------------------------------------------------

                 Key: HHH-2897
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2897
             Project: Hibernate3
          Issue Type: Improvement
          Components: core
    Affects Versions: 3.2.5
         Environment: Hibernate Core 3.2.5ga, DB2 UDB V8 OS390 (Z/OS)
            Reporter: Tobias Sternvik
         Attachments: DB2390Dialect.java

Since version 8 of DB2 sequence objects are supported on the OS390 platform. But, the syntax for use of sequences varies between OS390 platform and the "rest".

For retreival of next value in DB2 OS390 the syntax is "select nextval for <theSequenceName> from sysibm.sysdummy1" while in the "rest" it is "values nextval for <theSequenceName>". There migt be the case that within AS/400 environment the syntax is imilar to OS390, but I have not verified this.

Also other differences exists..

I've included a enhanced verion of DB2390Dialect.java that has been proven to work in DB2 mainframe environment.

-- 
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