Re: Bad data in JDBC ResultSet

--




For Case 2. DECIMAL length 8 scale 2.
File Data = Hex 4040404040 (Blank)

s = rs.getString(j) can not be tested for blank because the string s has a value
of 4040404.04 and a length of 10. Presumably this is because the class sees this
as DECIMAL rather CHAR.
Also, I'm surprised that rs.getBigDecimal(j) does not throw an SQLException for
this case otherwise how can it be trapped?

Thanks

Keith
|+-------------------------------+--------------------------------------------|
||   Christian Geisert           |                                            |
||   <christian.geisert@isu-gmbh.|
--

        To:        java400-l@midrange.com|
||   de>                         |           cc:        (bcc: Keith           |
||                               |   McCully/Wunderman/GB)                    |
||   04/09/02 16:33              |           Subject:        Re: Bad data in  |
||   Please respond to java400-l |   JDBC ResultSet                           |
||                               |                                            |
|+-------------------------------+--------------------------------------------|










[IMAGE]
Keith_McCully@wunderman.co.uk schrieb:
[..]
> I've tried :
>
> BigDecimal  bd = rs.getBigDecimal(j) //- rs is ResultSet and j column index.
>
> followed by catch SQLException.
>
> Case 1. DECIMAL length 4 scale 2.
> File Data = Hex D5E8D5 (YNY)
> Is caught by above and handled OK by setting to zero.
>
> Case 2. DECIMAL length 8 scale 2.
> File Data = Hex 4040404040 (Blank)
> No exception thrown.
>
> I am looking for a test for case 2 that can identify blank so I can set the
> result  to zero.
>
> Any suggestions much appreciated.

Use s = rs.getString(j) and test it for blank and then
bd = new BigDecimal(s) and check for a NumberFormatException

Christian

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


(Embedded image moved to file: pic06418.pcx)
--
[ pic06418.pcx of type application/octet-stream deleted ]
--