CN105721507A - Basic support system and method for data sharing service platform based on JDBC (Java Data Base Connectivity)-long message - Google Patents

Basic support system and method for data sharing service platform based on JDBC (Java Data Base Connectivity)-long message Download PDF

Info

Publication number
CN105721507A
CN105721507A CN201610250915.7A CN201610250915A CN105721507A CN 105721507 A CN105721507 A CN 105721507A CN 201610250915 A CN201610250915 A CN 201610250915A CN 105721507 A CN105721507 A CN 105721507A
Authority
CN
China
Prior art keywords
cjdbc
client
long message
module
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201610250915.7A
Other languages
Chinese (zh)
Other versions
CN105721507B (en
Inventor
邓勇
褚涵月
朱福珍
徐帆江
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Institute of Software of CAS
Original Assignee
Institute of Software of CAS
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Institute of Software of CAS filed Critical Institute of Software of CAS
Priority to CN201610250915.7A priority Critical patent/CN105721507B/en
Publication of CN105721507A publication Critical patent/CN105721507A/en
Application granted granted Critical
Publication of CN105721507B publication Critical patent/CN105721507B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00—Network architectures or network communication protocols for network security
    • H04L63/10—Network architectures or network communication protocols for network security for controlling access to devices or network resources
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00—Network architectures or network communication protocols for network security
    • H04L63/04—Network architectures or network communication protocols for network security for providing a confidential data exchange among entities communicating through data packet networks
    • H04L63/0428—Network architectures or network communication protocols for network security for providing a confidential data exchange among entities communicating through data packet networks wherein the data content is protected, e.g. by encrypting or encapsulating the payload
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]

