java.sql.SQLException

tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Update MySQL table from jsp
    via Stack Overflow by vishnu
    ,
  • Upgrade problems
    via by RichardP,
  • MySQL and REST API issue
    via by neyric,
    • java.sql.SQLException: Got temporary error 221 'Too many concurrently fired triggers (increase MaxNoOfFiredTriggers)' from NDBCLUSTER at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)[mysql-connector-java-5.1.29-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1748)[mysql-connector-java-5.1.29-bin.jar:na] at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:981)[c3p0-0.9.5.1.jar:0.9.5.1] at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112)[hibernate-core-4.1.0.Final.jar:4.1.0.Final] at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:178)[hibernate-core-4.1.0.Final.jar:4.1.0.Final]

    Users with the same issue

    mortalman7
    1 times, last one,
    Unknown visitor1 times, last one,
    ivanszkypeter
    470 times, last one,
    linxiaolong
    1 times, last one,
    rocday
    1 times, last one,
    145 more bugmates