[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-608) update HSQLDialect for HSQL 1.8 sequence support

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-608.
------------------------------


Closing stale resolved issues

> 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 at gmx.de>
> To: <fredt at users.sourceforge.net>
> 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";
> } 

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