public class ParameterMappingTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static int |
_X |
static boolean[][] |
allowRegisterOut |
static boolean[][] |
B2_MOD
JDBC 3.0 Section 13.2.2.1 specifies that table B-2 is used to specify type mappings
from the Java types (e.g. int as setInt) to the JDBC SQL Type (Types.INT).
|
private static java.lang.Class[] |
B3_GET_OBJECT |
static boolean[][] |
B5
Table B5 conversion of Objects using setObject
|
static boolean[][] |
B6
JDBC 3.0 spec Table B6 - Use of ResultSet getter Methods to Retrieve JDBC Data Types
|
private static java.lang.String |
BAD_TYPE |
private static java.math.BigDecimal |
bdMaxDoubleValue |
private static java.math.BigDecimal |
bdMaxFloatValue |
private static java.math.BigDecimal |
bdMaxIntValue |
private static java.math.BigDecimal |
bdMaxLongValue |
private static java.math.BigDecimal |
bdMaxShortValue |
private static java.math.BigDecimal |
bdMinDoubleValue |
private static java.math.BigDecimal |
bdMinFloatValue |
private static java.math.BigDecimal |
bdMinIntValue |
private static java.math.BigDecimal |
bdMinLongValue |
private static java.math.BigDecimal |
bdMinShortValue |
private static java.math.BigDecimal |
bdSmallestNegDoubleValue |
private static java.math.BigDecimal |
bdSmallestNegFloatValue |
private static java.math.BigDecimal |
bdSmallestPosDoubleValue |
private static java.math.BigDecimal |
bdSmallestPosFloatValue |
private static long |
BIG_INTEGER_SEED |
private static java.lang.String |
CALENDAR_METHOD_NAME |
private static long |
CALENDAR_SEED |
private static java.lang.String |
DATE_METHOD_NAME |
private static long |
DATE_SEED |
(package private) static double |
DB2_LARGEST_DOUBLE |
(package private) static double |
DB2_LARGEST_NEGATIVE_DOUBLE |
(package private) static float |
DB2_LARGEST_NEGATIVE_REAL |
(package private) static float |
DB2_LARGEST_REAL |
(package private) static double |
DB2_SMALLEST_DOUBLE |
(package private) static double |
DB2_SMALLEST_POSITIVE_DOUBLE |
(package private) static float |
DB2_SMALLEST_POSITIVE_REAL |
(package private) static float |
DB2_SMALLEST_REAL |
private static boolean |
HAVE_BIG_DECIMAL
We support BigDecimal if we're not running under JSR 169.
|
private static int[] |
jdbcTypes |
private static boolean |
n |
private static java.lang.String[] |
SQLTypes |
private static java.lang.String |
TRUNCATED |
private static java.lang.String |
UTF8 |
private static java.lang.String[] |
validString |
private static java.lang.String |
WONT_FIT |
private static boolean |
X |
private static int |
XXX_BYTE |
private static int |
XXX_DOUBLE |
private static int |
XXX_FLOAT |
private static int |
XXX_INT |
private static int |
XXX_LONG |
private static int |
XXX_SHORT |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ParameterMappingTest(java.lang.String arg0) |
Modifier and Type | Method and Description |
---|---|
private void |
assertGetState(java.sql.ResultSet rs,
java.lang.String colName,
int getType,
java.lang.String expected) |
private void |
assertUpdateOK(java.sql.ResultSet rs,
java.lang.String colName,
long value,
double dvalue,
int updateType) |
private void |
assertUpdateState(java.sql.ResultSet rs,
java.lang.String colName,
java.math.BigDecimal value,
java.lang.String expected) |
private void |
assertUpdateState(java.sql.ResultSet rs,
java.lang.String colName,
long value,
double dvalue,
int updateType,
java.lang.String expected) |
static void |
blobIn(java.sql.Blob c,
java.lang.String[] result) |
static void |
blobInOut(java.sql.Blob[] c) |
static void |
blobOut(java.sql.Blob[] c) |
protected java.sql.PreparedStatement |
chattyPrepare(java.sql.Connection conn,
java.lang.String text)
Prepare a statement and report its sql text.
|
protected java.sql.CallableStatement |
chattyPrepareCall(java.sql.Connection conn,
java.lang.String text)
Prepare a call statement and report its sql text.
|
private static java.lang.String |
checkForInvalidConversion(java.sql.SQLException sqle)
Look for an "Invalid Conversion" exception and format it for display.
|
private static void |
checkProcedureOutput(int param,
int paramType,
byte val) |
private static void |
checkProcedureOutput(int param,
int paramType,
byte[] val) |
private static void |
checkProcedureOutput(int param,
int paramType,
java.sql.Date val) |
private static void |
checkProcedureOutput(int param,
int paramType,
double val) |
private static void |
checkProcedureOutput(int param,
int paramType,
float val) |
private static void |
checkProcedureOutput(int param,
int paramType,
int val) |
private static void |
checkProcedureOutput(int param,
int paramType,
long val) |
private static void |
checkProcedureOutput(int param,
int paramType,
short val) |
private static void |
checkProcedureOutput(int param,
int paramType,
java.lang.String val) |
private static void |
checkProcedureOutput(int param,
int paramType,
java.sql.Time val) |
private static void |
checkProcedureOutput(int param,
int paramType,
java.sql.Timestamp val) |
private static void |
checkValidStringValue(java.lang.String method,
java.lang.String s) |
static void |
clobIn(java.sql.Clob c,
java.lang.String[] result) |
static void |
clobInOut(java.sql.Clob[] c) |
static void |
clobOut(java.sql.Clob[] c) |
private void |
compareBlobs(java.sql.Blob left,
java.sql.Blob right) |
private static boolean |
compareClobReader2CharArray(char[] cArray,
java.io.Reader charReader) |
private void |
compareClobs(java.sql.Clob left,
java.sql.Clob right) |
(package private) static void |
dumpSQLExceptions(java.sql.SQLException se) |
protected void |
expectCompilationError(java.lang.String sqlState,
java.lang.String query)
Assert that the statement text, when compiled, raises an exception
|
private static java.lang.String |
getBlobValue(java.sql.Blob c) |
private static java.lang.String |
getClobValue(java.sql.Clob c) |
private static boolean |
getOutValue(java.sql.CallableStatement cs,
int param,
int regJdbcType,
int paramType) |
private static boolean |
getValidValue(java.sql.PreparedStatement ps,
int jdbcType,
java.lang.String method) |
private static void |
getXXX(java.sql.PreparedStatement ps,
int type,
boolean isNull) |
private void |
helperTestClobOrVarchar(boolean testCLOB)
DERBY-6237(PreparedStatement.execute() fails starting 10.2 when
multiple rows are updated and
PreparedStatement.setCharacterStream(int, Reader, int) is used)
In 10.1, setCharacterStream to update CLOB and varchar columns
work even when update is going to update more than one row
|
void |
helperTestDerby6214(int numberOfRowsToUpdate,
int testVariation) |
private void |
helperTestDerby6237(int numberOfRowsToUpdate,
int testVariation,
boolean testCLOB) |
private static boolean |
isBooleanMethod(java.lang.String method) |
private static void |
judge_getXXX(boolean worked,
java.sql.SQLException sqleResult,
int whichCall,
int type) |
private static void |
judge_setObject(boolean worked,
java.sql.SQLException sqleResult,
int b5o,
int type) |
private static void |
judge_setXXX(boolean worked,
java.sql.SQLException sqleResult,
int whichCall,
int type) |
private java.sql.Blob |
makeBigBlob() |
private java.sql.Clob |
makeBigClob() |
private static java.util.Calendar |
makeCalendar(long calendarSeed) |
static void |
pmap(java.math.BigDecimal in,
java.math.BigDecimal[] inout,
java.math.BigDecimal[] out) |
static void |
pmap(java.sql.Blob in,
java.sql.Blob[] inout,
java.sql.Blob[] out) |
static void |
pmap(boolean in,
boolean[] inout,
boolean[] out) |
static void |
pmap(byte[] in,
byte[][] inout,
byte[][] out) |
static void |
pmap(java.sql.Clob in,
java.sql.Clob[] inout,
java.sql.Clob[] out) |
static void |
pmap(java.sql.Date in,
java.sql.Date[] inout,
java.sql.Date[] out) |
static void |
pmap(double in,
double[] inout,
double[] out) |
static void |
pmap(float in,
float[] inout,
float[] out) |
static void |
pmap(int in,
int[] inout,
int[] out) |
static void |
pmap(long in,
long[] inout,
long[] out) |
static void |
pmap(short in,
short[] inout,
short[] out) |
static void |
pmap(java.lang.String in,
java.lang.String[] inout,
java.lang.String[] out) |
static void |
pmap(java.sql.Timestamp in,
java.sql.Timestamp[] inout,
java.sql.Timestamp[] out) |
static void |
pmap(java.sql.Time in,
java.sql.Time[] inout,
java.sql.Time[] out) |
private static char[] |
reverse(char[] in) |
private static void |
setUnicodeStream(java.sql.PreparedStatement ps,
int parameterIndex,
java.io.InputStream stream,
int length)
Helper method for calling the deprecated
setUnicodeStream()
method without getting deprecation warnings from the compiler. |
protected void |
setUp() |
private static boolean |
setValidValue(java.sql.PreparedStatement ps,
int param,
int jdbcType) |
private static void |
setXXX_setObject_doWork(java.sql.Statement s,
java.sql.PreparedStatement psi,
java.sql.PreparedStatement psq,
int type,
java.lang.Object value,
java.lang.String className,
int b5o,
boolean withTypeFlag,
boolean batchExecution)
Helper method that does all the work for setXXX_setObject().
|
private static void |
setXXX_setObject(java.sql.Statement s,
java.sql.PreparedStatement psi,
java.sql.PreparedStatement psq,
int type,
java.lang.Object value,
java.lang.String className,
int b5o)
Do the
setObject() tests for setXXX() . |
private static void |
setXXX_setObjectNullNoTypeSpec(java.sql.Statement s,
java.sql.PreparedStatement psi,
java.sql.PreparedStatement psq,
int type)
Passes Java null to the setObject-call, expecting the driver to set the
column value to SQL NULL.
|
private static void |
setXXX(java.sql.Statement s,
java.sql.PreparedStatement psi,
java.sql.PreparedStatement psq,
int type) |
private static void |
showException(java.sql.SQLException sqle)
Fails the test, doing some processing on the SQL state and exception
message.
|
private static java.lang.String |
showFirstTwo(byte[] data) |
private static java.lang.String |
showFirstTwo(java.io.InputStream in) |
private static java.lang.String |
showFirstTwo(java.io.Reader in) |
private static boolean |
specificCheck(java.sql.ResultSet rs,
boolean worked,
java.sql.SQLException sqleResult,
boolean isNull) |
static junit.framework.Test |
suite() |
protected void |
tearDown()
Tear down this fixture, sub-classes should call
super.tearDown().
|
void |
test_jdbc4_1_objectMappings()
Test the new object mappings allowed by setObject() in JDBC 4.1.
|
void |
testBigInteger()
Test setObject( int, BigInteger ) in JDBC 4.1.
|
void |
testBlobMapping()
Verify correct mapping of blobs.
|
void |
testClobMapping()
Verify correct mapping of clobs.
|
void |
testDerby2073()
Test setBigDecimal does not lose fractional digits
|
void |
testDerby5533GetXXX()
Tests that SQLStates are correct across drivers on rs.getXXX
over/underflow.
|
void |
testDerby5533UpdateXXX()
Tests that SQLStates are correct across drivers on updateXXX
over/underflow.
|
void |
testDerby5536()
DERBY-5536: client driver change of implementation for getting long
from DECIMAL, so check correctness for two cases: 1) value with 18
decimal digits or less, and 2) value with more than 18 decimal
digits.
|
void |
testDerby6214()
DERBY-6214 (PreparedStatement.setObject(int, Object, Types.CLOB)
fail with DerbyNet)
Test setObject and setString on CLOB columns
|
void |
testParameterMapping() |
private static void |
testSetStringInvalidValue(int type,
java.sql.PreparedStatement psi)
Test for DERBY-149 fix Check that setString to an invalid value throws an
exception rather than causing a hang
|
void |
testUpdateSetCharacterStreamClob()
DERBY-6237(PreparedStatement.execute() fails starting 10.2 when
multiple rows are updated and
PreparedStatement.setCharacterStream(int, Reader, int) is used)
Test setCharacterStream on CLOB column
|
void |
testUpdateSetCharacterStreamVarchar()
DERBY-6237(PreparedStatement.execute() fails starting 10.2 when
multiple rows are updated and
PreparedStatement.setCharacterStream(int, Reader, int) is used)
Test setCharacterStream on VARCHAR column
|
private void |
vetBigInteger(java.sql.Connection conn,
java.lang.String seed,
java.lang.String[] allColumns,
java.util.HashSet undersizedIntColumns,
java.util.HashSet undersizedStringColumns) |
private void |
vetBigInteger(java.sql.Connection conn,
java.lang.String seed,
java.lang.String columnName,
java.lang.String errorState) |
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, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, 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, 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 boolean HAVE_BIG_DECIMAL
private static final java.lang.String BAD_TYPE
private static final java.lang.String UTF8
private static final long BIG_INTEGER_SEED
private static final long DATE_SEED
private static final long CALENDAR_SEED
private static final java.lang.String DATE_METHOD_NAME
private static final java.lang.String CALENDAR_METHOD_NAME
private static final java.lang.String WONT_FIT
private static final java.lang.String TRUNCATED
private static int[] jdbcTypes
private static java.lang.String[] SQLTypes
private static java.lang.String[] validString
private static java.lang.Class[] B3_GET_OBJECT
private static final boolean n
private static final boolean X
public static final boolean[][] B6
public static boolean[][] B2_MOD
public static boolean[][] B5
public static final boolean[][] allowRegisterOut
private static final java.math.BigDecimal bdMaxShortValue
private static final java.math.BigDecimal bdMinShortValue
private static final java.math.BigDecimal bdMaxIntValue
private static final java.math.BigDecimal bdMinIntValue
private static final java.math.BigDecimal bdMaxLongValue
private static final java.math.BigDecimal bdMinLongValue
private static final java.math.BigDecimal bdMaxFloatValue
private static final java.math.BigDecimal bdMinFloatValue
private static final java.math.BigDecimal bdSmallestPosFloatValue
private static final java.math.BigDecimal bdSmallestNegFloatValue
private static final java.math.BigDecimal bdMaxDoubleValue
private static final java.math.BigDecimal bdMinDoubleValue
private static final java.math.BigDecimal bdSmallestPosDoubleValue
private static final java.math.BigDecimal bdSmallestNegDoubleValue
static final float DB2_SMALLEST_REAL
static final float DB2_LARGEST_REAL
static final float DB2_SMALLEST_POSITIVE_REAL
static final float DB2_LARGEST_NEGATIVE_REAL
static final double DB2_SMALLEST_DOUBLE
static final double DB2_LARGEST_DOUBLE
static final double DB2_SMALLEST_POSITIVE_DOUBLE
static final double DB2_LARGEST_NEGATIVE_DOUBLE
private static final int _X
private static final int XXX_BYTE
private static final int XXX_SHORT
private static final int XXX_INT
private static final int XXX_LONG
private static final int XXX_FLOAT
private static final int XXX_DOUBLE
public ParameterMappingTest(java.lang.String arg0)
arg0
- protected void setUp() throws java.lang.Exception
setUp
in class junit.framework.TestCase
java.lang.Exception
public void helperTestDerby6214(int numberOfRowsToUpdate, int testVariation) throws java.lang.Exception
java.lang.Exception
public void testDerby6214() throws java.lang.Exception
java.lang.Exception
public void testDerby2073() throws java.lang.Exception
java.lang.Exception
public void testParameterMapping() throws java.lang.Exception
java.lang.Exception
public void testClobMapping() throws java.lang.Exception
java.lang.Exception
private java.sql.Clob makeBigClob() throws java.lang.Exception
java.lang.Exception
private void compareClobs(java.sql.Clob left, java.sql.Clob right) throws java.lang.Exception
java.lang.Exception
public void testBlobMapping() throws java.lang.Exception
java.lang.Exception
private java.sql.Blob makeBigBlob() throws java.lang.Exception
java.lang.Exception
private void compareBlobs(java.sql.Blob left, java.sql.Blob right) throws java.lang.Exception
java.lang.Exception
public void test_jdbc4_1_objectMappings() throws java.lang.Exception
java.lang.Exception
private static java.util.Calendar makeCalendar(long calendarSeed)
public void testBigInteger() throws java.lang.Exception
java.lang.Exception
private void vetBigInteger(java.sql.Connection conn, java.lang.String seed, java.lang.String[] allColumns, java.util.HashSet undersizedIntColumns, java.util.HashSet undersizedStringColumns) throws java.lang.Exception
java.lang.Exception
private void vetBigInteger(java.sql.Connection conn, java.lang.String seed, java.lang.String columnName, java.lang.String errorState) throws java.lang.Exception
java.lang.Exception
protected void tearDown() throws java.lang.Exception
BaseJDBCTestCase
tearDown
in class BaseJDBCTestCase
java.lang.Exception
private static void getXXX(java.sql.PreparedStatement ps, int type, boolean isNull) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
private static boolean specificCheck(java.sql.ResultSet rs, boolean worked, java.sql.SQLException sqleResult, boolean isNull) throws java.sql.SQLException
java.sql.SQLException
private static void judge_getXXX(boolean worked, java.sql.SQLException sqleResult, int whichCall, int type)
private static void judge_setXXX(boolean worked, java.sql.SQLException sqleResult, int whichCall, int type)
private static void judge_setObject(boolean worked, java.sql.SQLException sqleResult, int b5o, int type)
private static java.lang.String checkForInvalidConversion(java.sql.SQLException sqle)
private static void setXXX(java.sql.Statement s, java.sql.PreparedStatement psi, java.sql.PreparedStatement psq, int type) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
private static void setUnicodeStream(java.sql.PreparedStatement ps, int parameterIndex, java.io.InputStream stream, int length) throws java.sql.SQLException
setUnicodeStream()
method without getting deprecation warnings from the compiler.java.sql.SQLException
private static void setXXX_setObject(java.sql.Statement s, java.sql.PreparedStatement psi, java.sql.PreparedStatement psq, int type, java.lang.Object value, java.lang.String className, int b5o) throws java.sql.SQLException, java.io.IOException
setObject()
tests for setXXX()
. Test both for
the two-argument setObject(int,Object)
method and the
three-argument setObject(int,Object,int)
method.java.sql.SQLException
java.io.IOException
private static void setXXX_setObject_doWork(java.sql.Statement s, java.sql.PreparedStatement psi, java.sql.PreparedStatement psq, int type, java.lang.Object value, java.lang.String className, int b5o, boolean withTypeFlag, boolean batchExecution) throws java.sql.SQLException, java.io.IOException
withTypeFlag
- if true, use the setObject() method that takes a
type parameter; otherwise, use the two-argument type-less setObject()
methodbatchExecution
- if true, do batch execution; otherwise, do
normal executionjava.sql.SQLException
java.io.IOException
private static void setXXX_setObjectNullNoTypeSpec(java.sql.Statement s, java.sql.PreparedStatement psi, java.sql.PreparedStatement psq, int type) throws java.sql.SQLException, java.io.IOException
This behavior was allowed/introduced by DERBY-1938.
s
- statement used for auxiliary taskspsi
- statement used for insertpsq
- statement used for query (retrieving inserted value)type
- the type of the columnjava.sql.SQLException
java.io.IOException
private static void showException(java.sql.SQLException sqle)
The method accepts a null
SQLState and a null
exception
message, although these conditions would normally be considered as bugs.
sqle
- the cause of the failureprivate static boolean setValidValue(java.sql.PreparedStatement ps, int param, int jdbcType) throws java.sql.SQLException
java.sql.SQLException
private static boolean getValidValue(java.sql.PreparedStatement ps, int jdbcType, java.lang.String method) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
private static void checkValidStringValue(java.lang.String method, java.lang.String s)
private static boolean isBooleanMethod(java.lang.String method)
private static boolean getOutValue(java.sql.CallableStatement cs, int param, int regJdbcType, int paramType) throws java.sql.SQLException, java.io.IOException
java.sql.SQLException
java.io.IOException
private static void checkProcedureOutput(int param, int paramType, byte val)
private static void checkProcedureOutput(int param, int paramType, short val)
private static void checkProcedureOutput(int param, int paramType, int val)
private static void checkProcedureOutput(int param, int paramType, long val)
private static void checkProcedureOutput(int param, int paramType, float val)
private static void checkProcedureOutput(int param, int paramType, double val)
private static void checkProcedureOutput(int param, int paramType, java.lang.String val)
private static void checkProcedureOutput(int param, int paramType, byte[] val)
private static void checkProcedureOutput(int param, int paramType, java.sql.Date val)
private static void checkProcedureOutput(int param, int paramType, java.sql.Time val)
private static void checkProcedureOutput(int param, int paramType, java.sql.Timestamp val)
static void dumpSQLExceptions(java.sql.SQLException se)
private static void testSetStringInvalidValue(int type, java.sql.PreparedStatement psi)
type
- type for SQLTypes arraypsi
- -
insert prepared statement.private static java.lang.String showFirstTwo(java.io.Reader in) throws java.io.IOException
java.io.IOException
private static java.lang.String showFirstTwo(java.io.InputStream in) throws java.io.IOException
java.io.IOException
private static java.lang.String showFirstTwo(byte[] data)
public static junit.framework.Test suite()
public static void pmap(short in, short[] inout, short[] out)
public static void pmap(int in, int[] inout, int[] out)
public static void pmap(boolean in, boolean[] inout, boolean[] out)
public static void pmap(long in, long[] inout, long[] out)
public static void pmap(float in, float[] inout, float[] out)
public static void pmap(double in, double[] inout, double[] out)
public static void pmap(byte[] in, byte[][] inout, byte[][] out)
public static void pmap(java.sql.Date in, java.sql.Date[] inout, java.sql.Date[] out)
public static void pmap(java.sql.Time in, java.sql.Time[] inout, java.sql.Time[] out)
public static void pmap(java.sql.Timestamp in, java.sql.Timestamp[] inout, java.sql.Timestamp[] out)
public static void pmap(java.lang.String in, java.lang.String[] inout, java.lang.String[] out)
public static void pmap(java.math.BigDecimal in, java.math.BigDecimal[] inout, java.math.BigDecimal[] out)
public static void pmap(java.sql.Blob in, java.sql.Blob[] inout, java.sql.Blob[] out) throws java.sql.SQLException
java.sql.SQLException
public static void pmap(java.sql.Clob in, java.sql.Clob[] inout, java.sql.Clob[] out) throws java.sql.SQLException
java.sql.SQLException
public static void clobIn(java.sql.Clob c, java.lang.String[] result) throws java.sql.SQLException
java.sql.SQLException
public static void clobOut(java.sql.Clob[] c) throws java.sql.SQLException
java.sql.SQLException
public static void clobInOut(java.sql.Clob[] c) throws java.sql.SQLException
java.sql.SQLException
private static java.lang.String getClobValue(java.sql.Clob c) throws java.sql.SQLException
java.sql.SQLException
private static char[] reverse(char[] in)
public static void blobIn(java.sql.Blob c, java.lang.String[] result) throws java.lang.Exception
java.lang.Exception
public static void blobOut(java.sql.Blob[] c) throws java.lang.Exception
java.lang.Exception
public static void blobInOut(java.sql.Blob[] c) throws java.lang.Exception
java.lang.Exception
private static java.lang.String getBlobValue(java.sql.Blob c) throws java.lang.Exception
java.lang.Exception
protected java.sql.PreparedStatement chattyPrepare(java.sql.Connection conn, java.lang.String text) throws java.sql.SQLException
chattyPrepare
in class BaseJDBCTestCase
java.sql.SQLException
protected java.sql.CallableStatement chattyPrepareCall(java.sql.Connection conn, java.lang.String text) throws java.sql.SQLException
chattyPrepareCall
in class BaseJDBCTestCase
java.sql.SQLException
protected void expectCompilationError(java.lang.String sqlState, java.lang.String query)
expectCompilationError
in class BaseJDBCTestCase
public void testDerby5533GetXXX() throws java.sql.SQLException
java.sql.SQLException
- database access error. Causes test to
fail with an error.public void testDerby5533UpdateXXX() throws java.sql.SQLException
java.sql.SQLException
- database access error. Causes test to
fail with an error.public void testDerby5536() throws java.sql.SQLException
java.sql.SQLException
private void assertUpdateState(java.sql.ResultSet rs, java.lang.String colName, java.math.BigDecimal value, java.lang.String expected) throws java.sql.SQLException
java.sql.SQLException
private void assertUpdateOK(java.sql.ResultSet rs, java.lang.String colName, long value, double dvalue, int updateType) throws java.sql.SQLException
java.sql.SQLException
private void assertUpdateState(java.sql.ResultSet rs, java.lang.String colName, long value, double dvalue, int updateType, java.lang.String expected) throws java.sql.SQLException
java.sql.SQLException
private void assertGetState(java.sql.ResultSet rs, java.lang.String colName, int getType, java.lang.String expected) throws java.sql.SQLException
java.sql.SQLException
private static boolean compareClobReader2CharArray(char[] cArray, java.io.Reader charReader) throws java.lang.Exception
java.lang.Exception
public void testUpdateSetCharacterStreamClob() throws java.lang.Exception
java.lang.Exception
public void testUpdateSetCharacterStreamVarchar() throws java.lang.Exception
java.lang.Exception
private void helperTestClobOrVarchar(boolean testCLOB) throws java.lang.Exception
testCLOB
- - true means test setCharacterStream on CLOB
- false means test setCharacterStream on VARCHARjava.lang.Exception
private void helperTestDerby6237(int numberOfRowsToUpdate, int testVariation, boolean testCLOB) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.