Hello!
I'm using DB2 8.1. When I'm calling getBigDecimal method in CallableStatement (like:
Code:
CallableStatement cal = con.prepareCall("{call TEST_DECIMAL(?)}");
cal.registerOutParameter(1,Types.DECIMAL,2);
cal.execute();
System.out.println(cal.getBigDecimal(1));
)
I'm getting exception:
Code:
java.lang.NumberFormatException: For input string: "8,54"
because DB2 JDBC Driver tries to convert string "8,54" (which is the right value of returned parameter) to BigDecimal, while BigDecimal constructor require that char '.' (not ',') to be coma.
Is there any way to get round this problem?
Kuba Królikowski
dBforums
>
[JDBC] CallableStatement.getBigDecimal
05-08-04, 12:42
Linear Mode
