Automatic connection and query management

1. A method for accessing data at a network storage medium, comprising:

supplying connection information and a query interface to a first software object located in an Application Programming Interface (API), the connection information and the query interface being provided by an application;

creating a second software object in the Application Programming Interface using the first software object;

passing the connection information and query interface to the second software object;

establishing a connection with the network storage medium within a pool of network storage media through one of a set of pooled connections, the connection to the one of the set of pooled connections being created by the second software object using the connection information, an annotated method being provided by the query interface to the second software object; and

executing the annotated method to enable transactions with an appropriate database on the network storage medium, the annotated method processed into query statements by the second software object for execution at a specific database on the network storage medium, wherein the annotated method is configured to close the connection once the application is finished transacting with the database,

wherein the set of pooled connections is pre-created for the pooled network storage media for each specific database and made available to the application, and wherein the connection establishes a unique communication connection between the API and the network storage medium.

2. The method for accessing data at a network storage medium, as recited in claim 1 , wherein the connection information is obtained from a connection handle or a Datasource Logical Name.

3. The method for accessing data at a network storage medium, as recited in claim 2 , wherein the connection handle is a Universal Resource Locator (URL).

4. The method for accessing data at a network storage medium, as recited in claim 2 , wherein the Datasource Logical Name is converted into a URL using a Java™ Naming and Directory Interface™ (JNDI) naming service.

5. The method for accessing data at a network storage medium, as recited in claim 1 , wherein the application is Java™ based.

6. The method for accessing data at a network storage medium, as recited in claim 1 , wherein the transacting involves receiving data from the specific database on the network storage medium.

7. The method for accessing data at a network storage medium, as recited in claim 1 , wherein the transacting involves updating data in the specific database on the network storage medium.

8. The method for accessing data at a network storage medium, as recited in claim 1 , wherein the connection is a pooled connection.

9. The method for accessing data at a network storage medium, as recited claim 3 , wherein a driver manager object uses the connection information to select a specific device driver to arbitrate communications between the application and the network storage medium.

10. The method for accessing data at a network storage medium, as recited claim 1 , wherein the first software object is a QueryObjectFactory.

11. The method for accessing data at a network storage medium, as recited claim 1 , wherein the second software object is a QueryObjectGenerator.

12. A system for accessing data at a network storage medium, comprising:

a processor;

a memory storing computer executable instructions, which when executed by the processor enables the processor to perform the steps of:

supplying connection information and a query interface to a first software object located in an Application Programming Interface (API), the connection information and the query interface being provided by an application;

creating a second software object in the Application Programming Interface using the first software object;

passing the connection information and query interface to the second software object;

establishing a connection with the network storage medium within a pool of network storage media through one of a set of pooled connections, the connection to the one of the set of pooled connections being created by the second software object using the connection information, an annotated method being provided by the query interface to the second software object; and

executing the annotated method to enable transactions with an appropriate database on the network storage medium, the annotated method processed into query statements by the second software object for execution at a specific database on the network storage medium, wherein the annotated method is configured to close the connection once the application is finished transacting with the database,

wherein the set of pooled connections is pre-created for the pooled network storage media for each specific database and made available to the application, and wherein the connection establishes a unique communication connection between the API and the network storage medium.

13. The system for accessing data at a network storage medium, as recited in claim 12 , wherein the application is Java™ based.

14. The system for accessing data at a network storage medium, as recited in claim 12 , wherein the connection is a pooled connection.

15. The system for accessing data at a network storage medium, as recited in claim 12 , wherein the transacting involves receiving data from the specific database on the network storage medium.

16. The system for accessing data at a network storage medium, as recited in claim 12 , wherein the transacting involves updating data at the specific database on the network storage medium.

17. The system for accessing data at a network storage medium, as recited in claim 12 , wherein a driver manager object uses connection information from the query interface to select a specific device driver to arbitrate communications between the application and the network storage medium.

18. The system for accessing data at a network storage medium, as recited in claim 12 , wherein the application programming interface processes the database information to supply logic necessary to execute the annotated method.

19. A computer readable storage device having programming instructions, which when executed by a processor of a computer enables accessing data at a network storage medium, the computer readable medium comprising:

programming instructions for supplying connection information and a query interface to a first software object located in an Application Programming Interface (API), the connection information and the query interface being provided by an application;

programming instructions for creating a second software object in the Application Programming Interface using the first software object;

programming instructions for passing the connection information and query interface to the second software object;

programming instructions for establishing a connection with the network storage medium within a pool of network storage media through one of a set of pooled connections, the connection to the one of the set of pooled connections being created by the second software object using the connection information, an annotated method being provided by the query interface to the second software object; and

programming instructions for executing the annotated method to enable transactions with an appropriate database on the network storage medium, the annotated method processed into query statements by the second software object for execution at a specific database on the network storage medium, wherein the annotated method is configured to close the connection once the application is finished transacting with the database,

wherein the set of pooled connections is pre-created for the pooled network storage media for each specific database and made available to the application, and wherein the connection establishes a unique communication connection between the API and the network storage medium.