Modular configuration and deployment of JDBC resources

• US 7,461,070 B2
• Filed: 12/06/2005
• Issued: 12/02/2008
• Est. Priority Date: 10/14/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: BAE Systems Incorporated (BAE Systems Plc)
• Inventors: Srivastava, Rahul
• Primary Examiner(s): Wu; Yicun
• Application Number:
  US11/295,284
• Publication Number:
  US 20070088721A1
• Time in Patent Office: 1,092 Days
• Field of Search: 707/1, 707/104.1, 717/177, 719/310
• US Class Current: 1/1
• CPC Class Codes: G06F 9/44505 Configuring for program initiating, e.g. using registry, configuration files
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

The JDBC data sources configuration can be stored in a JDBC configuration XML. This configuration XML can be converted into Java beans to configure data sources such as basic data sources, connection pools or multipool. Migration can be done by using a administration console tool to update the configuration XML with the new binding variables for the production environment.

Claims

1. A system including:

Java Database Connectivity (JDBC) data sources that are configurable with XML configuration files, the XML configuration files being used to obtain configuration information for the Java Database Connectivity (JDBC) data sources;

wherein the XML configuration files are converted to Java Database Connectivity (JDBC) configuration MBeans for the Java Database Connectivity (JDBC) data sources;

wherein new binding variables are used to update test JDBC configuration XML to production JDBC configuration XML, and wherein the test JDBC configuration XML is used to produce test JDBC configuration MBeans and the production JDBC configuration XML is used to produce test JDBC configuration Mbeans;

further comprising a tool to convert the XML configuration files into configuration objects for the Java Database Connectivity (JDBC) data sources;

wherein migration to a new environment can include producing an updated XML configuration file;

wherein a tool is used to update the XML file by inputting new binding variables;

wherein the XML configuration files can be locally or globally scoped;

wherein an XML schema is used; and

wherein the system includes at least one processor.

2. The system of claim 1, wherein a tool can provide a two phase deployment of a configuration such that if the deployment of the update configuration fails, the configuration is rolled back to a previous configuration.

3. A system including:

Java Database Connectivity (JDBC) data sources that are configurable with XML configuration files, the XML configuration files being used to obtain configuration information for the Java Database Connectivity (JDBC) data sources and;

a tool to modify XML configuration files to produce updated XML configuration files;

wherein the XML configuration files are converted to Java Database Connectivity (JDBC) configuration MBeans for the Java Database Connectivity (JDBC) data sources;

wherein new binding variables are used to update test JDBC configuration XML to production JDBC configuration XML, and wherein the test JDBC configuration XML is used to produce test JDBC configuration MBeans and the production JDBC configuration XML is used to produce test JDBC configuration Mbeans;

further comprising a tool to convert the XML configuration files into configuration objects for the Java Database Connectivity (JDBC) data sources;

wherein migration to a new environment can include producing an updated XML configuration file;

wherein a tool is used to update the XML file by inputting new binding variables;

wherein the XML configuration files can be locally or globally scoped;

wherein an XML schema is used; and

wherein the system includes at least one processor.

4. The system of claim 3, wherein a tool can provide a two phase deployment of a configuration such that if the deployment of the update configuration fails, the configuration is rolled back to a previous configuration.

5. A system including:

a tool to create at least one XML configuration file for a Java Database Connectivity (JDBC) data source; and

a component to use the XML file to configure the Java Database Connectivity (JDBC) data source;

wherein the XML configuration files are converted to Java Database Connectivity (JDBC) configuration MBeans for the Java Database Connectivity (JDBC) data sources;

wherein new binding variables are used to update test JDBC configuration XML to production JDBC configuration XML, and wherein the test JDBC configuration XML is used to produce test JDBC configuration MBeans and the production JDBC configuration XML is used to produce test JDBC configuration Mbeans;

further comprising a tool to convert the XML configuration files into configuration objects for the Java Database Connectivity (JDBC) data sources;

wherein migration to a new environment can include producing an updated XML configuration file;

wherein a tool is used to update the XML file by inputting new binding variables;

wherein the XML configuration files can be locally or globally scoped;

wherein an XML schema is used; and

wherein the system includes at least one processor.

6. The system of claim 5, wherein a tool can provide a two phase deployment of a configuration such that if the deployment of the update configuration fails, the configuration is rolled back to a previous configuration.