MySQL, stored procedures and callable statements

admin 2

The stable 3.x versions of MySQL don’t support stored procedures. Consequently the associated JDBC driver can’t support callable statements. The alpha 4.x versions don’t support stored procedures either, but support for stored procedures (and therefore callable statements) is announced for the development 5.x versions at this time of writing.

This info can be important when you consider e.g. to replace an Oracle DB of an application with a MySQL DB.

2 thoughts on “MySQL, stored procedures and callable statements

  1. hi

    Can anyone help me to resolve this error………

    method cannot be resolved ,
    registerOutParameter(5,”dsadfs”)’;Im using CallableStatements

    while executing a JDBC Connection program with java and using procedures.

Comments are closed.

Next Post

End of an era (for me): Oracle SCM State of Direction

Facebook0TwitterLinkedinIt does not come as a great surprise, yet I feel sad. Oracle’s Statement of Direction on Oracle SCM declares the product ‘dead as a dodo’. Well, not quite. No new features will be added, yet the tool will be supported for a long time to come, along with Designer […]