java.sql.SQLException

General error, message from server: "Too many tables. MySQL can only use 31 tables in a join"

Solutions on the web11531

  • via java2s.com by Unknown author, 9 months ago
    General error, message from server: "Too many tables. MySQL can only use 31 tables in a join"
  • General error, message from server: "Access denied for user: 'samurai@bithorax' to database 'mysql'"
  • General error: Warning: Some non-transactional changed tables couldn't be rolled back
  • Stack trace

    • java.sql.SQLException: General error, message from server: "Too many tables. MySQL can only use 31 tables in a join" at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1651) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:889) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:956) at com.mysql.jdbc.Connection.execSQL(Connection.java:1874) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1538) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:87) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:875) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:269) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)

    Write tip

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

    Users with the same issue

    689 times, 12 hours ago
    5 times, 2 weeks ago
    Once, 1 month ago
    Once, 2 months ago
    Once, 5 months ago
    21 more bugmates