empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Weidele (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Created] (EMPIREDB-151) DBDatabaseDriverHSQL fails on selection of NEXT VALUE
Date Wed, 25 Jul 2012 12:57:34 GMT
Daniel Weidele created EMPIREDB-151:
---------------------------------------

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

        

Mime
View raw message