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.

  • Strange SQLException: Column not found
    via Stack Overflow by akafortes
    ,
  • Before start of result set
    via Stack Overflow by BalaYesu Ch.
    ,
  • SQL ResultSet closing suddently
    via Stack Overflow by Tom Lima
    ,
  • SQL exception before Start (with .next())
    via Stack Overflow by bateras
    ,
    • java.sql.SQLException: Column Index out of range, 2 > 1. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ResultSetImpl.checkColumnBounds(ResultSetImpl.java:831) at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5774) at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5693) at mmtc.Dashboard.<init>(Dashboard.java:79)

    Users with the same issue

    ivanszkypeter
    4 times, last one,
    Unknown visitor1 times, last one,
    jstrayer
    4 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    145 more bugmates