java.lang.RuntimeException: java.sql.SQLException: Specified key was too long. Max key length is 500

Apereo Issues | Elliot Metsger | 10 years ago
  1. 0

    Running ant initportal produces: <snip> compile: gapcreatedb: [echo] Invoking CreateTables [java] Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Specified key was too long. Max key length is 500 [java] at org.jasig.gap.db.DbUtils.jdbcExecuteStatement(DbUtils.java:98) [java] at org.jasig.gap.db.AbstractJdbcDao.primExecute(AbstractJdbcDao.java:74) [java] at org.jasig.gap.db.AbstractJdbcDao.createBackingStore(AbstractJdbcDao.java:43) [java] at org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:219) [java] at org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:170) [java] at org.jasig.gap.db.DbInit.main(DbInit.java:137) [java] Caused by: java.sql.SQLException: Specified key was too long. Max key length is 500 [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:3020) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1074) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1008) [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) [java] at org.jasig.gap.db.DbUtils.jdbcExecuteStatement(DbUtils.java:89) [java] ... 5 more [java] Java Result: 1

    Apereo Issues | 10 years ago | Elliot Metsger
    java.lang.RuntimeException: java.sql.SQLException: Specified key was too long. Max key length is 500
  2. 0

    Running ant initportal produces: <snip> compile: gapcreatedb: [echo] Invoking CreateTables [java] Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Specified key was too long. Max key length is 500 [java] at org.jasig.gap.db.DbUtils.jdbcExecuteStatement(DbUtils.java:98) [java] at org.jasig.gap.db.AbstractJdbcDao.primExecute(AbstractJdbcDao.java:74) [java] at org.jasig.gap.db.AbstractJdbcDao.createBackingStore(AbstractJdbcDao.java:43) [java] at org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:219) [java] at org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:170) [java] at org.jasig.gap.db.DbInit.main(DbInit.java:137) [java] Caused by: java.sql.SQLException: Specified key was too long. Max key length is 500 [java] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695) [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:3020) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1074) [java] at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1008) [java] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) [java] at org.jasig.gap.db.DbUtils.jdbcExecuteStatement(DbUtils.java:89) [java] ... 5 more [java] Java Result: 1

    Apereo Issues | 10 years ago | Elliot Metsger
    java.lang.RuntimeException: java.sql.SQLException: Specified key was too long. Max key length is 500
  3. 0

    Can't make successful connection to mysql database using java

    Stack Overflow | 8 months ago | Maria Boluda
    java.sql.SQLException: No database selected
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problems with MYSQL

    opengts | 8 years ago | miguelocepeda
    java.sql.SQLException: Access denied; you need the RELOAD privilege for this ope ration
  6. 0

    SqlExeption: After End of Result Set

    Coderanch | 3 months ago | tushar attar
    java.sql.SQLException: Duplicate entry '567' for key 'orderno_UNIQUE'

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Specified key was too long. Max key length is 500

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      Statement.executeUpdate
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
      4. com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
      5. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1074)
      6. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1008)
      6 frames
    3. Commons DBCP
      DelegatingStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
      1 frame
    4. org.jasig.gap
      DbInit.main
      1. org.jasig.gap.db.DbUtils.jdbcExecuteStatement(DbUtils.java:89)
      2. org.jasig.gap.db.AbstractJdbcDao.primExecute(AbstractJdbcDao.java:74)
      3. org.jasig.gap.db.AbstractJdbcDao.createBackingStore(AbstractJdbcDao.java:43)
      4. org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:219)
      5. org.jasig.gap.db.DbInit.createBackingStore(DbInit.java:170)
      6. org.jasig.gap.db.DbInit.main(DbInit.java:137)
      6 frames