Abstract: Systems, methods and articles of manufacture are disclosed for batching heterogeneous database commands. The heterogeneous database commands may include at least two database command types. Further, at least two of the heterogeneous database commands may include host variables. A request to execute the heterogeneous database commands may be received. The heterogeneous database commands may be sent to a database system for execution, responsive to the request.

Abstract: The present invention provides a method, computer program product and article for creating and reusing a value object for data that is requested a first time and again in subsequent data requests in related result sets. Mutation directives and an associated methodology are presented in one of four different levels which permit the present invention to operate within the JDBC standard.

Abstract: An apparatus, system, and method for establishing a reusable and reconfigurable trusted connection within a trusted context. The invention enhances interoperability with any existing authentication methods including the Kerberos, the DCE, and a combination of a user name and a password. The present invention includes common interfaces in a database driver for a middleware server to obtain a trusted connection. The invention enhances trusted context interoperability by allowing different types of trusted connections such as a normal connection, a pooled connection, or even a distribution transaction connection. The database driver generates unique identifiable information once a trusted connection is authenticated that can be utilized to reuse and reconfigure the trusted connection without re-authentication.

Abstract: A method for connecting a client to a database server are provided. The method provide for providing a generic interface, the generic interface being operable to interoperate with one or more non-GSSAPI (Generic Security Services Application Programming Interface) compliant security mechanisms, providing a set of specialized interfaces, the set of specialized interface being operable to interoperate with one or more GSSAPI compliant security mechanisms, and establishing a connection between a client and a database server using the generic interface or the set of specialized interfaces depending on a security mechanism used by the client. The one or more non-GSSAPI compliant security mechanisms and the one or more GSSAPI compliant security mechanisms may be predefined or user-defined.

Abstract: A method of accessing layers in a multi-layer software architecture including a first layer, a second layer, and a third layer. The method includes: at the third layer, publishing an interface; and at the first layer, before execution of a first function, registering a callback routine with the third layer using the interface.

Abstract: A system and method for database security provides multiple choices of security mechanisms for enabling access to a database through a database driver. A security mechanism that is compatible with a database is selected and the security mechanisms between an application and a database server are automatically determined using the selected security mechanism.

Abstract: Embodiments of the invention provide techniques for disaster recovery in the event of a database connection failure. In one embodiment, a network address for a secondary server may be stored in multiple data objects of a client computer. In the event of a failed connection to a primary server, the network address of the secondary server may be retrieved from one of the data objects stored in the client computer. When an updated network address for the secondary server is received, it may be propagated to the data objects of the client computer.

Abstract: A method is provided for developing a software module including support for multiple versions of an operating environment. The method includes determining a first set of references associated with a first version of an application operating environment. A second set of references associate with a second version of the computing environment is determined. A first class loader is associated with the first version of the computing environment. A second class loader is associated with the second version of the computing environment. The method also includes encapsulating the first set of references, the second set of references, the first class loader, and the second class loader in a software module, wherein the second set of references are obscured from the first class loader.

Abstract: A method, system, and computer program product for managing a heterogeneous connection pooling structure. The heterogeneous architecture of pooling management comprises connections having different connection attributes (i.e. different data source properties) that can share a same connection pool (i.e. same connection pool data source). An application requests a connection from data source having a specified data source property. An application server searches a pool module for an available cached connection. If a cached connection is available, the cached connection is automatically selected as a returned connection. A connection reuse protocol and a statement reuse protocol is determined and invoked to reconfigure the cached connection for reuse as a connection between the application and a database server.

Abstract: An apparatus, system, and method for establishing a reusable and reconfigurable trusted connection within a trusted context. The invention enhances interoperability with any existing authentication methods including the Kerberos, the DCE, and a combination of a user name and a password. The present invention includes common interfaces in a database driver for a middleware server to obtain a trusted connection. The invention enhances trusted context interoperability by allowing different types of trusted connections such as a normal connection, a pooled connection, or even a distribution transaction connection. The database driver generates unique identifiable information once a trusted connection is authenticated that can be utilized to reuse and reconfigure the trusted connection without re-authentication.

