Issue:
I am unable to insert using the native generator class. It will only insert if I set the class to increment. The id field is a MySQL AUTO_INCREMENT int datatype. What can I do to fix this?

What I have already done:
I have looked at the documentation and it looks like I should be able to use the identity or native fields with mysql. Also, the increment field is not clusterable.

Hibernate version:3.1.3

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.intraoss.pojo.domain.Testdb" table="testdb">
<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="45" not-null="true" />
</property>
<property name="description" type="java.lang.String">
<column name="description" length="45" not-null="true" />
</property>
</class>
</hibernate-mapping>

Database and Driver:MySQL 5 and the mysql-connector-java-5.0.3-bin.jar

In the past I've successfully used the identity generator in this situation. Not sure what is missing to make native work. Try identity, if still not working something else may be wrong...

Marius

I have already tried this, it seems to only allow me to do increment. Has anyone done this with this version of the mysql driver and mysql. If there is a configuration issue why would increment work am I missing something.

I apologize, I am still missing something. The way I used this in the past is that I created an object, left the id parameter as null (or what ever you set as unsaved-value) and save it to the database. When you save the database fills in the field. After this point you do not change the ID.

At what point are you trying to increment and what?

Sorry for the confusion... Increment is the generator cloass that is being set. So instead of using

<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="native" />
</id>
or
<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="identity" />
</id>
I am forced to use:
<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="increment" />
</id>

Which is not cluster safe and does a Select Max(id) prior to the insert.

Sorry for the confusion... Increment is the generator cloass that is being set. So instead of using

<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="native" />
</id>
or
<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="identity" />
</id>
I am forced to use:
<id name="id" column="id" type="integer" unsaved-value="0" >
<generator class="increment" />
</id>

Which is not cluster safe and does a Select Max(id) prior to the insert.

Pkourinos,

This usage case has been working for me, not sure what is wrong. You are setting an unsaved value of 0, is this what you are using in your new objects?

Marius