org.apache.derbyTesting.functionTests.tests.jdbc4

Class CallableStatementTest

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.Wrapper41Test

org.apache.derbyTesting.functionTests.tests.jdbc4.CallableStatementTest

All Implemented Interfaces:

junit.framework.Test

public class CallableStatementTest
extends Wrapper41Test

Tests of the java.sql.CallableStatement JDBC40 API.

Field Summary

Fields

Modifier and Type	Field and Description
private static boolean	_nullOutArgs
private java.sql.CallableStatement	cStmt Default callable statement used by the tests.

Fields inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test

BINARY_VALUE, TIME_VALUE, TIMESTAMP_VALUE

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static void	allTypesProc(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.lang.Double[] doublearg, java.lang.Double[] floatarg, java.lang.Integer[] intarg, java.lang.String[] longvarchararg, byte[][] longvarcharforbitdataarg, java.math.BigDecimal[] numericarg, java.lang.Float[] realarg, java.lang.Integer[] smallintarg, java.sql.Time[] timearg, java.sql.Timestamp[] timestamparg, java.lang.String[] varchararg, byte[][] varcharforbitdataarg) Procedure used by jdbc 4.1 tests.
private static junit.framework.Test	baseSuite(java.lang.String name)
static void	blobProc(java.sql.Blob[] blobarg)
static void	clobProc(java.sql.Clob[] clobarg)
protected void	setUp() Create a default callable statement and connection.
static junit.framework.Test	suite() Return suite with all tests of the class.
protected void	tearDown() Close default callable statement and connection.
void	test_4959() Regression test for https://issues.apache.org/jira/browse/DERBY-4959, an NPE trying to return null LOBs as procedure output args.
void	testGetCharacterStreamIntOnInParameterOfInvalidType() Test which SQLState is thrown when getCharacterStream is called on an IN parameter of an unsupported type.
void	testGetCharacterStreamIntOnInParameterOfValidType() Test which SQLState is thrown when getCharacterStream is called on an IN parameter of a supported type.
void	testGetCharacterStreamIntOnInvalidTypeDOUBLE()
void	testGetCharacterStreamIntOnVARBINARYWithNull() Read a SQL NULL value from a VARBINARY column through a reader.
void	testGetCharacterStreamIntOnVARCHARWithNull() Read a SQL NULL value from a VARCHAR column through a reader.
void	testGetCharacterStreamIntVARBINARYDirect() Test basic use of getCharacterStream on binary data.
void	testGetCharacterStreamIntVARBINARYFromDb() Fetch a string stored as bytes from the database through a reader, then recreate the string.
void	testGetCharacterStreamIntVARCHAR() Test basic use of getCharacterStream on character data.
void	testGetCharacterStreamStringNotImplemented()
void	testGetDoubleIntOnInParameter()
void	testGetNCharacterStreamIntNotImplemented()
void	testGetNCharacterStreamStringNotImplemented()
void	testGetNClobIntNotImplemented()
void	testGetNClobStringNotImplemented()
void	testGetNStringIntNotImplemented()
void	testGetNStringStringNotImplemented()
void	testGetSQLXMLIntNotImplemented()
void	testGetSQLXMLStringNotImplemented()
void	testIsNotWrapperForResultSet()
void	testIsWrapperForCallableStatement()
void	testIsWrapperForPreparedStatement()
void	testIsWrapperForSelf()
void	testIsWrapperForStatement()
private void	testIsWrapperForXXXStatement(java.lang.Class klass) Helper method for testIsWrapperFor*Statement test cases.
void	testJDBC4_1() Test the JDBC 4.1 extensions.
void	testNamedParametersAreNotSupported()
void	testSetAsciiStream() Tests the setAsciiStream method that accepts length as a long parameter in the Callable Statement interface
void	testSetBinaryStream() Tests the setBinaryStream method that accepts length as a long parameter in the Callable Statement interface
void	testSetBlobNotImplemented()
void	testSetCharacterStream() Tests the setCharacterStream method that accepts length as a long parameter in the Callable Statement interface
void	testSetClobNotImplemented()
void	testSetNCharacterStreamNotImplemented()
void	testSetNClobNClobNotImplemented()
void	testSetNClobReaderNotImplemented()
void	testSetNStringNotImplemented()
void	testSetSQLXMLNotImplemented()
void	testUnwrapAsSelf()
void	testUnwrapCallableStatement()
void	testUnwrapPreparedStatement()
void	testUnwrapResultSet()
void	testUnwrapStatement()
private void	vetDataTypeCount(java.sql.Connection conn)