Landscapes

  • Engineering & Computer Science (AREA)
  • Signal Processing (AREA)
  • Computer Security & Cryptography (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Computing Systems (AREA)
  • Computer Hardware Design (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a basic support system and method for a data sharing service platform based on JDBC (Java Data Base Connectivity)-long message and provides a Client-Server model used for remote access to a JDBC data source through a long message and is a JDBC type 3 driver. The support system comprises three main parts including a CJDBC client, a long message processing module and a CJDBC server side module, and assorted management configuration tools, such as database middleware network node maintenance software. The method comprises the following main steps that a client interface is compatible with a JDBC interface, an access request for a database is transmitted to the CJDBC server side through the long message, a server translates the request to call which conforms to the database standard, and the call is transmitted to a database server. The support system can solve a problem of remote access to the database under the specific environment, and meanwhile, the permission control for access to the database is carried out on the server side, so that the security for data access is guaranteed.

Description

A kind of data sharing service platform base based on JDBC service-long message supports system and method
Technical field
The invention belongs to computer data maintenance technology field, be specifically related to a kind of data sharing service platform base and support system data access middleware and method.
Background technology
Because of reasons such as secrecy and safety under available frame, the data between each node database can not carry out sharing and synchronizing.It is thus desirable to build data, services shared platform, for the data transmission channel that client and Database are reliable and stable, and ensure that the client transparent access to data；Data access for multitype database provides unified interface, improves ease for use.
The present invention is directed to current present situation, a kind of data, services shared platform is proposed, it provides one for carrying out remote access JDBC (JavaDataBaseConnectivity by long message, java data base connects) client-server (client-server end) model of data source, client-side interface compatibility JDBC interface, the access request of data base can will be passed to CJDBC server end by long message, server is translated as request and meets calling of normalizing database, more this calling is passed to database server.Can solving data sharing problem in certain circumstances, server end carries out the control of authority of database access simultaneously, it is ensured that the safety of data access.
Summary of the invention
The technology of the present invention solves problem: overcome the deficiencies in the prior art, a kind of data-base remote access method in certain circumstances is provided, carry out the control of authority of database access simultaneously at server end, make programing work more efficient, more convenient, and ensure the safety of data access.
The technical solution of the present invention: a kind of data sharing service platform base based on JDBC service-long message props up support system, including: CJDBC client modules, long message processing module, CJDBC server module；
Described CJDBC client modules includes: JDBC driving interface module, CJDBC client communication module, CJDBC client abnormality processing module；JDBC drives module to provide the JDBC accessing data base to drive interface, it it is a JDBCtype3 driver, and the interface that need to be used for transmitting data is serialized, interface is used to perform the DDL of SQL, DML statement, return and perform result, user sends database access request by this interface module, and is sent database access request to long message processing module by CJDBC client communication module；CJDBC client communication module uses long message to communicate, call long message interface carry out client and between service end data transmission, the request of user accesses data storehouse is sent to long message processing module by SOCKET, and receiving the database access result returned from long message processing module, the network produced in communication process calls CJDBC client abnormality processing module when connecting exception and SQL exception and processes；CJDBC client abnormality processing module provides network to connect abnormal and SQL abnormality processing, and network of dishing out when fault occurs connecting in CJDBC client communication network connects abnormal, and the SQL that dishes out when request operational data storehouse, user accesses data storehouse mistake is abnormal；
Described long message processing module includes again: long message SOCKET communication module, long message client communication module, long message data encryption module；Long message SOCKET communication module receives user program by CJDBC client communication module and sends the database access request of coming, it is given to long message client communication module, and uses SOCKET service that by CJDBC client communication module, the database access result received from long message client communication module is returned to user；The user received request is sent to CJDBC server module according to long message configuration by long message service by long message client communication module, and receives the database access result that CJDBC server module returns；Long message data encryption module uses existing encryption suite that the long message of long message client communication module is transmitted information and encrypts and decrypts, ensure the safety of data transmission, use existing encryption suite that the data sent by long message are encrypted at data sending terminal, and the transmission information after data receiver resolves encryption；
Described CJDBC server module includes again: CJDBC service end communication module, Access Control Module, database access module, concurrent processing module, service end abnormality processing module, CJDBC service end data encryption module；CJDBC service end communication module encapsulation long message dynamic link library, writes call back function and processes Content of Communication, uses long message to carry out data transmission, and receives user's request that long message client sends, returns database access result；Access Control Module accesses, to all, the access privilege control that user provides unified at server end according to the communication information from long message client, when connecting, Role Information according to client, give corresponding database-access rights, and by CJDBC service end communication module, permission match result is returned；Obtaining the user of corresponding access rights to access and call local driving by database access module and carry out database access, use configuration file configuration database access information, configuration file includes configuration long message server ip, data base's IP information；Concurrent processing module concurrently connects for processing, and processes multi-user's connection, Multi-Client Concurrency Access data base；Abnormality processing resume module network connects exception and SQL is abnormal, and SQL is abnormal results from service end, need to be forwarded to client again by abnormal for SQL, improve client ease for use；CJDBC service end data encryption module uses existing encryption suite that transmission information is encrypted and decrypted, ensure the safety of data transmission, the transmission information sent to CJDBC service end communication module is decrypted, and the information sent to long message client communication module is encrypted.
A kind of data sharing service platform base method for supporting based on JDBC service-long message, it is achieved step is as follows:
(1) user sends database access request by CJDBC client modules and obtains the execution result of return, the JDBC that this module provides drives interface to be serialized by the interface that need to be used for transmitting data, perform the DDL of SQL, DML statement, and by CJDBC client communication module, database access request is sent to long message processing module；
(2) user is asked to send to long message processing module by CJDBC client modules by TCP/IP Web vector graphic SOCKET service, and this request is sent the long message processing module to another node by the service of this node long message by this module；
(3) this data access request is passed to this node CJDBC service end by long message processing module, CJDBC service end uses the request of this node database access modules access data base and obtain the data structure of return, this data structure returns to CJDBC client by original path, and so far a communication process completes；
(4) CJDBC client and long message processing module are in a LAN, communicated by SOCKET, long message processing module, CJDBC service end, three module one communication nodes of composition of long message service end, communicated by long message dedicated network between communication node, it is achieved internodal reciprocal access；
(5) data encryption module uses encryption suite that transmission information is encrypted and decrypted, encryption and decryption and safety certification is carried out, it is ensured that data transmission security in long message processing module and the data sending terminal of CJDBC server module, the receiving terminal data to being sent by long message service；
(6) network that CJDBC client node produces in communication process calls CJDBC client abnormality processing module when connecting exception and SQL exception and processes, the network that CJDBC service end node produces in communication and access data base procedure connects exception and SQL is processed by CJDBC service end abnormality processing module extremely, and abnormal information is forwarded to CJDBC client node, return to user, improve client ease for use；
(7) when running into Multi-Client Concurrency Access, CJDBC server module processes the situation of multi-user's connection, Multi-Client Concurrency Access data base.Whenever user sends an access request to CJDBC client, CJDBC client opens a new process thread, until obtaining the remote database access data that service end returns, thread terminates.Whenever CJDBC service end receives the access request that CJDBC client sends, CJDBC service end opens a new process thread, until obtaining database access data, and returns to CJDBC client, and thread terminates.
Present invention advantage compared with prior art is in that:
(1) the deficiencies in the prior art are overcome, a kind of data-base remote access method in certain circumstances is provided, build the JDBCtype3 driver framework based on long message communication, realize conventional JDBC and drive interface, completely compatible existing JDBC drives, there is provided unified data access interface, it is to avoid the difference of disparate databases operation；
(2) present invention achieves the switching of heterogeneous networks communication mode, management, a database access, by repeatedly TCP/IP, long message communication conversion, serves the CJDBC client and long message server, CJDBC service end that are in multiple different network environments；
(3) present invention achieves the control of authority of database access at server end, and the user for different rights asks to provide corresponding database-access rights, it is ensured that the safety of data access；
(4) the invention provides perfect data base's exception and network connects exception throws mechanism, set up the abnormal transmission mechanism of SQL, service end directly access the database, produced by it, SQL anomaly occurs in service end, transfers back to client by abnormal for this SQL；
(5) providing quick multi-user to connect, stable process concurrently accesses, and establishes process multi-user and connects, and the concurrent access mechanism of Multi-Client Concurrency Access data base solves the problems such as concurrent access conflict.Make programing work more efficient, more convenient, and ensure the safety of data access；
(6) data encrypting and deciphering mechanism is provided, use encryption suite that transmission information is encrypted and decrypted, the data sent by long message are encrypted, it is encrypted and safety certification with CJDBC service end with CJDBC service end, database service end in customer side, it is ensured that data transmission security；
(7) providing the network node topology of innovation, each communication node comprises long message service end, CJDBC service end, CJDBC client application and database service.CJDBC client application or database service connect mutual with CJDBC service end by general network, CJDBC service end and long message service end are communicated by long message, communicated by long message between each communication node, it is achieved that internodal reciprocal access.
Accompanying drawing explanation
Fig. 1 is the composition frame chart of each module of present system；
Fig. 2 is the flowchart of the inventive method；
Fig. 3 is client-access database service communication flow diagram in the present invention；
Fig. 4 obtains data base to connect flow chart in the present invention；
Fig. 5 is client concurrent processing block flow diagram in the present invention；
Fig. 6 is CJDBC service end concurrent processing block flow diagram in the present invention.
Detailed description of the invention
Below by specific embodiment, and coordinate accompanying drawing, the present invention is described in detail.
As it is shown in figure 1, present system is mainly made up of three big modules, including CJDBC client modules, long message processing module and CJDBC server module.
1.CJDBC client modules is used for processing user's request, it is provided that the JDBC accessing data base drives interface, is serialized by the interface that need to be used for transmitting data；
2. long message processing module is for being sent to CJDBC server end according to long message configuration by long message service by the user received request, receives the database access result that CJDBC service end returns；
3.CJDBC server module is used for processing multi-user's connection, Multi-Client Concurrency Access data base, calls local driving and carries out database access, and result is back to client modules；
4. the entirety of native system processes user data storehouse access request realizes information flow as shown in Figure 2.
CJDBC client modules
Interface serialization module
There is provided the JDBC accessing data base to drive interface, and the interface that need to be used for transmitting data is carried out serializing operation, use interface to perform the DDL of SQL, DML statement, return and perform result.
CJDBC client SOCKET communication module
The request of user accesses data storehouse is sent to long message processing module by SOCKET, and receives the database access result returned from long message processing module.
CJDBC client abnormality processing module
The exception that client is occurred by abnormality processing module processes, including the process that network connects exception, SQL exception etc..When occurring data base to connect exception, SQL statement that user writes is abnormal, and long message connects abnormal, and when Network Abnormal etc. is abnormal, client the abnormal of correspondence of dishing out makes reference to user.
Long message processing module
Long message SOCKET communication module
This module receives user program and sends the database access request of coming, and is given to long message client communication module.And the database access result received from long message communication module is returned to user by SOCKET service.
Long message client communication module
The user received request is sent to CJDBC server end according to long message configuration by long message service by this module, receives the database access result that CJDBC service end returns.
(1) the data transmission that SOCKET interface carries out between CJDBC client and SOCKET service is called；
(2) the data transmission that long message interface carries out between applications client communication module and service end communication module is called.
Long message processes data encryption module
This module uses existing encryption suite that long message is transmitted information and encrypts and decrypts, it is ensured that the safety of data transmission, the data sent by long message are encrypted.When connecting encryption suite, transmitting information by encryption suite, transmission information is by encrypted, when disconnecting encryption suite, does not transmit information by encryption suite, and transmission information will be not encrypted；When connecting deciphering external member, resolving transmission information by deciphering external member, information of transmitting will be resolved, when disconnecting deciphering external member, not pass through to decipher set and resolves part transmission information, and transmission information will not be resolved.
CJDBC server module
CJDBC service end runs configuration
(1) long message configuration is carried out.Enter server configures, right click " long message configuration ", select " configuration long message ", eject the configuration long message IP page, fill in and subscribe to the long message IP that distribution is corresponding.
(2) local data base configuration is carried out.Right click " data base's configuration ", selects " local library configuration ", ejects local library configuration and initializes interface, and this is configured to subscribe to Distributor local data base information.Filling in instance name (data base SID), port numbers (is generally defaulted as 1521), and DBA user name (has a user of DBA authority), DBA password.Click " initialization " and complete initial work.
(3) data base's configuration it is associated.Right click " data base's configuration ", selects " linked database ", enters the configuration of server linked database.After having configured unlatching server, this data base of remote accessible.Database name be called oneself obtain title, external example be remote access needed for a virtual database instance title, can ask for, actual example is the example of the data base of association, IP is the IP at data base place, and port numbers is the port of data base, is generally defaulted as 1521.
(4) service is opened.After configuration work completes, right click " opens service ", selects " opening local IP access remote service ", and " opening remote access local service " opens whole CJDBC service.(opening local IP access remote service, local network node user can pass through this and subscribe to distribution access remote data base, opens remote access local service, and remote network node user can pass through this and subscribe to the data base that distribution access is local).
CJDBC service end communication module
This module receives user's request that long message client sends, and returns the access result that data base returns.
(1) CJDBC client is by SOCKET communication mode transmission database access request to CJDBC service end；
(2) this request is sent the long message service end to another node by the service of this node long message by CJDBC service；
(3) this data access request is passed to this node CJDBC service end by long message service end, and CJDBC service end is beneficial to this request and accesses data base and obtain data structure, and this data structure was by originally returning to client, and so far a communication process completes；
(4) CJDBC client and long message processing module are in a LAN, communicated by SOCKET, long message processing module, CJDBC service end, three module one communication nodes of composition of long message service end, communicated by long message dedicated network between communication node, it is achieved internodal reciprocal access.
Access Control Module
The access rights of all users are uniformly carried out control at server end by this module, when connecting, and the Role Information according to client, give corresponding database-access rights.
Database access module
This module is called local driving and corresponding data base is carried out data access, uses configuration file configuration database access information, and client-access database service communication flow diagram is as shown in Figure 3.
(1) client database accesses
Client user loads the driving of CJDBC, uses the string that connects meeting CJDBC rule to obtain virtual Connection, Statement, ResultSet etc., uses the interface accessing remote data base of JDBC.
(2) service end database access
Service end reading database configuration file, it is thus achieved that database linkage information, calls corresponding driving, arranges database connection pool etc..After server receives the request of user accesses data storehouse, access correspondence database, it is thus achieved that access data, and by Data Serialization, utilize communication module to return to client.
(3) output data function
1) effect of client1:client1 () function is to send a connection request to server, and server returns mark and the port numbers of cjdbc.Function return value is the character string that mark is combined into port numbers.
2) effect of send1:send1 () function is to send database (Database Identification), props (link information), clientInfo (client-side information), ctx (CallingContext) is to server, and server returns a UIDEx (linkage record).Function return value is this UIDEx.
3) effect of send2:send2 () function is to send connuid, uid, cmd, ctx to server, and server returns an Object (this object treated can be packaged into ResultSet, Statement etc.).Function return value is this Object.
(4) data base connects interface
Data base connects (Connection) object can provide the information of SQL syntax that descriptive data base table supports, storing process, linkage function etc..This information is to use getMetaData method to obtain.When configuring Connection, application program should use suitable Connection method, such as setAutoCommit or setTransactionIsolation.When there being available method, application program can not directly invoke the configuration that sql command change connects.Under default situations, Connection object is under automatic submission pattern, can automatically submit change after performing each statement to.If have disabled automatic submission pattern, then change will be submitted to be necessary for explicit calling commit method, data base's change otherwise cannot be preserved.Acquisition data base connects flow process and crosses as shown in Figure 4.
(5) stored-procedure interface is called
For performing the interface of sql procedure.Thering is provided a storing process SQL escape grammer, this grammer allows to use standard mode to call storing process.
(6) parameter is had to perform SQL interface
For processing the object of precompiler SQL statement, SQL statement is by precompile and is stored in interface object, and this object then can be used repeatedly to be effectively carried out this statement.
(7) printenv performs SQL interface
For performing static SQL statements and returning the object of its generated result.
(8) database metadata interface
For obtaining the whole synthesis information about data base.Different relation DBMS (DatabaseManagementSystem) usually supports different functions, realizes these functions by different way, and uses different data types.Additionally, driver can realize the DBMS top function provided.The information relationship that method in this interface returns is to the ability of the specific driver worked together and specific DBMS.
(9) savepoint interface
Savepoint be can point from the Current transaction that Connection.rollback method is quoted, during by transaction rollback to savepoint, the Change All made after this savepoint all will be undone.Savepoint can be name, it is also possible to being unnamed, the ID that unnamed savepoint is generated by basic data source identifies.This interface is for obtaining the ID and title formulating the savepoint that object represents.
(10) data set interface
Represent the tables of data of database result collection, generate usually by the statement performing inquiry data base.ResultSet object has the cursor pointing to its current data row.At first, before cursor is placed in the first row, next method moves the cursor to next line.Because the method returns false when ResultSet object does not have next line, it is possible to use it to iteration result collection in while circulates.
(11) driven management interface
This interface is for managing the basic service interface of one group of CJDBC driver.It provide the another kind of method being connected to data source.DataSource object is used to be attached to the prefered method of data source.Application program is no longer necessary to use Class.forName () explicitly to load JDBC driver.Currently used Class.forName () loads the existing program of CJDBC driver and will work on when not making an amendment.
1) connection is obtained
Setting up the connection of data-oriented storehouse URL, DriverManage concentrates from registered JDBC driver and selects a suitable driver；
2) driver is obtained
Searching the driver being understood that given URL, DriverManager concentrates from registered JDBC driver and selects a suitable driver；
3) registration driver
To the given driver of DriverManager registration, the new driver class loaded should be called registerDriver method notice DriverManager and register；
4) all drivers are obtained
Obtain all Enumeration currently having loaded JDBC driver that can access with current caller.
Concurrent processing module
This resume module multi-user connects, the situation of Multi-Client Concurrency Access data base.Whenever user sends an access request to applications client, applications client opens a new process thread, until obtaining the remote database access data that service end returns, thread terminates.Whenever service end receives the access request that applications client sends, service end opens a new process thread, until obtaining database access data, and returns to applications client, and thread terminates.
(1) client concurrent processing.As shown in Figure 5, user sends request and reception result passes through client1, send1, tri-functions of send2, whenever function is called, the client end of socket is set up with socket server and is connected, client end blocks wait result, socket server opens a thread, receives request, is transmitted to CJDBC server.When long message obtains the result that CJDBC server returns, being given to socket service, the server end of socket sends back to the client end of socket.So far the thread opened terminates.Often calling linear function, the server end at socket opens a thread, reaches the effect of concurrent processing with this.
(2) service end concurrent processing.As shown in Figure 6, CJDBC server end opens a receiving thread, and this thread is used for receiving the request data that user sends, and receives data and is undertaken by a call back function.The data received are the character string of a splicing, are divided into three kinds: client1 function request data, send1 function request data and send2 function request data.Three kinds of data character string beginnings that client1, send1, send2 send correspond to three kinds of marks, in call back function, it is judged that mark, calls mode three kinds different, processes 3 kinds of requests respectively.A thread is opened in request every time.When multiple users or a multiple request Concurrency of user arrive call back function, difference according to mark, open different thread process, and a new thread is opened in request every time, new thread processes request, generate result, and call long message and be sent to client, reach the purpose of concurrent processing with this.
Abnormality processing module
This module is used for processing network and connects the situation such as exception and SQL exception.SQL is abnormal results from service end, need to be forwarded to client again by abnormal for SQL, improve client ease for use.When occurring data base to connect exception, SQL statement that user writes is abnormal, and long message connects abnormal, and when Network Abnormal etc. is abnormal, client the abnormal of correspondence of dishing out makes reference to user.
Data encryption module
This module uses existing encryption suite that transmission information is encrypted and decrypted in service end, it is ensured that the safety of data transmission.When connecting encryption suite, transmitting information by encryption suite, transmission information is by encrypted, when disconnecting encryption suite, does not transmit information by encryption suite, and transmission information will be not encrypted；When connecting deciphering external member, resolving transmission information by deciphering external member, information of transmitting will be resolved, when disconnecting deciphering external member, not pass through to decipher set and resolves part transmission information, and transmission information will not be resolved.
Data platform is safeguarded
(1) local node is safeguarded
1) click node maintenance button, enter local node and safeguard the page；
2) input Local Node Information, clicks Local Node Information such as determining amendment button, input node title, node IP, node port, points out successfully modified, or prompting input information is illegal；
3) click initialization button, carry out local node initialization, be stored in data base, point out successfully, check the Local Node Information that should generate correspondence in data base's localuser table.
(2) remote node increases newly
1) click node maintenance button, enter remote node and safeguard the page；
2) click newly-increased button, enter the new Remote node page；
3) input remote node information, including remote node title, node IP, node port etc., points out successfully modified, or prompting input information is illegal；
4) clicking confirming button, remote node safeguards that the page shows newly-increased node, newly-increased node in data base's node table.
(3) remote node amendment, deletion
1) click node maintenance button, eject remote node and safeguard the page；
2) click amendment button, eject the amendment remote node page；
3) amendment remote node information, including remote node title, node IP, node port etc., points out successfully modified, or prompting input information is illegal；
4) clicking confirming button, remote node safeguards the node of page display amendment, corresponding node information amendment in data base's node table；
5) click deletion button, eject prompting and determine the page of deletion；
6) clicking confirming button, delete remote node, remote node safeguards that the page no longer shows the node deleted, and deletes corresponding node information in data base's node table simultaneously.
(4) remote node inquiry
1) click node maintenance button, eject remote node and safeguard the page；
2) Clicks Query button, ejects remote node query page；
3) input inquiry information inquiry, including remote node title, node IP, node port etc., the page shows the remote node information inquired.
(5) remote node connecting test
1) click node maintenance button, eject remote node and safeguard the page；
2) select a remote node, click testing button, enter time-out time and the page is set, input time-out time, and determine；
3) selecting form show, show that the test of each node is by whether, display is tested consuming time；
4) selecting connected graph show, connected graph show the test of each node is by whether, show test consuming time.
(6) data base querying
1) click data library management button, enters the data base administration page；
2) input database information format is as follows:
Database node IP；
Database node title；
Data base SID；
Data base IP；
3) Clicks Query button, the data base administration page is according to the information video data storehouse information of inquiry.
(7) data base increases newly
1) click data library management button, enters the data base administration page；
2) click newly-increased button, enter newly-increased database page；
3) input database information, form is as follows:
Database node IP；
Data base SID；
Data base IP；
Database user name；
Database password；
Database-name；
4) clicking confirming button, the data base administration page shows newly-increased data base, newly-increased node in data base's node_database table.
(8) database update, deletion
1) click data library management button, enters the data base administration page；
2) click amendment button, enter amendment database page；
3) amendment database information, including: node IP, data base SID, data base IP, database user name, database password, database-name；
4) clicking confirming button, the data base administration page shows amended database information, correspondence database information amendment in data base's node_database table；
5) click deletion button, eject prompting and determine the page of deletion, click confirming button, delete remote node.
(9) connection diagnostic
1) click normal diagnostic button, enter the normal diagnostic page；
2) filling in nodal information, form is as follows:
Local subscription distributing ip；
Local subscription dispatch ports；
Time-out time；
3) click nodal test button, enter the result display mode page；
4) selecting form show, show that the test of each node is by whether, display is tested consuming time；
5) selecting connected graph show, connected graph show the test of each node is by whether, show test consuming time；
6) filling in database information, form is as follows:
Local subscription distributing ip；
Local subscription dispatch ports；
Time-out time；
Long-range long message IP；
Data base's virtual instance；
Database user name；
Database password；
7) click data storehouse detection button, enters the result display mode page；
8) selecting form show, show that the test of each node is by whether, display is tested consuming time；
9) selecting connected graph show, connected graph show the test of each node is by whether, show test consuming time.
(10) request monitoring is safeguarded
1) click local request monitoring button, enter this locality request monitoring page；
2) input inquiry information, including: requesting party IP, requesting party's type, communication direction, call duration time, display monitoring Query Result；
3) click and refresh immediately, refresh display monitoring result immediately；Click stopping to refresh, no longer refresh display monitoring result；
4) select a communication information, click more fresh information, show detailed result of communication.
System flow
(1) CJDBC client is by socket communication mode transmission database access request to CJDBC service end；
(2) this request is sent the long message service end to another node by the service of this node long message by CJDBC service end；
(3) this data access request is passed to this node CJDBC service end by long message service end；
(4) CJDBC service end is beneficial to this request access data base and obtains data structure；
(5) this data structure was by originally returning to CJDBC client, and so far a communication process completes.
In a word, the present invention can solve data-base remote access problem in certain circumstances, carries out the control of authority of database access at server end, it is ensured that the safety of data access simultaneously.
Above example is only limited in order to technical scheme to be described; technical scheme can be modified or equivalent replacement by those of ordinary skill in the art; without deviating from the spirit and scope of the present invention, protection scope of the present invention should be as the criterion with described in claim.

