Message Title

I have a hibernate application for which unit tests have started failing after upgrading from Hibernate 4.2.11 to Hibernate 5.0.1. The failure appears to be that Hibernate is trying to create a sequence, when one already exists.

I have been able to fix this locally by patching my HibernateTenSevenDialect to add the following:

	@Override
	public String getQuerySequencesString() {
		return "select SEQUENCENAME from sys.syssequences";
	}

Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Unable to execute schema management to JDBC target [create sequence hibernate_sequence start with 1 increment by 1]
	at org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:59) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlString(SchemaMigratorImpl.java:371) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.applySqlStrings(SchemaMigratorImpl.java:360) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigrationToTargets(SchemaMigratorImpl.java:168) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.schema.internal.SchemaMigratorImpl.doMigration(SchemaMigratorImpl.java:59) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:129) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:97) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:481) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:444) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:802) ~[hibernate-entitymanager-5.0.1.Final.jar:5.0.1.Final]
	... 46 common frames omitted
Caused by: java.sql.SQLException: Sequence 'HIBERNATE_SEQUENCE' already exists.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:107) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:233) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2396) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1430) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:704) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeUpdate(EmbedStatement.java:181) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:170) ~[derby-10.11.1.1.jar:na]
	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234) ~[commons-dbcp2-2.1.1.jar:2.1.1]
	at org.apache.commons.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:234) ~[commons-dbcp2-2.1.1.jar:2.1.1]
	at org.hibernate.tool.schema.internal.TargetDatabaseImpl.accept(TargetDatabaseImpl.java:56) ~[hibernate-core-5.0.1.Final.jar:5.0.1.Final]
	... 55 common frames omitted
Caused by: org.apache.derby.iapi.error.StandardException: Sequence 'HIBERNATE_SEQUENCE' already exists.
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:290) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:285) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.sql.execute.CreateSequenceConstantAction.executeConstantAction(CreateSequenceConstantAction.java:115) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:470) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:349) ~[derby-10.11.1.1.jar:na]
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1338) ~[derby-10.11.1.1.jar:na]
	... 61 common frames omitted