update HSQLDialect for HSQL 1.8 sequence support ------------------------------------------------ Key: HHH-608 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-608 Project: Hibernate Core Issue Type: Improvement Components: core Environment: Hibernate 3.0.5 HSQLDB 1.8.0 RC 10 Reporter: Christian Stein Assignee: Steve Ebersole Fix For: 3.1 rc 1 Attachments: hibernate3modified.jar, HSQLDialect.java, HSQLDialect.java, HSQLDialect.patch, HSQLDialect.patch, TestHSQLDialectPatch.java ----- Original Message ----- From: "Christian Stein" <sormuras(a)gmx.de&gt; To: <fredt(a)users.sourceforge.net&gt; Sent: 11 June 2005 05:40 Subject: [HSQLDB-rc10] ...and Hibernate 3.0.5 Hello Fred, when using the SchemaUpdate tool of Hibernate 3, it reports that it can't find the system table named "system_sequences". Is this table gone or not longer visible? I attached the stack trace first, and the interesting parts of the "HSQLDialect" class from the Hibernate source. Cheers, Christian === stack trace === INFO [main] SchemaUpdate - Running hbm2ddl schema update INFO [main] SchemaUpdate - fetching database metadata ERROR [main] SchemaUpdate - could not get database metadata java.sql.SQLException: Table not found in statement [select sequence_name from system_sequences] org.hsqldb.jdbc.Util.sqlException(Unknown Source) org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source) org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:113) org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:39) org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:124) === org.hibernate.dialect.HSQLDialect snippet === public boolean supportsSequences() { return true; } public String getQuerySequencesString() { return "select sequence_name from system_sequences"; }