BlobClob4BlobTestCoverage

Lob size

Small (<=10K)

Medium(<200M)

Large(>200M)

Embedded

Client

java.sql.Clob

1.6

void

free()

InputStream

getAsciiStream()

C

C

X

X

Reader

getCharacterStream()

C

C

X

X

1.6

Reader

getCharacterStream(long pos, long length)

String

getSubString(long pos, int length)

C

C

X

X

long

length()

C

C

X

X

long

position(Clob searchstr, long start)

C

C

X

X

long

position(String searchstr, long start)

C

C

X

X

1.4

OutputStream

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()

InputStream

getBinaryStream()

B

B

X

X

1.6

InputStream

getBinaryStream(long pos, long length)

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="da2b79c4-6d0a-4949-b0d6-e908ec6c9247"><ac:plain-text-body><![CDATA[

byte[]

getBytes(long pos, int length)

B

B

X

X

]]></ac:plain-text-body></ac:structured-macro>

long

length()

B

B

X

X

long

position(Blob pattern, long start)

B

B

X

X

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="4db8613a-4ec7-4883-b3d6-d1e7de35b7bb"><ac:plain-text-body><![CDATA[

long

position(byte[] pattern, long start)

B

B

X

X

]]></ac:plain-text-body></ac:structured-macro>

1.4

OutputStream

setBinaryStream(long pos)

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="eb50e90d-e3a8-45ab-a774-fc23e0d4f39a"><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="d56f90f6-80ce-446c-9081-acbf6f98f481"><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)

InputStream

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="e2d87c3e-73a2-49b0-80e4-139738b5e9ea"><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="d90ce347-4baf-479b-90ed-04cfa9e3f508"><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)

OutputStream

void

close()

void

flush()

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="9ef512a8-5856-41df-b141-fe3afab3dc88"><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="858b2cc1-6a6e-4abd-b6c8-8e76f19297d5"><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="4719c9e7-68f7-4a36-b65d-67d865441b39"><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="d41c7031-74a2-4f94-afeb-b16505a3931b"><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="40ce6d24-48f7-4dac-8e66-c44e9128de3b"><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="ff40650f-3e56-467a-9c5b-e1159479e768"><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)

B

B

X

X

Blob

getBlob(String columnName)

1.4

void

updateBlob(int columnIndex, Blob x)

1.4

void

updateBlob(String columnName, Blob 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)

C

C

X

X

Clob

getClob(String columnName)

1.4

void

updateClob(int columnIndex, Clob x)

1.4

void

updateClob(String columnName, Clob 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)

C

X

void

updateCharacterStream(String columnName, Reader x, int length)

InputStream

getAsciiStream(int columnIndex)

InputStream

getAsciiStream(String columnName)

void

updateAsciiStream(int columnIndex, InputStream x, int length)

void

updateAsciiStream(String columnName, InputStream x, int length)

InputStream

getBinaryStream(int columnIndex)

InputStream

getBinaryStream(String columnName)

void

updateBinaryStream(int columnIndex, InputStream x, int length)

B

X

void

updateBinaryStream(String columnName, InputStream x, int length)

1.6

Reader

getNCharacterStream(int columnIndex)

1.6

Reader

getNCharacterStream(String columnName)

InputStream

getUnicodeStream(int columnIndex)

InputStream

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)

B

B

X

X

void

setBlob(int parameterIndex, InputStream inputStream, long length)

void

setCharacterStream(int parameterIndex, Reader reader, int length)

C

X

X

1.6

void

setCharacterStream(int parameterIndex, Reader reader, long length)

void

setClob(int parameterIndex, Clob x)

C

C

X

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()