Java JDBC NumberFormatException: For input string


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

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!

Solution:

Replace getInt() with getString()

Java.lang.NumberFormatException- For input string


Have Questions? Post them here!
Advertisements
Try Out Code2care Dev Tools:

Advertisements

Advertisements
Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and software developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include learnings, tutorials, trouble-shooting steps, video tutorials, code snippets, how-to, blogs, articles, etc.

🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.