JDBC数据库重连机制的研究与实现

ON JDBC DATABASE RECONNECTION MECHANISM AND ITS IMPLEMENTATION

JDBC是Java程序连接和访问各种数据库的API,由一组类和接口构成,提供了Java程序与各种数据库之间的连接服务。通过分析研究JDBC2.0接口原理以及现有数据库连接池在数据库重连技术方面的缺陷,提出了一种能进行自动重新连接数据库的策略。该策略运用循环检测机制,弥补了现有数据库连接池的不足。测试结果证明,数据库重连机制的策略能有效提高系统的健壮性和整体性能、减少系统维护量。

JDBC is the API of Java program for connecting and accessing various databases,it consists of a set of classes and interfaces,and provides a connection service between Java program and various databases.In the paper the authors analyse JDBC 2.0 interface principle and the defect of current database connection pool in database reconnection technology,and propose a kind of strategy which can automatically reconnect database.This strategy uses loop detection mechanism,which makes up the shortage of current database connection pool.Test result proves that the strategy of database reconnection mechanism can improve system robustness and overall performance effectively and reduce the maintenance of the system.