Re: modification required to pass Sun's CTS - Mailing list pgsql-jdbc

Dave Cramer wrote:

>                         cstmt = conn.prepareCall("{call Numeric_Proc
> (?,?,?)}");
>
>                         msg.setMsg("Register the output parameter");
>                         cstmt.registerOutParameter
> (1,java.sql.Types.NUMERIC,15);
>                         cstmt.registerOutParameter
> (2,java.sql.Types.NUMERIC,15);
>                         cstmt.registerOutParameter
> (3,java.sql.Types.NUMERIC,15);
>
>                         msg.setMsg("execute the procedure");
>                         cstmt.executeUpdate();

Ok, so that is exactly the case I was talking about, a procedure that
doesn't return a value or resultset, but has OUT parameters. We should
mask the resultset we get from the backend in this case as it's just an
implementation detail of our OUT mechanism. (i.e. executeUpdate() does
not complain, executeQuery() does complain, etc)

-O