Default implementation of the LobHandler interface. Invokes the direct accessor methods that java.sql.ResultSet and java.sql.PreparedStatement offer.

By default, incoming streams are going to be passed to the appropriate setBinary/Ascii/CharacterStream method on the JDBC driver's PreparedStatement. If the specified content length is negative, this handler will use the JDBC 4.0 variants of the set-stream methods without a length parameter; otherwise, it will pass the specified length on to the driver.

This LobHandler should work for any JDBC driver that is JDBC compliant in terms of the spec's suggestions regarding simple BLOB and CLOB handling. This does not apply to Oracle 9i's drivers at all; as of Oracle 10g, it does work but may still come with LOB size limitations. Consider using recent Oracle drivers even when working against an older database server. See the LobHandler javadoc for the full set of recommendations.

Some JDBC drivers require values with a BLOB/CLOB target column to be explicitly set through the JDBC setBlob / setClob API: for example, PostgreSQL's driver. Switch the "wrapAsLob" property to "true" when operating against such a driver.

On JDBC 4.0, this LobHandler also supports streaming the BLOB/CLOB content via the setBlob / setClob variants that take a stream argument directly. Consider switching the "streamAsLob" property to "true" when operating against a fully compliant JDBC 4.0 driver.

Finally, this LobHandler also supports the creation of temporary BLOB/CLOB objects. Consider switching the "createTemporaryLob" property to "true" when "streamAsLob" happens to run into LOB size limitations.

See the LobHandler interface javadoc for a summary of recommendations.

Modifier and Type	Class and Description
protected class	DefaultLobHandler.DefaultLobCreator Default LobCreator implementation as an inner class.

Modifier and Type	Field and Description
private boolean	createTemporaryLob
protected final Log	logger
private boolean	streamAsLob
private boolean	wrapAsLob

Constructor Summary

Access	Constructor and Description
public	DefaultLobHandler()

Method Summary

Modifier and Type	Method and Description
public InputStream	getBlobAsBinaryStream(ResultSet the ResultSet to retrieve the content from rs, int the column index to use columnIndex) Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBinaryStream. Retrieve the given column as binary stream from the given ResultSet.
public byte[]	getBlobAsBytes(ResultSet the ResultSet to retrieve the content from rs, int the column index to use columnIndex) Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBytes. Retrieve the given column as bytes from the given ResultSet.
public InputStream	getClobAsAsciiStream(ResultSet the ResultSet to retrieve the content from rs, int the column index to use columnIndex) Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsAsciiStream. Retrieve the given column as ASCII stream from the given ResultSet.
public Reader	getClobAsCharacterStream(ResultSet the ResultSet to retrieve the content from rs, int the column index to use columnIndex) Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsCharacterStream. Retrieve the given column as character stream from the given ResultSet.
public String	getClobAsString(ResultSet the ResultSet to retrieve the content from rs, int the column index to use columnIndex) Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsString. Retrieve the given column as String from the given ResultSet.
public LobCreator	getLobCreator() Implements org.springframework.jdbc.support.lob.LobHandler.getLobCreator. Create a new `LobCreator` instance, i.e. a session for creating BLOBs and CLOBs.
public void	setCreateTemporaryLob(boolean createTemporaryLob) Specify whether to copy a byte array / String into a temporary JDBC Blob / Clob object created through the JDBC 4.0 `createBlob` / `createClob` methods.
public void	setStreamAsLob(boolean streamAsLob) Specify whether to submit a binary stream / character stream to the JDBC driver as explicit LOB content, using the JDBC 4.0 `setBlob` / `setClob` method with a stream argument.
public void	setWrapAsLob(boolean wrapAsLob) Specify whether to submit a byte array / String to the JDBC driver wrapped in a JDBC Blob / Clob object, using the JDBC `setBlob` / `setClob` method with a Blob / Clob argument.

