Browse Prior Art Database

Method Of Enabling SQL Stored Procedures To Access Transactions Managed By Transaction Server

IP.com Disclosure Number: IPCOM000200555D
Publication Date: 2010-Oct-19
Document File: 1 page(s) / 12K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method for enabling transactions managed by a transactional management system (not a DBMS) to be accessed via SQL as if they were a SQL stored procedure.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 63% of the total text.

Page 01 of 1

Method Of Enabling SQL Stored Procedures To Access Transactions Managed By Transaction Server

Disclosed is a method for enabling transactions managed by a transactional management system (not a DBMS) to be accessed via SQL as if they were a SQL stored procedure.

A SQL stored procedure is an application program that gets

executed under database manager control.

SQL stored procedure that is located at another remote database manager using Structured Query Language (SQL). This enables the SQL stored procedure to retrieve data in a more efficient way because the SQL stored procedure is able to extract the data before sending it back to the application program which has called the SQL stored procedure.

Transactions in a transaction server have defined input and output message structures much like a stored procedure. These transactions are typically invoked via job submission or in more sophisticated arenas by technologies such as SOAP or RESTful services. Programmatic access via standards-based access paradigms to these transactions is not typically offered. This disclosure offers a means by which these transactions can be treated as if they were stored procedures and offers standards-based SQL access to invoke these transactions. JDBC applications can issue SQL to access databases and stored procedures managed by a DBMS as well as transactions managed by a non-DBMS system. The fact that the transactions are not stored procedures themselves is transparent to the appl...