The supported database systems include numerous data types that are not contained in all database systems or that have other names or different semantics there.
To avoid undesired behavior, the list below indicates data types that have been tested successfully with PPM Process Extractor JDBC-2-PPM.
Database system |
Data types |
Note |
---|---|---|
Oracle |
CHAR, VARCHAR2, NCHAR, NVARCHAR2, NUMBER, LONG, DATE, TIMESTAMP |
The CLOB, NCLOB, BINARY_FLOAT, and BINARY_DOUBLE data types are not supported. |
IBM DB2 |
VARCHAR, CHAR, BIGINT, REAL, DOUBLE, FLOAT, DATE, TIME, TIMESTAMP |
The LONG VARCHAR and CLOB data types are not supported. |
Microsoft SQL Server |
CHAR, VARCHAR, NCHAR, NVARCHAR, INT, TINYINT, SMALLINT, BIGINT, REAL, FLOAT, DECIMAL, DATETIME, SMALLDATETIME |
The LONG VARCHAR and CLOB data types are not supported. |