类 OracleLobHandler

字段详细资料

• logger

  protected final Log logger

  已过时。

构造器详细资料

• OracleLobHandler

  public OracleLobHandler()

  已过时。

方法详细资料

• setNativeJdbcExtractor

  public void setNativeJdbcExtractor​(NativeJdbcExtractor nativeJdbcExtractor)

  已过时。
  Set an appropriate NativeJdbcExtractor to be able to retrieve the underlying native oracle.jdbc.OracleConnection. This is necessary for DataSource-based connection pools, as those need to return wrapped JDBC Connection handles that cannot be cast to a native Connection implementation.

  Effectively, this LobHandler just invokes a single NativeJdbcExtractor method, namely getNativeConnectionFromStatement with a PreparedStatement argument (falling back to a PreparedStatement.getConnection() call if no extractor is set).

  A common choice is SimpleNativeJdbcExtractor, whose Connection unwrapping (which is what OracleLobHandler needs) will work with many connection pools. See SimpleNativeJdbcExtractor and oracle.jdbc.OracleConnection javadoc for details.

  另请参阅:

  NativeJdbcExtractor.getNativeConnectionFromStatement(java.sql.Statement), SimpleNativeJdbcExtractor, OracleJdbc4NativeJdbcExtractor

• setCache

  public void setCache​(boolean cache)

  已过时。
  Set whether to cache the temporary LOB in the buffer cache. This value will be passed into BLOB/CLOB.createTemporary.

  Default is true.

  See Also:

  • oracle.sql.BLOB.createTemporary
  • oracle.sql.CLOB.createTemporary

• setReleaseResourcesAfterRead

  public void setReleaseResourcesAfterRead​(boolean releaseResources)

  已过时。
  Set whether to aggressively release any resources used by the LOB. If set to true then you can only read the LOB values once. Any subsequent reads will fail since the resources have been closed.

  Setting this property to true can be useful when your queries generates large temporary LOBs that occupy space in the TEMPORARY tablespace or when you want to free up any memory allocated by the driver for the LOB reading.

  Default is false.

  See Also:

  • oracle.sql.BLOB.freeTemporary
  • oracle.sql.CLOB.freeTemporary
  • oracle.sql.BLOB.open
  • oracle.sql.CLOB.open
  • oracle.sql.BLOB.close
  • oracle.sql.CLOB.close

• initOracleDriverClasses

  protected void initOracleDriverClasses​(Connection con)

  已过时。
  Retrieve the oracle.sql.BLOB and oracle.sql.CLOB classes via reflection, and initialize the values for the DURATION_SESSION, MODE_READWRITE and MODE_READONLY constants defined there.

  See Also:

  • oracle.sql.BLOB.DURATION_SESSION
  • oracle.sql.BLOB.MODE_READWRITE
  • oracle.sql.BLOB.MODE_READONLY
  • oracle.sql.CLOB.DURATION_SESSION
  • oracle.sql.CLOB.MODE_READWRITE
  • oracle.sql.CLOB.MODE_READONLY

  参数:

  con - the Oracle Connection, for using the exact same class loader that the Oracle driver was loaded with

• getBlobAsBytes

  public byte[] getBlobAsBytes​(ResultSet rs,
                               int columnIndex)
                        throws SQLException

  已过时。
  从接口复制的说明: LobHandler
  Retrieve the given column as bytes from the given ResultSet. Might simply invoke ResultSet.getBytes or work with ResultSet.getBlob, depending on the database and driver.

  参数:

  rs - the ResultSet to retrieve the content from

  columnIndex - the column index to use

  返回:

  the content as byte array, or null in case of SQL NULL

  抛出:

  SQLException - if thrown by JDBC methods

  另请参阅:

  ResultSet.getBytes(int)

