BLOB/CLOB support for uncertified databases
Other types of databases are supported if they are up to the JDBC standard. These include mySQL, PostgreSQL, and others.
Because different databases might have different definitions of the BLOB/CLOB datatype, the
database protocol driver cannot handle all of the various data types. To support these
additional databases, CIS has a customized largeObjectType
connection
property for the database URL. With this property, CIS can specify a JDBC that handles
BLOB/CLOB for uncertified databases. The value of largeObjectType
must be one
of oracle
(default), sqlserver
, or
sqlite
.
LargeObjectType Value | Expectation |
---|---|
oracle |
BLOB/CLOB is treated as Oracle database. |
sqlserver |
BLOB/CLOB is treated as MS SQL SERVER database. |
sqlite |
BLOB/CLOB is treated as SQLite database. |
For example, if a MySQL database is taken, the largeObjectType
property in
database JDBC URL is set as oracle
:
{DB_URLjdbc:mysql://192.168.1.10:3306/cloverleaf_test;largeObjectType=oracle}
.
largeObjectType=oracle
indicates the database protocol driver deals with the
BLOB/CLOB data type in MySQL in the same manner as Oracle.
Additional information is available at: