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()
Have Questions? Post them here!
More Posts related to Java,
- Java JDBC Connection with Database using SSL (https) URL
- [Solution] IntelliJ: Cannot find declaration to go to, Nothing here, Java file outside of source root Errors
- Java get day of the week as an int using DayOfWeek
- Your JBoss Application Server 7 is running However you have not yet added any users to be able to access the admin console
- Convert Instant timestamp into LocalDateTime Java Code Example
- [Program] How to read three different values using Scanner in Java
- [Java] NoClassDefFoundError Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory
- Read and Parse XML file using Java DOM Parser [Java Tutorial]
- Truncate table using Java JDBC Example
- Add two numbers using Java Generics
- Spring Boot Web + Thymeleaf Hello World Example in IntelliJ in 5 Easy Steps
- Java JDBC Connection with MySQL Driver in VS Code + Troubleshooting
- Java SE JDBC with Prepared Statement Parameterized Select Example
- Java JDBC Batch Update Example with PreparedStatement
- Convert String to int in Java
- How to declare and initialize Array in Java Programming
- Java 8 Predicate Functional Interface Examples
- [fix] The declared package does not match the expected package
- Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end users experience
- [Fix] java: integer number too large compilation error
- List of Java Keywords
- Tutorial Java SOAP WebServices JAS-WS with Eclipse J2EE IDE and Tomcat Server Part 1
- JBoss stuck loading JBAS015899: AS 7.1.1.Final Brontes starting
- Java java.time.Clock class code examples [Java Date Time API]
- Java monitoring and management console [jconsole]
More Posts:
- Git Config Command - A Deep Dive - Git
- Show Notepad++ tabs in multiple lines instead of scroll on tab bar - NotepadPlusPlus
- How to display Toast in a thread : Android - Android
- Convert Float to String in Python - Python
- How to search (find) in macOS Terminal Console Text - MacOS
- [Fix] Restricted View permission level missing in SharePoint Online site library - SharePoint
- Check if String Contains a Substring - Python - Python
- Calculate Sum of List elements using Java Streams - Java