#309 Spring JDBC Call with return not suported

[gbonk]

Note: related to https://sourceforge.net/p/hsqldb/feature-requests/280/

Getting exception when using Spring's SimpleJdbcCall....

org.springframework.dao.TransientDataAccessResourceException: CallableStatementCallback; SQL [{? = call PAR3214.VOID_ALLOCATION(?, ?, ?)}]; Invalid argument in JDBC call: Not OUT or INOUT mode: 1 for parameter: 1; nested exception is java.sql.SQLException: Invalid argument in JDBC call: Not OUT or INOUT mode: 1 for parameter: 1
...snip...
Caused By 

HsqlException: Invalid argument in JDBC call: Not OUT or INOUT mode: 1 for parameter: 1

Spring hard codes the format of the callable statement to begin with "{? = call" which is explicitly not supported by the org.hsqldb.jdbc.JDBCConnection method of nativeSQL

[gbonk]

I boiled it down to just JDBC and I'm still having the issue...

~~~~~~~~~~~~~~~~~

        Connection c = jdbcTemplate.getDataSource().getConnection();

        String sql = "{?= call PAR3214.VOID_ALLOCATION(?, ?, ?)}";

        CallableStatement  s = c.prepareCall(sql);

        s.registerOutParameter(1, Types.VARCHAR);
        s.setLong(2, fromLocation);
        s.setString(3, controlNumber);
        s.setString(4, controlNumber);

        boolean b = s.execute();

~~~~~~~~~~~~~~~~~~~~~~

tried this is 2.2.9 and 2.3.2 and it fails in both. This example works fine in oracle. We are using JDK 5