org.apache.derbyTesting.functionTests.tests.jdbc4

Class PreparedStatementTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbc4.PreparedStatementTest

All Implemented Interfaces:

junit.framework.Test

public class PreparedStatementTest
extends BaseJDBCTestCase

This class is used to test JDBC4 specific methods in the PreparedStatement(s) object. A number of methods and variables are in place to aid the writing of tests:

• setBinaryStreamOnBlob
• setAsciiStream
• key - an id. One is generated each time setUp is run.
• reqeustKey() - generate a new unique id.
• psInsertX - prepared statements for insert.
• psFetchX - prepared statements for fetching values.

For table creation, see the suite-method.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	PreparedStatementTest.PreparedStatementWrapper This wrapper is used to expose JDBC 4.2 methods which can run on VM rev levels lower than Java 8.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	BLOBTBL
private static byte[]	BYTES Byte array passed in to the database.
private static java.lang.String	CLOBTBL
private static int	globalKey Key used to id data inserted into the database.
private int	key Default key to use for insertions.
private static java.lang.String	LONGVARCHAR
private java.sql.PreparedStatement	ps PreparedStatement object with no positional arguments.
private java.sql.PreparedStatement	psFetchBlob PreparedStatement to fetch BLOB with specified id.
private java.sql.PreparedStatement	psFetchClob PreparedStatement to fetch CLOB with specified id.
private java.sql.PreparedStatement	psInsertBlob PreparedStatement to insert a BLOB with specified id.
private java.sql.PreparedStatement	psInsertClob PreparedStatement to insert a CLOB with specified id.
private java.sql.PreparedStatement	psInsertLongVarchar PreparedStatement to insert a LONG VARCHAR with specified id.
private java.sql.Statement	s

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
PreparedStatementTest(java.lang.String name) Create a test with the given name.

Method Summary

Modifier and Type	Method and Description
private void	assertInternalDerbyIOExceptionState(java.lang.String preSQLState, java.lang.String expectedInternal, java.sql.SQLException sqle) This methods is not to be used, but sometimes you have to!
private static junit.framework.Test	baseSuite(java.lang.String name)
void	cpTestIsPoolableHintFalse() Tests that the isPoolable-hint works by exploiting the fact that the client cannot prepare a statement referring to a deleted table (unless the statement is already in the statement cache).
void	cpTestIsPoolableHintTrue() Tests that the isPoolable-hint works by exploiting the fact that the client can prepare a statement referring to a deleted table if JDBC statement caching is enabled and the statement is already in the cache.
static void	largeUpdate_jdbc4_2(java.sql.Connection conn)
private static void	largeUpdateTest(java.sql.Statement stmt, PreparedStatementTest.PreparedStatementWrapper psw, long rowCountBase)
private static int	requestKey() Get next key to id inserted data with.
private void	setAsciiStream(java.sql.PreparedStatement ps, int id, int actualLength, int specifiedLength, int trailingBlanks, boolean lengthLess) Insert data into a column with setAsciiStream.
private void	setBinaryStreamOnBlob(int id, int actualLength, int specifiedLength, int trailingBlanks, boolean lengthLess) Insert data into a Blob column with setBinaryStream.
void	setUp() Obtain a "regular" connection and PreparedStatement that the tests can use.
private static junit.framework.Test	statementCachingSuite() Returns a suite for tests that need JDBC statement caching to be enabled.
static junit.framework.Test	suite()
void	tearDown() Release the resources that are used in this test
void	testBlobExceptionDoesNotRollbackOtherStatements()
void	testExceptionPathMultiplePages_bs()
void	testExceptionPathOnePage_bs()
void	testIsNotWrapperForCallableStatement()
void	testIsNotWrapperForResultSet()
void	testIsPoolableDefault() Tests the PreparedStatement interface method isPoolable
void	testIsPoolableOnClosed() Tests the PreparedStatement interface method isPoolable on closed PreparedStatement
void	testIsWrapperForPreparedStatement()
void	testIsWrapperForSelf()
void	testIsWrapperForStatement()
void	testLargeUpdate_jdbc4_2() Test the large update methods added by JDBC 4.2.
void	testSetAsciiStream() Tests the PreparedStatement interface method setAsciiStream
void	testSetAsciiStreamLengthless()
void	testSetAsciiStreamLengthLess1KOnClob()
void	testSetAsciiStreamLengthLess32KOnClob()
void	testSetAsciiStreamLengthLess65KOnClob()
void	testSetAsciiStreamLengthLessOnClobTooLong()
void	testSetAsciiStreamLengthLessOnClobTooLongTruncate()
void	testSetAsciiStreamLengthlessOnLongVarCharDontTruncate()
void	testSetAsciiStreamLengthlessOnLongVarCharTooLong()
void	testSetBinaryStream() Tests the PreparedStatement interface method setBinaryStream
void	testSetBinaryStreamLengthless()
void	testSetBinaryStreamLengthLess1KOnBlob()
void	testSetBinaryStreamLengthLess32KOnBlob()
void	testSetBinaryStreamLengthLess65KOnBlob()
void	testSetBinaryStreamLengthLessOnBlobTooLong()
void	testSetBlob() Test the setBlob() method
void	testSetBlobLengthless() Insert Blob without specifying length and read it back for verification.
void	testSetCharacterStream() Tests the PreparedStatement interface method setCharacterStream
void	testSetCharacterStreamLengthless()
void	testSetClob() Test the setClob() method
void	testSetClobLengthless() Insert Clob without specifying length and read it back for verification.
void	testSetNCharacterStream() Tests the setNCharacterStream method of the PreparedStatement interface
void	testSetNCharacterStreamLengthlessNotImplemented()
void	testSetNClob1() Tests the setNClob method of the PreparedStatement interface
void	testSetNClob2() Tests the setNClob method of the PreparedStatement interface
void	testSetNClobLengthlessNotImplemented()
void	testSetNString() Tests the setNString method of the PreparedStatement interface
void	testSetPoolable() Tests the PreparedStatement interface method setPoolable
void	testSetPoolableOnClosed() Tests the PreparedStatement interface method setPoolable on a closed PreparedStatement
void	testSetRowId() Tests the setRowId method of the PreparedStatement interface
void	testSetSQLXML() Tests the setSQLXML method of the PreparedStatement interface
void	testUnwrapAsSelf()
void	testUnwrapCallableStatement()
void	testUnwrapPreparedStatement()
void	testUnwrapResultSet()
void	testUnwrapStatement()

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, 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

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

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

