You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/12/20 19:41:33 UTC
[Db-derby Wiki] Update of "PrepareStatementTestCoverage" by OysteinGrovlen
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.
The following page has been changed by OysteinGrovlen:
http://wiki.apache.org/db-derby/PrepareStatementTestCoverage
New page:
Original test: derbynet/prepStmt.java [[BR]]
New test: derbynet/PrepareStatementTest.junit [[BR]]
[[BR]]
[[BR]]
||<-3> ||<-3> Lob size || || ||
||<-3> || Small (<=10K) || Medium(<200M) || Large(>200M) || Embedded || Client ||
||<-8>java.sql.Clob ||
|| 1.6 || void || free() || || || || || ||
|| || InputStream || 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 || 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) || || || || || ||
||<-8>java.sql.Blob ||
|| 1.6 || void || free() || || || || || ||
|| || InputStream || getBinaryStream() || || || || || ||
|| 1.6 || InputStream || getBinaryStream(long pos, long length) || || || || || ||
|| || byte[] || getBytes(long pos, int length) || || || || || ||
|| || long || length() || || || || || ||
|| || long || position(Blob pattern, long start) || || || || || ||
|| || long || position(byte[] pattern, long start) || || || || || ||
|| 1.4 || OutputStream || setBinaryStream(long pos) || || || || || ||
|| 1.4 || int || setBytes(long pos, byte[] bytes) || || || || || ||
|| 1.4 || int || setBytes(long pos, byte[] bytes, int offset, int len) || || || || || ||
|| 1.4 || void || truncate(long len) || || || || || ||
||<-8> InputStream ||
|| || int || available() || || || || || ||
|| || void || close() || || || || || ||
|| || void || mark (int readlimit) || || || || || ||
|| || boolean || markSupported() || || || || || ||
|| || int || read() || || || || || ||
|| || int || read(byte[] b) || || || || || ||
|| || int || read(byte[] b, int off, int len) || || || || || ||
|| || void || reset() || || || || || ||
|| || long || skip(long n) || || || || || ||
||<-8> OutputStream ||
|| || void || close() || || || || || ||
|| || void || flush() || || || || || ||
|| || void || write(byte[] b) || || || || || ||
|| || void || write(byte[] b, int off, int len) || || || || || ||
|| || void || write(int b) || || || || || ||
||<-8> Reader ||
|| || void || close() || || || || || ||
|| || void || mark(int readlimit) || || || || || ||
|| || boolean || markSupported() || || || || || ||
|| || int || read() || || || || || ||
|| || int || read(char[] buff) || || || || || ||
|| || int || read(char[] buff, int off, int len) || || || || || ||
|| || int || read(CharBuffer target) || || || || || ||
|| || boolean || ready() || || || || || ||
|| || void || reset() || || || || || ||
|| || long || skip(long n) || || || || || ||
||<-8> Writer ||
|| || Writer || append(char c) || || || || || ||
|| || Writer || append(CharSequence csq) || || || || || ||
|| || Writer || append(CharSequence csq, int start, int end) || || || || || ||
|| || void || close() || || || || || ||
|| || void || flush() || || || || || ||
|| || void || write(char[] cbuf) || || || || || ||
|| || void || write(char[] cbuf, int off, int len) || || || || || ||
|| || void || write(int c) || || || || || ||
|| || void || write(String str) || || || || || ||
|| || void || write(String str, int off, int len) || || || || || ||
||<-8> java.sql.ResultSet ||
|| || Blob || getBlob(int columnIndex) || 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 || || || 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) || || || || || ||
|| || 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) || || || || || ||
|| || 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) || || || || || ||
||<-8> 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 || || || X || 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) || 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) || || || || || ||
||<-8> 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) || || || || || ||
||<-8> java.sql.Connection: ||
|| 1.6 || Blob || createBlob() || || || || || ||
|| 1.6 || Clob || createClob() || || || || || ||
|| 1.6 || NClob || createNClob() || || || || || ||
[[BR]]
Note: Also tests BLOB/CLOB with PreparedStatement.setBytes/setString/setNull for small LOBs and setBytes for mediom BLOBs.
[[BR]]
B - Blob[[BR]]
C - Clob[[BR]]