public abstract class ProcedureTest extends SimpleProcedureTest implements java.sql.ResultSet
Constructor and Description |
---|
ProcedureTest() |
Modifier and Type | Method and Description |
---|---|
static void |
alterTable() |
static void |
ambigious1(int p1,
java.lang.String p2,
java.sql.ResultSet[] data1) |
static void |
ambigious1(int p1,
java.lang.String p2,
java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2) |
static void |
ambigious2(java.lang.Integer p1,
int p2) |
static void |
ambigious2(int p1,
java.lang.Integer p2) |
static void |
badDynamicParameter(int p1,
ProcedureTest[] data) |
static void |
BIG_COL_491(int i,
java.sql.ResultSet[] rs1,
java.sql.ResultSet[] rs2) |
static void |
bigTestData(int i) |
static void |
blobselect(java.sql.ResultSet[] results) |
static void |
clobselect(java.sql.ResultSet[] results,
java.sql.ResultSet[] results1,
java.sql.ResultSet[] results2) |
static int |
countRows(java.lang.String schema,
java.lang.String table) |
static void |
createIndex() |
static void |
createTrigger() |
static void |
deleteRow(int p1) |
static void |
dropIndex() |
static void |
dropTable() |
static void |
dropTrigger() |
private static void |
executeStatement(java.sql.Statement s,
java.lang.String sql,
java.lang.String[] result) |
static void |
fivejp(java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2,
java.sql.ResultSet[] data3,
java.sql.ResultSet[] data4,
java.sql.ResultSet[] data5) |
static void |
grantSelect() |
static void |
inoutparams2(int[] p1,
int p2) |
static void |
inoutparams3(java.lang.String[] p1,
int p2) |
static void |
inoutparams4(java.math.BigDecimal[] p1,
java.lang.String p2) |
private static void |
insertInBig(java.sql.Connection conn,
java.lang.String A,
java.lang.String B,
java.lang.String C,
java.lang.String D) |
static void |
insertRow(int p1) |
static void |
insertRow(int p1,
java.lang.String p2) |
static void |
literalTest(java.math.BigDecimal p1,
java.lang.String[] p2) |
static void |
literalTest(java.sql.Date p1,
java.lang.String[] p2) |
static void |
literalTest(double p1,
java.lang.String[] p2) |
static void |
literalTest(float p1,
java.lang.String[] p2) |
static void |
literalTest(int p1,
java.lang.String[] p2) |
static void |
literalTest(long p1,
java.lang.String[] p2) |
static void |
literalTest(java.lang.String p1,
java.lang.String[] p2) |
static void |
literalTest(java.sql.Timestamp p1,
java.lang.String[] p2) |
static void |
literalTest(java.sql.Time p1,
java.lang.String[] p2) |
static void |
LOTS_O_COLS_492(java.sql.ResultSet[] rs) |
static void |
missingDynamicParameter(int p1) |
static void |
missingDynamicParameter(int p1,
java.lang.Object p2) |
static void |
multiResult(int p1,
int p2,
java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2)
Procedure installed to test multiple ResultSets in the lang/procedure.java
test class.
|
static void |
noname(int p1,
java.lang.String p2) |
static void |
noname2(java.sql.Timestamp p1,
java.lang.String p2) |
static void |
oALLINT(java.lang.Integer in,
java.lang.Integer[] inout,
java.lang.Integer[] out) |
static void |
oBOOLEAN(java.lang.Boolean in,
java.lang.Boolean[] inout,
java.lang.Boolean[] out) |
static void |
outparams1(int[] p1,
int p2) |
static void |
parameter1(int a,
java.lang.String b,
java.lang.String c,
java.sql.ResultSet[] rs) |
static void |
parameter2(int a,
java.math.BigDecimal b,
java.math.BigDecimal c,
java.sql.ResultSet[] rs) |
static void |
pBOOLEAN(boolean in,
boolean[] inout,
boolean[] out) |
static void |
pmap(java.math.BigDecimal in,
java.math.BigDecimal[] inout,
java.math.BigDecimal[] out) |
static void |
pSMALLINT(short in,
short[] inout,
short[] out) |
static void |
pTINYINT(byte in,
byte[] inout,
byte[] out) |
static void |
revokeSelect() |
static int |
selectFromSpecificSchema(int p1) |
static void |
selectRows(int p1,
int p2,
java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2) |
static void |
selectRows(int p1,
java.sql.ResultSet[] data) |
static void |
selectRows(java.lang.String table,
java.sql.ResultSet[] rs) |
static void |
sqlControl(java.lang.String[] e1,
java.lang.String[] e2,
java.lang.String[] e3,
java.lang.String[] e4,
java.lang.String[] e5,
java.lang.String[] e6,
java.lang.String[] e7) |
static void |
sqlControl2(java.lang.String[] e1,
java.lang.String[] e2,
java.lang.String[] e3,
java.lang.String[] e4,
java.lang.String[] e5,
java.lang.String[] e6,
java.lang.String[] e7) |
static void |
sqlControl3(java.lang.String[] e1,
java.lang.String[] e2,
java.lang.String[] e3,
java.lang.String[] e4,
java.lang.String[] e5,
java.lang.String[] e6,
java.lang.String[] e7) |
static void |
sqlControl4(int sqlc,
java.lang.String[] e1,
java.lang.String[] e2,
java.lang.String[] e3,
java.lang.String[] e4,
java.lang.String[] e5,
java.lang.String[] e6,
java.lang.String[] e7,
java.lang.String[] e8) |
static void |
updateRow(int p1) |
static void |
zeroArg() |
static void |
zeroArgDynamicResult(java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2,
java.sql.ResultSet[] data3,
java.sql.ResultSet[] data4) |
pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
public static void zeroArg()
public static void insertRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void insertRow(int p1, java.lang.String p2) throws java.sql.SQLException
java.sql.SQLException
public static void updateRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void deleteRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void alterTable() throws java.sql.SQLException
java.sql.SQLException
public static void dropTable() throws java.sql.SQLException
java.sql.SQLException
public static void createIndex() throws java.sql.SQLException
java.sql.SQLException
public static void dropIndex() throws java.sql.SQLException
java.sql.SQLException
public static void createTrigger() throws java.sql.SQLException
java.sql.SQLException
public static void dropTrigger() throws java.sql.SQLException
java.sql.SQLException
public static int selectFromSpecificSchema(int p1) throws java.sql.SQLException
java.sql.SQLException
private static void insertInBig(java.sql.Connection conn, java.lang.String A, java.lang.String B, java.lang.String C, java.lang.String D) throws java.sql.SQLException
java.sql.SQLException
public static void bigTestData(int i) throws java.sql.SQLException
java.sql.SQLException
public static void selectRows(int p1, java.sql.ResultSet[] data) throws java.sql.SQLException
java.sql.SQLException
public static void selectRows(int p1, int p2, java.sql.ResultSet[] data1, java.sql.ResultSet[] data2) throws java.sql.SQLException
java.sql.SQLException
public static void selectRows(java.lang.String table, java.sql.ResultSet[] rs) throws java.sql.SQLException
java.sql.SQLException
public static void fivejp(java.sql.ResultSet[] data1, java.sql.ResultSet[] data2, java.sql.ResultSet[] data3, java.sql.ResultSet[] data4, java.sql.ResultSet[] data5) throws java.sql.SQLException
java.sql.SQLException
public static void parameter1(int a, java.lang.String b, java.lang.String c, java.sql.ResultSet[] rs) throws java.sql.SQLException
java.sql.SQLException
public static void parameter2(int a, java.math.BigDecimal b, java.math.BigDecimal c, java.sql.ResultSet[] rs) throws java.sql.SQLException
java.sql.SQLException
public static void outparams1(int[] p1, int p2)
public static void clobselect(java.sql.ResultSet[] results, java.sql.ResultSet[] results1, java.sql.ResultSet[] results2) throws java.lang.Exception
java.lang.Exception
public static void blobselect(java.sql.ResultSet[] results) throws java.lang.Exception
java.lang.Exception
public static void inoutparams2(int[] p1, int p2)
public static void inoutparams3(java.lang.String[] p1, int p2)
public static void inoutparams4(java.math.BigDecimal[] p1, java.lang.String p2)
public static void ambigious1(int p1, java.lang.String p2, java.sql.ResultSet[] data1, java.sql.ResultSet[] data2)
public static void ambigious1(int p1, java.lang.String p2, java.sql.ResultSet[] data1)
public static void ambigious2(int p1, java.lang.Integer p2)
public static void ambigious2(java.lang.Integer p1, int p2)
public static void missingDynamicParameter(int p1)
public static void missingDynamicParameter(int p1, java.lang.Object p2)
public static void badDynamicParameter(int p1, ProcedureTest[] data)
public static void zeroArgDynamicResult(java.sql.ResultSet[] data1, java.sql.ResultSet[] data2, java.sql.ResultSet[] data3, java.sql.ResultSet[] data4)
public static void sqlControl(java.lang.String[] e1, java.lang.String[] e2, java.lang.String[] e3, java.lang.String[] e4, java.lang.String[] e5, java.lang.String[] e6, java.lang.String[] e7) throws java.sql.SQLException
java.sql.SQLException
public static void sqlControl2(java.lang.String[] e1, java.lang.String[] e2, java.lang.String[] e3, java.lang.String[] e4, java.lang.String[] e5, java.lang.String[] e6, java.lang.String[] e7) throws java.sql.SQLException
java.sql.SQLException
public static void sqlControl3(java.lang.String[] e1, java.lang.String[] e2, java.lang.String[] e3, java.lang.String[] e4, java.lang.String[] e5, java.lang.String[] e6, java.lang.String[] e7) throws java.sql.SQLException
java.sql.SQLException
public static void sqlControl4(int sqlc, java.lang.String[] e1, java.lang.String[] e2, java.lang.String[] e3, java.lang.String[] e4, java.lang.String[] e5, java.lang.String[] e6, java.lang.String[] e7, java.lang.String[] e8) throws java.sql.SQLException
java.sql.SQLException
private static void executeStatement(java.sql.Statement s, java.lang.String sql, java.lang.String[] result)
public static void oBOOLEAN(java.lang.Boolean in, java.lang.Boolean[] inout, java.lang.Boolean[] out) throws java.sql.SQLException
java.sql.SQLException
public static void pBOOLEAN(boolean in, boolean[] inout, boolean[] out) throws java.sql.SQLException
java.sql.SQLException
public static void oALLINT(java.lang.Integer in, java.lang.Integer[] inout, java.lang.Integer[] out) throws java.sql.SQLException
java.sql.SQLException
public static void pTINYINT(byte in, byte[] inout, byte[] out) throws java.sql.SQLException
java.sql.SQLException
public static void pSMALLINT(short in, short[] inout, short[] out) throws java.sql.SQLException
java.sql.SQLException
public static void literalTest(int p1, java.lang.String[] p2)
public static void literalTest(long p1, java.lang.String[] p2)
public static void literalTest(float p1, java.lang.String[] p2)
public static void literalTest(double p1, java.lang.String[] p2)
public static void literalTest(java.math.BigDecimal p1, java.lang.String[] p2)
public static void literalTest(java.lang.String p1, java.lang.String[] p2)
public static void literalTest(java.sql.Date p1, java.lang.String[] p2)
public static void literalTest(java.sql.Time p1, java.lang.String[] p2)
public static void literalTest(java.sql.Timestamp p1, java.lang.String[] p2)
public static void pmap(java.math.BigDecimal in, java.math.BigDecimal[] inout, java.math.BigDecimal[] out)
public static int countRows(java.lang.String schema, java.lang.String table) throws java.sql.SQLException
java.sql.SQLException
public static void multiResult(int p1, int p2, java.sql.ResultSet[] data1, java.sql.ResultSet[] data2) throws java.sql.SQLException
p1
- Number parameter for the first ResultSetp2
- Number parameter for the second ResultSetdata1
- The first ResultSet to be returned.data2
- The Second ResultSet to be returnedjava.sql.SQLException
public static void BIG_COL_491(int i, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2) throws java.sql.SQLException
java.sql.SQLException
public static void LOTS_O_COLS_492(java.sql.ResultSet[] rs) throws java.sql.SQLException
java.sql.SQLException
public static void grantSelect() throws java.sql.SQLException
java.sql.SQLException
public static void revokeSelect() throws java.sql.SQLException
java.sql.SQLException
public static void noname(int p1, java.lang.String p2)
public static void noname2(java.sql.Timestamp p1, java.lang.String p2)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.