Versions:
Hibernate 3.2.5.ga
Oracle 10g
I'm trying to use the <database-object> element discussed here:
https://www.hibernate.org/hib_docs/nhib ... ase-objectThis doesn't work:
Code:
<database-object>
<create>
create table foo ( id number(10) );
</create>
<drop />
<dialect-scope name="org.hibernate.dialect.Oracle10gDialect" />
</database-object>
It fails with:
Code:
Unsuccessful: create table foo ( id number(10) ); ERROR SchemaExport(274) 09:30:35,338 main
ORA-00911: invalid character ERROR SchemaExport(275) 09:30:35,339 main
If I remove the semicolon at the end of the statement, it works. This, however, means that I can only put one create statement per database-object, and I have around 50 that need to be executed. I'd much rather not have to have the clutter of all the database-object xml for every single statement.
The same kind of thing works in H2 with the semicolons so that I can include multiple statements like I want to. Does anyone have an idea why it doesn't work for oracle?