Claims (2)

1. one kind is propped up support system based on the data sharing service platform base of JDBC service-long message, it is characterised in that including: CJDBC client modules, long message processing module, CJDBC server module；
Described CJDBC client modules includes: JDBC driving interface module, CJDBC client communication module, CJDBC client abnormality processing module；JDBC drives module to provide the JDBC accessing data base to drive interface, it it is a JDBCtype3 driver, and the interface that need to be used for transmitting data is serialized, interface is used to perform the DDL of SQL, DML statement, return and perform result, user sends database access request by this interface module, and is sent database access request to long message processing module by CJDBC client communication module；CJDBC client communication module uses long message to communicate, call long message interface carry out client and between service end data transmission, the request of user accesses data storehouse is sent to long message processing module by SOCKET, and receiving the database access result returned from long message processing module, the network produced in communication process calls CJDBC client abnormality processing module when connecting exception and SQL exception and processes；CJDBC client abnormality processing module provides network to connect abnormal and SQL abnormality processing, and network of dishing out when fault occurs connecting in CJDBC client communication network connects abnormal, and the SQL that dishes out when request operational data storehouse, user accesses data storehouse mistake is abnormal；
Described long message processing module includes again: long message SOCKET communication module, long message client communication module, long message data encryption module；Long message SOCKET communication module receives user program by CJDBC client communication module and sends the database access request of coming, it is given to long message client communication module, and uses SOCKET service that by CJDBC client communication module, the database access result received from long message client communication module is returned to user；The user received request is sent to CJDBC server module according to long message configuration by long message service by long message client communication module, and receives the database access result that CJDBC server module returns；Long message data encryption module uses existing encryption suite that the long message of long message client communication module is transmitted information and encrypts and decrypts, ensure the safety of data transmission, use existing encryption suite that the data sent by long message are encrypted at data sending terminal, and the transmission information after data receiver resolves encryption；
Described CJDBC server module includes again: CJDBC service end communication module, Access Control Module, database access module, concurrent processing module, service end abnormality processing module, CJDBC service end data encryption module；CJDBC service end communication module encapsulation long message dynamic link library, writes call back function and processes Content of Communication, uses long message to carry out data transmission, and receives user's request that long message client sends, returns database access result；Access Control Module accesses, to all, the access privilege control that user provides unified at server end according to the communication information from long message client, when connecting, Role Information according to client, give corresponding database-access rights, and by CJDBC service end communication module, permission match result is returned；Obtaining the user of corresponding access rights to access and call local driving by database access module and carry out database access, use configuration file configuration database access information, configuration file includes configuration long message server ip, data base's IP information；Concurrent processing module concurrently connects for processing, and processes multi-user's connection, Multi-Client Concurrency Access data base；Abnormality processing resume module network connects exception and SQL is abnormal, and SQL is abnormal results from service end, need to be forwarded to client again by abnormal for SQL, improve client ease for use；CJDBC service end data encryption module uses existing encryption suite that transmission information is encrypted and decrypted, ensure the safety of data transmission, the transmission information sent to CJDBC service end communication module is decrypted, and the information sent to long message client communication module is encrypted.
2. the data sharing service platform base method for supporting based on JDBC service-long message, it is characterised in that realize step as follows:
(1) user sends database access request by CJDBC client modules and obtains the execution result of return, the JDBC that this module provides drives interface to be serialized by the interface that need to be used for transmitting data, perform the DDL of SQL, DML statement, and by CJDBC client communication module, database access request is sent to long message processing module；
(2) user is asked to send to long message processing module by CJDBC client modules by TCP/IP Web vector graphic SOCKET service, and this request is sent the long message processing module to another node by the service of this node long message by this module；
(3) this data access request is passed to this node CJDBC service end by long message processing module, CJDBC service end uses the request of this node database access modules access data base and obtain the data structure of return, this data structure returns to CJDBC client by original path, and so far a communication process completes；
(4) CJDBC client and long message processing module are in a LAN, communicated by SOCKET, long message processing module, CJDBC service end, three module one communication nodes of composition of long message service end, communicated by long message dedicated network between communication node, it is achieved internodal reciprocal access；
(5) data encryption module uses encryption suite that transmission information is encrypted and decrypted, encryption and decryption and safety certification is carried out, it is ensured that data transmission security in long message processing module and the data sending terminal of CJDBC server module, the receiving terminal data to being sent by long message service；
(6) network that CJDBC client node produces in communication process calls CJDBC client abnormality processing module when connecting exception and SQL exception and processes, the network that CJDBC service end node produces in communication and access data base procedure connects exception and SQL is processed by CJDBC service end abnormality processing module extremely, and abnormal information is forwarded to CJDBC client node, return to user, improve client ease for use；
(7) when running into Multi-Client Concurrency Access, CJDBC server module processes the situation of multi-user's connection, Multi-Client Concurrency Access data base.Whenever user sends an access request to CJDBC client, CJDBC client opens a new process thread, until obtaining the remote database access data that service end returns, thread terminates.Whenever CJDBC service end receives the access request that CJDBC client sends, CJDBC service end opens a new process thread, until obtaining database access data, and returns to CJDBC client, and thread terminates.
CN201610250915.7A 2016-04-21 2016-04-21 It is a kind of based on JDBC service-long message data sharing service platform base support system and method Active CN105721507B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610250915.7A CN105721507B (en) 2016-04-21 2016-04-21 It is a kind of based on JDBC service-long message data sharing service platform base support system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610250915.7A CN105721507B (en) 2016-04-21 2016-04-21 It is a kind of based on JDBC service-long message data sharing service platform base support system and method

