Field 'ID' doesn't have a default value: org.hibernate.exception.GenericJDBCException: could not ins

[Baktha Elumalai]

Hi

I have two table like xydataa and fm4featuress

xydataa.hbm.cml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 19, 2010 4:59:08 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class catalog="navl" name="test.Xydataa" table="xydataa">
<id name="id" type="java.lang.Integer">
<column name="ID"/>
<generator class="native"/>
</id>
<property name="longi" type="string">
<column name="Longi"/>
</property>
<property name="lat" type="string">
<column name="Lat"/>
</property>
<property name="altitude" type="int">
<column name="Altitude" not-null="true"/>
</property>
<property name="angle" type="int">
<column name="Angle" not-null="true"/>
</property>
<property name="satellite" type="int">
<column name="Satellite" not-null="true"/>
</property>
<property name="speed" type="int">
<column name="Speed" not-null="true"/>
</property>
<property name="objectId" type="int">
<column name="ObjectId" not-null="true"/>
</property>
<property name="clientId" type="int">
<column name="ClientId" not-null="true"/>
</property>
<property name="gpsTime" type="string">
<column length="19" name="GpsTime" not-null="true"/>
</property>
<property name="location" type="string">
<column name="Location"/>
</property>
<property name="city" type="string">
<column name="City"/>
</property>
<property name="state" type="string">
<column name="State"/>
</property>
<property name="distance" type="string">
<column length="100" name="Distance"/>
</property>
<property name="times" type="timestamp">
<column length="19" name="Times"/>
</property>
<many-to-one name="fm4featuress" class="test.Fm4Featuress" cascade="all" insert="false" update="false">
<column name="ID" not-null="false" />
</many-to-one>
</class>
</hibernate-mapping>

and

fm4featuress.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 19, 2010 4:59:08 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class catalog="navl" name="test.Fm4Featuress" table="fm4featuress">
<id name="id" type="java.lang.Integer">
<column name="ID"/>
<generator class="native"/>
</id>
<property name="DataId" type="int">
<column name="DataId" not-null="true"/>
</property>
<property name="Value" type="int">
<column name="Value" not-null="true"/>
</property>
<set name="xydataa" table="xydataa" lazy="false">
<key>
<column name="ID" not-null="true"/>
</key>
<one-to-many class="test.Xydataa" />
</set>
</class>
</hibernate-mapping>


java code:

package test;
// Generated Mar 27, 2010 2:31:16 PM by Hibernate Tools 3.2.1.GA


import java.util.Date;
import java.util.HashSet;
import java.util.Set;

/**
 * Xydata generated by hbm2java
 */
public class Xydataa  implements java.io.Serializable {


     private Integer id;
     private String longi;
     private String lat;
     private int altitude;
     private int angle;
     private int satellite;
     private int speed;
     private int objectId;
     private int clientId;
     private String gpsTime;
     private String location;
     private String city;
     private String state;
     private String distance;
     private Date times;

    public Xydataa() {
    }


    public Xydataa(int altitude, int angle, int satellite, int speed, int objectId, int clientId, String gpsTime, Date times) {
        this.altitude = altitude;
        this.angle = angle;
        this.satellite = satellite;
        this.speed = speed;
        this.objectId = objectId;
        this.clientId = clientId;
        this.gpsTime = gpsTime;
        this.times = times;
    }
    public Xydataa(String longi, String lat, int altitude, int angle, int satellite, int speed, int objectId, int clientId, String gpsTime, String location, String city, String state, String distance, Date times) {
       this.longi = longi;
       this.lat = lat;
       this.altitude = altitude;
       this.angle = angle;
       this.satellite = satellite;
       this.speed = speed;
       this.objectId = objectId;
       this.clientId = clientId;
       this.gpsTime = gpsTime;
       this.location = location;
       this.city = city;
       this.state = state;
       this.distance = distance;
       this.times = times;
    }

    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }
    public String getLongi() {
        return this.longi;
    }

    public void setLongi(String longi) {
        this.longi = longi;
    }
    public String getLat() {
        return this.lat;
    }

    public void setLat(String lat) {
        this.lat = lat;
    }
    public int getAltitude() {
        return this.altitude;
    }

    public void setAltitude(int altitude) {
        this.altitude = altitude;
    }
    public int getAngle() {
        return this.angle;
    }

    public void setAngle(int angle) {
        this.angle = angle;
    }
    public int getSatellite() {
        return this.satellite;
    }

    public void setSatellite(int satellite) {
        this.satellite = satellite;
    }
    public int getSpeed() {
        return this.speed;
    }

    public void setSpeed(int speed) {
        this.speed = speed;
    }
    public int getObjectId() {
        return this.objectId;
    }

    public void setObjectId(int objectId) {
        this.objectId = objectId;
    }
    public int getClientId() {
        return this.clientId;
    }

    public void setClientId(int clientId) {
        this.clientId = clientId;
    }
    public String getGpsTime() {
        return this.gpsTime;
    }

    public void setGpsTime(String gpsTime) {
        this.gpsTime = gpsTime;
    }
    public String getLocation() {
        return this.location;
    }

    public void setLocation(String location) {
        this.location = location;
    }
    public String getCity() {
        return this.city;
    }

    public void setCity(String city) {
        this.city = city;
    }
    public String getState() {
        return this.state;
    }

    public void setState(String state) {
        this.state = state;
    }
    public String getDistance() {
        return this.distance;
    }

    public void setDistance(String distance) {
        this.distance = distance;
    }
    public Date getTimes() {
        return this.times;
    }

    public void setTimes(Date times) {
        this.times = times;
    }

   private Set Fm4Featuress;

   public Set getfm4featuress() {
      return this.Fm4Featuress;
   }

   public void setfm4featuress(Set id) {
      this.Fm4Featuress = Fm4Featuress;
   }

   // helper method to maintain bi-directional relationship
   public void addFm4Feature(Fm4Featuress fm4featuress) {
      this.Fm4Featuress.add(fm4featuress);
      fm4featuress.setXydataa(this);
   }

  
}

