外部数据库配置5.7.16报错

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(Unknown Source)

Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x8C\x99++...' for column 'realAlias' at row 1

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.Util.getInstance(Util.java:408)

at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1162)

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1778)

at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1262)

at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:970)

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: '\xF0\x9F\x8C\x99++...' for column 'realAlias' at row 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)

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

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

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

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

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2487)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)

at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)

at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1756)

... 27 more

FineBI wenglei 发布于 2021-7-7 15:24
1min目标场景问卷 立即参与
回答问题
悬赏:4 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共1回答
最佳回答
0
zsh331Lv8专家互助
发布于2021-7-7 15:28

外接数据库配置常见问题-https://help.fanruan.com/finebi/doc-view-529.html

——————————————

image.png

  • wenglei wenglei(提问者) 是按照这个操作的,但还是报 Caused by: java.sql.SQLException: Incorrect string value: \'\\xF0\\x9F\\x8C\\x99++...\' for column \'realAlias\' at row 1 ,网上查了一些,都是修改编码格式
    2021-07-07 15:32 
  • zsh331 zsh331 回复 wenglei(提问者) 编码和引擎都有可能,文档有相关介绍,参考下~
    2021-07-07 15:38 
  • wenglei wenglei(提问者) 回复 zsh331 嗯,我再研究下
    2021-07-07 15:39 
  • 2关注人数
  • 305浏览人数
  • 最后回答于:2021-7-7 15:28
    请选择关闭问题的原因
    确定 取消
    返回顶部