Hibernate:
/* insert cn.jbit.bid.entity.Bidding
*/ insert
into
BIDS.BIDDING
(ITEMNAME, CONTENT, UPTOTIMES, STATE, BNUMBER)
values
(?, ?, ?, ?, ?)
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
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.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:339)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at cn.jbit.bid.test.BiddingTest.main(BiddingTest.java:40)
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247)
... 8 more
给为前辈们好,我是刚学习Hibernate的,我在向数据库插入一条数据的时候他就给我报这个错。我的主键是通过通过生成策略的assigned的属性。经过我的一番调试我发现在实体类中为String的属性为name的列不能添加中文 ,添加英文就可以成功的添加一条数据。所以想不出来是什么原因,希望前辈们指点!谢谢!
/* insert cn.jbit.bid.entity.Bidding
*/ insert
into
BIDS.BIDDING
(ITEMNAME, CONTENT, UPTOTIMES, STATE, BNUMBER)
values
(?, ?, ?, ?, ?)
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
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.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:339)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at cn.jbit.bid.test.BiddingTest.main(BiddingTest.java:40)
Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:247)
... 8 more
给为前辈们好,我是刚学习Hibernate的,我在向数据库插入一条数据的时候他就给我报这个错。我的主键是通过通过生成策略的assigned的属性。经过我的一番调试我发现在实体类中为String的属性为name的列不能添加中文 ,添加英文就可以成功的添加一条数据。所以想不出来是什么原因,希望前辈们指点!谢谢!
解决方案 »
- 关于数值型转换成货币型
- netbeans 调用新建的JPanel
- JBPM只能用在JBOSS下面吗?
- 政府门户网站的安全性架构设置
- 在struts中,怎样实现这样的Form?
- 寻会JAVA朋友帮做个小东东,所有分相送,谢谢
- JB编译时出现下列错误信息Cannot narrow remote object to com.dyzq.ejb.db.ConnPoolHome
- 搜索引擎的实现和算法
- tcp包数据监视
- 【求助】java线程同步相关问题
- jsp中,session内int型的值的传递与获取
- 高分求救:异常ognlException:source is null for getProperty(null, "valueStack")
而引发的抛出的异常!我还是第一次遇到这个问题!希望前辈们 帮我解决一下这个问题。
这是我创建的那张表:--创建表
create table bidding
(
bNumber varchar2(100) primary key,
itemName varchar2(100),
content varchar2(100),
uptoTimes Date ,
state varchar2(20)
);
state 为中文的时候不行,英文就可以。
Session session = HibernateUtil.getSession();
Transaction ti = session.beginTransaction();
Bidding bi2 = new Bidding();
bi2.setBnumber("ZB20011-01-03FDS");
bi2.setUptotimes(Date.valueOf("2008-2-23"));
bi2.setState("招标中");
try {
session.save(bi2);
ti.commit();
} catch (HibernateException e) {
ti.rollback();
e.printStackTrace();
}finally{
session.close();
}
仔细核对下你插入的数据,如类型长度等