RDBMS Event Generator

Supported Data Types

This section lists the supported data types for the RDBMS Event Generator for the Trigger Event Scheme and the Intrusive Event Query Scheme. The non-supported data types are also listed.

The following topics are covered in this section:

Supported Data Types - Trigger Event Scheme

The following table summarizes the supported data types for the RDBMS Event Generator (Trigger Event Scheme).

Table A-1 Supported Data Types (Trigger Event Scheme)

Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`BLOB` `CHAR` `CLOB` `DATE` `DECIMAL` `FLOAT` `INTEGER` `NUMBER` `NUMERIC` `RAW` `REAL` `SMALLINT` `VARCHAR2` `NCLOB` `NVARCHAR2` `NCHAR`	`BIGINT` `BIT` `CHAT` `DATETIME` `DECIMAL` `FLOAT` `INT` `MONEY` `NCHAR` `NUMERIC` `NVARCHAR` `REAL` `SMALLDATETIME` `SMALLINT` `SMALLMONEY` `TINYINT` `VARCHAR`	`BIGINT` `BLOB` `CHARACTER` `CLOB` `DATE` `DECIMAL` `DOUBLE` `INTEGER` `LONGVARCHAR` `REAL` `SMALLINT` `TIME` `TIMESTAMP` `VARCHAR`	`BLOB` `BOOLEAN` `BYTE` `CHAR` `CLOB` `DATE` `DATETIME` `DECIMAL` `FLOAT` `INT` `INT8` `INTEGER` `MONEY` `NCHAR` `NVARCHAR` `SMALLFLOAT` `SMALLINT` `TEXT` `VARCHAR`	`BINARY` `BIT` `CHAR` `DATETIME` `DECIMAL` `DOUBLE` `FLOAT` `INTEGER` `NCHAR` `NUMERIC` `NVARCHAR` `REAL` `SMALLDATETIME` `SMALLINT` `TINYINT` `VARBINARY` `VARCHAR` `MONEY` `SMALLMONEY`

Oracle

Microsoft SQL Server

DB2 UDB

Informix Dynamic Server

Sybase Adaptive Server

BLOB

CHAR

CLOB

DATE

DECIMAL

FLOAT

INTEGER

NUMBER

NUMERIC

RAW

REAL

SMALLINT

VARCHAR2

NCLOB

NVARCHAR2

NCHAR

BIGINT

BIT

CHAT

DATETIME

DECIMAL

FLOAT

INT

MONEY

NCHAR

NUMERIC

NVARCHAR

REAL

SMALLDATETIME

SMALLINT

SMALLMONEY

TINYINT

VARCHAR

BIGINT

BLOB

CHARACTER

CLOB

DATE

DECIMAL

DOUBLE

INTEGER

LONGVARCHAR

REAL

SMALLINT

TIME

TIMESTAMP

VARCHAR

BLOB

BOOLEAN

BYTE

CHAR

CLOB

DATE

DATETIME

DECIMAL

FLOAT

INT

INT8

INTEGER

MONEY

NCHAR

NVARCHAR

SMALLFLOAT

SMALLINT

TEXT

VARCHAR

BINARY

BIT

CHAR

DATETIME

DECIMAL

DOUBLE

FLOAT

INTEGER

NCHAR

NUMERIC

NVARCHAR

REAL

SMALLDATETIME

SMALLINT

TINYINT

VARBINARY

VARCHAR

MONEY

SMALLMONEY

Note: In Oracle databases, the driver returns java.sql.Types.NUMERIC as the JDBC Type for the following Oracle data types:

DECIMAL
FLOAT
INTEGER
NUMBER
NUMERIC
REAL

The generated XSD maps all these data types to xsd:integer.

Note: For the MS SQL driver:

NUMERIC(p,s) returns a JDBC Type of NUMERIC which maps to xsd:integer
TIMESTAMP returns a JDBC Type of BINARY which maps to xsd:base64Binary
UNIQUEIDENTIFIER returns a JDBC Type of CHAR which maps to xsd:string

Supported Data Types - Intrusive Query Event Scheme

In addition to the data types supported by the Trigger Event scheme listed above, the Intrusive Query Event scheme supports the data types listed in the following table:

Table A-2 Supported Data Types (Intrusive Query Event Scheme)

Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`LONG`	`BINARY` `TIMESTAMP` `UNIQUEIDENTIFIER` `VARBINARY`

Oracle

Microsoft SQL Server

DB2 UDB

Informix Dynamic Server

Sybase Adaptive Server

LONG

BINARY

TIMESTAMP

UNIQUEIDENTIFIER

VARBINARY

Non-Supported Data Types for RDBMS

Table A-3 Non-Supported Data Types (Trigger Event Scheme)

Oracle	Microsoft SQL Server	DB2 UDB	Informix Dynamic Server	Sybase Adaptive Server
`REFCURSOR` `LONGRAW` `INTERVAL DAY (day_precision) TO SECOND` `INTERVAL YEAR (year_precision) TO MONTH` `TIMESTAMP` `ROWID` `UROWID` `BFILE`	`NTEXT` `IMAGE` `TEXT` `TIMESTAMP` `UNIQUEIDENTIFIER` `VARBINARY` `BINARY` `SQL_VARIANT`		`SERIAL` `SERIAL8` `INTERVAL` `LVARCHAR`	`TEXT` `IMAGE` `TIME` `TIMESTAMP` `DATE` `SYSNAME` `UNICHAR` `UNIVARCHAR`

Oracle

Microsoft SQL Server

DB2 UDB

Informix Dynamic Server

Sybase Adaptive Server

REFCURSOR

LONGRAW

INTERVAL DAY (day_precision) TO SECOND

INTERVAL YEAR (year_precision) TO MONTH

TIMESTAMP

ROWID

UROWID

BFILE

NTEXT

IMAGE

TEXT

TIMESTAMP

UNIQUEIDENTIFIER

VARBINARY

BINARY

SQL_VARIANT

SERIAL

SERIAL8

INTERVAL

LVARCHAR

TEXT

IMAGE

TIME

TIMESTAMP

DATE

SYSNAME

UNICHAR

UNIVARCHAR