Re: CallableStatement.getParameterMetaData() throws exception for valid {call ...} statement

dmp wrote on 30.05.2015 21:50:
> Seems to work fine, maybe I have it wrong?
>

interesting, your code indeed works.

After playing around with it, the difference is that I call getParameterMetaData() *before* calling registerOutParameter().

This works:

cstmt = connection.prepareCall("{call sum_n_product(?,?,?,?)}");

cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.setInt(1, 2);
cstmt.setInt(2, 5);

cstmt.execute();

meta = cstmt.getParameterMetaData();

This also works:

cstmt = connection.prepareCall("{call sum_n_product(?,?,?,?)}");

cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.registerOutParameter(4, Types.INTEGER);

meta = cstmt.getParameterMetaData();

cstmt.setInt(1, 2);
cstmt.setInt(2, 5);

cstmt.execute();

This does NOT work:

cstmt = connection.prepareCall("{call sum_n_product(?,?,?,?)}");

meta = cstmt.getParameterMetaData(); -- right after preparing the statement!

cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.setInt(1, 2);
cstmt.setInt(2, 5);

cstmt.execute();

So getParameterMetaData() seems to only work after all OUT parameters have been registered (I also tried calling it after the first registerOutParameter() - failed as well).

So how can I retrieve the information about the parameters if I can't call getParameterMetaData() before registering the parameters (which I try to detect by calling that method). The JDBC JavaDocs do not mention such a restriction.

Thomas