public class ParameterMetaDataJdbc30Test extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ParameterMetaDataJdbc30Test(java.lang.String name)
Create a test with the given name.
|
Modifier and Type | Method and Description |
---|---|
private static junit.framework.Test |
baseSuite(java.lang.String name) |
static void |
booleanProc(boolean inarg,
boolean[] outarg,
boolean[] inoutarg)
Java method for testing procedures with boolean args
|
static void |
dummy_numeric_Proc(java.math.BigDecimal[] max_param,
java.math.BigDecimal[] min_param)
A really simple method to test callable statement.
|
static void |
dummyDecimal(java.math.BigDecimal in_param,
java.math.BigDecimal in_param2,
java.math.BigDecimal[] in_param3,
java.math.BigDecimal[] in_param4)
Java method for procedure PMDD which tests ParameterMetaData for Java procedures
with DECIMAL parameters.
|
static void |
dummyint(int in_param,
int in_param2,
int[] in_param3,
int[] in_param4)
A simple method to test callable statement.
|
static void |
dummyint2(int in_param,
int in_param2,
int[] in_param3,
int[] in_param4)
This is the Java method for procedure dummyint.
|
static void |
dummyString(java.lang.String in_param,
java.lang.String in_param2,
java.lang.String[] in_param3,
java.lang.String[] in_param4)
Java method for procedure PMDC which tests ParameterMetaData for Java procedures
with CHAR parameters.
|
static void |
dummyString(java.sql.Timestamp in_param1,
java.sql.Timestamp[] inout_param2,
java.sql.Timestamp[] out_param3)
Java method for procedure PMDT which tests ParameterMetaData for Java procedures
with TIMESTAMP parameters.
|
(package private) static void |
dumpParameterMetaDataNegative(java.sql.ParameterMetaData paramMetaData)
ParameterMetaData Negative Test
|
(package private) static java.lang.String |
parameterIsNullableInStringForm(int nullabilityValue)
print the parameter isNullable value in human readable form
|
(package private) static java.lang.String |
parameterModeInStringForm(int mode)
print the parameter mode in human readable form
|
static junit.framework.Test |
suite()
Create suite containing client and embedded tests and to run
all tests in this class
|
void |
testBooleanParameters()
Test boolean parameters
|
void |
testBooleanProcedureArgs()
Testing a callable statement by calling a SQL procedure with
boolean IN parameters, OUT parameters and IN_OUT parameters.
|
void |
testCallableStatement()
Testing a callable statement by calling a SQL procedure with
IN parameters, OUT parameters and IN_OUT parameters.
|
void |
testCallableStatementReturnedScale()
test: the scale returned should be the one set by registerOutParameter
|
void |
testExecuteStatementUsing()
test execute statements that no parameters would be returned if
prepareStatement("execute statement systab using values('SYS%','8000001%')");
|
void |
testLikeEscaleStatement()
DERBY-44 added support for SELECT ...
|
void |
testMetatdataAfterProcRecompile()
test behaviour of meta data and out params after re-compile
|
(package private) static void |
testParameterMetaData(java.sql.ParameterMetaData paramMetaData,
java.lang.String[][] paramMetaDataArray)
tests parameterMetaData and reports error if the ParameterMetaData results
does not match the expected results.
|
void |
testParameterMetadataWithCHARParameters()
test ParameterMetaData for Java procedures with CHAR parameters
|
void |
testParameterMetadataWithDECIMALParameters()
test ParameterMetaData for Java procedures with DECIMAL parameters
|
void |
testParameterMetadataWithINTParameters()
test ParameterMetaData for Java procedures with INTEGER parameters
|
void |
testParameterMetadataWithLITERALParameters()
test ParameterMetaData for Java procedures with some literal parameters
|
void |
testParameterMetadataWithTimestampParameters()
test ParameterMetaData for Java procedures with TIMESTAMP parameters
|
void |
testPreparedStatement()
Testing a prepared statement.
|
void |
testSelectStatementUsingBoolean()
testing SELECT statements for BOOLEANs (1 for true, 0 for false)
|
void |
testSelectStatementUsingNoParameter()
test: no parameter for the statement and then do getParameterMetaData()
|
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, setUp, toString
public ParameterMetaDataJdbc30Test(java.lang.String name)
name
- name of the test.public static junit.framework.Test suite()
private static junit.framework.Test baseSuite(java.lang.String name)
public void testCallableStatement() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testPreparedStatement() throws java.sql.SQLException
java.sql.SQLException
- if database access errors or other errors occurpublic void testBooleanParameters() throws java.sql.SQLException
java.sql.SQLException
- if database access errors or other errors occurpublic void testBooleanProcedureArgs() throws java.lang.Exception
java.lang.Exception
public void testLikeEscaleStatement() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testExecuteStatementUsing() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testSelectStatementUsingBoolean() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testSelectStatementUsingNoParameter() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testCallableStatementReturnedScale() throws java.sql.SQLException
java.sql.SQLException
public void testMetatdataAfterProcRecompile() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testParameterMetadataWithINTParameters() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testParameterMetadataWithCHARParameters() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testParameterMetadataWithTimestampParameters() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testParameterMetadataWithDECIMALParameters() throws java.sql.SQLException
java.sql.SQLException
- if error occurspublic void testParameterMetadataWithLITERALParameters() throws java.sql.SQLException
java.sql.SQLException
- if error occursstatic java.lang.String parameterIsNullableInStringForm(int nullabilityValue)
nullabilityValue
- static java.lang.String parameterModeInStringForm(int mode)
mode
- identifies parameter's mode (IN, OUT, or IN_OUT)static void testParameterMetaData(java.sql.ParameterMetaData paramMetaData, java.lang.String[][] paramMetaDataArray) throws java.sql.SQLException
paramMetaData
- ParameterMetadata objectparamMetaDataArray
- 2 dimensional array containing expected test results.java.sql.SQLException
- if any error occursstatic void dumpParameterMetaDataNegative(java.sql.ParameterMetaData paramMetaData) throws java.sql.SQLException
paramMetaData
- ParameterMetadata objectjava.sql.SQLException
- if any error occurspublic static void dummyint(int in_param, int in_param2, int[] in_param3, int[] in_param4) throws java.sql.SQLException
in_param
- in_param2
- in_param3
- in_param4
- java.sql.SQLException
public static void dummyint2(int in_param, int in_param2, int[] in_param3, int[] in_param4) throws java.sql.SQLException
in_param
- in_param2
- in_param3
- in_param4
- java.sql.SQLException
public static void dummy_numeric_Proc(java.math.BigDecimal[] max_param, java.math.BigDecimal[] min_param) throws java.sql.SQLException
max_param
- min_param
- java.sql.SQLException
public static void dummyString(java.lang.String in_param, java.lang.String in_param2, java.lang.String[] in_param3, java.lang.String[] in_param4)
in_param
- in_param2
- in_param3
- in_param4
- public static void dummyString(java.sql.Timestamp in_param1, java.sql.Timestamp[] inout_param2, java.sql.Timestamp[] out_param3)
public static void dummyDecimal(java.math.BigDecimal in_param, java.math.BigDecimal in_param2, java.math.BigDecimal[] in_param3, java.math.BigDecimal[] in_param4)
in_param
- in_param2
- in_param3
- in_param4
- public static void booleanProc(boolean inarg, boolean[] outarg, boolean[] inoutarg)
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.