Re: NumberFormatException?

[dawall@xxxxxxxxxx]

Are you trying to convert a packed decimal?  It looks like an attempt to
convert a packed decimal to a Java object and the bytes in question have a
bad sign nibble.  This is probably a db problem (time to check with AS/400
Service to see if it is a known problem).

David Wall
AS/400 Toolbox for Java


"Luther Ananda Miller" <luther.miller@HYPERE.COM> on 02/08/2000 09:56:16 AM

Please respond to JAVA400-L@midrange.com

To:   "L-JAVA400@midrange.com" <JAVA400-L@midrange.com>
cc:
Subject:  NumberFormatException?




I have a field in a table which is decimal (10,0). Field values are
populated with 10 digit decimal values. When I run a very simple select
query (Toolbox JDBC V4R2M0 latest-SF59803), and then try and retrieve one
of
the value, I get a NumberFormatException being generated in the toolbox
drivers themselves.

Here is some of the trace output in addition to the exception:

as400: Connection XXX: Setting server NLV = 2924.
as400: Connection XXX: Using extended datastreams.
as400: Connection XXX: Server CCSID = 37.
as400: Properties : decimal separator = ".".
as400: Properties : date separator = ".".
as400: Properties : time separator = ":".
as400: Connection XX open.
as400: Connection XX: Auto commit = "true".
as400: Connection XX: Read only = "false".
as400: Connection XX: Transaction isolation = "2".
as400: Connection XX: SQL package = QGPL/EASY400FCI.
getConnection returning
driver[className=com.ibm.as400.access.AS400JDBCDriver,context=null,DB2 for
OS/400 JDBC Driver]
...
as400: Statement STMT0002 open.
as400: Statement STMT0002: Escape processing = "true".
as400: Statement STMT0002: Fetch direction = "1000".
as400: Statement STMT0002: Fetch size = "0".
as400: Statement STMT0002: Max field size = "0".
as400: Statement STMT0002: Max rows = "0".
as400: Statement STMT0002: Query timeout = "0".
as400: Statement STMT0002: Result set conncurrency = "1007".
as400: Statement STMT0002: Result set type = "1003".
...
as400: Statement STMT0002: Update count = -1.
as400: Statement STMT0002: Result set = true.
as400: Statement STMT0002: Number of result sets = 0.
...
java.lang.NumberFormatException: 275
 java.lang.Throwable(java.lang.String)
 java.lang.Exception(java.lang.String)
 java.lang.RuntimeException(java.lang.String)
 java.lang.IllegalArgumentException(java.lang.String)
 java.lang.NumberFormatException(java.lang.String)
 java.lang.Object com.ibm.as400.access.AS400PackedDecimal.toObject(byte [],
int)
 void com.ibm.as400.access.SQLDecimal.convertFromRawBytes(byte [], int,
com.ibm.as400.access.Converter)
 com.ibm.as400.access.SQLData
com.ibm.as400.access.JDServerRow.getSQLData(int)
 com.ibm.as400.access.SQLData
com.ibm.as400.access.AS400JDBCResultSet.getValue(int)
 java.math.BigDecimal
com.ibm.as400.access.AS400JDBCResultSet.getBigDecimal(int, int)
 java.math.BigDecimal
com.ibm.as400.access.AS400JDBCResultSet.getBigDecimal(java.lang.String,
int)

Any ideas?

luther.miller @ hypere.com

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---