Methods inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test

examineJDBC4_1extensions, prepareCall, prepareStatement

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

cStmt

private java.sql.CallableStatement cStmt

Default callable statement used by the tests.

_nullOutArgs

private static boolean _nullOutArgs

Constructor Detail

CallableStatementTest

public CallableStatementTest(java.lang.String name)

Create a test with the given name.

Parameters:

name - name of the test.

Method Detail

setUp

protected void setUp()
              throws java.sql.SQLException

Create a default callable statement and connection.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException - if creation of connection or callable statement fail.

tearDown

protected void tearDown()
                 throws java.lang.Exception

Close default callable statement and connection.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.sql.SQLException - if closing of the connection or the callable statement fail.

java.lang.Exception

testNamedParametersAreNotSupported

public void testNamedParametersAreNotSupported()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetDoubleIntOnInParameter

public void testGetDoubleIntOnInParameter()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNClobIntNotImplemented

public void testGetNClobIntNotImplemented()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNClobStringNotImplemented

public void testGetNClobStringNotImplemented()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNStringIntNotImplemented

public void testGetNStringIntNotImplemented()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNStringStringNotImplemented

public void testGetNStringStringNotImplemented()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetCharacterStreamIntOnInvalidTypeDOUBLE

public void testGetCharacterStreamIntOnInvalidTypeDOUBLE()
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetCharacterStreamIntOnInParameterOfInvalidType

public void testGetCharacterStreamIntOnInParameterOfInvalidType()
                                                         throws java.sql.SQLException

Test which SQLState is thrown when getCharacterStream is called on an IN parameter of an unsupported type.

Throws:

java.sql.SQLException

testGetCharacterStreamIntOnInParameterOfValidType

public void testGetCharacterStreamIntOnInParameterOfValidType()
                                                       throws java.sql.SQLException

Test which SQLState is thrown when getCharacterStream is called on an IN parameter of a supported type.

Throws:

java.sql.SQLException

testGetCharacterStreamIntVARCHAR

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

Test basic use of getCharacterStream on character data. Create a CallableStatement that takes an integer as input and returns the number as a string. The string is read as a stream, and the integer is recreated from it and compared to the integer passed in.

Throws:

java.io.IOException

java.sql.SQLException

testGetCharacterStreamIntVARBINARYDirect

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

Test basic use of getCharacterStream on binary data. Create a CallableStatement that takes a string as input and returns a byte representation, which is then read through a stream. The string is recreated and compared to the one passed in. Note that strings must be represented in UTF-16BE for this to work.

Throws:

java.io.IOException

java.sql.SQLException

testGetCharacterStreamIntVARBINARYFromDb

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

Fetch a string stored as bytes from the database through a reader, then recreate the string.

Throws:

java.io.IOException

java.sql.SQLException

testGetCharacterStreamIntOnVARBINARYWithNull

public void testGetCharacterStreamIntOnVARBINARYWithNull()
                                                  throws java.sql.SQLException

Read a SQL NULL value from a VARBINARY column through a reader.

Throws:

java.sql.SQLException

testGetCharacterStreamIntOnVARCHARWithNull

public void testGetCharacterStreamIntOnVARCHARWithNull()
                                                throws java.sql.SQLException

Read a SQL NULL value from a VARCHAR column through a reader.

Throws:

java.sql.SQLException

