java.sql.SQLException: java.lang.NumberFormatException: For input string: "11) BEGIN declare retval int(11); select count(*) into retval from x where id in (1"

mysql.com | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MySQL Bugs: #39510: Certain Stored Procedures Fail with a NumberFormatException

    mysql.com | 2 years ago
    java.sql.SQLException: java.lang.NumberFormatException: For input string: "11) BEGIN declare retval int(11); select count(*) into retval from x where id in (1"
  2. 0

    MySQL Bugs: #39510: Certain Stored Procedures Fail with a NumberFormatException

    mysql.com | 8 months ago
    java.sql.SQLException: java.lang.NumberFormatException: For input string: "11) BEGIN declare retval int(11); select count(*) into retval from x where id in (1"
  3. 0

    MySQL java.lang.NumberFormatException generated dependent on Stored Proc content

    Google Groups | 2 years ago | Lindley Smith
    java.sql.SQLException: java.lang.NumberFormatException: For input string: "11) BEGIN declare linstructorid int; declare ltemplateusername varchar(50); declare ltemplateinstructorid int; declare lpermtemplateusername varchar(50); declare lpermtemplateinstructorid int;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL - ADF (insert, update) | Oracle Community

    oracle.com | 2 years ago
    java.sql.SQLException: Unable to retrieve metadata for procedure.

    Root Cause Analysis

    1. java.sql.SQLException

      java.lang.NumberFormatException: For input string: "11) BEGIN declare retval int(11); select count(*) into retval from x where id in (1"

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      ConnectionImpl.prepareCall
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
      2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
      4. com.mysql.jdbc.Util.handleNewInstance(Util.java:430)
      5. com.mysql.jdbc.CallableStatement.getInstance(CallableStatement.java:505)
      6. com.mysql.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:3881)
      7. com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3965)
      8. com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3939)
      8 frames
    3. test
      TestBug.main
      1. test.TestBug.main(TestBug.java:16)
      1 frame