public class PreparedStatementTest42 extends BaseJDBCTestCase
Modifier and Type | Class and Description |
---|---|
static class |
PreparedStatementTest42.ColumnDesc |
Modifier and Type | Field and Description |
---|---|
private static PreparedStatementTest42.ColumnDesc[] |
_columnDescs |
private static java.sql.JDBCType[] |
ILLEGAL_JDBC_TYPES |
private static int[] |
ILLEGAL_SQL_TYPES |
private static java.lang.String |
UNIMPLEMENTED_FEATURE |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
PreparedStatementTest42(java.lang.String name)
Create a new test with the given name.
|
Modifier and Type | Method and Description |
---|---|
private static boolean |
aliasExists(java.sql.Connection conn,
java.lang.String aliasName) |
static void |
assertObjectEquals(java.lang.Object expected,
java.lang.Object actual) |
private static void |
assertUnimplemented(java.sql.SQLException se) |
static void |
callableStatementSetObjectTest(java.sql.Connection conn) |
private static void |
compareBytes(byte[] left,
byte[] right) |
private static void |
createProc(java.sql.Connection conn) |
private static void |
createSchemaObjects(java.sql.Connection conn) |
private static void |
createSetObjectProc(java.sql.Connection conn) |
private static void |
createSetObjectSchemaObjects(java.sql.Connection conn) |
private void |
insertRow(java.sql.PreparedStatement insert,
int rowIdx) |
private static byte[] |
makeBinary(java.lang.String contents) |
private static java.sql.Blob |
makeBlob(java.lang.String contents) |
private static java.sql.Clob |
makeClob(java.lang.String contents) |
private static Price |
makePrice(long raw) |
private void |
makeTable(java.sql.Connection conn) |
static void |
packAllTypes(int valueIdx,
java.lang.Long bigintValue,
java.sql.Blob blobValue,
java.lang.Boolean booleanValue,
java.lang.String charValue,
byte[] binaryValue,
java.sql.Clob clobValue,
java.sql.Date dateValue,
java.math.BigDecimal decimalValue,
java.lang.Double doubleValue,
java.lang.Double floatValue,
java.lang.Integer intValue,
java.lang.String longVarcharValue,
byte[] longVarbinaryValue,
java.math.BigDecimal numericValue,
java.lang.Float realValue,
java.lang.Integer smallintValue,
java.sql.Time timeValue,
java.sql.Timestamp timestampValue,
Price priceValue,
java.lang.String varcharValue,
byte[] varbinaryValue) |
private void |
populateTable(java.sql.Connection conn) |
private java.sql.PreparedStatement |
prepareInsert(java.sql.Connection conn) |
private void |
prepTable(java.sql.Connection conn,
int rowIdx) |
static void |
registerObjectTest(java.sql.Connection conn) |
private static void |
setupPrice(java.sql.Connection conn) |
static junit.framework.Test |
suite() |
void |
test_01_setObject()
Test the setObject() overloads added by JDBC 4.2.
|
void |
test_02_registerObject()
Test the CallableStatement.registerObject() overloads added by JDBC 4.2.
|
void |
test_03_setObject()
Test the CallableStatement.setObject() overloads added by JDBC 4.2.
|
void |
test_04_targetTypeIsNull()
DERBY-6081: Verify that an SQLException is raised if the supplied
SQLType argument is null.
|
static void |
unpackAllTypes(int valueIdx,
java.lang.Long[] bigintValue,
java.sql.Blob[] blobValue,
java.lang.Boolean[] booleanValue,
java.lang.String[] charValue,
byte[][] binaryValue,
java.sql.Clob[] clobValue,
java.sql.Date[] dateValue,
java.math.BigDecimal[] decimalValue,
java.lang.Double[] doubleValue,
java.lang.Double[] floatValue,
java.lang.Integer[] intValue,
java.lang.String[] longVarcharValue,
byte[][] longVarbinaryValue,
java.math.BigDecimal[] numericValue,
java.lang.Float[] realValue,
java.lang.Integer[] smallintValue,
java.sql.Time[] timeValue,
java.sql.Timestamp[] timestampValue,
Price[] priceValue,
java.lang.String[] varcharValue,
byte[][] varbinaryValue) |
private void |
updateColumns(java.sql.Connection conn) |
private static void |
vetCS(java.sql.CallableStatement cs,
int valueIdx) |
private static void |
vetProc(java.sql.Connection conn) |
private static void |
vetSetObjectProc(java.sql.Connection conn) |
private void |
vetTable(java.sql.Connection conn,
int rowIdx,
int expectedRowCount) |
private void |
vetTableContents(java.sql.Connection conn) |
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
private static final java.lang.String UNIMPLEMENTED_FEATURE
private static final java.sql.JDBCType[] ILLEGAL_JDBC_TYPES
private static final int[] ILLEGAL_SQL_TYPES
private static PreparedStatementTest42.ColumnDesc[] _columnDescs
public PreparedStatementTest42(java.lang.String name)
public static junit.framework.Test suite()
public void test_01_setObject() throws java.lang.Exception
Test the setObject() overloads added by JDBC 4.2.
java.lang.Exception
private void makeTable(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private void populateTable(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void assertUnimplemented(java.sql.SQLException se) throws java.lang.Exception
java.lang.Exception
private java.sql.PreparedStatement prepareInsert(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private void insertRow(java.sql.PreparedStatement insert, int rowIdx) throws java.lang.Exception
java.lang.Exception
private void vetTableContents(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private void updateColumns(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private void prepTable(java.sql.Connection conn, int rowIdx) throws java.lang.Exception
java.lang.Exception
private void vetTable(java.sql.Connection conn, int rowIdx, int expectedRowCount) throws java.lang.Exception
java.lang.Exception
public void test_02_registerObject() throws java.lang.Exception
Test the CallableStatement.registerObject() overloads added by JDBC 4.2.
java.lang.Exception
public static void registerObjectTest(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void createSchemaObjects(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void createProc(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void vetProc(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void vetCS(java.sql.CallableStatement cs, int valueIdx) throws java.lang.Exception
java.lang.Exception
public void test_03_setObject() throws java.lang.Exception
Test the CallableStatement.setObject() overloads added by JDBC 4.2.
java.lang.Exception
public static void callableStatementSetObjectTest(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void createSetObjectSchemaObjects(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void createSetObjectProc(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static void vetSetObjectProc(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
public void test_04_targetTypeIsNull() throws java.lang.Exception
java.lang.Exception
public static void unpackAllTypes(int valueIdx, java.lang.Long[] bigintValue, java.sql.Blob[] blobValue, java.lang.Boolean[] booleanValue, java.lang.String[] charValue, byte[][] binaryValue, java.sql.Clob[] clobValue, java.sql.Date[] dateValue, java.math.BigDecimal[] decimalValue, java.lang.Double[] doubleValue, java.lang.Double[] floatValue, java.lang.Integer[] intValue, java.lang.String[] longVarcharValue, byte[][] longVarbinaryValue, java.math.BigDecimal[] numericValue, java.lang.Float[] realValue, java.lang.Integer[] smallintValue, java.sql.Time[] timeValue, java.sql.Timestamp[] timestampValue, Price[] priceValue, java.lang.String[] varcharValue, byte[][] varbinaryValue)
public static void packAllTypes(int valueIdx, java.lang.Long bigintValue, java.sql.Blob blobValue, java.lang.Boolean booleanValue, java.lang.String charValue, byte[] binaryValue, java.sql.Clob clobValue, java.sql.Date dateValue, java.math.BigDecimal decimalValue, java.lang.Double doubleValue, java.lang.Double floatValue, java.lang.Integer intValue, java.lang.String longVarcharValue, byte[] longVarbinaryValue, java.math.BigDecimal numericValue, java.lang.Float realValue, java.lang.Integer smallintValue, java.sql.Time timeValue, java.sql.Timestamp timestampValue, Price priceValue, java.lang.String varcharValue, byte[] varbinaryValue) throws java.lang.Exception
java.lang.Exception
private static void setupPrice(java.sql.Connection conn) throws java.lang.Exception
java.lang.Exception
private static boolean aliasExists(java.sql.Connection conn, java.lang.String aliasName) throws java.lang.Exception
java.lang.Exception
private static java.sql.Blob makeBlob(java.lang.String contents)
private static java.sql.Clob makeClob(java.lang.String contents)
private static byte[] makeBinary(java.lang.String contents)
private static Price makePrice(long raw)
public static void assertObjectEquals(java.lang.Object expected, java.lang.Object actual) throws java.lang.Exception
java.lang.Exception
private static void compareBytes(byte[] left, byte[] right) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.