Mailing-List: contact commits-help@empire-db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: empire-db-dev@empire-db.apache.org
Date: Wed, 25 Jul 2012 13:24:34 +0000 (UTC)
From: "Daniel Weidele (JIRA)" <empire-db-dev@incubator.apache.org>
To: empire-db-commits@incubator.apache.org
Message-ID: <259529147.101023.1343222675226.JavaMail.jiratomcat@issues-vm>
In-Reply-To: <374847148.100929.1343221054499.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Updated] (EMPIREDB-151) DBDatabaseDriverHSQL fails on
 selection of NEXT VALUE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/EMPIREDB-151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Weidele updated EMPIREDB-151:
------------------------------------

    Comment: was deleted

(was: public static class TTest extends DBTable
    {
        private static final long  serialVersionUID = 1L;

        public final DBTableColumn ID;

        public TTest(DBDatabase db)
        {
            super("TEST", db);

            this.ID = addColumn("ID", DataType.AUTOINC, 0, true);

            setPrimaryKey(this.ID);
        }
    }
)
    
> 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