org.hibernate.exception.DataException: could not execute native bulk manipulation query

使用hibernatede 时遇到了下面的错误。google了一下,只要在连接字符串中设置

<property name="connection.url">jdbc:mysql://localhost:4406/wrzl?jdbcCompliantTruncation=false</property>

属性即可。问题解决,不知到有没有副作用。观察中。。。。。。。

native

  • adj. 本国的;土著的;天然的;与生俱来的;天赋的
  • n. 本地人;土产;当地居民
manipulation
  • n. 操纵;操作;处理;篡改

bulk

  • n. 体积,容量;大多数,大部分;大块
  • vt. 使扩大,使形成大量;使显得重要

 // 执行原生的insert 等SQL语句
    public void executeUpdateSql(String sql) throws HibernateException, SQLException {       
        Session session = getSession();
        Transaction ts = null;
        try {
            ts = session.beginTransaction();
            SQLQuery query = session.createSQLQuery(sql);
            query.executeUpdate();           
            ts.commit();
            //log.debug("save successful");
        } catch (RuntimeException re) {
            //log.error("save failed", re);
            ts.rollback();
            throw re;
        } finally{
            closeSession();
        }
    }

2011-8-29 13:40:16 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: Data truncation: Out of range value for column 'XST_jbqyxzt1' at row 120
org.hibernate.exception.DataException: could not execute native bulk manipulation query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)
    at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1191)
    at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)
    at cn.com.bcsoft.dao.BaseHibernateDAO.executeUpdateSql(BaseHibernateDAO.java:118)
    at cn.com.bcsoft.backgroud.Handler.insertDB(Handler.java:999)
    at cn.com.bcsoft.backgroud.Handler.run(Handler.java:209)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'XST_jbqyxzt1' at row 120
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3595)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)
    ... 8 more

posted on 2011-08-29 13:51  白开水易拉罐  阅读(25870)  评论(0编辑  收藏  举报