Inherited from org.springframework.jdbc.support.lob.AbstractLobHandler:: getBlobAsBinaryStream getBlobAsBytes getClobAsAsciiStream getClobAsCharacterStream getClobAsString

Field Detail

createTemporaryLob	back to summary
private boolean createTemporaryLob

logger	back to summary
protected final Log logger

streamAsLob	back to summary
private boolean streamAsLob

wrapAsLob	back to summary
private boolean wrapAsLob

Constructor Detail

DefaultLobHandler	back to summary
public DefaultLobHandler()

Method Detail

getBlobAsBinaryStream back to summary

getBlobAsBinaryStream	back to summary
public InputStream getBlobAsBinaryStream(ResultSet rs, int columnIndex) throws SQLException Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBinaryStream. Doc from org.springframework.jdbc.support.lob.LobHandler.getBlobAsBinaryStream. 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. Parameters rs:ResultSet the ResultSet to retrieve the content from columnIndex:int the column index to use Returns:InputStream the content as binary stream, or `null` in case of SQL NULL Annotations @Override @Nullable Exceptions SQLException: if thrown by JDBC methods

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

Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBinaryStream.

Doc from org.springframework.jdbc.support.lob.LobHandler.getBlobAsBinaryStream.

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.

Parameters

rs:ResultSet: the ResultSet to retrieve the content from
columnIndex:int: the column index to use

Returns:InputStream

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

Annotations

@Override
@Nullable

Exceptions

SQLException:: if thrown by JDBC methods

getBlobAsBytes back to summary

getBlobAsBytes	back to summary
public byte[] getBlobAsBytes(ResultSet rs, int columnIndex) throws SQLException Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBytes. Doc from org.springframework.jdbc.support.lob.LobHandler.getBlobAsBytes. 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. Parameters rs:ResultSet the ResultSet to retrieve the content from columnIndex:int the column index to use Returns:byte[] the content as byte array, or `null` in case of SQL NULL Annotations @Override @Nullable Exceptions SQLException: if thrown by JDBC methods

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

Implements org.springframework.jdbc.support.lob.LobHandler.getBlobAsBytes.

Doc from org.springframework.jdbc.support.lob.LobHandler.getBlobAsBytes.

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.

Parameters

rs:ResultSet: the ResultSet to retrieve the content from
columnIndex:int: the column index to use

Returns:byte[]

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

Annotations

@Override
@Nullable

Exceptions

SQLException:: if thrown by JDBC methods

getClobAsAsciiStream back to summary

getClobAsAsciiStream	back to summary
public InputStream getClobAsAsciiStream(ResultSet rs, int columnIndex) throws SQLException Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsAsciiStream. Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsAsciiStream. 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. Parameters rs:ResultSet the ResultSet to retrieve the content from columnIndex:int the column index to use Returns:InputStream the content as ASCII stream, or `null` in case of SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

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

Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsAsciiStream.

Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsAsciiStream.

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.

Parameters

rs:ResultSet: the ResultSet to retrieve the content from
columnIndex:int: the column index to use

Returns:InputStream

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

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

getClobAsCharacterStream back to summary

getClobAsCharacterStream	back to summary
public Reader getClobAsCharacterStream(ResultSet rs, int columnIndex) throws SQLException Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsCharacterStream. Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsCharacterStream. 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. Parameters rs:ResultSet the ResultSet to retrieve the content from columnIndex:int the column index to use Returns:Reader the content as character stream Annotations @Override Exceptions SQLException: if thrown by JDBC methods

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

Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsCharacterStream.

Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsCharacterStream.

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.

Parameters

rs:ResultSet: the ResultSet to retrieve the content from
columnIndex:int: the column index to use

Returns:Reader

the content as character stream

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

getClobAsString back to summary

getClobAsString	back to summary
public String getClobAsString(ResultSet rs, int columnIndex) throws SQLException Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsString. Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsString. 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. Parameters rs:ResultSet the ResultSet to retrieve the content from columnIndex:int the column index to use Returns:String the content as String, or `null` in case of SQL NULL Annotations @Override @Nullable Exceptions SQLException: if thrown by JDBC methods

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

