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 | 5 months ago
  1. 0

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

    mysql.com | 1 year 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 | 5 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 | 1 year 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.
  6. 0

    Interface without a source datastore

    Oracle Community | 9 years ago | 561732
    java.sql.SQLException: Unexpected token: SELECT in statement [insert into DIFF__I$_FILE_ ( ) select from where (1=1)]

    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

      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