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 | 1 year ago
  1. 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;
  2. 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"
  3. 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"
  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

    Openreports 3.0 not running after deployed

    oreports | 9 years ago | blurfish
    org.quartz.SchedulerConfigException: Failure occured during job recovery. \[See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ? 1 ?: ?? DECLARE CURSOR ????? FOR UPDATE ??? \[See nested exception: java.sql.SQLException: ? 1 ?: ?? DECLARE CURSOR ????? FOR UPDATE ???\]\]

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