public class ProcedureTest extends BaseJDBCTestCase
Modifier and Type | Class and Description |
---|---|
static class |
ProcedureTest.AllTypesTuple |
Modifier and Type | Field and Description |
---|---|
private static java.lang.String[] |
PROCEDURES
Procedures that should be created before the tests are run and
dropped when the tests have finished.
|
private static java.lang.String[][] |
TABLES
Tables that should be created before the tests are run and
dropped when the tests have finished.
|
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ProcedureTest(java.lang.String name)
Creates a new
ProcedureTest instance. |
Modifier and Type | Method and Description |
---|---|
private void |
assertMultipleResultsFromExecuteQuery(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by
executeQuery() returning multiple result sets. |
private void |
assertNoResultSetFromExecuteQuery(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by
executeQuery() returning no result set. |
private void |
assertResultsFromExecuteUpdate(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by
executeUpdate() returning result sets. |
private static junit.framework.Test |
baseSuite(java.lang.String name)
Creates the test suite and wraps it in a
TestSetup
instance which sets up and tears down the test environment. |
private void |
checkCSCloseClosesResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS)
Check that CallableStatement.close() closes results
|
private void |
checkExecuteClosesResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS)
Check that CallableStatement.execute() closes results
|
private void |
closeCurrentGetMoreResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS) |
private void |
defaultGetMoreResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS)
Test default getMoreResults() closes result set.
|
private ProcedureTest.AllTypesTuple |
getActualReturnArgs(java.sql.CallableStatement cs) |
static void |
intOut(int[] out)
Stored procedure with an integer output parameter.
|
private void |
keepCurrentGetMoreResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS)
Check getMoreResults(Statement.KEEP_CURRENT_RESULT)
|
static ProcedureTest.AllTypesTuple |
makeFirstAllTypesTuple()
Procedure to test that INOUT args preserve their value when the
procedure is re-executed (DERBY-2515).
|
static ProcedureTest.AllTypesTuple |
makeFourthAllTypesTuple() |
static ProcedureTest.AllTypesTuple |
makeSecondAllTypesTuple() |
static ProcedureTest.AllTypesTuple |
makeThirdAllTypesTuple() |
private void |
mixedGetMoreResults(java.sql.CallableStatement cs,
java.sql.ResultSet[] allRS) |
static void |
nestedDynamicResultSets(java.lang.String procedureText,
java.sql.ResultSet[] rs1,
java.sql.ResultSet[] rs2,
java.sql.ResultSet[] rs3,
java.sql.ResultSet[] rs4,
java.sql.ResultSet[] rs5,
java.sql.ResultSet[] rs6)
Method for a Java procedure that calls another procedure
and just passes on the dynamic results from that call.
|
static void |
proc_2515(int passNumber,
java.lang.String[] message,
java.lang.Long[] bigintArg,
java.sql.Blob[] blobArg,
java.lang.Boolean[] booleanArg,
java.lang.String[] charArg,
byte[][] charForBitDataArg,
java.sql.Clob[] clobArg,
java.sql.Date[] dateArg,
java.math.BigDecimal[] decimalArg,
java.lang.Double[] doubleArg,
java.lang.Integer[] intArg,
java.lang.String[] longVarcharArg,
byte[][] longVarcharForBitDataArg,
java.lang.Float[] realArg,
java.lang.Integer[] smallintArg,
java.sql.Time[] timeArg,
java.sql.Timestamp[] timestampArg,
Price[] priceArg,
java.lang.String[] varcharArg,
byte[][] varcharForBitDataArg) |
static void |
proc_2516(java.lang.Integer[] i)
Stored procedure used by the regression test case for DERBY-2516.
|
static void |
proc_5280()
Procedure that drops a non-existent table and ignores the exception
thrown because of it.
|
static void |
procWithManyParams(int p001,
int p002,
int p003,
int p004,
int p005,
int p006,
int p007,
int p008,
int p009,
int p010,
int p011,
int p012,
int p013,
int p014,
int p015,
int p016,
int p017,
int p018,
int p019,
int p020,
int p021,
int p022,
int p023,
int p024,
int p025,
int p026,
int p027,
int p028,
int p029,
int p030,
int p031,
int p032,
int p033,
int p034,
int p035,
int p036,
int p037,
int p038,
int p039,
int p040,
int p041,
int p042,
int p043,
int p044,
int p045,
int p046,
int p047,
int p048,
int p049,
int p050,
int p051,
int p052,
int p053,
int p054,
int p055,
int p056,
int p057,
int p058,
int p059,
int p060,
int p061,
int p062,
int p063,
int p064,
int p065,
int p066,
int p067,
int p068,
int p069,
int p070,
int p071,
int p072,
int p073,
int p074,
int p075,
int p076,
int p077,
int p078,
int p079,
int p080,
int p081,
int p082,
int p083,
int p084,
int p085,
int p086,
int p087,
int p088,
int p089,
int p090,
int p091,
int p092,
int p093,
int p094,
int p095,
int p096,
int p097,
int p098,
int p099,
int p100,
int p101,
int p102,
int p103,
int p104,
int p105,
int p106,
int p107,
int p108,
int p109,
int p110,
int p111,
int p112,
int p113,
int p114,
int p115,
int p116,
int p117,
int p118,
int p119,
int p120,
int p121,
int p122,
int p123,
int p124,
int p125,
int p126,
int p127,
int p128,
int p129,
int p130,
int p131,
int p132,
int p133,
int p134,
int p135,
int p136,
int p137,
int p138,
int p139,
int p140,
int p141,
int p142,
int p143,
int p144,
int p145,
int p146,
int p147,
int p148,
int p149,
int p150,
int p151,
int p152,
int p153,
int p154,
int p155,
int p156,
int p157,
int p158,
int p159,
int p160,
int p161,
int p162,
int p163,
int p164,
int p165,
int p166,
int p167,
int p168,
int p169,
int p170,
int p171,
int p172,
int p173,
int p174,
int p175,
int p176,
int p177,
int p178,
int p179,
int p180,
int p181,
int p182,
int p183,
int p184,
int p185,
int p186,
int p187,
int p188,
int p189,
int p190,
int p191,
int p192,
int p193,
int p194,
int p195,
int p196,
int p197,
int p198,
int p199,
int p200,
int p201,
int p202,
int p203,
int p204,
int p205,
int p206,
int p207,
int p208,
int p209,
int p210,
int p211,
int p212,
int p213,
int p214,
int p215,
int p216,
int p217,
int p218,
int p219,
int p220,
int p221,
int p222,
int p223,
int p224,
int p225,
int p226,
int p227,
int p228,
int p229,
int p230,
int p231,
int p232,
int p233,
int p234,
int p235,
int p236,
int p237,
int p238,
int p239,
int p240,
int p241,
int p242,
int p243,
int p244,
int p245,
int p246,
int p247,
int p248,
int p249,
int p250,
int p251,
int p252,
int p253,
int p254,
int p255) |
static void |
procWithSideEffects(int returnResults,
java.sql.ResultSet[] rs1,
java.sql.ResultSet[] rs2)
Stored procedure which inserts a row into SIMPLE_TABLE and
optionally returns result sets.
|
static void |
retrieveClosedResult(java.sql.ResultSet[] closed)
Stored procedure which produces a closed result set.
|
static void |
retrieveDynamicResults(int number,
java.sql.ResultSet[] rs1,
java.sql.ResultSet[] rs2,
java.sql.ResultSet[] rs3,
java.sql.ResultSet[] rs4)
Stored procedure which returns 0, 1, 2, 3 or 4
ResultSet s. |
static void |
retrieveExternalResult(java.lang.String dbName,
java.lang.String user,
java.lang.String password,
java.sql.ResultSet[] external)
Stored procedure which produces a result set in another
connection.
|
void |
setUp()
Sets up the connection for a test case and clears all tables
used in the test cases.
|
static junit.framework.Test |
suite()
Runs the test fixtures in embedded and client.
|
void |
test_2515()
Test that INOUT args are preserved over procedure invocations.
|
void |
testClosedDynamicResultSetsFromExecuteQuery()
Tests that closed result sets are not returned when calling
executeQuery() . |
void |
testClosedDynamicResultSetsFromExecuteUpdate()
Tests that closed result sets are ignored when calling
executeUpdate() . |
void |
testDynamicResultSetsFromOtherConnectionWithExecuteQuery()
Tests that dynamic result sets from other connections are
ignored when calling
executeQuery . |
void |
testDynamicResultSetsFromOtherConnectionWithExecuteUpdate()
Tests that dynamic result sets from other connections are
ignored when calling
executeUpdate . |
void |
testExecuteQueryWithMoreThanOneDynamicResultSet_callable()
Tests that
CallableStatement.executeQuery() fails
when multiple result sets are returned. |
void |
testExecuteQueryWithMoreThanOneDynamicResultSet_prepared()
Tests that
PreparedStatement.executeQuery() fails
when multiple result sets are returned. |
void |
testExecuteQueryWithMoreThanOneDynamicResultSet()
Tests that
Statement.executeQuery() fails when
multiple result sets are returned. |
void |
testExecuteQueryWithNoDynamicResultSets_callable()
Tests that
CallableStatement.executeQuery() fails
when no result sets are returned. |
void |
testExecuteQueryWithNoDynamicResultSets_prepared()
Tests that
PreparedStatement.executeQuery() fails
when no result sets are returned. |
void |
testExecuteQueryWithNoDynamicResultSets()
Tests that
Statement.executeQuery() fails when no
result sets are returned. |
void |
testExecuteQueryWithOneDynamicResultSet_callable()
Tests that
CallableStatement.executeQuery()
succeeds when one result set is returned from a stored
procedure. |
void |
testExecuteQueryWithOneDynamicResultSet_prepared()
Tests that
PreparedStatement.executeQuery()
succeeds when one result set is returned from a stored
procedure. |
void |
testExecuteQueryWithOneDynamicResultSet()
Tests that
Statement.executeQuery() succeeds when
one result set is returned from a stored procedure. |
void |
testExecuteUpdateWithNoDynamicResultSets_callable()
Tests that
CallableStatement.executeUpdate()
succeeds when no result sets are returned. |
void |
testExecuteUpdateWithNoDynamicResultSets_prepared()
Tests that
PreparedStatement.executeUpdate()
succeeds when no result sets are returned. |
void |
testExecuteUpdateWithNoDynamicResultSets()
Tests that
Statement.executeUpdate() succeeds when
no result sets are returned. |
void |
testExecuteUpdateWithOneDynamicResultSet_callable()
Tests that
CallableStatement.executeUpdate() fails
when a result set is returned from a stored procedure. |
void |
testExecuteUpdateWithOneDynamicResultSet_prepared()
Tests that
PreparedStatement.executeUpdate() fails
when a result set is returned from a stored procedure. |
void |
testExecuteUpdateWithOneDynamicResultSet()
Tests that
Statement.executeUpdate() fails when a
result set is returned from a stored procedure. |
void |
testGetBlobFromIntParameter()
Test that a call to getBlob() to retrieve the value of a non-BLOB
parameter fails with the expected SQLException.
|
void |
testGetClobFromIntParameter()
Test that a call to getClob() to retrieve the value of a non-CLOB
parameter fails with the expected SQLException.
|
void |
testGetMoreResults()
Test various combinations of getMoreResults
|
void |
testInOutParamNotSet()
Regression test case for DERBY-2516.
|
void |
testMaxNumberOfParameters()
Test that we create and execute stored procedures with as many
parameters as the Java specification allows.
|
private void |
testMaxNumberOfParameters(int params,
boolean methodExists)
Create and execute a stored procedure backed by a Java method with the
specified number of parameters.
|
void |
testRollbackStoredProcWhenExecuteQueryReturnsNothing_prepared()
Tests that the effects of executing a stored procedure with
executeQuery() are correctly rolled back when the
query fails because the number of returned result sets is zero. |
void |
testRollbackStoredProcWhenExecuteQueryReturnsNothing()
Tests that the effects of executing a stored procedure with
executeQuery() are correctly rolled back when the
query fails because the number of returned result sets is zero. |
void |
testRollbackStoredProcWhenExecuteQueryReturnsTooMuch_prepared()
Tests that the effects of executing a stored procedure with
executeQuery() are correctly rolled back when the
query fails because the number of returned result sets is more
than one. |
void |
testRollbackStoredProcWhenExecuteQueryReturnsTooMuch()
Tests that the effects of executing a stored procedure with
executeQuery() are correctly rolled back when the
query fails because the number of returned result sets is more
than one. |
void |
testRollbackStoredProcWhenExecuteUpdateReturnsResults_prepared()
Tests that the effects of executing a stored procedure with
executeUpdate() are correctly rolled back when the
query fails because the stored procedure returned a result set. |
void |
testRollbackStoredProcWhenExecuteUpdateReturnsResults()
Tests that the effects of executing a stored procedure with
executeUpdate() are correctly rolled back when the
query fails because the stored procedure returned a result set. |
void |
testRollbackStoredProcWithExecuteQuery()
Tests that the effects of executing a stored procedure with
executeQuery() are correctly rolled back when
Connection.rollback() is called. |
void |
testRollbackStoredProcWithExecuteUpdate()
Tests that the effects of executing a stored procedure with
executeUpdate() are correctly rolled back when
Connection.rollback() is called. |
void |
testStatementSeverityErrorInProcedure()
Test that a statement severity error inside a procedure doesn't kill
the top-level statement that executes the stored procedure.
|
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, toString
private static final java.lang.String[] PROCEDURES
private static final java.lang.String[][] TABLES
public ProcedureTest(java.lang.String name)
ProcedureTest
instance.name
- name of the testpublic void testExecuteQueryWithNoDynamicResultSets() throws java.sql.SQLException
Statement.executeQuery()
fails when no
result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithOneDynamicResultSet() throws java.sql.SQLException
Statement.executeQuery()
succeeds when
one result set is returned from a stored procedure.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithMoreThanOneDynamicResultSet() throws java.sql.SQLException
Statement.executeQuery()
fails when
multiple result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithNoDynamicResultSets() throws java.sql.SQLException
Statement.executeUpdate()
succeeds when
no result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithOneDynamicResultSet() throws java.sql.SQLException
Statement.executeUpdate()
fails when a
result set is returned from a stored procedure.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithNoDynamicResultSets_prepared() throws java.sql.SQLException
PreparedStatement.executeQuery()
fails
when no result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithOneDynamicResultSet_prepared() throws java.sql.SQLException
PreparedStatement.executeQuery()
succeeds when one result set is returned from a stored
procedure.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithMoreThanOneDynamicResultSet_prepared() throws java.sql.SQLException
PreparedStatement.executeQuery()
fails
when multiple result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithNoDynamicResultSets_prepared() throws java.sql.SQLException
PreparedStatement.executeUpdate()
succeeds when no result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithOneDynamicResultSet_prepared() throws java.sql.SQLException
PreparedStatement.executeUpdate()
fails
when a result set is returned from a stored procedure.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithNoDynamicResultSets_callable() throws java.sql.SQLException
CallableStatement.executeQuery()
fails
when no result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithOneDynamicResultSet_callable() throws java.sql.SQLException
CallableStatement.executeQuery()
succeeds when one result set is returned from a stored
procedure.java.sql.SQLException
- if a database error occurspublic void testExecuteQueryWithMoreThanOneDynamicResultSet_callable() throws java.sql.SQLException
CallableStatement.executeQuery()
fails
when multiple result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithNoDynamicResultSets_callable() throws java.sql.SQLException
CallableStatement.executeUpdate()
succeeds when no result sets are returned.java.sql.SQLException
- if a database error occurspublic void testExecuteUpdateWithOneDynamicResultSet_callable() throws java.sql.SQLException
CallableStatement.executeUpdate()
fails
when a result set is returned from a stored procedure.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWithExecuteQuery() throws java.sql.SQLException
executeQuery()
are correctly rolled back when
Connection.rollback()
is called.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWithExecuteUpdate() throws java.sql.SQLException
executeUpdate()
are correctly rolled back when
Connection.rollback()
is called.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteQueryReturnsNothing() throws java.sql.SQLException
executeQuery()
are correctly rolled back when the
query fails because the number of returned result sets is zero.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch() throws java.sql.SQLException
executeQuery()
are correctly rolled back when the
query fails because the number of returned result sets is more
than one.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteUpdateReturnsResults() throws java.sql.SQLException
executeUpdate()
are correctly rolled back when the
query fails because the stored procedure returned a result set.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteQueryReturnsNothing_prepared() throws java.sql.SQLException
executeQuery()
are correctly rolled back when the
query fails because the number of returned result sets is zero.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch_prepared() throws java.sql.SQLException
executeQuery()
are correctly rolled back when the
query fails because the number of returned result sets is more
than one.java.sql.SQLException
- if a database error occurspublic void testRollbackStoredProcWhenExecuteUpdateReturnsResults_prepared() throws java.sql.SQLException
executeUpdate()
are correctly rolled back when the
query fails because the stored procedure returned a result set.java.sql.SQLException
- if a database error occurspublic void testClosedDynamicResultSetsFromExecuteQuery() throws java.sql.SQLException
executeQuery()
.java.sql.SQLException
- if a database error occurspublic void testClosedDynamicResultSetsFromExecuteUpdate() throws java.sql.SQLException
executeUpdate()
.java.sql.SQLException
- if a database error occurspublic void testDynamicResultSetsFromOtherConnectionWithExecuteQuery() throws java.sql.SQLException
executeQuery
.java.sql.SQLException
- if a database error occurspublic void testDynamicResultSetsFromOtherConnectionWithExecuteUpdate() throws java.sql.SQLException
executeUpdate
.java.sql.SQLException
- if a database error occurspublic void testGetBlobFromIntParameter() throws java.sql.SQLException
java.sql.SQLException
public void testGetClobFromIntParameter() throws java.sql.SQLException
java.sql.SQLException
public void testStatementSeverityErrorInProcedure() throws java.sql.SQLException
java.sql.SQLException
public static void proc_5280() throws java.sql.SQLException
java.sql.SQLException
public void test_2515() throws java.lang.Exception
java.lang.Exception
private ProcedureTest.AllTypesTuple getActualReturnArgs(java.sql.CallableStatement cs) throws java.lang.Exception
java.lang.Exception
public void testInOutParamNotSet() throws java.sql.SQLException
java.sql.SQLException
public static void proc_2516(java.lang.Integer[] i)
i
- INOUT parameter that gets set to 10 by the procedurepublic void testMaxNumberOfParameters() throws java.sql.SQLException
java.sql.SQLException
private void testMaxNumberOfParameters(int params, boolean methodExists) throws java.sql.SQLException
params
- the number of parametersmethodExists
- whether or not a method called
procWithManyParams
with the specified number of parameters
existsjava.sql.SQLException
public static void procWithManyParams(int p001, int p002, int p003, int p004, int p005, int p006, int p007, int p008, int p009, int p010, int p011, int p012, int p013, int p014, int p015, int p016, int p017, int p018, int p019, int p020, int p021, int p022, int p023, int p024, int p025, int p026, int p027, int p028, int p029, int p030, int p031, int p032, int p033, int p034, int p035, int p036, int p037, int p038, int p039, int p040, int p041, int p042, int p043, int p044, int p045, int p046, int p047, int p048, int p049, int p050, int p051, int p052, int p053, int p054, int p055, int p056, int p057, int p058, int p059, int p060, int p061, int p062, int p063, int p064, int p065, int p066, int p067, int p068, int p069, int p070, int p071, int p072, int p073, int p074, int p075, int p076, int p077, int p078, int p079, int p080, int p081, int p082, int p083, int p084, int p085, int p086, int p087, int p088, int p089, int p090, int p091, int p092, int p093, int p094, int p095, int p096, int p097, int p098, int p099, int p100, int p101, int p102, int p103, int p104, int p105, int p106, int p107, int p108, int p109, int p110, int p111, int p112, int p113, int p114, int p115, int p116, int p117, int p118, int p119, int p120, int p121, int p122, int p123, int p124, int p125, int p126, int p127, int p128, int p129, int p130, int p131, int p132, int p133, int p134, int p135, int p136, int p137, int p138, int p139, int p140, int p141, int p142, int p143, int p144, int p145, int p146, int p147, int p148, int p149, int p150, int p151, int p152, int p153, int p154, int p155, int p156, int p157, int p158, int p159, int p160, int p161, int p162, int p163, int p164, int p165, int p166, int p167, int p168, int p169, int p170, int p171, int p172, int p173, int p174, int p175, int p176, int p177, int p178, int p179, int p180, int p181, int p182, int p183, int p184, int p185, int p186, int p187, int p188, int p189, int p190, int p191, int p192, int p193, int p194, int p195, int p196, int p197, int p198, int p199, int p200, int p201, int p202, int p203, int p204, int p205, int p206, int p207, int p208, int p209, int p210, int p211, int p212, int p213, int p214, int p215, int p216, int p217, int p218, int p219, int p220, int p221, int p222, int p223, int p224, int p225, int p226, int p227, int p228, int p229, int p230, int p231, int p232, int p233, int p234, int p235, int p236, int p237, int p238, int p239, int p240, int p241, int p242, int p243, int p244, int p245, int p246, int p247, int p248, int p249, int p250, int p251, int p252, int p253, int p254, int p255)
private void assertNoResultSetFromExecuteQuery(java.sql.SQLException sqle)
executeQuery()
returning no result set.sqle
- a SQLException
valueprivate void assertMultipleResultsFromExecuteQuery(java.sql.SQLException sqle)
executeQuery()
returning multiple result sets.sqle
- a SQLException
valueprivate void assertResultsFromExecuteUpdate(java.sql.SQLException sqle)
executeUpdate()
returning result sets.sqle
- a SQLException
valuepublic static junit.framework.Test suite()
private static junit.framework.Test baseSuite(java.lang.String name)
TestSetup
instance which sets up and tears down the test environment.public void setUp() throws java.sql.SQLException
setUp
in class junit.framework.TestCase
java.sql.SQLException
- if a database error occurspublic static void retrieveDynamicResults(int number, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2, java.sql.ResultSet[] rs3, java.sql.ResultSet[] rs4) throws java.sql.SQLException
ResultSet
s.number
- the number of ResultSet
s to returnrs1
- first ResultSet
rs2
- second ResultSet
rs3
- third ResultSet
rs4
- fourth ResultSet
java.sql.SQLException
- if a database error occurspublic static void retrieveClosedResult(java.sql.ResultSet[] closed) throws java.sql.SQLException
closed
- holder for the closed result setjava.sql.SQLException
- if a database error occurspublic static void retrieveExternalResult(java.lang.String dbName, java.lang.String user, java.lang.String password, java.sql.ResultSet[] external) throws java.sql.SQLException
external
- result set from another connectionjava.sql.SQLException
- if a database error occurspublic static void procWithSideEffects(int returnResults, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2) throws java.sql.SQLException
returnResults
- if one, return one result set; if greater
than one, return two result sets; otherwise, return no result
setrs1
- first result set to returnrs2
- second result set to returnjava.sql.SQLException
- if a database error occurspublic static void nestedDynamicResultSets(java.lang.String procedureText, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2, java.sql.ResultSet[] rs3, java.sql.ResultSet[] rs4, java.sql.ResultSet[] rs5, java.sql.ResultSet[] rs6) throws java.sql.SQLException
java.sql.SQLException
public static void intOut(int[] out)
out
- an output parameterpublic static ProcedureTest.AllTypesTuple makeFirstAllTypesTuple() throws java.lang.Exception
java.lang.Exception
public static ProcedureTest.AllTypesTuple makeSecondAllTypesTuple() throws java.lang.Exception
java.lang.Exception
public static ProcedureTest.AllTypesTuple makeThirdAllTypesTuple() throws java.lang.Exception
java.lang.Exception
public static ProcedureTest.AllTypesTuple makeFourthAllTypesTuple() throws java.lang.Exception
java.lang.Exception
public static void proc_2515(int passNumber, java.lang.String[] message, java.lang.Long[] bigintArg, java.sql.Blob[] blobArg, java.lang.Boolean[] booleanArg, java.lang.String[] charArg, byte[][] charForBitDataArg, java.sql.Clob[] clobArg, java.sql.Date[] dateArg, java.math.BigDecimal[] decimalArg, java.lang.Double[] doubleArg, java.lang.Integer[] intArg, java.lang.String[] longVarcharArg, byte[][] longVarcharForBitDataArg, java.lang.Float[] realArg, java.lang.Integer[] smallintArg, java.sql.Time[] timeArg, java.sql.Timestamp[] timestampArg, Price[] priceArg, java.lang.String[] varcharArg, byte[][] varcharForBitDataArg) throws java.lang.Exception
java.lang.Exception
public void testGetMoreResults() throws java.sql.SQLException
java.sql.SQLException
private void checkExecuteClosesResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
cs
- allRS
- java.sql.SQLException
private void checkCSCloseClosesResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
cs
- allRS
- java.sql.SQLException
private void mixedGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
java.sql.SQLException
private void keepCurrentGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
cs
- allRS
- java.sql.SQLException
private void closeCurrentGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
java.sql.SQLException
private void defaultGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS) throws java.sql.SQLException
cs
- allRS
- java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.