Hello,
I have a table with exactly one column. This column uses a sequence in Oracle, and is set to autoincrement in MySQL. This table has also a one-to-many relation to another table.
When i try to update the tables, hibernate generates an sql statement that looks like this:
Code:
insert into ex_batch (batch_id) values ()
This works perfectly for MySQL, but not at all for Oracle, (ORA-00936: missing expression).
I use Hibernate 3.0.5 together with Jboss 4.0.3.
Is there anything to do except to explicitly set the value of the column and not use a sequence?
Börje Jonsson