Skip Navigation Links | |
Exit Print View | |
Oracle Java CAPS Database Binding Component User's Guide Java CAPS Documentation |
Understanding the Database Binding Component
About the Database Binding Component
Components of the Database Binding Component
Packages that Make Up the Database Binding Component
Database Binding Component as Provider
Database Binding Component as Consumer
Database Binding Component WSDL Extensibility Elements
Functional Architecture of Database Binding Component
Functional Architecture of the JDBC Binding Component -- Comparative Study
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 a step-by-step wizard for the following:
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
For information about the database platforms and versions supported by the Database Binding Components, see Java CAPS 6.3 Components and Supported External Systems in Planning for Oracle Java CAPS 6.3 Installation .
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.
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.