Author: steve.ebersole(a)jboss.com Date: 2010-09-25 11:35:02 -0400 (Sat, 25 Sep 2010) New Revision: 20705 Modified: core/trunk/core/src/main/java/org/hibernate/dialect/InformixDialect.java Log: HHH-5581 - Improve InformixDialect sequence support Modified: core/trunk/core/src/main/java/org/hibernate/dialect/InformixDialect.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/dialect/InformixDialect.java 2010-09-25 10:41:36 UTC (rev 20704) +++ core/trunk/core/src/main/java/org/hibernate/dialect/InformixDialect.java 2010-09-25 15:35:02 UTC (rev 20705) @@ -86,8 +86,8 @@ public String getIdentitySelectString(String table, String column, int type) throws MappingException { return type==Types.BIGINT ? - "select dbinfo('serial8') from systables where tabid=1" : - "select dbinfo('sqlca.sqlerrd1') from systables where tabid=1"; + "select dbinfo('serial8') from informix.systables where tabid=1" : + "select dbinfo('sqlca.sqlerrd1') from informix.systables where tabid=1"; } public String getIdentityColumnString(int type) throws MappingException { @@ -146,7 +146,7 @@ } public String getSequenceNextValString(String sequenceName) { - return "select " + getSelectSequenceNextValString( sequenceName ) + " from systables where tabid=1"; + return "select " + getSelectSequenceNextValString( sequenceName ) + " from informix.systables where tabid=1"; } public String getSelectSequenceNextValString(String sequenceName) { @@ -157,6 +157,14 @@ return true; } + public boolean supportsPooledSequences() { + return true; + } + + public String getQuerySequencesString() { + return "select tabname from informix.systables where tabtype='Q'"; + } + public boolean supportsLimit() { return true; }