[hibernate-issues] [Hibernate-JIRA] Created: (HBX-1173) hbm2ddl generates bad sql schema when forbidden column name is used on Oracle
hbm2ddl generates bad sql schema when forbidden column name is used on Oracle
-----------------------------------------------------------------------------
Key: HBX-1173
URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1173
Project: Hibernate Tools
Issue Type: Improvement
Environment: 16:04:20,778 INFO org.hibernate.cfg.annotations.Version - Hibernate
Annotations 3.3.0.GA
16:04:20,789 INFO org.hibernate.cfg.Environment - Hibernate 3.2.7
16:04:20,808 INFO org.hibernate.cfg.Environment - hibernate.properties not found
16:04:20,812 INFO org.hibernate.cfg.Environment - Bytecode provider name : cglib
16:04:20,815 INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp
handling
+ Oracle / H2 (tests)
Reporter: Lorber Sebastien
Priority: Minor
Hello,
It's not a major issue but anyway it made me wonder some minutes what was the
problem.
I used this in an entity:
@Enumerated(EnumType.STRING)
@Column(name = "size", nullable=false)
public ImageSize getImageSize() {
return imageSize;
}
Hbm2ddl generates:
create table NWS_PICTURE (
news_id varchar2(36 char) not null,
size varchar2(255 char) not null,
path varchar2(255 char) not null,
picture_id number(19,0),
primary key (picture_id)
);
but i can't pass that on Oracle:
create table NWS_PICTURE (
news_id varchar2(36 char) not null,
size varchar2(255 char) not null,
path varchar2(255 char) not null,
picture_id number(19,0),
primary key (picture_id)
)
Erreur à la ligne de commande : 3, colonne : 8
Rapport d'erreur :
Erreur SQL : ORA-00904: : invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Because size is a keyword, it doesn't work.
Wouldn't it be better to make it fail fast and not generate the SQL schema in these
cases?
I don't know if it is specific to oracle. If it is, perhaps adding a comment above the
generated sql create table, or a warning in the hbm2ddl process?
It seems ok when using H2, i was able during tests to retrieve data from this table.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira