Search code examples
javastored-proceduresjdbccallable-statementocpjp

Executing stored procedure from Java, other than with JDBC CallableStatement

I am preparing the Java 7 certification using one of the mock test suites available.

One of the test questions I stumbled upon is about the JDBC CallableStatement class, and one of the correct answers (according to the tool) is:

A CallableStatement is the only way for a Java program to execute stored procedures in the database if the procedure has in and out parameters.

This seems very presumptuous to me and I was wondering if there are existing libraries out there (maybe proprietary db libraries for instance) which allow running stored procedures without JDBC?

Solution

  • MyBatis, Hibernate/JPA and other open source framework all use JDBC under the table.