FAQ
[ https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Zeigler updated CAY-1095:
--------------------------------

Attachment: cay-1095.patch

Patch includes fix for the issue + unit test to verify the fix.
Unit test also includes a test to ensure that hsqldb table creation inserts the "CACHED" keyword, since I didn't see anywhere where that was being explicitly guaranteed.
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
Attachments: cay-1095.patch


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.

Search Discussions

  • Anonymous at Aug 13, 2008 at 3:42 am
    [ https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13047#action_13047 ]

    Robert Zeigler commented on CAY-1095:
    -------------------------------------

    The patch was created from the top of 3.0 trunk.
    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
    Attachments: cay-1095.patch


    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.
  • Anonymous at Aug 21, 2008 at 12:12 am
    [ https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Kevin Menard reassigned CAY-1095:
    ---------------------------------

    Assignee: Kevin Menard (was: Andrus Adamchik)
    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: Kevin Menard
    Priority: Minor
    Attachments: cay-1095.patch


    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.
  • Anonymous at Aug 23, 2008 at 3:57 pm
    [ https://issues.apache.org/cayenne/browse/CAY-1095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Kevin Menard closed CAY-1095.
    -----------------------------

    Resolution: Fixed
    Fix Version/s: 3.0

    Patch looked good. Applied mostly as is.
    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: Kevin Menard
    Priority: Minor
    Fix For: 3.0

    Attachments: cay-1095.patch


    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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdev @
categoriescayenne
postedAug 13, '08 at 3:41a
activeAug 23, '08 at 3:57p
posts4
users1
websitecayenne.apache.org

1 user in discussion

Anonymous: 4 posts

People

Translate

site design / logo © 2022 Grokbase