[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1950) Database Dialect for Progress 9.1D

[George G. (JIRA) <no...@at...>]

Database Dialect for Progress 9.1D
----------------------------------

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

  Components: core  
    Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3    
 Environment: Progress 9.1D
    Reporter: George Gastaldi


The current org.hibernate.dialect.ProgressDialect does not support Sequences, as Progress 9.1 does. Following is a working Dialect for Progress 9.1 D Databases.
Please include it on the distribution (or update ProgressDialect).


package org.hibernate.dialect;

import java.sql.Types;

import org.hibernate.dialect.Dialect;

public class Progress9Dialect extends ProgressDialect {
	
	@Override
	public boolean supportsSequences() {
		return true;
	}
	
	@Override
	public String getSequenceNextValString(String sequenceName) {
		return "select " + getSelectSequenceNextValString( sequenceName ) + " from SYSPROGRESS.SYSCALCTABLE";
	}

	@Override
	public String getSelectSequenceNextValString(String sequenceName) {
		return sequenceName + ".nextval";
	}
	
}




Thanks.

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