Publications (2)

Publication Number Publication Date
CN105721507A true CN105721507A (en) 2016-06-29
CN105721507B CN105721507B (en) 2019-03-19

Family

ID=56161384

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610250915.7A Active CN105721507B (en) 2016-04-21 2016-04-21 It is a kind of based on JDBC service-long message data sharing service platform base support system and method

Country Status (1)

Country Link
CN (1) CN105721507B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111683067A (en) * 2020-05-28 2020-09-18 山东鲁能软件技术有限公司 Method, system and readable storage medium for screening decoration mode and request based on jdbc
CN112688976A (en) * 2019-10-17 2021-04-20 广州迈安信息科技有限公司 Data processing transmission service system adopting JDBC/HTTP standard

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110023055A1 (en) * 2009-07-21 2011-01-27 Oracle International Corporation Standardized database connectivity support for an event processing server
CN103761265A (en) * 2014-01-02 2014-04-30 上海起维信息科技有限公司 NoSQL (not only SOL) based medical information system database implementation method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110023055A1 (en) * 2009-07-21 2011-01-27 Oracle International Corporation Standardized database connectivity support for an event processing server
CN103761265A (en) * 2014-01-02 2014-04-30 上海起维信息科技有限公司 NoSQL (not only SOL) based medical information system database implementation method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
王彦士 等: "支持透明集成的数据缓存机制", 《计算机研究与发展》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112688976A (en) * 2019-10-17 2021-04-20 广州迈安信息科技有限公司 Data processing transmission service system adopting JDBC/HTTP standard
CN111683067A (en) * 2020-05-28 2020-09-18 山东鲁能软件技术有限公司 Method, system and readable storage medium for screening decoration mode and request based on jdbc