Abstract: A computer program product and database driver for connecting a client to a database server are provided. The computer program product and database driver provide for providing a generic interface, the generic interface being operable to interoperate with one or more non-GSSAPI (Generic Security Services Application Programming Interface) compliant security mechanisms, providing a set of specialized interfaces, the set of specialized interface being operable to interoperate with one or more GSSAPI compliant security mechanisms, and establishing a connection between a client and a database server using the generic interface or the set of specialized interfaces depending on a security mechanism used by the client. The one or more non-GSSAPI compliant security mechanisms and the one or more GSSAPI compliant security mechanisms may be predefined or user-defined.

Abstract: A method and a computer program product for storing a specific instant in time as a java.util.Date object are provided. The method and the computer program product provide for defining a first enhanced class that extends java.sql.Date, defining a second enhanced class that extends java.sql.Time, defining a third enhanced class that extends java.sql.Timestamp, creating a first object of the java.util.Calendar class, creating a second object that stores a specific instant in time in a first time zone, and creating a third object based on the first object, the second object, and a provided value, the provided value corresponding to a second time zone and the third object storing a particular instant in time in the second time zone corresponding to the specific instant in time in the first time zone.

Abstract: A method and a computer program product for managing user-configurable variables are provided. The method and the computer program product provide for defining a plurality of user-configurable variables in a computer program, providing an interface operable to be utilized in the computer program for each of the plurality of user-configurable variables, creating an instance of the interface in the computer program for each of the plurality of user-configurable variables, incorporating code for implementing each of the plurality of user-configurable variables into at least one method in the instance of the interface created for the user-configurable variable, and defining a function in the computer program operable to configure any of the plurality of user-configurable variables according to a provided user specification.

Abstract: The present invention provides a method, computer program product and article for creating and reusing a value object for data that is requested a first time and again in subsequent data requests in related result sets. Mutation directives and an associated methodology are presented in one of four different levels which permit the present invention to operate within the JDBC standard.

Abstract: A method, computer program product, and database driver for connecting a client to a database server are provided. The method, computer program product, and database driver provide for providing a generic interface, the generic interface being operable to interoperate with one or more non-GSSAPI (Generic Security Services Application Programming Interface) compliant security mechanisms, providing a set of specialized interfaces, the set of specialized interface being operable to interoperate with one or more GSSAPI compliant security mechanisms, and establishing a connection between a client and a database server using the generic interface or the set of specialized interfaces depending on a security mechanism used by the client. The one or more non-GSSAPI compliant security mechanisms and the one or more GSSAPI compliant security mechanisms may be predefined or user-defined.

Abstract: A computer readable medium encoded with a computer program for performing streaming of character-based data from a storage system is provided. The computer program comprises code for fetching a block of data from the storage system, wherein the character-based data includes the block of the data; converting a portion of the block of the data into a part of a character; retaining a remaining part of the block, if any, the remaining part of the block of the data corresponding to a portion of the character and a portion of an additional character; and converting the remaining part of the block of the data into one of the portion of the character and the portion of the additional character in a next conversion responsive to the next conversion including the character or the additional character.

Abstract: A method and system for performing streaming of character-based data is disclosed. The method and system include fetching a block of data and converting at least a portion of the block of the data into at least a part of a character. The character-based data includes the block of the data. The method and system also include retaining a remaining part of the block, if any. The remaining part corresponds to at least a portion of a character. The method and system also include converting the remaining part into at least the portion of the character in a next conversion if the next conversion includes the character.

Abstract: A database server helps to streamline the retrieval of LOB values by deciding to send a locator in replacement of the LOB value, or the LOB value itself, depending upon the specific LOB value being retrieved. A threshold value is determined in a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding fetch response, and the lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client the form of retrieval that was used for each requested LOB value being returned.

Abstract: A database server helps to streamline the retrieval of LOB values by deciding to send a locator in replacement of the LOB value, or the LOB value itself, depending upon the specific LOB value being retrieved. A threshold value is determined in a fetch query, and the LOB sizes below that threshold are sent as values in a corresponding fetch response, and the lengths above are sent as locators in the fetch response. Indicators are inserted in a fetch parameter of the response to inform the receiving client the form of retrieval that was used for each requested LOB value being returned.