openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (OPENJPA-2045) NAME is a valid column name for H2 databases.
Date Thu, 15 Sep 2011 13:29:08 GMT

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

Michael Dick reassigned OPENJPA-2045:
-------------------------------------

    Assignee: Jacob Nowosatka

> NAME is a valid column name for H2 databases.
> ---------------------------------------------
>
>                 Key: OPENJPA-2045
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2045
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.1.0, 2.2.0
>            Reporter: Michael Dick
>            Assignee: Jacob Nowosatka
>            Priority: Minor
>         Attachments: OPENJPA-2045.patch
>
>
> This issue was originally reported on the users mailing list : http://openjpa.208410.n2.nabble.com/GenerationType-TABLE-question-column-name-suffixed-with-0-td6729676.html.

> The H2 DBDictionary is picking up the default list of invalid column names from openjpa-jdbc/src/main/resources/org/apache/openjpa/jdbc/sql/sql-keywords.rsrc,
which includes "NAME". As a result we're trying to fix the column so that it contains a valid
identifier, and end up with the wrong value. 
> Users can work around the problem by delimiting columns in their annotations or xml mapping
files, for example : 
> @javax.persistence.TableGenerator(
>     name = "fred", 
>     table = "jpa_sequence", 
>     pkColumnName = "\"name\"", 
>     valueColumnName = "last_value", 
>     pkColumnValue = "fred", 
>     allocationSize = 500)
> To fix the problem we need to either remove NAME from the default list, or manually remove
it in the H2 Dictionary. Some additional investigation may be needed to determine whether
this is a problem for other databases too. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message