Supporting Features in the 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
    
  • 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, SQL File.
      
    • DB2 Native
      db2jcc.jar: This driver works with Table, Prepared Statements, Procedures, and SQL File.
      

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

See Also

• About Database Binding Component.
  
• Open ESB Packages that Make Up the New Database Binding Component.
  
• Functional Architecture of Database Binding Component.
  

Return to Working With the Database Binding Component

This page (revision-5) was last changed on 14-Dec-08 08:57 AM, -0800 by PRABHAMS.
This page was created on 06-Dec-08 01:51 AM, -0800 by PRABHAMS.

More info...