Index Changes

Database Binding Component

What is Database Binding Component?

The Database Binding Component provides a comprehensive solution for configuring and connecting to databases that support JDBC from within a JBI environment. Database Binding Component is a JBI component that provides database operations as services. These webservices would be invoked by other JBI components acting as consumers.

The Database Binding Component supports the following database artifacts to be exposed as services.

  • Tables
  • Prepared Statements
  • Stored Procedures and Functions.

Components of Database BC

Database Binding Component provides the user an easy way of working with databases and provide webservices in conjunction with other openESB components.

The following components are part of the Database Binding Component.

  • WSDL from Database wizard which supports tables, prepared statements and Stored Procedures/Functions. (Netbeans plugin)
  • Custom WSDL extensions for configuring the web service. (Netbeans plugin)
  • Database Binding Runtime component. (JBI runtime component)

How to Use Database Binding Component?

Features

  • Database Objects
    • Table
    • View
    • Prepared Statements
    • Procedures
    • SQL File
  • Database Operations (DDL)
    • Table
      • Insert
      • Update
      • Delete
      • Select
      • Database Polling for Inbound
        • PollPostProcessing Delete
        • PollPostProcessing Mark Column
        • PollPostProcessing Copy
        • PollPostProcessing Move
    • Prepared Statements
      • Select
      • Insert
      • Update
      • Delete
    • Procedures
  • Database Connectivity
    Database connectivity through Java Naming and Directory Interface (JNDI) lookup.
  • XSD Creation and Editing
    Creating XML Schema Definition (XSD) through wizard for -
    • Table
    • Prepared Statements
    • Procedures
    • SQL File
  • WSDL Creation and Editing
    Creating WSDL components through a wizard with relevant binding information, service, and port definitions.
    • Table
    • Prepared Statements
    • Procedures
    • SQL File
  • Other Features
    • Transaction Control (including XA)
    • JDBC WSDL extension validations in the WSDL Editor
    • Fault Handling
  • Databases Supported
    • Tier 1 Databases Supported
      • MySQL
      • Oracle
    • Tier 2 Databases Supported
      • SQL Server
      • DB2
      • Sybase
  • Driver Types Supported
    Drivers are uniquely different in what they do and the type of functions they support.
    • DataDirect 3.7 (Type 4)
    • Derby Network client driver for Derby 10.2
    • Oracle Database
      • Oracle Type 2 driver (thin) for Oracle 9i
      • Oracle Type 2 driver (thin) for Oracle 10G
      • Oracle Type 2 driver (thin) for Oracle 11G
        ojdbc14.jar#,ojdbc5.jar: This driver works with Table, Prepared Statements, and Procedures.
      • MySQL Native
        mysql-connector-java-5.1.5-bin.jar: This driver works with Table, Prepared Statements, Procedures, and SQL File.
      • MySQL DataDirect Driver
        This driver works with Table, Prepared Statements, Procedures, and SQL File.
      • Oracle Native
        This driver works with Table, Prepared Statements (supports only during Runtime), Procedures, and SQL File (supports only during Runtime).
      • Oracle DataDirect Driver
        This driver works with Table, Prepared Statements, and SQL File.
      • SQL SERVER 2005 Native
        sqljdbc.jar: This driver works with Table, Prepared Statements, and SQL File.
      • SQL SERVER 2005 DataDirect Driver
        sqljdbc.jar: This driver works with Table, Prepared Statements, and SQL File.
      • Sybase Native
        jconn3.jar: This driver works with Table, Prepared Statements, and SQL File.
      • DB2 Native
        db2jcc.jar: This driver works with Table, Prepared Statements, Procedures, and SQL File.
Note - With this, both the JAR Files and the NBM Files are installed together.
  • Supported Platforms
    • Windows
    • Solaris
    • Mac OS X
    • Linux
  • Support for OpenESB
    NetBeans plug-in compliant with the NetBeans enterprise suite.
  • Systemic Qualities
    • Application Configuration and Variables
      Provides support for application configuration at deployment time and runtime, that is, after an application has been packaged. Must allow for changing configuration without modifying the packaged application.
    • Logging
      Develop a consistent logging strategy across all runtime components.
    • Monitoring and Management
      Provides a shared model for instrumentation, aggregation, and presentation of monitoring data related to performance, activity, and status. Needs to allow for unified monitoring across Sierra. This includes the core platform as well as components.
    • Recovery
      XA recovery is a big part of this picture, but it's not everything. All components need to be able to recover gracefully from failure, including failure of other components internally and externally; and dealing with faults or errors in a manner that does not compromise message reliability.
    • Dynamic Addressing
      Extend the scope of an application dynamically through dynamic addressing or invocation.
    • Retry
      Qualities that can be added to an interaction with an endpoints.
    • Throttling
      Qualities that can be added to an interaction with an endpoints.
    • Serial Processing and Message Ordering
      Needs explicit support by all components; might benefit from conventions with respect to the status (DONE or ERROR) is sent back (that convention is related to TX and reliable messaging as well).
    • Common Fault and Error Handling
      Establishes a common fault or error framework for all components. This ensures consistency in fault behavior and content.
    • Transaction Propagation
      Provides a transferable construct for transaction information within the context of a given invocation (parent -> child).
    • Configuration Usability
      MBean and WSDL extensibility elements consistency or usability.

System Requirements

Database Binding Component has the following system requirements:
  • A jre 1.5 or higher. It has been tested with:
    • Sun jdk 1.5.x over Linux.
    • Sun jdk 1.5.x over Windows.
  • A JBI container 1.0 or higher. It has been tested with:
    • OpenESB 2.0.
  • A JCA container. It has been tested with:
    • GlasshFish 2.0.

Project Documentation

Features Development

This section details the functional specifications, designs, implementation, and tests for the various features of the Database BC. It might also include information on using the feature if applicable, but most information on using particular features will be included in the user guide.



Return to the Database Binding Component Landing Page

JSPWiki v2.4.100
« Home Index Changes Prefs
This page (revision-8) was last changed on 22-Jan-09 02:42 AM, -0800 by PRABHAMS