[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1754) Sequence support for DB2400Dialect
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1754?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira