java.sql.SQLException: Access denied; you need the RELOAD privilege for this ope ration

opengts | miguelocepeda | 8 years ago
  1. 0

    Problems with MYSQL

    opengts | 8 years ago | miguelocepeda
    java.sql.SQLException: Access denied; you need the RELOAD privilege for this ope ration
  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

    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
  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

      Access denied; you need the RELOAD privilege for this ope ration

      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