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:



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

I use Oracle's sequences too (but not MySQL).
For Oracle's sequences you should map your primary key something like that:

<id name="id" type="java.lang.Long" column="ID">
<generator class="sequence">
<param name="sequence">YOUR_ORACLE_SEQ</param>
</generator>
</id>

Well, no that's not the problem.

The id part of my mapper file looks like this:



The sequence exists and works.
The problem seems to be database dependent - Oracle doesn't like empty values "()" in insert statements.
I'm really asking to see if I made something wrong, of if there is some workaround.
Otherwise i have to explicitly supply the batch_id.

/BJ