Method for providing a client computer device with access to a database management system

A method for providing a client computer device with access to a database management system via an http connection with an agent server, comprising:

• a step of generating a query by said client device
• a step of processing said query by said agent server to search said database, according to the parameters contained in said query, wherein said query is an SQL query
• said agent server has a security module parametrizable by dependency injection to extract the content of said SQL statements from the client data as an http query, as well as an identifier of the client device that transmitted the query, and the parameters thereof;
• to transmit the parameters thereof to a parametrizable filter stage comparing the data via a program which makes it possible to define authorized commands for the client device corresponding to the identifier and parameters extracted by an analysis stage,
• this program is modified by dependency injection to adapt the authorized or prohibited commands according to specificities of the context of use of the database concerned;
• conditionally ensure the transmission of said query to an extraction module;
• if the query transmitted by the analysis stage contains unauthorized commands, the filtering stage sends the client device a notification that the query has not been processed;
• if the query transmitted by the analysis stage contains incorrect commands, the filtering stage sends back to the client device an error notification with a code indicating the nature of the error and a message,
• if the query contains only authorized commands, the filter stage transmits to a JDBC pilot constituting a gateway for access to a database management system;
• said extraction module converting the query into JDBC instructions transmitted to said database management system;
• said extraction module receiving in response the data in JDBC format and converting it into a JSON stream;
• and
• the agent server transmits said JSON stream to the client device.