You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Daniel Weidele (JIRA)" <em...@incubator.apache.org> on 2012/07/25 16:00:38 UTC
[jira] [Comment Edited] (EMPIREDB-151) DBDatabaseDriverHSQL fails
on selection of NEXT VALUE
[ https://issues.apache.org/jira/browse/EMPIREDB-151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13422277#comment-13422277 ]
Daniel Weidele edited comment on EMPIREDB-151 at 7/25/12 2:00 PM:
------------------------------------------------------------------
you should be using:
addColumn("DATA_ID", DataType.AUTOINC, 0, DataMode.AutoGenerated, "DATA_ID_SEQUENCE");
fixed the issue!
However I agree there's a bug anyway, as with create ddl generation it could successfully generate a sequence name.
But give the workaround, it should be set to a minor issue.
Thanks!
was (Author: cheazy):
you should be using:
addColumn("DATA_ID", DataType.AUTOINC, 0, DataMode.AutoGenerated, "DATA_ID_SEQUENCE");
fixed the issue!
However I agree there's a bug anyway, as with ddl generation it could successfully generate a sequence name.
But give the workaround, it should be set to a minor issue.
Thanks!
> DBDatabaseDriverHSQL fails on selection of NEXT VALUE
> -----------------------------------------------------
>
> Key: EMPIREDB-151
> URL: https://issues.apache.org/jira/browse/EMPIREDB-151
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.3.0
> Environment: HSQLDB 1.8.0.10
> Reporter: Daniel Weidele
> Assignee: Francis De Brabandere
> Priority: Blocker
>
> The SQL to retrieve a next sequence value is badly generated by the DBDatabaseDriverHSQL:
> Executing: SELECT NEXT VALUE FOR "org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42" FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES WHERE SEQUENCE_NAME='ORG.APACHE.EMPIRE.DB.HSQL.DBDATABASEDRIVERHSQL@7FFC6E42'
> Error executing query 'SELECT NEXT VALUE FOR "org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42" FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES WHERE SEQUENCE_NAME='ORG.APACHE.EMPIRE.DB.HSQL.DBDATABASEDRIVERHSQL@7FFC6E42'' --> Sequence not found: org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42 in statement [SELECT NEXT VALUE FOR "org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42" FROM]
> java.sql.SQLException: Sequence not found: org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42 in statement [SELECT NEXT VALUE FOR "org.apache.empire.db.hsql.DBDatabaseDriverHSql@7ffc6e42" FROM]
> at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
> at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
> at org.apache.empire.db.DBDatabaseDriver.executeQuery(DBDatabaseDriver.java:596)
> at org.apache.empire.db.DBDatabase.querySingleValue(DBDatabase.java:766)
> at org.apache.empire.db.DBDatabase.querySingleValue(DBDatabase.java:806)
> at org.apache.empire.db.DBDatabase.querySingleValue(DBDatabase.java:820)
> at org.apache.empire.db.hsql.DBDatabaseDriverHSql.getNextSequenceValue(DBDatabaseDriverHSql.java:238)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira