Methods, systems, and computer program products for managing and utilizing connections between an application server and an enterprise information system based on a daytona architecture

A system for managing and utilizing connections between an application server comprising the Java Platform, Enterprise Edition architecture and an enterprise information system comprising a database management system based on a Daytona architecture comprising:

• a resource adapter, said resource adapter conforming to a Java Platform, Enterprise Edition Connector architecture and being interfaced with and managed by the application server, said resource adapter comprising:
• a processor;
• and
• a memory comprising computer readable program code that when executed by the processor causes the processor to perform operations comprising:
• providing a connection to the enterprise information system;
• submitting a query request to the enterprise information system;
• and receiving query results from the enterprise information system;
• wherein submitting a query request to the enterprise information system comprises:
• receiving the query request from a client;
• instructing the enterprise information system to open a query;
• instructing the enterprise information system to compile the query;
• instructing the enterprise information system to execute the query;
• and wherein
• receiving query results from the enterprise information system comprises:
• instructing the enterprise information system to return the results of the execution of the query;
• receiving the results of the execution of the query from the enterprise information system;
• instructing the enterprise information system to terminate the connection;
• and returning the results of the execution of the query to the client;
• wherein instructing the enterprise information system to open a query comprises issuing a DS OPEN command, including login credentials and a specification of the type of the query, to a PolyClient Daytona Query server of the enterprise information system;
• and
• wherein instructing the enterprise information system to compile the query comprises issuing a DS COMPILE command, including a name for the query and the query itself, to the PolyClient Daytona Query server;
• and
• wherein instructing the enterprise information system to execute the query comprises issuing a DS EXECUTE command, including the name for the query, to the PolyClient Daytona Query server;
• and
• wherein instruction the enterprise information system to return the results of the query comprises issuing a DS CAT command, including the name for the query, to the PolyClient Daytona Query server;
• and
• wherein instructing the enterprise information system to terminate the connection comprises issuing a DS CLOSE command to the PolyClient Daytona Query server.

A computer program product for managing and utilizing connections between an application server comprising the Java Platform, Enterprise Edition architecture and an enterprise information system comprising a database management system based on a Daytona architecture, comprising:

• a non-transitory tangible computer readable medium comprising computer readable program code that when executed by a processor causes the processor to perform operations comprising:
• operating a resource adapter, said resource adapter conforming to a Java Platform, Enterprise Edition Connector architecture and being interfaced with and managed by the application server, wherein operating the resource adapter comprises:
• providing a connection to the enterprise information system;
• submitting a query request to the enterprise information system;
• and receiving query results from the enterprise information system;
• wherein submitting a query request to the enterprise information system comprises:
• receiving the query request from a client;
• instructing the enterprise information system to open a query;
• instructing the enterprise information system to compile the query;
• instructing the enterprise information system to execute the query;
• and wherein receiving query results from the enterprise information system comprises:
• instructing the enterprise information system to return the results of the execution of the query;
• receiving the results of the execution of the query from the enterprise information system;
• instructing the enterprise information system to terminate the connection;
• and returning the results of the execution of the query to the client;
• wherein instructing the enterprise information system to open a query comprises issuing a DS OPEN command, including login credentials and a specification of the type of the query, to a PolyClient Daytona Query server of the enterprise information system;
• and
• wherein instructing the enterprise information system to compile the query comprises issuing a DS COMPILE command, including a name for the query and the query itself, to the PolyClient Daytona Query server;
• and
• wherein instructing the enterprise information system to execute the query comprises issuing a DS EXECUTE command, including the name for the query, to the PolyClient Daytona Query server;
• and wherein instructing the enterprise information system to return the results of the query comprises issuing a DS CAT command, including the name for the query, to the PolyClient Daytona Query server;
• and
• wherein instructing the enterprise information system to terminate the connection comprises issuing a DS CLOSE command to the PolyClient Daytona Query server.