BLOB/CLOB support for uncertified databases

Note: See the Release Notes for the latest supported BLOB/CLOB 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:

https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15