SchemaExport generating incorrect Postgresql DDL

macritchie · **Joined:** Tue May 25, 2004 6:35 pm **Posts:** 3

Hello,
I'm running SchemaExport on my hbm file and generating DDL file for a postgresql database. I have a hibernate config file that sets the dialect to postresql.
My issue is that the DDL that gets generated does not have a semi-colon at the end of each DDL command. I went through the hibernate code that generates the DDL and found that the dialect is not consulted for this (ie: a semi-colon will never be produced no matter what dialect you use).

I'm wondering if anyone else has experienced this problem? Is this a bug, or am I setting something up wrong?

I'm using hibernate 2.0.3.

Here is a snip from the DDL that I am generating:

Code:

drop table portfolio
create table portfolio (
    portfolio_id INT8 not null,
    title VARCHAR(255),
    size INT8,
    primary key (portfolio_id)
);

The above gives me errors when I try to execute it. When I add semi-colon's as follows, it runs fine:

Code:

drop table portfolio;
create table portfolio (
    portfolio_id INT8 not null,
    title VARCHAR(255),
    size INT8,
    primary key (portfolio_id)
);

Any ideas?
Thanks!

macritchie · **Joined:** Tue May 25, 2004 6:35 pm **Posts:** 3

Sorry, just to be clear, the DDL that gets generated without semi-colon's and does not run looks like this:

Code:

drop table portfolio 
create table portfolio ( 
    portfolio_id INT8 not null, 
    title VARCHAR(255), 
    size INT8, 
    primary key (portfolio_id) 
)

Without any semi-colons.

christian · **Posted:** Wed May 26, 2004 5:41 pm

--delimiter

macritchie · **Joined:** Tue May 25, 2004 6:35 pm **Posts:** 3

Thank you christian.

caoilte · **Joined:** Thu Dec 02, 2004 6:27 am **Posts:** 10

If it's not clear from the above (I had to scratch my head, having just run into the same problem) you need to set the "delimiter" property.

If you use maven that is documented here.