java default t_异常引起的：java.sql.SQLException：一般错误，来自服务器的消息：" 字段'empid'没有默认值" (Exception Caused by: ja...

2016-01-08 00:42:43

0

My Model Class:

package com.igate.model;

import java.util.Date;

//import java.sql.Date;

import java.sql.Timestamp;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

@Entity

@Table(name="Employee")

public class Employee

{

@Id

@Column(name="empid")

@GeneratedValue(strategy=GenerationType.IDENTITY)

int id;

@Column(name="empname")

String name;

String job;

Date hiredate;

int sal;

int deptid;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getJob() {

return job;

}

public void setJob(String job) {

this.job = job;

}

public Date getHiredate() {

return hiredate;

}

public void setHiredate(Date hiredate) {

this.hiredate = hiredate;

}

public int getSal() {

return sal;

}

public void setSal(int sal) {

this.sal = sal;

}

public int getDeptid() {

return deptid;

}

public void setDeptid(int deptid) {

this.deptid = deptid;

}

public void setHiredate(Timestamp hiredate) {

this.hiredate = hiredate;

}

}

My cfg file:

/p>

"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test

root

MenhiBaba

org.hibernate.dialect.MySQLDialect

validate

true

My Error:

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.annotations.Version).

log4j:WARN Please initialize the log4j system properly.

Hibernate: insert into Employee (deptid, hiredate, job, empname, sal) values (?, ?, ?, ?, ?)

problem in creating session object

Exception in thread "main" java.lang.ExceptionInInitializerError

at Test.main(Test.java:37)

Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.igate.model.Employee]

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 Test.main(Test.java:27)

Caused by: java.sql.SQLException: General error, message from server: "Field 'empid' doesn't have a default value"

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2236)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1588)

at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)

at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)

... 16 more

Main method:

import java.sql.Date;

import org.hibernate.Session;

import org.hibernate.Transaction;

import com.igate.model.Employee;

import com.igate.utils.HibernateUtils;

public class Test

{

public static void main(String[] args) {

Session session =null;

Transaction txn = null;

try

{

session = HibernateUtils.getSessionFactory().openSession();

txn = session.beginTransaction();

txn.begin();

Employee emp = new Employee();

emp.setId(101);

emp.setName("Rahim");

emp.setJob("PO");

emp.setHiredate(new Date(24-11-2011));

emp.setSal(5500);

emp.setDeptid(20);

int i=(Integer)session.save(emp);

if(i>=0)

System.out.println("data saved");

else

System.out.println("data not saved");

txn.commit();

session.close();

}catch(Exception e)

{

System.out.println("problem in creating session object");

throw new ExceptionInInitializerError(e);

}

}

}

Before this i executed many programs but i did not get any problem.but i don't know what is problem in my code.i expended 2 hours on this simple program. Please anybody can help me ?

Thanks in advance.