org.apache.derbyTesting.functionTests.util

Class ProcedureTest

java.lang.Object

org.apache.derbyTesting.functionTests.util.SimpleProcedureTest

org.apache.derbyTesting.functionTests.util.ProcedureTest

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.ResultSet, java.sql.Wrapper

public abstract class ProcedureTest
extends SimpleProcedureTest
implements java.sql.ResultSet

Java procedures for the procedure.sql test.

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors

Constructor and Description
ProcedureTest()

Method Summary

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)

Methods inherited from class org.apache.derbyTesting.functionTests.util.SimpleProcedureTest

pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap, pmap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet

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

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Detail

ProcedureTest

public ProcedureTest()

Method Detail

zeroArg

public static void zeroArg()

insertRow

public static void insertRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

insertRow

public static void insertRow(int p1,
                             java.lang.String p2)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

updateRow

public static void updateRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteRow

public static void deleteRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

alterTable

public static void alterTable()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

dropTable

public static void dropTable()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

createIndex

public static void createIndex()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

dropIndex

public static void dropIndex()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

createTrigger

public static void createTrigger()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

dropTrigger

public static void dropTrigger()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

selectFromSpecificSchema

public static int selectFromSpecificSchema(int p1)
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

insertInBig

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

Throws:

java.sql.SQLException

bigTestData

public static void bigTestData(int i)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

selectRows

public static void selectRows(int p1,
                              java.sql.ResultSet[] data)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

selectRows

public static void selectRows(int p1,
                              int p2,
                              java.sql.ResultSet[] data1,
                              java.sql.ResultSet[] data2)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

selectRows

public static void selectRows(java.lang.String table,
                              java.sql.ResultSet[] rs)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

fivejp

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

Throws:

java.sql.SQLException

parameter1

public static void parameter1(int a,
                              java.lang.String b,
                              java.lang.String c,
                              java.sql.ResultSet[] rs)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

parameter2

public static void parameter2(int a,
                              java.math.BigDecimal b,
                              java.math.BigDecimal c,
                              java.sql.ResultSet[] rs)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

outparams1

public static void outparams1(int[] p1,
                              int p2)

clobselect

public static void clobselect(java.sql.ResultSet[] results,
                              java.sql.ResultSet[] results1,
                              java.sql.ResultSet[] results2)
                       throws java.lang.Exception

Throws:

java.lang.Exception

blobselect

public static void blobselect(java.sql.ResultSet[] results)
                       throws java.lang.Exception

Throws:

java.lang.Exception

inoutparams2

public static void inoutparams2(int[] p1,
                                int p2)

inoutparams3

public static void inoutparams3(java.lang.String[] p1,
                                int p2)

inoutparams4

public static void inoutparams4(java.math.BigDecimal[] p1,
                                java.lang.String p2)

ambigious1

public static void ambigious1(int p1,
                              java.lang.String p2,
                              java.sql.ResultSet[] data1,
                              java.sql.ResultSet[] data2)

ambigious1

public static void ambigious1(int p1,
                              java.lang.String p2,
                              java.sql.ResultSet[] data1)

ambigious2

public static void ambigious2(int p1,
                              java.lang.Integer p2)

ambigious2

public static void ambigious2(java.lang.Integer p1,
                              int p2)

missingDynamicParameter

public static void missingDynamicParameter(int p1)

missingDynamicParameter

public static void missingDynamicParameter(int p1,
                                           java.lang.Object p2)

badDynamicParameter

public static void badDynamicParameter(int p1,
                                       ProcedureTest[] data)

zeroArgDynamicResult

public static void zeroArgDynamicResult(java.sql.ResultSet[] data1,
                                        java.sql.ResultSet[] data2,
                                        java.sql.ResultSet[] data3,
                                        java.sql.ResultSet[] data4)

sqlControl

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

Throws:

java.sql.SQLException

sqlControl2

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

Throws:

java.sql.SQLException

sqlControl3

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

Throws:

java.sql.SQLException

sqlControl4

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

Throws:

java.sql.SQLException

executeStatement

private static void executeStatement(java.sql.Statement s,
                                     java.lang.String sql,
                                     java.lang.String[] result)

oBOOLEAN

public static void oBOOLEAN(java.lang.Boolean in,
                            java.lang.Boolean[] inout,
                            java.lang.Boolean[] out)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

pBOOLEAN

public static void pBOOLEAN(boolean in,
                            boolean[] inout,
                            boolean[] out)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

oALLINT

public static void oALLINT(java.lang.Integer in,
                           java.lang.Integer[] inout,
                           java.lang.Integer[] out)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

pTINYINT

public static void pTINYINT(byte in,
                            byte[] inout,
                            byte[] out)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

pSMALLINT

public static void pSMALLINT(short in,
                             short[] inout,
                             short[] out)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

literalTest

public static void literalTest(int p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(long p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(float p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(double p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(java.math.BigDecimal p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(java.lang.String p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(java.sql.Date p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(java.sql.Time p1,
                               java.lang.String[] p2)

literalTest

public static void literalTest(java.sql.Timestamp p1,
                               java.lang.String[] p2)

pmap

public static void pmap(java.math.BigDecimal in,
                        java.math.BigDecimal[] inout,
                        java.math.BigDecimal[] out)

countRows

public static int countRows(java.lang.String schema,
                            java.lang.String table)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

multiResult

public static void multiResult(int p1,
                               int p2,
                               java.sql.ResultSet[] data1,
                               java.sql.ResultSet[] data2)
                        throws java.sql.SQLException

Procedure installed to test multiple ResultSets in the lang/procedure.java test class.

Parameters:

p1 - Number parameter for the first ResultSet

p2 - Number parameter for the second ResultSet

data1 - The first ResultSet to be returned.

data2 - The Second ResultSet to be returned

Throws:

java.sql.SQLException

BIG_COL_491

public static void BIG_COL_491(int i,
                               java.sql.ResultSet[] rs1,
                               java.sql.ResultSet[] rs2)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

LOTS_O_COLS_492

public static void LOTS_O_COLS_492(java.sql.ResultSet[] rs)
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

grantSelect

public static void grantSelect()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

revokeSelect

public static void revokeSelect()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

noname

public static void noname(int p1,
                          java.lang.String p2)

noname2

public static void noname2(java.sql.Timestamp p1,
                           java.lang.String p2)