Java JDBC NumberFormatException: For input string

Stack Trace:
Exception in thread "main" java.lang.NumberFormatException: For input string: "Mike"
 at sun.misc.FloatingDecimal.readJavaFormatString(
 at sun.misc.FloatingDecimal.parseDouble(
 at java.lang.Double.parseDouble(
 at com.mysql.cj.protocol.a.MysqlTextValueDecoder.getDouble(
 at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(
 at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(
 at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(
 at Sample.main(

This Exception occurs when you are trying to iterate over the ResultSet Object and making use of the getInt() method instead of getString(), the column in the Database table is a String and not a Number!


Replace getInt() with getString()

Java.lang.NumberFormatException- For input string

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap