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)
Database Connectivity
Database connectivity through Java Naming and Directory Interface (JNDI) lookup
XSD Creation and Editing
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.
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.