hbm2ddl: single quotes not escaped in table comment

peter.hilton · **Posted:** Tue Jan 15, 2008 6:41 am

I'm using hbm2ddl with annotationconfiguration to generate a database creation script.

A neat feature is that you can use the Hibernate @Table annotation to specify a comment/description for the table in the datatbase. However, if I annotation my Comment entity class with

Code:

@org.hibernate.annotations.Table(appliesTo = "component_comment", comment = "A user's comment on a component")

then hbm2ddl generates an SQL script that includes:

Code:

comment on table component_comment is 'A user's comment on a component';

which breaks because of the single quote in user's. This should be escaped like user''s with two single quotes.

max · **Posted:** Tue Jan 15, 2008 10:31 am

sounds like a bug in the ddl generation - submit a patch/request to jira.

peter.hilton · **Posted:** Tue Jan 15, 2008 10:56 am

Which JIRA project and component do you think I should create a bug for? There seem to be 'wrong DDL' bugs scattered across different components in HHH, ANN and HBX.

max · **Posted:** Tue Jan 15, 2008 1:30 pm

depends - if you can reproduce it with hibernate core (via hbm.xml) then it should go to hibernate core - if only visible when using annotations report should go into ANN