Methods inherited from class java.lang.Object

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

Field Detail

BLOBTBL

private static final java.lang.String BLOBTBL

See Also:

Constant Field Values

CLOBTBL

private static final java.lang.String CLOBTBL

See Also:

Constant Field Values

LONGVARCHAR

private static final java.lang.String LONGVARCHAR

See Also:

Constant Field Values

globalKey

private static int globalKey

Key used to id data inserted into the database.

BYTES

private static final byte[] BYTES

Byte array passed in to the database.

key

private int key

Default key to use for insertions. Is unique for each fixture. More keys can be fetched by calling requestKey.

ps

private java.sql.PreparedStatement ps

PreparedStatement object with no positional arguments.

psFetchBlob

private java.sql.PreparedStatement psFetchBlob

PreparedStatement to fetch BLOB with specified id.

psInsertBlob

private java.sql.PreparedStatement psInsertBlob

PreparedStatement to insert a BLOB with specified id.

psFetchClob

private java.sql.PreparedStatement psFetchClob

PreparedStatement to fetch CLOB with specified id.

psInsertClob

private java.sql.PreparedStatement psInsertClob

PreparedStatement to insert a CLOB with specified id.

psInsertLongVarchar

private java.sql.PreparedStatement psInsertLongVarchar

PreparedStatement to insert a LONG VARCHAR with specified id.

s

private java.sql.Statement s

Constructor Detail

PreparedStatementTest

public PreparedStatementTest(java.lang.String name)

Create a test with the given name.

Parameters:

name - name of the test.

Method Detail

setUp

public void setUp()
           throws java.sql.SQLException

Obtain a "regular" connection and PreparedStatement that the tests can use.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

public void tearDown()
              throws java.lang.Exception

Release the resources that are used in this test

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.sql.SQLException

java.lang.Exception

suite

public static junit.framework.Test suite()

baseSuite

private static junit.framework.Test baseSuite(java.lang.String name)

statementCachingSuite

private static junit.framework.Test statementCachingSuite()

Returns a suite for tests that need JDBC statement caching to be enabled.

testSetRowId

public void testSetRowId()
                  throws java.sql.SQLException

Tests the setRowId method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testSetNString

public void testSetNString()
                    throws java.sql.SQLException

Tests the setNString method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testSetNCharacterStream

public void testSetNCharacterStream()
                             throws java.sql.SQLException

Tests the setNCharacterStream method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testSetNCharacterStreamLengthlessNotImplemented

public void testSetNCharacterStreamLengthlessNotImplemented()
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNClobLengthlessNotImplemented

