The RDBMS Event Generator is one of the Oracle WebLogic Integration event generators that you can create from the Oracle WebLogic Integration Administration Console.
The RDBMS Event Generator uses triggers to detect changes to a database table for added, deleted, or updated rows and publishes the results to Message Broker channels. You can also use the RDBMS Event Generator to run custom queries on the database table and publish the results to Message Broker channels.
To learn more about the event generators available from the Oracle WebLogic Integration Administration Console and for information on defining channel rules for the RDBMS Event Generator, see Managing Oracle WebLogic Integration Solutions.
The RDBMS Event Generator enables integration with RDBMS by retrieving data from a database as XML or a CachedRowSet that can be used in a business process. This provides a convenient and simple method for integrating databases with enterprise applications using Oracle WebLogic Integration.
The RDBMS Event Generator supports asynchronous message retrieval from databases, including Oracle, Microsoft SQL Server, IBM DB2 UDB, Informix Dynamic Server, and Sybase Adaptive Server in 2 ways:
Integration of table event (Insert/Delete/Update) operations in processes
Integration of custom SQL query output in processes
Supported Databases
The following databases are currently supported:
DB2
IBM Informix Dynamic Server
MS SQL 2005
Sybase
Oracle
Supported Drivers
This section lists the drivers that the Oracle WebLogic RDBMS Event Generator supports on the following operating systems:
Windows XP and 2000 Professional
Sun Solaris 8, 9, and 10
HP-UX 11i
AIX
It also lists the driver class names and JDBC URLs corresponding to the drivers.
Note:
The Oracle WebLogic RDBMS Event Generator should be used in conjunction with a JDBC 2.1 compliant driver.
Oracle Thin Driver
The Oracle 10g 10.1.0.2.0 Thin Driver file (WL_HOME/server/lib/ojdbc14.jar) is shipped with the product.
Table 1-1 Driver Class Names and JDBC URLs for Oracle Thin Driver
For integration with Sybase Adaptive Server databases, use the Oracle WebLogic RDBMS Event Generatorwith DataDirect Connect for JDBC (Release 3.3). The required JDBC Driver files, util.jar, base.jar, and sybase.jar, are part of DataDirect Connect for JDBC Release 3.3.
See DataDirect for information about obtaining DataDirect Connect for JDBC.
Table 1-5 Driver Class Names and JDBC URLs for Informix JDBC Driver