Announcement Announcement Module
Collapse
No announcement yet.
Internal error when parsing callable statement metadata - mysql stored procedure Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Internal error when parsing callable statement metadata - mysql stored procedure

    I am using spring 2.5.6 on a legacy project to access a MySql Stored Procedure from a class which extends StoredProcedure. I've done this many times when working with Oracle but it's the first time I've done so when working with MySql.

    Running the app against my local tomcat works fine and the SP runs and records my records. It also works fine when I call the statement using Toad. However, when I deploy to our development server, which runs the same version of tomcat and mysql connectorj, I get the following error.

    Has anyone seen this before or have any ideas?

    Code:
    java.sql.SQLException: Internal error when parsing callable statement metadata
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
            at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1375)
            at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:3670)
            at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:702)
            at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
            at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4422)
            at com.mysql.jdbc.Connection.prepareCall(Connection.java:4496)
            at com.mysql.jdbc.Connection.prepareCall(Connection.java:4470)
    Thanks
Working...
X