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

[john daly (JIRA)]

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

john daly commented on HHH-1754:
--------------------------------

The change:
	public String getSequenceNextValString(String sequenceName) {
		return "select nextval for " + sequenceName + " from sysibm.sysdummy1";
	}
will work for both standard DB2 and DB2400 so it might be best to put it in DB2Dialect.java?

Select nextval for SEQUENCENAME  from sysibm.sysdummy1
and 
VALUES nextval for SEQUENCENAME  

arer apparently equivalent in DB2 but the VALUES version doesn't work in DB2400


> 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