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;

Google Groups | Lindley Smith | 2 years 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 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;
  2. 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"
  3. 0

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

    mysql.com | 7 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"
  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 linstructorid int; declare ltemplateusername varchar(50); declare ltemplateinstructorid int; declare lpermtemplateusername varchar(50); declare lpermtemplateinstructorid int;

      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. dbfit.api
      DbStoredProcedure.buildPreparedStatement
      1. dbfit.api.DbStoredProcedureCall.toStatementExecution(DbStoredProcedureCall.java:54)
      2. dbfit.api.DbStoredProcedure.buildPreparedStatement(DbStoredProcedure.java:27)
      2 frames
    4. dbfit.fixture
      DbObjectExecutionFixture.doRows
      1. dbfit.fixture.DbObjectExecutionFixture.doRows(DbObjectExecutionFixture.java:74)
      1 frame
    5. FitNesse
      Fixture.doTable
      1. fit.Fixture.doTable(Fixture.java:155)
      1 frame
    6. fitlibrary.traverse
      AlienTraverseHandler.doTable
      1. fitlibrary.traverse.AlienTraverseHandler.doTable(AlienTraverseHandler.java:18)
      1 frame
    7. fitlibrary.traverse.workflow
      DoTraverseInterpreter.interpretWholeTable
      1. fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:99)
      2. fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:87)
      2 frames
    8. fitlibrary
      DoFixture.interpretWholeTable
      1. fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:69)
      1 frame
    9. fitlibrary.suite
      InFlowPageRunner.run
      1. fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:34)
      1 frame
    10. fitlibrary
      DoFixture.interpretTables
      1. fitlibrary.DoFixture.interpretTables(DoFixture.java:42)
      1 frame
    11. dbfit
      DatabaseTest.interpretTables
      1. dbfit.DatabaseTest.interpretTables(DatabaseTest.java:26)
      1 frame
    12. FitNesse
      FitServer.main
      1. fit.Fixture.doTables(Fixture.java:80)
      2. fit.FitServer.process(FitServer.java:81)
      3. fit.FitServer.run(FitServer.java:56)
      4. fit.FitServer.main(FitServer.java:41)
      4 frames