[jira] Created: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception.

From: Robert Zeigler (JIRA) ("Robert)
Date: Tue Aug 12 2008 - 23:11:11 EDT

Next message: Robert Zeigler (JIRA): "[jira] Updated: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."

Previous message: Ari Maniatis (JIRA): "[jira] Closed: (CAY-794) Abstract objEntities"
Next in thread: Robert Zeigler (JIRA): "[jira] Updated: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."
Reply: Robert Zeigler (JIRA): "[jira] Updated: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."
Reply: Robert Zeigler (JIRA): "[jira] Commented: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."
Reply: Kevin Menard (JIRA): "[jira] Assigned: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."
Reply: Kevin Menard (JIRA): "[jira] Closed: (CAY-1095) Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception."
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Cayenne attempts to append precision information to DOUBLE types when creating tables in hsqldb which results in a sql exception.
---------------------------------------------------------------------------------------------------------------------------------

                 Key: CAY-1095
                 URL: https://issues.apache.org/cayenne/browse/CAY-1095
             Project: Cayenne
          Issue Type: Bug
          Components: Cayenne Core Library
    Affects Versions: 3.0
         Environment: os x, hsqldb 1.8.0.10, java 1.5
            Reporter: Robert Zeigler
            Assignee: Andrus Adamchik
            Priority: Minor

According to the documentation on hsql's website, hsqldb should support precision on DOUBLE types, so the following:

create table foo(bar DOUBLE(22));

should be valid. However, the docs are apparently out of sync with reality, as the above produces the following feedback:
java.sql.SQLException: Unexpected token in statement [CREATE CACHED TABLE foo (bar DOUBLE(22]

This is now documented in the following bug report:

http://sourceforge.net/tracker/index.php?func=detail&aid=2048932&group_id=23316&atid=378131

Cayenne's hsqldb adapter should work around this hsqldb problem by dropping the precision statement for DOUBLE, resulting in sql like:
create table foo(bar DOUBLE);

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

This archive was generated by hypermail 2.0.0 : Tue Aug 12 2008 - 23:12:06 EDT