JDBC Connection Issues Solutions

• JDBC “java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver”
• JDBC “java.sql.SQLException: ORA-01005: null password given; logon denied”
• [Solved] JDBC : com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
• [Solved] JDBC: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near…
• [Solved] org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: null

Database Queries Issues Solutions

• [Solved] JDBC: java.sql.SQLException: Can’t drop database ‘database_name’; database doesn’t exist
• [solved] org.h2.jdbc.JdbcSQLSyntaxErrorException: Column count does not match

Batch Update Issues Solutions

• [Solved] java.sql.BatchUpdateException: Data truncation

Other JDBC Issues

• [Solved] java.lang.ClassNotFoundException: org.hsqldb.jdbcDriver
• [Solved] java.sql.SQLSyntaxErrorException: unexpected token: XYZ
• [Solved] com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
• [Solved] java.sql.SQLException: No suitable driver
• [Solved] com.microsoft.sqlserver.jdbc. SQLServerException: Invalid object name ‘dual’
• [Solved] JDBC : java.sql.SQLSyntaxErrorException: Unknown database ‘database_name’
• [Solved] java.sql.SQLException: ORA-28000: the account is locked

---