Locating JDBC Issues
The main causes of JDBC issues are as follows:
- Applications or application framework errors
- JDBC function errors
- Improper database configurations
There are mainly three types of JDBC issues:
- An error is reported during execution, and JDBC throws an exception.
- The execution duration is abnormally long.
- A feature is not supported. The JDBC has not implemented the required JDK interface.
The following table describes JDBC issues in detail.
| Type | Cause |
|---|---|
| The JDBC client configuration is incorrect. For example, the URL format is incorrect, or the user name or password is incorrect. | |
| The network is abnormal. | |
| A JAR package conflict occurs. | |
| The database configuration is incorrect. The remote access permission has not been configured for the database. | |
| The input SQL statement is incorrect and is not supported by the kernel. | |
| The kernel has a bug. An error occurs during service processing, and an abnormal packet is returned. | |
| Network fault. | |
| The database connection times out, and the socket is closed. | |
| The SQL execution by the kernel is slow. | |
| The result set is too large. As a result, the application segment responds slowly. | |
| The passed SQL statement is too long and the JDBC parsing is slow. | |
| The JDK does not provide standard APIs. | |
| The JDBC does not implement the APIs. |
Last Article: JDBC Connection Error Message
Next Article: Database Connection Fails
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.