This chapter describes how to configure the Oracle JDBC cartridge and Oracle Spatial cartridge, which extend Oracle Continuous Query Language (CQL) for use with Oracle Event Processing.
This chapter includes the following sections:
You define an application context for an instance of Oracle Spatial using element spatial:context
in your Oracle Event Processing application's Event Processing Network (EPN) assembly file.
All constructors and methods from com.oracle.cartridge.spatial.Geometry
and Oracle Spatial functions are aware of spatial:context
. For example, the SRID is automatically set from the value in the Oracle Spatial application context.
For more information, see "SDO_SRID" in the Oracle Spatial Developer's Guide at: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e11830/sdo_objrelschema.htm#SPATL492
To configure Oracle Spatial application context:
You define an application context for an instance of an Oracle JDBC data cartridge using:
A jdbc:jdbc-context
element in the EPN assembly file.
A jc:jdbc-ctx
element in the component configuration file.
The jc:jdbc-ctx
element:
references one and only one jdbc:jdbc-context
references one and only one data-source
defines one or more SQL functions
Note:
You must provide alias names for every SELECT
list column in the SQL function.
To configure Oracle JDBC data cartridge application context: