AS/400 (iSeries) Data type mismatch – NumberFormatException
For iSeries users seeing a Data type mismatch. (class java.lang.NumberFormatException) error, adjusting the database connection string to include the correct CCSID will resolve any character set translation issues. For information on where to edit your database connection, consult the following: Where to Set Up Your Database Connection
For specific CCSID values, consult the following resource: https://www.ibm.com/docs/en/i/7.4?topic=information-ccsid-values-defined-i