Fm4featuress.java

package test;
// Generated Mar 19, 2010 4:59:06 PM by Hibernate Tools 3.2.1.GA


import java.util.Date;

public class Fm4Featuress  implements java.io.Serializable {


    private Integer ID;
    private Integer DataId;
    private Integer Value;


     public Fm4Featuress()
   {
    }

   public Fm4Featuress(int ID, int DataId, int Value)
   {
        this.ID = ID;
        this.DataId = DataId;
        this.Value = Value;
    }

    public Integer getId() {
        return this.ID;
    }

    public void setId(Integer ID) {
        this.ID = ID;
    }
    public void setDataId(Integer DataId) {
        this.DataId = DataId;
    }
        public Integer getDataId() {
        return this.Value;
    }

    public void setValue(Integer Value) {
        this.Value = Value;
    }

        public Integer getValue() {
        return this.Value;
    }

  Xydataa xydata;

   public Xydataa getXydataa() {
      return this.xydata;
   }

   public void setXydataa(Xydataa xydata) {
      this.xydata = xydata;
   }


}

this is the main java file

{
 DateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    DecimalNumber xx ;
    DecimalNumber yy ;
    Session sess = null;
    Transaction tr = null;
    sess = HibernateUtil.getSessionFactory().openSession();
      try
        {
          tr = sess.beginTransaction();
           Date resultdate = new Date(times);
           xx = new DecimalNumber(x,7);
           yy = new DecimalNumber(y,7);
           System.out.println("Inserting xydataa");
           Xydataa xy=new Xydataa();
           Fm4Featuress fm = new Fm4Featuress();
           Set fm1 = new HashSet();
           //xy.setId(null);
           xy.setLongi(xx+"");
           xy.setLat(yy+"");
           xy.setAltitude(altitude);
           xy.setAngle(angle);
           xy.setSatellite(satellites);
           xy.setSpeed(speed);
           xy.setObjectId(objectId);
           xy.setClientId(clientId);
           xy.setGpsTime(sdf.format(resultdate));
           xy.setLocation(location);
           xy.setCity(city);
           xy.setState(state);
           xy.setDistance(distance);
           sess.save(xy);
           System.out.println("Done");
           tr.commit();
          
          
           for (int i = 0; i < obj.length && obj[i] != 0; i++)
          {
           tr = sess.beginTransaction();
           int all = obj[i] - 1;
           System.out.println("Inserting Fm4Featuress");
           System.out.println("Xydata: "+xy.getId());
           fm.setId(xy.getId());
           fm.setDataId(all);
           fm.setValue(obja[i]);
           fm1.add(fm);
           xy.setfm4featuress(fm1);
           sess.save(xy);
           //sess.flush();
           //xy=(Xydataa)sess.merge(fm);
         //  xy.getfm4featuress();
         //  fm.getXydataa();
           sess.save(fm);
           //sess.flush();
          // tr.commit();
          }
        System.out.println("Commit");
        }catch(HibernateException exx)
        {
         Logger.getLogger(Alldatabase.class.getName()).log(Level.SEVERE, null, exx);

        }finally
        {
         sess.close();
         }
}

I got the error like this

Stacktrace

INFO: Inserting xydataa
INFO: Hibernate: insert into navl.xydataa (Longi, Lat, Altitude, Angle, Satellite, Speed, ObjectId, ClientId, GpsTime, Location, City, State, Distance, Times) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
INFO: Done
INFO: Inserting Fm4Featuress
INFO: Xydata: 3762
INFO: Hibernate: insert into navl.fm4featuress (DataId, Value) values (?, ?)
WARNING: SQL Error: 1364, SQLState: HY000
SEVERE: Field 'ID' doesn't have a default value
SEVERE: null
org.hibernate.exception.GenericJDBCException: could not insert: [test.Fm4Featuress]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
at tcplistener.Alldatabase.Database(Alldatabase.java:174)
at tcplistener.ModuleHandler.run(ModuleHandler.java:155)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: Field 'ID' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2696)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2105)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2398)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2316)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2301)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 18 more

please help me

what i am doing wrong in my code