RE: Bigdecimal, result set question

["Clapham, Paul" <pclapham@xxxxxxxxxxxxx>]

You mean that the getBigDecimal method of ResultSet was deprecated?  How
about this:

BigDecimal rate = new BigDecimal(rs.getString(3));

As for your second question, there is a class called ResultSetMetaData that
can give you this sort of information.  But you might get away with simply
reading all fields via getString() and letting the spreadsheet figure out
what is numbers and what isn't.

PC2

-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
Sent: March 21, 2002 10:18
To: 'java400-l@midrange.com'
Subject: Bigdecimal, result set question


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
What object should I use in place of BigDecimal, since the compiler says
it's being deprecated?  ... I know I can turn the warning off, but I figure
there must be a better object for decimal (business) precision, if there
removing the object...


Also, when I retrieve a result set, how do I determine, its was defined on
the as/400 as a character or number, before I read the column.  I'm trying
to populate a spread sheet and want my program to work no matter what table
there reading, so I didn't want to hard code the column values...