• getBlobAsBinaryStream

  public InputStream getBlobAsBinaryStream​(ResultSet rs,
                                           int columnIndex)
                                    throws SQLException

  已过时。
  从接口复制的说明: LobHandler
  Retrieve the given column as binary stream from the given ResultSet. Might simply invoke ResultSet.getBinaryStream or work with ResultSet.getBlob, depending on the database and driver.

  参数:

  rs - the ResultSet to retrieve the content from

  columnIndex - the column index to use

  返回:

  the content as binary stream, or null in case of SQL NULL

  抛出:

  SQLException - if thrown by JDBC methods

  另请参阅:

  ResultSet.getBinaryStream(int)

• getClobAsString

  public String getClobAsString​(ResultSet rs,
                                int columnIndex)
                         throws SQLException

  已过时。
  从接口复制的说明: LobHandler
  Retrieve the given column as String from the given ResultSet. Might simply invoke ResultSet.getString or work with ResultSet.getClob, depending on the database and driver.

  参数:

  rs - the ResultSet to retrieve the content from

  columnIndex - the column index to use

  返回:

  the content as String, or null in case of SQL NULL

  抛出:

  SQLException - if thrown by JDBC methods

  另请参阅:

  ResultSet.getString(int)

• getClobAsAsciiStream

  public InputStream getClobAsAsciiStream​(ResultSet rs,
                                          int columnIndex)
                                   throws SQLException

  已过时。
  从接口复制的说明: LobHandler
  Retrieve the given column as ASCII stream from the given ResultSet. Might simply invoke ResultSet.getAsciiStream or work with ResultSet.getClob, depending on the database and driver.

  参数:

  rs - the ResultSet to retrieve the content from

  columnIndex - the column index to use

  返回:

  the content as ASCII stream, or null in case of SQL NULL

  抛出:

  SQLException - if thrown by JDBC methods

  另请参阅:

  ResultSet.getAsciiStream(int)

• getClobAsCharacterStream

  public Reader getClobAsCharacterStream​(ResultSet rs,
                                         int columnIndex)
                                  throws SQLException

  已过时。
  从接口复制的说明: LobHandler
  Retrieve the given column as character stream from the given ResultSet. Might simply invoke ResultSet.getCharacterStream or work with ResultSet.getClob, depending on the database and driver.

  参数:

  rs - the ResultSet to retrieve the content from

  columnIndex - the column index to use

  返回:

  the content as character stream

  抛出:

  SQLException - if thrown by JDBC methods

  另请参阅:

  ResultSet.getCharacterStream(int)

• getLobCreator

  public LobCreator getLobCreator()

  已过时。
  从接口复制的说明: LobHandler
  Create a new LobCreator instance, i.e. a session for creating BLOBs and CLOBs. Needs to be closed after the created LOBs are not needed anymore - typically after statement execution or transaction completion.

  返回:

  the new LobCreator instance

  另请参阅:

  LobCreator.close()

• initializeResourcesBeforeRead

  protected void initializeResourcesBeforeRead​(Connection con,
                                               Object lob)

  已过时。
  Initialize any LOB resources before a read is done.

  This implementation calls BLOB.open(BLOB.MODE_READONLY) or CLOB.open(CLOB.MODE_READONLY) on any non-temporary LOBs if releaseResourcesAfterRead property is set to true.

  This method can be overridden by sublcasses if different behavior is desired.

  参数:

  con - the connection to be usde for initilization

  lob - the LOB to initialize

• releaseResourcesAfterRead

  protected void releaseResourcesAfterRead​(Connection con,
                                           Object lob)

  已过时。
  Release any LOB resources after read is complete.

  If releaseResourcesAfterRead property is set to true then this implementation calls BLOB.close() or CLOB.close() on any non-temporary LOBs that are open or BLOB.freeTemporary() or CLOB.freeTemporary() on any temporary LOBs.

  This method can be overridden by sublcasses if different behavior is desired.

  参数:

  con - the connection to be usde for initilization

  lob - the LOB to initialize