Method And System For Exposing Data Access Business Logic As Stored Procedures
Publication Date: 2010-Oct-18
The IP.com Prior Art Database
A method and system is provided to expose data access business logic as stored procedures in a Java Database Connectivity (JDBC) driver. A set of Java business logic components are loaded and exposed as a set of stored procedures to a third party application that supports JDBC.
Page 01 of 2
Method And System For Exposing Data Access Business Logic As Stored
Disclosed is a method and system for exposing data access business logic as stored procedures in a Java Database Connectivity (JDBC) driver.
Typically, many applications have complex data storage schemas that require a data access business logic layer to enable retrieval and storage of data and information. During integration of data access business logic with a third party application, they need to be customized to support the third party application.
The method and system disclosed herein exposes data access business logic written in Java, as stored procedures in a JDBC driver in a Java compliant interface. The method involves loading a set of Java business logic components, known as a Datalet, and exposing them as a set of stored procedures to a third party application on a client that supports JDBC. The Datalet may be plugged in to the JDBC driver and exposed to clients as a single stored procedure. Thereafter, the Datalet may be executed by the client using a JDBC call statement syntax to return a standard JDBC ResultSet containing the requested data.
Each Datalet contains the specific data access business logic required for accessing and maintaining a specific set of data in the data store. Further, each of the Datalets has a name and a set of positional parameters that can be set at execution time.
Datalet may be executed via the JDBC driver using a CallableStatement and a stor...