Supporting Features in Database Binding Component

The Database BC has all the features of the JDBC Binding Component and subset of SQL Service Engine. The Database BC supports the listed database artifacts that are exposed as Services.

• 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

    • Procedure

    • 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.