Re: JDBC CallableStatement bug on functions with return parameter - Mailing list pgsql-jdbc

(Please do not top-post.)

John LH wrote:
>
> I create the CallableStatement with this :
>
> callStatement = conn.prepareCall("{ ? = CALL "public"."sales_tax"(?) }");
>
> For the return parameter I use :
>
> callStatement.registerOutParameter(1, java.sql.Types.FLOAT);
>
> For the function parameter I use :
>
> callStatement.setObject(2, new Float(25.25));

You do realize that 'float' ('Float') is pretty much the worst type to use for
monetary facts, right?


--
Lew
Ceci n'est pas une fenêtre.
.___________.
|###] | [###|
|##/  | *\##|
|#/ * |   \#|
|#----|----#|
||    |  * ||
|o *  |    o|
|_____|_____|
|===========|