testGetCharacterStreamStringNotImplemented

public void testGetCharacterStreamStringNotImplemented()
                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNCharacterStreamIntNotImplemented

public void testGetNCharacterStreamIntNotImplemented()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetNCharacterStreamStringNotImplemented

public void testGetNCharacterStreamStringNotImplemented()
                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetBlobNotImplemented

public void testSetBlobNotImplemented()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetClobNotImplemented

public void testSetClobNotImplemented()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNCharacterStreamNotImplemented

public void testSetNCharacterStreamNotImplemented()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNClobNClobNotImplemented

public void testSetNClobNClobNotImplemented()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNClobReaderNotImplemented

public void testSetNClobReaderNotImplemented()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetNStringNotImplemented

public void testSetNStringNotImplemented()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetSQLXMLIntNotImplemented

public void testGetSQLXMLIntNotImplemented()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetSQLXMLStringNotImplemented

public void testGetSQLXMLStringNotImplemented()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetSQLXMLNotImplemented

public void testSetSQLXMLNotImplemented()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForXXXStatement

private void testIsWrapperForXXXStatement(java.lang.Class klass)
                                   throws java.sql.SQLException

Helper method for testIsWrapperFor*Statement test cases.

Throws:

java.sql.SQLException

testIsWrapperForStatement

public void testIsWrapperForStatement()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForPreparedStatement

public void testIsWrapperForPreparedStatement()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForCallableStatement

public void testIsWrapperForCallableStatement()
                                       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

testUnwrapCallableStatement

public void testUnwrapCallableStatement()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapAsSelf

public void testUnwrapAsSelf()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapResultSet

public void testUnwrapResultSet()

testSetCharacterStream

public void testSetCharacterStream()
                            throws java.sql.SQLException

Tests the setCharacterStream method that accepts length as a long parameter in the Callable Statement interface

Throws:

java.sql.SQLException - Upon any error that occurs while calling this method

testSetAsciiStream

public void testSetAsciiStream()
                        throws java.sql.SQLException

Tests the setAsciiStream method that accepts length as a long parameter in the Callable Statement interface

Throws:

java.sql.SQLException - Upon any error that occurs while calling this method

testSetBinaryStream

public void testSetBinaryStream()
                         throws java.sql.SQLException

Tests the setBinaryStream method that accepts length as a long parameter in the Callable Statement interface

Throws:

java.sql.SQLException - Upon any error that occurs while calling this method

testJDBC4_1

public void testJDBC4_1()
                 throws java.lang.Exception

Test the JDBC 4.1 extensions.

Throws:

java.lang.Exception

vetDataTypeCount

private void vetDataTypeCount(java.sql.Connection conn)
                       throws java.lang.Exception

Throws:

java.lang.Exception

test_4959

public void test_4959()
               throws java.lang.Exception

Regression test for https://issues.apache.org/jira/browse/DERBY-4959, an NPE trying to return null LOBs as procedure output args.

Throws:

java.lang.Exception

allTypesProc

public static void allTypesProc(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.lang.Double[] doublearg,
                                java.lang.Double[] floatarg,
                                java.lang.Integer[] intarg,
                                java.lang.String[] longvarchararg,
                                byte[][] longvarcharforbitdataarg,
                                java.math.BigDecimal[] numericarg,
                                java.lang.Float[] realarg,
                                java.lang.Integer[] smallintarg,
                                java.sql.Time[] timearg,
                                java.sql.Timestamp[] timestamparg,
                                java.lang.String[] varchararg,
                                byte[][] varcharforbitdataarg)
                         throws java.lang.Exception

Procedure used by jdbc 4.1 tests.

Throws:

java.lang.Exception

blobProc

public static void blobProc(java.sql.Blob[] blobarg)
                     throws java.lang.Exception

Throws:

java.lang.Exception

clobProc

public static void clobProc(java.sql.Clob[] clobarg)
                     throws java.lang.Exception

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()

Return suite with all tests of the class.

baseSuite

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