If your SQL repository definition includes properties that might correspond to large objects in the database, you may need to set some properties in the SQL repository component to handle them.

useSetBinaryStream

If useSetBinaryStream is set to true, then the SQL repository always uses setBinaryStream() instead of setBytes() in prepared statements. The setBinaryStream() is required for large byte arrays in some JDBC drivers.

useSetUnicodeStream

If useSetUnicodeStream is set to true, then the SQL repository always uses setUnicodeStream() instead of setString() in prepared statements. The setUnicodeStream() method is required for large Strings in some JDBC drivers. Setting useSetUnicodeStream="true" is recommended if you are using Oracle with internationalized content, but is not recommended if you do not have internationalized content in your database. Note that if you are using MS SQL Server, you must set useSetUnicodeStream to false.

useSetAsciiStream

If useSetAsciiStream is set to true, then the SQL repository always uses setAsciiStream() instead of setString() in prepared statements. You can useSetAsciiStream instead of useSetUnicodeStream, but then you lose the ability to handle internationalized values in the database.

useSetObject

If useSetObject is set to true, then the SQL repository always uses setObject() instead of setInt(), setFloat(), setDouble(), or setString() in prepared statements.

 
loading table of contents...