找回密码
 立即注册

QQ登录

只需一步,快速开始

扫一扫,极速登录

帆软报表demo配置外接数据库失败

com.fr.third.org.hibernate.exception.GenericJDBCException: could not execute batch 
 at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) 
 at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) 
 at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) 
 at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) 
 at com.fr.third.org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) 
 at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:236) 
 at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:617) 
 at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:462) 
 at com.fr.third.org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) 
 at com.fr.third.org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) 
 at com.fr.third.org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1294) 
 at com.fr.third.org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:467) 
 at com.fr.third.org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3158) 
 at com.fr.third.org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2351) 
 at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:516) 
 at com.fr.third.org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.beforeCompletionCallback(JdbcResourceLocalTransactionCoordinatorImpl.java:147) 
 at com.fr.third.org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl.access$100(JdbcResourceLocalTransactionCoordinatorImpl.java:38) 
 at com.fr.third.org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:231) 
 at com.fr.third.org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:65) 
 at com.fr.stable.db.session.SessionManager$DBSessionImpl.commitTransaction(Unknown Source) 
 at com.fr.decision.migration.manager.AbstractTransferManager.copyTables(Unknown Source) 
 at com.fr.decision.migration.manager.AbstractTransferManager.transfer(Unknown Source) 
 at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(Unknown Source) 
 at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(Unknown Source) 
 at com.fr.decision.migration.MigrationContext$1.run(Unknown Source) 
 at java.lang.Thread.run(Thread.java:748) 
Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xE5\xAE\x9A\xE6\x97\xB6...' for column 'JOB_GROUP' at row 1 
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) 
 at com.mysql.jdbc.Util.getInstance(Util.java:387) 
 at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1161) 
 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773) 
 at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257) 
 at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958) 
 at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:558) 
 at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) 
 ... 23 more 
Caused by: java.sql.SQLException: Incorrect string value: '\xE5\xAE\x9A\xE6\x97\xB6...' for column 'JOB_GROUP' at row 1 
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963) 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) 
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) 
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) 
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549) 
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) 
 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073) 
 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751) 
 ... 27 more

具体报错如上


image.png

image.png

已配置数据库,表格已建,但是没有数据,应该是导入数据时的错误。

已更新最新版 FineReport

FineReporttinydata 发布于 2019-12-13 19:16
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
0
zsh331Lv7专家互助
发布于2019-12-13 19:31
  • cntouch cntouch 解决方案测试有效,谢谢
    2020-06-01 10:54 
  • 2关注人数
  • 1097浏览人数
  • 最后回答于:2019-12-13 19:31
    请选择关闭问题的原因
    确定 取消

    联系社区管理员|联系帆软|《帆软社区协议》|手机版|帆软社区|Copyright © 帆软软件有限公司 ( 苏ICP备18065767号-7 )

    GMT+8, 2021-6-23 10:06 , Processed in 0.159234 second(s), 38 queries , Gzip On.

    返回顶部