[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5427) derby 10.6.1.0 native sequence support broken

derby 10.6.1.0 native sequence support broken --------------------------------------------- Key: HHH-5427 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5427 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.5.2, 3.5.3, 3.5.4, 3.6.0.Beta1 Environment: apache derby, hibernate 3.5.x/3.6 Reporter: Max Giesbert Assignee: Steve Ebersole Priority: Minor Original Estimate: 5m Remaining Estimate: 5m see also: https://forum.hibernate.org/viewtopic.php?f=1&t=1005637&view=prev... Derby 10.6.1 officially supports sequences. (See JIRA-Task: https://issues.apache.org/jira/browse/DERBY-712, Docs: https://issues.apache.org/jira/browse/DERBY-4568). usage (e.g. @Id @GeneratedValue(strategy=GenerationType.SEQUENCE) ) produces: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:487) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:430) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) fix is: org.hibernate.dialect.DerbyDialect needs to override getSequenceNextValString as follows @Override public String getSequenceNextValString(String sequenceName) { return "values next value for " + sequenceName; }