Section 9.4, "Oracle Database Adapter Concepts" Section 9.3, "Oracle Database Adapter Features" Section 1.2.4, "Oracle Adapter for Oracle Applications"įor more information on the Oracle Database Adapter, see: Section 1.2.3, "Packaged-Application Adapters" For more information about application and mainframe adapters, see: For more information, see Chapter 7, "Oracle JCA Adapter for AQ".įor non-relational and legacy systems (with a few exceptions such as DB2 on AS/400), application and mainframe adapters are available. The Oracle Database Adapter can currently be used only within the context of an SOA process as Section 9.1.1.1, "Oracle Database Adapter Integration with Oracle BPEL PM" describes.Īlthough Oracle Streams Advanced Queuing (Oracle AQ) is an Oracle Database feature, you use the separate, specialized Oracle JCA Adapter for AQ to integrate with Oracle AQ. Have database events initiate an Oracle Fusion Middleware process.
#Agile guitar serial number lookup update
Import a relational schema (one or more related tables) and map it as an XML schema (XSD)įor more information, see Section 9.4.1, "Relational-to-XML Mapping."Ībstract SQL operations such as SELECT, INSERT, and UPDATE as Web servicesįor more information, see Section 9.4.2, "SQL Operations as Web Services."
To access an existing relational schema, you must create an application and an SOA project to use the Adapter Configuration Wizard to perform the following:
These XML inputs and outputs allow the Oracle Database Adapter services to be plugged into Oracle Fusion Middleware. The inputs/outputs are XML, most easily seen as input parameters and result sets converted to XML. The interaction (series of SELECT, UPDATE, INSERT) is loosely modeled using the Adapter Configuration Wizard. In contrast to JDBC, it is non-programmatic. It relies on an underlying JDBC connector/driver to enact the database communication. The Oracle Database Adapter is a JCA 1.5 connector, which runs on the Oracle Application Server. While stored procedure support is less standard across databases, Oracle Database Adapter provides support for stored procedures as the guide describes. In exposing databases to SOA, it is also about combining the technologies of SQL and XML, the former an ideal language for querying information, the latter an ideal format for transporting and representing information. From an integration standpoint, tables and SQL are what relational database products have in common, so a generic solution focused on what is standard has the greatest reach. The principle of the tables and views in the Oracle Database Adapter is to expose to SOA tables and SQL as transparently and non-intrusively as possible. These include Oracle database servers and any relational databases that follow the ANSI SQL standard and which provide JDBC drivers. The Oracle Database Adapter enables Oracle SOA Suite and Oracle Fusion Middleware to communicate with database end points. This section provides a functional overview of the Oracle Database Adapter.
0 kommentar(er)
