[jboss-jira] [JBoss JIRA] Resolved: (EJBTHREE-637) Entity attributes conflict with PostgreSQL keywords

Tue Feb 13 20:23:31 EST 2007

     [ http://jira.jboss.com/jira/browse/EJBTHREE-637?page=all ]

Emmanuel Bernard resolved EJBTHREE-637.
---------------------------------------

    Resolution: Rejected
      Assignee: Emmanuel Bernard

as per the doc, use backticks `

> Entity attributes conflict with PostgreSQL keywords
> ---------------------------------------------------
>
>                 Key: EJBTHREE-637
>                 URL: http://jira.jboss.com/jira/browse/EJBTHREE-637
>             Project: EJB 3.0
>          Issue Type: Bug
>    Affects Versions: EJB 3.0 RC8 - FD
>            Reporter: Seweryn Niemiec
>         Assigned To: Emmanuel Bernard
>
> I have EJB3 Entity with attribute "desc". Hibernate can't create SQL table for it.
> 13:58:11 DEBUG impl.Log4JLogger SchemaExport - create table ports (id int8 not null, name varchar(80) not null, desc varchar(240), device_ip varchar(15) not null, primary key (id))
> 13:58:11 ERROR impl.Log4JLogger SchemaExport - Unsuccessful: create table ports (id int8 not null, name varchar(80) not null, desc varchar(240), device_ip varchar(15) not null, primary key (id))
> 13:58:11 ERROR impl.Log4JLogger SchemaExport - ERROR: syntax error at or near "desc"
> Maybe I don't understand something (because it's hard to believe) but SchemaExport component
> doesn't use delimited identifiers to escape column names.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira