|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.