public void testSetNClobLengthlessNotImplemented()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNClob1

public void testSetNClob1()
                   throws java.sql.SQLException

Tests the setNClob method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testSetNClob2

public void testSetNClob2()
                   throws java.sql.SQLException

Tests the setNClob method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testSetSQLXML

public void testSetSQLXML()
                   throws java.sql.SQLException

Tests the setSQLXML method of the PreparedStatement interface

Throws:

java.sql.SQLException - upon any failure that occurs in the call to the method.

testIsWrapperForStatement

public void testIsWrapperForStatement()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForPreparedStatement

public void testIsWrapperForPreparedStatement()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsNotWrapperForCallableStatement

public void testIsNotWrapperForCallableStatement()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsNotWrapperForResultSet

public void testIsNotWrapperForResultSet()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForSelf

public void testIsWrapperForSelf()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapStatement

public void testUnwrapStatement()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapPreparedStatement

public void testUnwrapPreparedStatement()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapAsSelf

public void testUnwrapAsSelf()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapCallableStatement

public void testUnwrapCallableStatement()

testUnwrapResultSet

public void testUnwrapResultSet()

testSetClob

public void testSetClob()
                 throws java.io.IOException,
                        java.sql.SQLException

Test the setClob() method

Throws:

java.sql.SQLException - if a failure occurs during the call to setClob

java.io.IOException

testSetClobLengthless

public void testSetClobLengthless()
                           throws java.io.IOException,
                                  java.sql.SQLException

Insert Clob without specifying length and read it back for verification.

Throws:

java.io.IOException - If an IOException during the close operation on the reader.

java.sql.SQLException - If an SQLException occurs.

testSetBlob

public void testSetBlob()
                 throws java.io.IOException,
                        java.sql.SQLException

Test the setBlob() method

Throws:

java.sql.SQLException - if a failure occurs during the call to setBlob

java.io.IOException

testSetBlobLengthless

public void testSetBlobLengthless()
                           throws java.io.IOException,
                                  java.sql.SQLException

Insert Blob without specifying length and read it back for verification.

Throws:

java.io.IOException

java.sql.SQLException

testSetPoolable

public void testSetPoolable()
                     throws java.sql.SQLException

Tests the PreparedStatement interface method setPoolable

Throws:

java.sql.SQLException

testSetPoolableOnClosed

public void testSetPoolableOnClosed()
                             throws java.sql.SQLException

Tests the PreparedStatement interface method setPoolable on a closed PreparedStatement

Throws:

java.sql.SQLException

testIsPoolableDefault

public void testIsPoolableDefault()
                           throws java.sql.SQLException

Tests the PreparedStatement interface method isPoolable

Throws:

java.sql.SQLException

cpTestIsPoolableHintFalse

public void cpTestIsPoolableHintFalse()
                               throws java.sql.SQLException

Tests that the isPoolable-hint works by exploiting the fact that the client cannot prepare a statement referring to a deleted table (unless the statement is already in the statement cache).

Throws:

java.sql.SQLException - if something goes wrong...

cpTestIsPoolableHintTrue

public void cpTestIsPoolableHintTrue()
                              throws java.sql.SQLException

Tests that the isPoolable-hint works by exploiting the fact that the client can prepare a statement referring to a deleted table if JDBC statement caching is enabled and the statement is already in the cache.

Throws:

java.sql.SQLException - if something goes wrong...

testIsPoolableOnClosed

public void testIsPoolableOnClosed()
                            throws java.sql.SQLException

Tests the PreparedStatement interface method isPoolable on closed PreparedStatement

Throws:

java.sql.SQLException

testSetCharacterStream

public void testSetCharacterStream()
                            throws java.lang.Exception

Tests the PreparedStatement interface method setCharacterStream

Throws:

java.sql.SQLException

java.lang.Exception

testSetCharacterStreamLengthless

public void testSetCharacterStreamLengthless()
                                      throws java.io.IOException,
                                             java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetAsciiStream

public void testSetAsciiStream()
                        throws java.lang.Exception

Tests the PreparedStatement interface method setAsciiStream

Throws:

java.sql.SQLException

java.lang.Exception

testSetAsciiStreamLengthless

public void testSetAsciiStreamLengthless()
                                  throws java.io.IOException,
                                         java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetBinaryStream

public void testSetBinaryStream()
                         throws java.lang.Exception

Tests the PreparedStatement interface method setBinaryStream

Throws:

java.sql.SQLException

java.lang.Exception

testSetBinaryStreamLengthless