Also Published As

Publication number Publication date
CN105721507B (en) 2019-03-19

Similar Documents

Publication Publication Date Title
WO2022126968A1 (en) Micro-service access method, apparatus and device, and storage medium
CN103297475B (en) Mock service system and the processing method of Mock service
US20030088656A1 (en) Directory server software architecture
CN106777227A (en) Multidimensional data convergence analysis system and method based on cloud platform
EP0972258A1 (en) Java-to-database connectivity server
KR20050115907A (en) Relational model for management information in network devices
US9135297B2 (en) Database translation system and method
CN107689949B (en) Database authority management method and system
CN109213790A (en) A kind of data circulation analysis method and system based on block chain
CN105893055A (en) Method for triggering process engine platformization
US20200293502A1 (en) Systems and methods for database management system (dbms) discovery
CN110650061A (en) Distributed cooperative cloud testing system
CN105721507A (en) Basic support system and method for data sharing service platform based on JDBC (Java Data Base Connectivity)-long message
CN1863193B (en) Method for implementing safety tactics of network safety apparatus
CN108734023A (en) A kind of access of Encrypted Database System and integrated system and method
CN106776203A (en) Based role is controlled and the cloud platform O＆M KBM method for externally interacting
WO2021093671A1 (en) Task processing method, system, apparatus and device, and computer readable storage medium
CN115757589A (en) Data exchange and sharing method and device of database and readable storage medium
CN116244682A (en) Database access method, device, equipment and storage medium
CN113342845B (en) Data synchronization method, computer device and readable storage medium
CN107203594A (en) A kind of data processing equipment, method and computer-readable recording medium
CN111400394B (en) Distributed database real-time synchronization method crossing security areas
CN107145606A (en) A kind of data managing method and device
CN114816579B (en) SaaS chemical industrial APP access method based on industrial Internet platform
US11449497B1 (en) Method and system for implementing dynamic stored procedures

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant