Transparent database port changing method

Abstract

The invention discloses a transparent database port changing method. The method includes the following steps that firstly, a default connection port of a database is configured on an application server, and a port switching module is started; secondly, a client side initiates a request, and after receiving the request, the application server judges whether a connection port is the default connection port of the database or not; thirdly, if the connection port is the default connection port, a request packet is intercepted and encapsulated to enter the port switching module, and the port is switched according to a designated port mapping corresponding relation; fourthly, after switching a target port in the request packet into a changed port, the port switching module creates physical connection with the database to acquire data from the database and then returns the data to the client side. By means of the method, transparent database port changing for access to an application program can be achieved, the changing efficiency, the changing safety and the ease of manageability of changing can be improved, faults caused by changing can be reduced, and the system operating stability can be improved.

Description

technical field [0001] The invention relates to a database connection method, in particular to a transparent database port change method. Background technique [0002] Generally speaking, the process of java application program accessing the database is: ① loading the database driver; ② establishing a database connection through jdbc; ③ accessing the database and executing sql statements; ④ disconnecting the database connection. Among them, JDBC is a bridge between java and relational database. JDBC (Java Data Base Connectivity, java database connection) is a Java API for executing SQL statements, which can provide unified access to various relational databases. It consists of a set of classes and interfaces written in the Java language. JDBC provides a baseline from which higher-level tools and interfaces can be built to enable database developers to write database applications. JDBC points to the specific database connection object through Connection (connection object i...

AI Technical Summary

Problems solved by technology

[0005] 1), low efficiency

A database usually has many applications connected to it. If the database changes the connection port, it is necessary to modify the database connection configuration on each application and have to operate an additional server. The efficiency of configuration changes in a large-scale enterprise system environment will be very high. the low

[0006] 2), low security

In a large enterprise environment, after the database connection port is modified, there may be missing system configurations that have not been changed, or errors have been corrected, resulting in the failure of the application to connect to the database, resulting in production failures, and the security of configuration changes is very low.

[0007] 3), difficult to manage

When the connection port of the database is changed, it is necessary to manually modify the port number in the database connection URL on each application server. From the perspective of efficient operation and maintenance and automatic operation and maintenance, such configuration changes are very inconvenient to manage

Images