Implements org.springframework.jdbc.support.lob.LobHandler.getClobAsString.

Doc from org.springframework.jdbc.support.lob.LobHandler.getClobAsString.

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.

Parameters

rs:ResultSet: the ResultSet to retrieve the content from
columnIndex:int: the column index to use

Returns:String

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

Annotations

@Override
@Nullable

Exceptions

SQLException:: if thrown by JDBC methods

getLobCreator back to summary

getLobCreator	back to summary
public LobCreator getLobCreator() Implements org.springframework.jdbc.support.lob.LobHandler.getLobCreator. Doc from org.springframework.jdbc.support.lob.LobHandler.getLobCreator. 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. Returns:LobCreator the new LobCreator instance Annotations @Override

public LobCreator getLobCreator()

Implements org.springframework.jdbc.support.lob.LobHandler.getLobCreator.

Doc from org.springframework.jdbc.support.lob.LobHandler.getLobCreator.

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.

Returns:LobCreator

the new LobCreator instance

Annotations

@Override

setCreateTemporaryLob back to summary

setCreateTemporaryLob	back to summary
public void setCreateTemporaryLob(boolean createTemporaryLob) Specify whether to copy a byte array / String into a temporary JDBC Blob / Clob object created through the JDBC 4.0 `createBlob` / `createClob` methods. Default is "false", using the common JDBC 2.0 `setBinaryStream` / `setCharacterStream` method for setting the content. Switch this to "true" for explicit Blob / Clob creation using JDBC 4.0. This setting affects stream arguments as well as byte array / String arguments, requiring JDBC 4.0 support. For supporting LOB content against JDBC 3.0, check out the `"wrapAsLob"` setting. See Also `java.sql.Connection#createBlob()`, `java.sql.Connection#createClob()`

public void setCreateTemporaryLob(boolean createTemporaryLob)

Specify whether to copy a byte array / String into a temporary JDBC Blob / Clob object created through the JDBC 4.0 createBlob / createClob methods.

Default is "false", using the common JDBC 2.0 setBinaryStream / setCharacterStream method for setting the content. Switch this to "true" for explicit Blob / Clob creation using JDBC 4.0.

This setting affects stream arguments as well as byte array / String arguments, requiring JDBC 4.0 support. For supporting LOB content against JDBC 3.0, check out the "wrapAsLob" setting.

See Also: java.sql.Connection#createBlob(), java.sql.Connection#createClob()

setStreamAsLob back to summary

