原来是连Oracle的，昨天改成MySQL，重新建的表，不知道哪出错了。。
真诚请教。。
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: insert into huanghz (reason, amount, bank, type, pid) values (?, ?, ?, '卡', ?)
Exception in thread "main" org.hibernate.exception.DataException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:202)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:91)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:86)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:171)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2048)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at huanghz.biz.test.OneTablePerclass.main(OneTablePerclass.java:18)
Caused by: java.sql.BatchUpdateException: Out of range value adjusted for column 'pid' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1566)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)

package huanghz.biz.test;
import org.hibernate.Session;
import org.hibernate.Transaction;

import huanghz.biz.entity.CarPayment;
import huanghz.biz.entity.CashPayment;
import huanghz.biz.entity.Payment;
import Util.HbnUtil;
public class OneTablePerclass {
public static void main(String[] args) {
Payment car=new CarPayment("吹黑哨被罚",10000,"中国农业银行");
Payment cash=new CashPayment("把钱扔地上了",100,"日元");

Session s=HbnUtil.getSession();
Transaction tran=s.beginTransaction();//at huanghz.biz.test.OneTablePerclass.main(OneTablePerclass.java:18)
s.save(car);
s.save(cash);
tran.commit();
s.close();
}
}

[此贴子已经被作者于2007-5-17 22:31:37编辑过]