DUE TO SPAM, SIGN-UP IS DISABLED. Goto Selfserve wiki signup and request an account.
Original test: lang/updatableResultSet.java
New test: lang/UpdatableResultSetTest.junit
|
Lob size |
|
|
||||||
|
Small (<=10K) |
Medium(<200M) |
Large(>200M) |
Embedded |
Client |
||||
java.sql.Clob |
|||||||||
1.6 |
void |
free() |
|
|
|
|
|
||
|
getAsciiStream() |
|
|
|
|
|
|||
|
Reader |
getCharacterStream() |
|
|
|
|
|
||
1.6 |
Reader |
getCharacterStream(long pos, long length) |
|
|
|
|
|
||
|
String |
getSubString(long pos, int length) |
|
|
|
|
|
||
|
long |
length() |
|
|
|
|
|
||
|
long |
position(Clob searchstr, long start) |
|
|
|
|
|
||
|
long |
position(String searchstr, long start) |
|
|
|
|
|
||
1.4 |
setAsciiStream(long pos) |
|
|
|
|
|
|||
1.4 |
Writer |
setCharacterStream(long pos) |
|
|
|
|
|
||
1.4 |
int |
setString(long pos, String str) |
|
|
|
|
|
||
1.4 |
int |
setString(long pos, String str, int offset, int len) |
|
|
|
|
|
||
1.4 |
void |
truncate(long len) |
|
|
|
|
|
||
java.sql.Blob |
|||||||||
1.6 |
void |
free() |
|
|
|
|
|
||
|
getBinaryStream() |
|
|
|
|
|
|||
1.6 |
getBinaryStream(long pos, long length) |
|
|
|
|
|
|||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="f240f878-694f-47d0-8be9-128d088be0d7"><ac:plain-text-body><![CDATA[ |
|
byte[] |
getBytes(long pos, int length) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
|
long |
length() |
|
|
|
|
|
||
|
long |
position(Blob pattern, long start) |
|
|
|
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="7c20d9e7-9ec1-4da4-a431-4db3a2fefd78"><ac:plain-text-body><![CDATA[ |
|
long |
position(byte[] pattern, long start) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
1.4 |
setBinaryStream(long pos) |
|
|
|
|
|
|||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="98e50641-0c6c-4103-becf-5a4fe7dc149b"><ac:plain-text-body><![CDATA[ |
1.4 |
int |
setBytes(long pos, byte[] bytes) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="eda8a35f-2a78-45a1-ae3d-4795bafb875e"><ac:plain-text-body><![CDATA[ |
1.4 |
int |
setBytes(long pos, byte[] bytes, int offset, int len) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
1.4 |
void |
truncate(long len) |
|
|
|
|
|
||
|
int |
available() |
|
|
|
|
|
||
|
void |
close() |
|
|
|
|
|
||
|
void |
mark (int readlimit) |
|
|
|
|
|
||
|
boolean |
markSupported() |
|
|
|
|
|
||
|
int |
read() |
|
|
|
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b1d233f1-ad21-4bfc-915a-8a1103af4ca8"><ac:plain-text-body><![CDATA[ |
|
int |
read(byte[] b) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="232b8f58-a523-4e2c-a87f-9fac59897036"><ac:plain-text-body><![CDATA[ |
|
int |
read(byte[] b, int off, int len) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
|
void |
reset() |
|
|
|
|
|
||
|
long |
skip(long n) |
|
|
|
|
|
||
|
void |
close() |
|
|
|
|
|
||
|
void |
flush() |
|
|
|
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="1d36a3bd-ce1e-4c83-8190-ff831f197b41"><ac:plain-text-body><![CDATA[ |
|
void |
write(byte[] b) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="61117ae2-2617-4f1f-a223-e4893e5710c0"><ac:plain-text-body><![CDATA[ |
|
void |
write(byte[] b, int off, int len) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
|
void |
write(int b) |
|
|
|
|
|
||
Reader |
|||||||||
|
void |
close() |
|
|
|
|
|
||
|
void |
mark(int readlimit) |
|
|
|
|
|
||
|
boolean |
markSupported() |
|
|
|
|
|
||
|
int |
read() |
|
|
|
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="b7f9a97e-7643-4702-9c3b-4fd59ae08ddf"><ac:plain-text-body><![CDATA[ |
|
int |
read(char[] buff) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="c1f99884-d916-462e-96a5-5ff633bc4c0d"><ac:plain-text-body><![CDATA[ |
|
int |
read(char[] buff, int off, int len) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
|
int |
read(CharBuffer target) |
|
|
|
|
|
||
|
boolean |
ready() |
|
|
|
|
|
||
|
void |
reset() |
|
|
|
|
|
||
|
long |
skip(long n) |
|
|
|
|
|
||
Writer |
|||||||||
|
Writer |
append(char c) |
|
|
|
|
|
||
|
Writer |
append(CharSequence csq) |
|
|
|
|
|
||
|
Writer |
append(CharSequence csq, int start, int end) |
|
|
|
|
|
||
|
void |
close() |
|
|
|
|
|
||
|
void |
flush() |
|
|
|
|
|
||
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="10d19f6c-5661-4903-81af-2a57e4f83248"><ac:plain-text-body><![CDATA[ |
|
void |
write(char[] cbuf) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="d93b0757-7479-4007-998d-507540e35a8d"><ac:plain-text-body><![CDATA[ |
|
void |
write(char[] cbuf, int off, int len) |
|
|
|
|
|
]]></ac:plain-text-body></ac:structured-macro> |
|
void |
write(int c) |
|
|
|
|
|
||
|
void |
write(String str) |
|
|
|
|
|
||
|
void |
write(String str, int off, int len) |
|
|
|
|
|
||
java.sql.ResultSet |
|||||||||
|
Blob |
getBlob(int columnIndex) |
|
|
|
|
|
||
|
Blob |
getBlob(String columnName) |
|
|
|
|
|
||
1.4 |
void |
updateBlob(int columnIndex, Blob x) |
X |
|
|
X |
X |
||
1.4 |
void |
updateBlob(String columnName, Blob x) |
X |
|
|
X |
X |
||
1.6 |
void |
updateBlob(int columnIndex, InputStream inputStream, long length) |
|
|
|
|
|
||
1.6 |
void |
updateBlob(String columnName, InputStream inputStream, long length) |
|
|
|
|
|
||
|
Clob |
getClob(int columnIndex) |
|
|
|
|
|
||
|
Clob |
getClob(String columnName) |
|
|
|
|
|
||
1.4 |
void |
updateClob(int columnIndex, Clob x) |
X |
|
|
X |
X |
||
1.4 |
void |
updateClob(String columnName, Clob x) |
X |
|
|
X |
X |
||
1.6 |
void |
updateClob(int columnIndex, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
void |
updateClob(String columnName, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
NClob |
getNClob(int columnIndex) |
|
|
|
|
|
||
1.6 |
NClob |
getNClob(String columnName) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(int columnIndex, NClob nClob) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(String columnName, NClob nClob) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(int columnIndex, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(String columnName, Reader reader, long length) |
|
|
|
|
|
||
|
Reader |
getCharacterStream(int columnIndex) |
|
|
|
|
|
||
|
Reader |
getCharacterStream(String columnName) |
|
|
|
|
|
||
|
void |
updateCharacterStream(int columnIndex, Reader x, int length) |
X |
|
|
X |
X |
||
|
void |
updateCharacterStream(String columnName, Reader x, int length) |
X |
|
|
X |
X |
||
|
getAsciiStream(int columnIndex) |
|
|
|
|
|
|||
|
getAsciiStream(String columnName) |
|
|
|
|
|
|||
|
void |
updateAsciiStream(int columnIndex, InputStream x, int length) |
X |
|
|
X |
X |
||
|
void |
updateAsciiStream(String columnName, InputStream x, int length) |
X |
|
|
X |
X |
||
|
getBinaryStream(int columnIndex) |
|
|
|
|
|
|||
|
getBinaryStream(String columnName) |
|
|
|
|
|
|||
|
void |
updateBinaryStream(int columnIndex, InputStream x, int length) |
X |
|
|
X |
X |
||
|
void |
updateBinaryStream(String columnName, InputStream x, int length) |
X |
|
|
X |
X |
||
1.6 |
Reader |
getNCharacterStream(int columnIndex) |
|
|
|
|
|
||
1.6 |
Reader |
getNCharacterStream(String columnName) |
|
|
|
|
|
||
|
getUnicodeStream(int columnIndex) |
|
|
|
|
|
|||
|
getUnicodeStream(String columnName) |
|
|
|
|
|
|||
1.6 |
void |
updateAsciiStream(int columnIndex, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
updateAsciiStream(java.lang.String columnLabel, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
updateBinaryStream(int columnIndex, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
updateBinaryStream(java.lang.String columnLabel, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
updateCharacterStream(int columnIndex, java.io.Reader x) |
|
|
|
|
|
||
1.6 |
void |
updateCharacterStream(java.lang.String columnLabel, java.io.Reader x) |
|
|
|
|
|
||
1.6 |
void |
updateNCharacterStream(int columnIndex, java.io.Reader x) |
|
|
|
|
|
||
1.6 |
void |
updateNCharacterStream(java.lang.String columnLabel, java.io.Reader x) |
|
|
|
|
|
||
1.6 |
void |
updateBlob(int columnIndex, java.io.InputStream inputStream) |
|
|
|
|
|
||
1.6 |
void |
updateBlob(java.lang.String columnLabel, java.io.InputStream inputStream) |
|
|
|
|
|
||
1.6 |
void |
updateClob(int columnIndex, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
updateClob(java.lang.String columnLabel, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(int columnIndex, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
updateNClob(java.lang.String columnLabel, java.io.Reader reader) |
|
|
|
|
|
||
java.sql.PreparedStatement |
|||||||||
|
void |
setAsciiStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setAsciiStream(int parameterIndex, InputStream x, long length) |
|
|
|
|
|
||
|
void |
setBinaryStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setBinaryStream(int parameterIndex, InputStream x, long length) |
|
|
|
|
|
||
|
void |
setBlob(int parameterIndex, Blob x) |
|
|
|
|
|
||
|
void |
setBlob(int parameterIndex, InputStream inputStream, long length) |
|
|
|
|
|
||
|
void |
setCharacterStream(int parameterIndex, Reader reader, int length) |
|
|
|
|
|
||
1.6 |
void |
setCharacterStream(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
|
void |
setClob(int parameterIndex, Clob x) |
|
|
|
|
|
||
1.6 |
void |
setClob(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
void |
setNCharacterStream(int parameterIndex, Reader value, long length) |
|
|
|
|
|
||
1.6 |
void |
setNClob(int parameterIndex, NClob value) |
|
|
|
|
|
||
1.6 |
void |
setNClob(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
|
void |
setUnicodeStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setAsciiStream(int parameterIndex, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
setBinaryStream(int parameterIndex, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
setCharacterStream(int parameterIndex, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setNCharacterStream(int parameterIndex, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setBlob(int parameterIndex, java.io.InputStream inputStream) |
|
|
|
|
|
||
1.6 |
void |
setClob(int parameterIndex, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setNClob(int parameterIndex, java.io.Reader reader) |
|
|
|
|
|
||
java.sql.CallableStatement |
|||||||||
|
void |
setAsciiStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setAsciiStream(int parameterIndex, InputStream x, long length) |
|
|
|
|
|
||
|
void |
setBinaryStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setBinaryStream(int parameterIndex, InputStream x, long length) |
|
|
|
|
|
||
|
void |
setBlob(int parameterIndex, Blob x) |
|
|
|
|
|
||
|
void |
setBlob(int parameterIndex, InputStream inputStream, long length) |
|
|
|
|
|
||
|
void |
setCharacterStream(int parameterIndex, Reader reader, int length) |
|
|
|
|
|
||
1.6 |
void |
setCharacterStream(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
|
void |
setClob(int parameterIndex, Clob x) |
|
|
|
|
|
||
1.6 |
void |
setClob(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
void |
setNCharacterStream(int parameterIndex, Reader value, long length) |
|
|
|
|
|
||
1.6 |
void |
setNClob(int parameterIndex, NClob value) |
|
|
|
|
|
||
1.6 |
void |
setNClob(int parameterIndex, Reader reader, long length) |
|
|
|
|
|
||
|
void |
setUnicodeStream(int parameterIndex, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setAsciiStream(java.lang.String parameterName, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
setBinaryStream(java.lang.String parameterName, java.io.InputStream x) |
|
|
|
|
|
||
1.6 |
void |
setCharacterStream(java.lang.String parameterName, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setNCharacterStream(java.lang.String parameterName, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setBlob(java.lang.String parameterName, java.io.InputStream inputStream) |
|
|
|
|
|
||
1.6 |
void |
setClob(java.lang.String parameterName, java.io.Reader reader) |
|
|
|
|
|
||
1.6 |
void |
setNClob(java.lang.String parameterName, java.io.Reader reader) |
|
|
|
|
|
||
|
Blob |
getBlob(int parameterIndex) |
|
|
|
|
|
||
1.4 |
Blob |
getBlob(String parameterName) |
|
|
|
|
|
||
1.6 |
Reader |
getCharacterStream(int parameterIndex) |
|
|
|
|
|
||
1.6 |
Reader |
getCharacterStream(String parameterName) |
|
|
|
|
|
||
|
Clob |
getClob(int parameterIndex) |
|
|
|
|
|
||
1.4 |
Clob |
getClob(String parameterName) |
|
|
|
|
|
||
1.6 |
Reader |
getNCharacterStream(int parameterIndex) |
|
|
|
|
|
||
1.6 |
Reader |
getNCharacterStream(String parameterName) |
|
|
|
|
|
||
1.6 |
NClob |
getNClob(int parameterIndex) |
|
|
|
|
|
||
1.6 |
NClob |
getNClob(String parameterName) |
|
|
|
|
|
||
1.4 |
void |
setAsciiStream(String parameterName, InputStream x, int length) |
|
|
|
|
|
||
1.4 |
void |
setBinaryStream(String parameterName, InputStream x, int length) |
|
|
|
|
|
||
1.6 |
void |
setBlob(String parameterName, InputStream inputStream, long length) |
|
|
|
|
|
||
1.4 |
void |
setCharacterStream(String parameterName, Reader reader, int length) |
|
|
|
|
|
||
1.6 |
void |
setClob(String parameterName, Reader reader, long length) |
|
|
|
|
|
||
1.6 |
void |
setNCharacterStream(String parameterName, Reader value, long length) |
|
|
|
|
|
||
1.6 |
void |
setNClob(String parameterName, NClob value) |
|
|
|
|
|
||
1.6 |
void |
setNClob(String parameterName, Reader reader, long length) |
|
|
|
|
|
||
java.sql.Connection: |
|||||||||
1.6 |
Blob |
createBlob() |
|
|
|
|
|
||
1.6 |
Clob |
createClob() |
|
|
|
|
|
||
1.6 |
NClob |
createNClob() |
|
|
|
|
|
B - Blob
C - Clob