setStreamAsLob	back to summary
public void setStreamAsLob(boolean streamAsLob) Specify whether to submit a binary stream / character stream to the JDBC driver as explicit LOB content, using the JDBC 4.0 `setBlob` / `setClob` method with a stream argument. Default is "false", using the common JDBC 2.0 `setBinaryStream` / `setCharacterStream` method for setting the content. Switch this to "true" for explicit JDBC 4.0 streaming, provided that your JDBC driver actually supports those JDBC 4.0 operations (e.g. Derby's). This setting affects stream arguments as well as byte array / String arguments, requiring JDBC 4.0 support. For supporting LOB content against JDBC 3.0, check out the `"wrapAsLob"` setting. See Also `java.sql.PreparedStatement#setBlob(int, java.io.InputStream, long)`, `java.sql.PreparedStatement#setClob(int, java.io.Reader, long)`

public void setStreamAsLob(boolean streamAsLob)

Specify whether to submit a binary stream / character stream to the JDBC driver as explicit LOB content, using the JDBC 4.0 setBlob / setClob method with a stream argument.

Default is "false", using the common JDBC 2.0 setBinaryStream / setCharacterStream method for setting the content. Switch this to "true" for explicit JDBC 4.0 streaming, provided that your JDBC driver actually supports those JDBC 4.0 operations (e.g. Derby's).

This setting affects stream arguments as well as byte array / String arguments, requiring JDBC 4.0 support. For supporting LOB content against JDBC 3.0, check out the "wrapAsLob" setting.

See Also: java.sql.PreparedStatement#setBlob(int, java.io.InputStream, long), java.sql.PreparedStatement#setClob(int, java.io.Reader, long)

setWrapAsLob back to summary

setWrapAsLob	back to summary
public void setWrapAsLob(boolean wrapAsLob) Specify whether to submit a byte array / String to the JDBC driver wrapped in a JDBC Blob / Clob object, using the JDBC `setBlob` / `setClob` method with a Blob / Clob argument. Default is "false", using the common JDBC 2.0 `setBinaryStream` / `setCharacterStream` method for setting the content. Switch this to "true" for explicit Blob / Clob wrapping against JDBC drivers that are known to require such wrapping (e.g. PostgreSQL's for access to OID columns, whereas BYTEA columns need to be accessed the standard way). This setting affects byte array / String arguments as well as stream arguments, unless `"streamAsLob"` overrides this handling to use JDBC 4.0's new explicit streaming support (if available). See Also `java.sql.PreparedStatement#setBlob(int, java.sql.Blob)`, `java.sql.PreparedStatement#setClob(int, java.sql.Clob)`

public void setWrapAsLob(boolean wrapAsLob)

Specify whether to submit a byte array / String to the JDBC driver wrapped in a JDBC Blob / Clob object, using the JDBC setBlob / setClob method with a Blob / Clob argument.

Default is "false", using the common JDBC 2.0 setBinaryStream / setCharacterStream method for setting the content. Switch this to "true" for explicit Blob / Clob wrapping against JDBC drivers that are known to require such wrapping (e.g. PostgreSQL's for access to OID columns, whereas BYTEA columns need to be accessed the standard way).

This setting affects byte array / String arguments as well as stream arguments, unless "streamAsLob" overrides this handling to use JDBC 4.0's new explicit streaming support (if available).

See Also: java.sql.PreparedStatement#setBlob(int, java.sql.Blob), java.sql.PreparedStatement#setClob(int, java.sql.Clob)

org.springframework.jdbc.support.lob back to summary

protected Class DefaultLobHandler.DefaultLobCreator

Class Inheritance

extends Object
implements LobCreator

java.lang.Object
org.springframework.jdbc.support.lob.DefaultLobHandler.DefaultLobCreator

All Implemented Interfaces

org.springframework.jdbc.support.lob.LobCreator, java.io.Closeable, java.lang.AutoCloseable

Default LobCreator implementation as an inner class. Can be subclassed in DefaultLobHandler extensions.

Constructor Summary

Access	Constructor and Description
protected	DefaultLobCreator()

Method Summary

Modifier and Type	Method and Description
public void	close() Implements org.springframework.jdbc.support.lob.LobCreator.close. Close this LobCreator session and free its temporarily created BLOBs and CLOBs.
public void	setBlobAsBinaryStream(PreparedStatement the PreparedStatement to the set the content on ps, int the parameter index to use paramIndex, InputStream the content as binary stream, or `null` for SQL NULL binaryStream, int contentLength) Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBinaryStream. Set the given content as binary stream on the given statement, using the given parameter index.
public void	setBlobAsBytes(PreparedStatement the PreparedStatement to the set the content on ps, int the parameter index to use paramIndex, byte[] the content as byte array, or `null` for SQL NULL content) Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBytes. Set the given content as bytes on the given statement, using the given parameter index.
public void	setClobAsAsciiStream(PreparedStatement the PreparedStatement to the set the content on ps, int the parameter index to use paramIndex, InputStream the content as ASCII stream, or `null` for SQL NULL asciiStream, int contentLength) Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsAsciiStream. Set the given content as ASCII stream on the given statement, using the given parameter index.
public void	setClobAsCharacterStream(PreparedStatement the PreparedStatement to the set the content on ps, int the parameter index to use paramIndex, Reader the content as character stream, or `null` for SQL NULL characterStream, int contentLength) Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsCharacterStream. Set the given content as character stream on the given statement, using the given parameter index.
public void	setClobAsString(PreparedStatement the PreparedStatement to the set the content on ps, int the parameter index to use paramIndex, String the content as String, or `null` for SQL NULL content) Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsString. Set the given content as String on the given statement, using the given parameter index.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

DefaultLobCreator	back to summary
protected DefaultLobCreator()

Method Detail

close	back to summary
public void close() Implements org.springframework.jdbc.support.lob.LobCreator.close. Doc from org.springframework.jdbc.support.lob.LobCreator.close. Close this LobCreator session and free its temporarily created BLOBs and CLOBs. Will not need to do anything if using PreparedStatement's standard methods, but might be necessary to free database resources if using proprietary means. Note Needs to be invoked after the involved PreparedStatements have been executed or the affected O/R mapping sessions have been flushed. Otherwise, the database resources for the temporary BLOBs might stay allocated. Annotations @Override

back to summary

public void close()

Implements org.springframework.jdbc.support.lob.LobCreator.close.

Doc from org.springframework.jdbc.support.lob.LobCreator.close.

Close this LobCreator session and free its temporarily created BLOBs and CLOBs. Will not need to do anything if using PreparedStatement's standard methods, but might be necessary to free database resources if using proprietary means.

Note

Needs to be invoked after the involved PreparedStatements have been executed or the affected O/R mapping sessions have been flushed. Otherwise, the database resources for the temporary BLOBs might stay allocated.

Annotations

@Override

setBlobAsBinaryStream back to summary

setBlobAsBinaryStream	back to summary
public void setBlobAsBinaryStream(PreparedStatement ps, int paramIndex, InputStream binaryStream, int contentLength) throws SQLException Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBinaryStream. Doc from org.springframework.jdbc.support.lob.LobCreator.setBlobAsBinaryStream. Set the given content as binary stream on the given statement, using the given parameter index. Might simply invoke `PreparedStatement.setBinaryStream` or create a Blob instance for it, depending on the database and driver. Parameters ps:PreparedStatement the PreparedStatement to the set the content on paramIndex:int the parameter index to use binaryStream:InputStream the content as binary stream, or `null` for SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

public void setBlobAsBinaryStream(PreparedStatement ps, int paramIndex, InputStream binaryStream, int contentLength) throws SQLException

Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBinaryStream.

Doc from org.springframework.jdbc.support.lob.LobCreator.setBlobAsBinaryStream.

Set the given content as binary stream on the given statement, using the given parameter index. Might simply invoke PreparedStatement.setBinaryStream or create a Blob instance for it, depending on the database and driver.

Parameters

ps:PreparedStatement: the PreparedStatement to the set the content on
paramIndex:int: the parameter index to use
binaryStream:InputStream: the content as binary stream, or null for SQL NULL

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

setBlobAsBytes back to summary

setBlobAsBytes	back to summary
public void setBlobAsBytes(PreparedStatement ps, int paramIndex, byte[] content) throws SQLException Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBytes. Doc from org.springframework.jdbc.support.lob.LobCreator.setBlobAsBytes. Set the given content as bytes on the given statement, using the given parameter index. Might simply invoke `PreparedStatement.setBytes` or create a Blob instance for it, depending on the database and driver. Parameters ps:PreparedStatement the PreparedStatement to the set the content on paramIndex:int the parameter index to use content:byte[] the content as byte array, or `null` for SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

public void setBlobAsBytes(PreparedStatement ps, int paramIndex, byte[] content) throws SQLException

Implements org.springframework.jdbc.support.lob.LobCreator.setBlobAsBytes.

Doc from org.springframework.jdbc.support.lob.LobCreator.setBlobAsBytes.

Set the given content as bytes on the given statement, using the given parameter index. Might simply invoke PreparedStatement.setBytes or create a Blob instance for it, depending on the database and driver.

Parameters

ps:PreparedStatement: the PreparedStatement to the set the content on
paramIndex:int: the parameter index to use
content:byte[]: the content as byte array, or null for SQL NULL

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

setClobAsAsciiStream back to summary

setClobAsAsciiStream	back to summary
public void setClobAsAsciiStream(PreparedStatement ps, int paramIndex, InputStream asciiStream, int contentLength) throws SQLException Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsAsciiStream. Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsAsciiStream. Set the given content as ASCII stream on the given statement, using the given parameter index. Might simply invoke `PreparedStatement.setAsciiStream` or create a Clob instance for it, depending on the database and driver. Parameters ps:PreparedStatement the PreparedStatement to the set the content on paramIndex:int the parameter index to use asciiStream:InputStream the content as ASCII stream, or `null` for SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

public void setClobAsAsciiStream(PreparedStatement ps, int paramIndex, InputStream asciiStream, int contentLength) throws SQLException

Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsAsciiStream.

Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsAsciiStream.

Set the given content as ASCII stream on the given statement, using the given parameter index. Might simply invoke PreparedStatement.setAsciiStream or create a Clob instance for it, depending on the database and driver.

Parameters

ps:PreparedStatement: the PreparedStatement to the set the content on
paramIndex:int: the parameter index to use
asciiStream:InputStream: the content as ASCII stream, or null for SQL NULL

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

setClobAsCharacterStream back to summary

setClobAsCharacterStream	back to summary
public void setClobAsCharacterStream(PreparedStatement ps, int paramIndex, Reader characterStream, int contentLength) throws SQLException Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsCharacterStream. Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsCharacterStream. Set the given content as character stream on the given statement, using the given parameter index. Might simply invoke `PreparedStatement.setCharacterStream` or create a Clob instance for it, depending on the database and driver. Parameters ps:PreparedStatement the PreparedStatement to the set the content on paramIndex:int the parameter index to use characterStream:Reader the content as character stream, or `null` for SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

public void setClobAsCharacterStream(PreparedStatement ps, int paramIndex, Reader characterStream, int contentLength) throws SQLException

Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsCharacterStream.

Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsCharacterStream.

Set the given content as character stream on the given statement, using the given parameter index. Might simply invoke PreparedStatement.setCharacterStream or create a Clob instance for it, depending on the database and driver.

Parameters

ps:PreparedStatement: the PreparedStatement to the set the content on
paramIndex:int: the parameter index to use
characterStream:Reader: the content as character stream, or null for SQL NULL

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

setClobAsString back to summary

setClobAsString	back to summary
public void setClobAsString(PreparedStatement ps, int paramIndex, String content) throws SQLException Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsString. Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsString. Set the given content as String on the given statement, using the given parameter index. Might simply invoke `PreparedStatement.setString` or create a Clob instance for it, depending on the database and driver. Parameters ps:PreparedStatement the PreparedStatement to the set the content on paramIndex:int the parameter index to use content:String the content as String, or `null` for SQL NULL Annotations @Override Exceptions SQLException: if thrown by JDBC methods

public void setClobAsString(PreparedStatement ps, int paramIndex, String content) throws SQLException

Implements org.springframework.jdbc.support.lob.LobCreator.setClobAsString.

Doc from org.springframework.jdbc.support.lob.LobCreator.setClobAsString.

Set the given content as String on the given statement, using the given parameter index. Might simply invoke PreparedStatement.setString or create a Clob instance for it, depending on the database and driver.

Parameters

ps:PreparedStatement: the PreparedStatement to the set the content on
paramIndex:int: the parameter index to use
content:String: the content as String, or null for SQL NULL

Annotations

@Override

Exceptions

SQLException:: if thrown by JDBC methods

public Class DefaultLobHandler

Nested and Inner Type Summary

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail

protected Class DefaultLobHandler.DefaultLobCreator

Constructor Summary

Method Summary

Constructor Detail

Method Detail