public void testSetBinaryStreamLengthless()
                                   throws java.io.IOException,
                                          java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetBinaryStreamLengthLess1KOnBlob

public void testSetBinaryStreamLengthLess1KOnBlob()
                                           throws java.io.IOException,
                                                  java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetBinaryStreamLengthLess32KOnBlob

public void testSetBinaryStreamLengthLess32KOnBlob()
                                            throws java.io.IOException,
                                                   java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetBinaryStreamLengthLess65KOnBlob

public void testSetBinaryStreamLengthLess65KOnBlob()
                                            throws java.io.IOException,
                                                   java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetBinaryStreamLengthLessOnBlobTooLong

public void testSetBinaryStreamLengthLessOnBlobTooLong()

testExceptionPathOnePage_bs

public void testExceptionPathOnePage_bs()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testExceptionPathMultiplePages_bs

public void testExceptionPathMultiplePages_bs()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testBlobExceptionDoesNotRollbackOtherStatements

public void testBlobExceptionDoesNotRollbackOtherStatements()
                                                     throws java.io.IOException,
                                                            java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetAsciiStreamLengthLess1KOnClob

public void testSetAsciiStreamLengthLess1KOnClob()
                                          throws java.io.IOException,
                                                 java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetAsciiStreamLengthLess32KOnClob

public void testSetAsciiStreamLengthLess32KOnClob()
                                           throws java.io.IOException,
                                                  java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetAsciiStreamLengthLess65KOnClob

public void testSetAsciiStreamLengthLess65KOnClob()
                                           throws java.io.IOException,
                                                  java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

testSetAsciiStreamLengthLessOnClobTooLong

public void testSetAsciiStreamLengthLessOnClobTooLong()

testSetAsciiStreamLengthLessOnClobTooLongTruncate

public void testSetAsciiStreamLengthLessOnClobTooLongTruncate()
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetAsciiStreamLengthlessOnLongVarCharTooLong

public void testSetAsciiStreamLengthlessOnLongVarCharTooLong()

testSetAsciiStreamLengthlessOnLongVarCharDontTruncate

public void testSetAsciiStreamLengthlessOnLongVarCharDontTruncate()

testLargeUpdate_jdbc4_2

public void testLargeUpdate_jdbc4_2()
                             throws java.lang.Exception

Test the large update methods added by JDBC 4.2.

Throws:

java.lang.Exception

largeUpdate_jdbc4_2

public static void largeUpdate_jdbc4_2(java.sql.Connection conn)
                                throws java.lang.Exception

Throws:

java.lang.Exception

largeUpdateTest

private static void largeUpdateTest(java.sql.Statement stmt,
                                    PreparedStatementTest.PreparedStatementWrapper psw,
                                    long rowCountBase)
                             throws java.lang.Exception

Throws:

java.lang.Exception

setBinaryStreamOnBlob

private void setBinaryStreamOnBlob(int id,
                                   int actualLength,
                                   int specifiedLength,
                                   int trailingBlanks,
                                   boolean lengthLess)
                            throws java.sql.SQLException

Insert data into a Blob column with setBinaryStream.

Parameters:

id - unique id for inserted row

actualLength - the actual length of the stream

specifiedLength - the specified length of the stream

trailingBlanks - number of characters at the end that is blank

lengthLess - whether to use the length less overloads or not

Throws:

java.sql.SQLException

setAsciiStream

private void setAsciiStream(java.sql.PreparedStatement ps,
                            int id,
                            int actualLength,
                            int specifiedLength,
                            int trailingBlanks,
                            boolean lengthLess)
                     throws java.sql.SQLException

Insert data into a column with setAsciiStream. The prepared statement passed must have two positional parameters; one int and one more. Depending on the last parameter, the execute might succeed or it might fail. This is intended behavior, and should be handled by the caller. For instance, calling this method on an INT-column would fail, calling it on a CLOB-column would succeed.

Parameters:

id - unique id for inserted row

actualLength - the actual length of the stream

specifiedLength - the specified length of the stream

trailingBlanks - number of characters at the end that is blank

lengthLess - whether to use the length less overloads or not

Throws:

java.sql.SQLException

requestKey

private static int requestKey()

Get next key to id inserted data with.

assertInternalDerbyIOExceptionState

private void assertInternalDerbyIOExceptionState(java.lang.String preSQLState,
                                                 java.lang.String expectedInternal,
                                                 java.sql.SQLException sqle)

This methods is not to be used, but sometimes you have to!

Parameters:

preSQLState - the expected outer SQL state

expectedInternal - the expected internal SQL state

sqle - the outer SQLException