DEPRECATED
Interface for the JdbcHelperDelegate, which is used to delegate CLOB read/write operations for specific database drivers.
Method Summary |
public void |
|
public |
|
public |
|
public |
|
public boolean |
|
Method Detail |
public void commitConnection(Commits the java.sql.Connection that you have been using for CLOB operations. A CLOB becomes inactive as soon as a transaction is committed. You must have auto-commit=false on your connection if you need to have a CLOB available across multiple SQL statements.Connection
con)
throwsSQLException
The delegate may implement this as a no-op method if it is illegal to do a Connection.commit() for the driver (e.g., jDriver for Oracle XA)
SQLException
publicRetrieve the LOB locator for a CLOB. The method creates a PreparedStatement from the specified parameters and gets the LOB locator from the ResultSet.Clob
getClobLocator(Connection
con,String
tableName,String
clobColumnName,String
whereClause)
throwsSQLException
This method only returns a single CLOB locator. If the WHERE clause results in mutiple rows, only the CLOB from the first row is returned.
SQLException
publicReturn the database specific keyword that must be used when inserting a row with an empty CLOB. For example, the method returns EMPTY_CLOB() when the database is Oracle.String
getEmptyClobInitializer()
throwsSQLException
SQLException
publicRetrieve CLOB value as a String of Unicode characters.String
readClobData(ResultSet
rs, int index)
throwsSQLException
SQLException
public boolean writeClobData(Write to a CLOB. Write the input stream containing the ASCII data associated with the passed String to the CLOB's output stream. Streams support for updating CLOB columns is not addressed by JDBC 2.0 so this method uses an extension implemented in the delegate.PreparedStatement
stmt, int index,Clob
clob,String
str)
throwsSQLException
SQLException