testsuite.simple

Class StatementsTest

java.lang.Object

testsuite.BaseTestCase

testsuite.simple.StatementsTest

public class StatementsTest
extends BaseTestCase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	StatementsTest.QueryInfoQueryInterceptor

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	testDateString
private java.lang.String	testDateTimeString
private java.lang.String	testISODateTimeString
private java.time.LocalDate	testLocalDate
private java.time.LocalDateTime	testLocalDateTime
private java.time.LocalTime	testLocalTime
private java.time.OffsetDateTime	testOffsetDateTime
private java.time.OffsetTime	testOffsetTime
private java.sql.Date	testSqlDate
private java.sql.Time	testSqlTime
private java.sql.Timestamp	testSqlTimeStamp
private java.lang.String	testTimeString
private java.time.ZonedDateTime	testZonedDateTime

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
StatementsTest()

Method Summary

Modifier and Type	Method and Description
private void	checkUnsupportedTypesBehavior(java.sql.PreparedStatement prepStmt) Helper method for *SetObject* tests.
private int	insertTestDataLocalDTTypes(java.sql.PreparedStatement prepStmt) Helper method for *SetObject* tests.
private int	insertTestDataOffsetDTTypes(java.sql.PreparedStatement prepStmt) Helper method for *SetObject* tests.
void	testAccessorsAndMutators()
void	testAutoIncrement()
void	testBatchRewriteErrors()
void	testBinaryResultSetNumericTypes() Tests all variants of numerical types (signed/unsigned) for correct operation when used as return values from a prepared statement.
private void	testBinaryResultSetNumericTypesInternal(java.sql.Connection con)
void	testCallableStatement() Tests stored procedure functionality
void	testCallStmtExecuteLargeBatch() Test for CallableStatement.executeLargeBatch().
void	testCallStmtExecuteLargeUpdate() Test for CallableStatement.executeLargeUpdate().
void	testCallStmtRegisterOutParameter() Test for CallableStatement.registerOutParameter().
void	testCallStmtRegisterOutParameterNewUnsupportedTypes() Test for CallableStatement.registerOutParameter(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.
void	testCallStmtRegisterOutParameterWithMysqlType() Test for CallableStatement.registerOutParameter(...MysqlType...).
void	testCallStmtSetObjectAndNewSupportedTypes() Test for CallableStatement.setObject().
void	testCallStmtSetObjectAndNewUnsupportedTypes() Test for CallableStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.
void	testCancelStatement()
void	testClose()
void	testEnableStreamingResults()
void	testGetNCharacterStream() Tests for ResultSet.getNCharacterStream()
void	testGetNClob() Tests for ResultSet.getNClob()
void	testGetNString() Tests for ResultSet.getNString()
void	testHoldingResultSetsOverClose()
void	testInsert()
void	testJdbc4LoadBalancing()
void	testLocalInfileHooked()
void	testMultiStatements() Tests multiple statement support
void	testNulls() Tests that NULLs and '' work correctly.
void	testParameterBindings()
void	testParsedConversionWarning()
void	testPreparedStatement()
void	testPreparedStatementBatch()
void	testPrepStmtExecuteLargeBatch() Test for PreparedStatement.executeLargeBatch().
void	testPrepStmtExecuteLargeUpdateExplicitGeneratedKeys() Test for PreparedStatement.executeLargeUpdate().
void	testPrepStmtExecuteLargeUpdateNoGeneratedKeys() Test for PreparedStatement.executeLargeUpdate().
void	testPrepStmtSetObjectAndNewSupportedTypes() Test for PreparedStatement.setObject().
void	testPrepStmtSetObjectAndNewUnsupportedTypes() Test for PreparedStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.
void	testQueryInfoParsingAndRewrittingInsertSetEroteme()
void	testQueryInfoParsingAndRewrittingInsertValuesEroteme()
void	testQueryInfoParsingAndRewrittingInsertValuesRowEroteme()
void	testQueryInfoParsingAndRewrittingInsertValuesStatic()
void	testQueryInfoParsingAndRewrittingLoadData()
void	testQueryInfoParsingAndRewrittingReplaceSetEroteme()
void	testQueryInfoParsingAndRewrittingReplaceValuesRowEroteme()
void	testQueryInfoParsingAndRewrittingReplaceVauesEroteme()
void	testQueryInfoParsingAndRewrittingSpecialCases()
void	testQueryInterceptors()
void	testReadOnlySafeStatements()
void	testResultSetProducingQueries()
void	testRowFetch()
void	testSelectColumns()
void	testServerPreparedStatementsCaching() WL#11101 - Remove de-cache and close of SSPSs on double call to close()
void	testServerPrepStmtExecuteLargeBatch() Test for (Server)PreparedStatement.executeLargeBatch().
void	testServPrepStmtSetObjectAndNewSupportedTypes() Test for (Server)PreparedStatement.setObject().
void	testServPrepStmtSetObjectAndNewUnsupportedTypes() Test for (Server)PreparedStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.
void	testSetNCharacterStream() Tests for PreparedStatement.setNCharacterSteam()
void	testSetNCharacterStreamServer() Tests for ServerPreparedStatement.setNCharacterSteam()
void	testSetNClob() Tests for PreparedStatement.setNClob()
void	testSetNClobServer() Tests for ServerPreparedStatement.setNClob()
void	testSetNString() Tests for PreparedStatement.setNString()
void	testSetNStringServer() Tests for ServerPreparedStatement.setNString()
void	testSetObject() Tests for PreparedStatement.setObject()
void	testSetObjectWithMysqlType() Tests for PreparedStatement.setObject(...SQLType...)
void	testSharedTestData() Test shared test data validity.
void	testStatementRewriteBatch()
void	testStmtExecuteLargeBatch() Test for Statement.executeLargeBatch().
void	testStmtExecuteLargeUpdate() Test for Statement.executeLargeUpdate(String, _).
void	testStmtExecuteLargeUpdateNoGeneratedKeys() Test for Statement.executeLargeUpdate(String).
void	testStmtGetSetLargeMaxRows() Test for Statement.[get/set]LargeMaxRows().
void	testStreamChange()
void	testStubbed()
void	testTruncationOnRead()
void	testUpdateNCharacterStream() Tests for ResultSet.updateNCharacterStream()
void	testUpdateNClob() Tests for ResultSet.updateNClob()
void	testUpdateNString() Tests for ResultSet.updateNString()
private void	validateTestDataLocalDTTypes(java.lang.String tableName, int expectedRowCount) Helper method for *SetObject* tests.
private void	validateTestDataOffsetDTTypes(java.lang.String tableName, int expectedRowCount) Helper method for *SetObject* tests.

Methods inherited from class testsuite.BaseTestCase

appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object

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

Field Detail

testDateString

private final java.lang.String testDateString

See Also:

Constant Field Values

testTimeString

private final java.lang.String testTimeString

See Also:

Constant Field Values

testDateTimeString

private final java.lang.String testDateTimeString

testISODateTimeString

private final java.lang.String testISODateTimeString

testSqlDate

private final java.sql.Date testSqlDate

testSqlTime

private final java.sql.Time testSqlTime

testSqlTimeStamp

private final java.sql.Timestamp testSqlTimeStamp

testLocalDate

private final java.time.LocalDate testLocalDate

testLocalTime

private final java.time.LocalTime testLocalTime

testLocalDateTime

private final java.time.LocalDateTime testLocalDateTime

testOffsetDateTime

private final java.time.OffsetDateTime testOffsetDateTime

testOffsetTime

private final java.time.OffsetTime testOffsetTime

testZonedDateTime

private final java.time.ZonedDateTime testZonedDateTime

Constructor Detail

StatementsTest

public StatementsTest()

Method Detail

testAccessorsAndMutators

@Test
public void testAccessorsAndMutators()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testAutoIncrement

@Test
public void testAutoIncrement()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

testBinaryResultSetNumericTypes

@Test
public void testBinaryResultSetNumericTypes()
                                           throws java.lang.Exception

Tests all variants of numerical types (signed/unsigned) for correct operation when used as return values from a prepared statement.

Throws:

java.lang.Exception

testBinaryResultSetNumericTypesInternal

@Test
private void testBinaryResultSetNumericTypesInternal(java.sql.Connection con)
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

testCallableStatement

@Test
public void testCallableStatement()
                                 throws java.lang.Exception

Tests stored procedure functionality

Throws:

java.lang.Exception

testCancelStatement

@Test
public void testCancelStatement()
                               throws java.lang.Exception

Throws:

java.lang.Exception

testClose

@Test
public void testClose()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testEnableStreamingResults

@Test
public void testEnableStreamingResults()
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testHoldingResultSetsOverClose

@Test
public void testHoldingResultSetsOverClose()
                                          throws java.lang.Exception

Throws:

java.lang.Exception

testInsert

@Test
public void testInsert()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testMultiStatements

@Test
public void testMultiStatements()
                               throws java.lang.Exception

Tests multiple statement support

Throws:

java.lang.Exception

testNulls

@Test
public void testNulls()
                     throws java.sql.SQLException

Tests that NULLs and '' work correctly.

Throws:

java.sql.SQLException

testParsedConversionWarning

@Test
public void testParsedConversionWarning()
                                       throws java.lang.Exception

Throws:

java.lang.Exception

testPreparedStatement

@Test
public void testPreparedStatement()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testPreparedStatementBatch

@Test
public void testPreparedStatementBatch()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

testRowFetch

@Test
public void testRowFetch()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testSelectColumns

@Test
public void testSelectColumns()
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

testSetObject

@Test
public void testSetObject()
                         throws java.lang.Exception

Tests for PreparedStatement.setObject()

Throws:

java.lang.Exception

testSetObjectWithMysqlType

@Test
public void testSetObjectWithMysqlType()
                                      throws java.lang.Exception

Tests for PreparedStatement.setObject(...SQLType...)

Throws:

java.lang.Exception

testStatementRewriteBatch

@Test
public void testStatementRewriteBatch()
                                     throws java.lang.Exception

Throws:

java.lang.Exception

testBatchRewriteErrors

@Test
public void testBatchRewriteErrors()
                                  throws java.lang.Exception

Throws:

java.lang.Exception

testStreamChange

@Test
public void testStreamChange()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testStubbed

@Test
public void testStubbed()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testTruncationOnRead

@Test
public void testTruncationOnRead()
                                throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInterceptors

@Test
public void testQueryInterceptors()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testParameterBindings

@Test
public void testParameterBindings()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testLocalInfileHooked

@Test
public void testLocalInfileHooked()
                                 throws java.lang.Exception

Throws:

java.lang.Exception

testGetNCharacterStream

@Test
public void testGetNCharacterStream()
                                   throws java.lang.Exception

Tests for ResultSet.getNCharacterStream()

Throws:

java.lang.Exception

testGetNClob

@Test
public void testGetNClob()
                        throws java.lang.Exception

Tests for ResultSet.getNClob()

Throws:

java.lang.Exception

testGetNString

@Test
public void testGetNString()
                          throws java.lang.Exception

Tests for ResultSet.getNString()

Throws:

java.lang.Exception

testSetNCharacterStream

@Test
public void testSetNCharacterStream()
                                   throws java.lang.Exception

Tests for PreparedStatement.setNCharacterSteam()

Throws:

java.lang.Exception

testSetNCharacterStreamServer

@Test
public void testSetNCharacterStreamServer()
                                         throws java.lang.Exception

Tests for ServerPreparedStatement.setNCharacterSteam()

Throws:

java.lang.Exception

testSetNClob

@Test
public void testSetNClob()
                        throws java.lang.Exception

Tests for PreparedStatement.setNClob()

Throws:

java.lang.Exception

testSetNClobServer

@Test
public void testSetNClobServer()
                              throws java.lang.Exception

Tests for ServerPreparedStatement.setNClob()

Throws:

java.lang.Exception

testSetNString

@Test
public void testSetNString()
                          throws java.lang.Exception

Tests for PreparedStatement.setNString()

Throws:

java.lang.Exception

testSetNStringServer

@Test
public void testSetNStringServer()
                                throws java.lang.Exception

Tests for ServerPreparedStatement.setNString()

Throws:

java.lang.Exception

testUpdateNCharacterStream

@Test
public void testUpdateNCharacterStream()
                                      throws java.lang.Exception

Tests for ResultSet.updateNCharacterStream()

Throws:

java.lang.Exception

testUpdateNClob

@Test
public void testUpdateNClob()
                           throws java.lang.Exception

Tests for ResultSet.updateNClob()

Throws:

java.lang.Exception

testUpdateNString

@Test
public void testUpdateNString()
                             throws java.lang.Exception

Tests for ResultSet.updateNString()

Throws:

java.lang.Exception

testJdbc4LoadBalancing

@Test
public void testJdbc4LoadBalancing()
                                  throws java.lang.Exception

Throws:

java.lang.Exception

testSharedTestData

@Test
public void testSharedTestData()
                              throws java.lang.Exception

Test shared test data validity.

Throws:

java.lang.Exception

testStmtExecuteLargeBatch

@Test
public void testStmtExecuteLargeBatch()
                                     throws java.lang.Exception

Test for Statement.executeLargeBatch(). Validate update count returned and generated keys.

Throws:

java.lang.Exception

testStmtExecuteLargeUpdateNoGeneratedKeys

@Test
public void testStmtExecuteLargeUpdateNoGeneratedKeys()
                                                     throws java.lang.Exception

Test for Statement.executeLargeUpdate(String). Validate update count returned and generated keys. Case: without requesting generated keys.

Throws:

java.lang.Exception

testStmtExecuteLargeUpdate

@Test
public void testStmtExecuteLargeUpdate()
                                      throws java.lang.Exception

Test for Statement.executeLargeUpdate(String, _). Validate update count returned and generated keys. Case 1: explicitly requesting generated keys. Case 2: requesting generated keys by defining column indexes. Case 3: requesting generated keys by defining column names.

Throws:

java.lang.Exception

testPrepStmtExecuteLargeBatch

@Test
public void testPrepStmtExecuteLargeBatch()
                                         throws java.lang.Exception

Test for PreparedStatement.executeLargeBatch(). Validate update count returned and generated keys.

Throws:

java.lang.Exception

testPrepStmtExecuteLargeUpdateNoGeneratedKeys

@Test
public void testPrepStmtExecuteLargeUpdateNoGeneratedKeys()
                                                         throws java.lang.Exception

Test for PreparedStatement.executeLargeUpdate(). Validate update count returned and generated keys. Case: without requesting generated keys.

Throws:

java.lang.Exception

testPrepStmtExecuteLargeUpdateExplicitGeneratedKeys

@Test
public void testPrepStmtExecuteLargeUpdateExplicitGeneratedKeys()
                                                               throws java.lang.Exception

Test for PreparedStatement.executeLargeUpdate(). Validate update count returned and generated keys. Case: explicitly requesting generated keys.

Throws:

java.lang.Exception

testCallStmtExecuteLargeBatch

@Test
public void testCallStmtExecuteLargeBatch()
                                         throws java.lang.Exception

Test for CallableStatement.executeLargeBatch(). Validate update count returned and generated keys.

Throws:

java.lang.Exception

testCallStmtExecuteLargeUpdate

@Test
public void testCallStmtExecuteLargeUpdate()
                                          throws java.lang.Exception

Test for CallableStatement.executeLargeUpdate(). Validate update count returned and generated keys.

Throws:

java.lang.Exception

testServerPrepStmtExecuteLargeBatch

@Test
public void testServerPrepStmtExecuteLargeBatch()
                                               throws java.lang.Exception

Test for (Server)PreparedStatement.executeLargeBatch(). Validate update count returned and generated keys.

Throws:

java.lang.Exception

testStmtGetSetLargeMaxRows

@Test
public void testStmtGetSetLargeMaxRows()
                                      throws java.lang.Exception

Test for Statement.[get/set]LargeMaxRows().

Throws:

java.lang.Exception

testPrepStmtSetObjectAndNewSupportedTypes

@Test
public void testPrepStmtSetObjectAndNewSupportedTypes()
                                                     throws java.lang.Exception

Test for PreparedStatement.setObject(). Validate new methods as well as support for the types java.time.Local[Date][Time] and java.time.Offset[Date]Time.

Throws:

java.lang.Exception

testPrepStmtSetObjectAndNewUnsupportedTypes

@Test
public void testPrepStmtSetObjectAndNewUnsupportedTypes()
                                                       throws java.lang.Exception

Test for PreparedStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.

Throws:

java.lang.Exception

testCallStmtSetObjectAndNewSupportedTypes

@Test
public void testCallStmtSetObjectAndNewSupportedTypes()
                                                     throws java.lang.Exception

Test for CallableStatement.setObject(). Validate new methods as well as support for the types java.time.Local[Date][Time] and java.time.Offset[Date]Time.

Throws:

java.lang.Exception

testCallStmtSetObjectAndNewUnsupportedTypes

@Test
public void testCallStmtSetObjectAndNewUnsupportedTypes()
                                                       throws java.lang.Exception

Test for CallableStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.

Throws:

java.lang.Exception

testServPrepStmtSetObjectAndNewSupportedTypes

@Test
public void testServPrepStmtSetObjectAndNewSupportedTypes()
                                                         throws java.lang.Exception

Test for (Server)PreparedStatement.setObject(). Validate new methods as well as support for the types java.time.Local[Date][Time] and java.time.Offset[Date]Time.

Throws:

java.lang.Exception

testServPrepStmtSetObjectAndNewUnsupportedTypes

@Test
public void testServPrepStmtSetObjectAndNewUnsupportedTypes()
                                                           throws java.lang.Exception

Test for (Server)PreparedStatement.setObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.

Throws:

java.lang.Exception

insertTestDataLocalDTTypes

private int insertTestDataLocalDTTypes(java.sql.PreparedStatement prepStmt)
                                throws java.lang.Exception

Helper method for *SetObject* tests. Insert data into the given PreparedStatement, or any of its subclasses, with the following structure: 1 - `id` INT 2 - `d` DATE (or any kind of *CHAR) 3 - `t` TIME (or any kind of *CHAR) 4 - `dt` DATETIME (or any kind of *CHAR) 5 - `ts` TIMESTAMP (or any kind of *CHAR)

Parameters:

prepStmt -

Returns:

the row count of inserted records.

Throws:

java.lang.Exception

validateTestDataLocalDTTypes

private void validateTestDataLocalDTTypes(java.lang.String tableName,
                                          int expectedRowCount)
                                   throws java.lang.Exception

Helper method for *SetObject* tests. Validate the test data contained in the given ResultSet with following structure: 1 - `id` INT 2 - `d` DATE (or any kind of *CHAR) 3 - `t` TIME (or any kind of *CHAR) 4 - `dt` DATETIME (or any kind of *CHAR) 5 - `ts` TIMESTAMP (or any kind of *CHAR) Additionally validate support for the types java.time.Local[Date][Time] in ResultSet.getObject().

Parameters:

tableName -

expectedRowCount -

Throws:

java.lang.Exception

insertTestDataOffsetDTTypes

private int insertTestDataOffsetDTTypes(java.sql.PreparedStatement prepStmt)
                                 throws java.lang.Exception

Helper method for *SetObject* tests. Insert data into the given PreparedStatement, or any of its subclasses, with the following structure: 1 - `id` INT 2 - `ot1` VARCHAR 3 - `ot2` BLOB 4 - `odt1` VARCHAR 5 - `odt2` BLOB

Parameters:

prepStmt -

Returns:

the row count of inserted records.

Throws:

java.lang.Exception

validateTestDataOffsetDTTypes

private void validateTestDataOffsetDTTypes(java.lang.String tableName,
                                           int expectedRowCount)
                                    throws java.lang.Exception

Helper method for *SetObject* tests. Validate the test data contained in the given ResultSet with following structure: 1 - `id` INT 2 - `ot1` VARCHAR 3 - `ot2` BLOB 4 - `odt1` VARCHAR 5 - `odt2` BLOB Additionally validate support for the types java.time.Offset[Date]Time in ResultSet.getObject().

Parameters:

tableName -

expectedRowCount -

Throws:

java.lang.Exception

checkUnsupportedTypesBehavior

private void checkUnsupportedTypesBehavior(java.sql.PreparedStatement prepStmt)

Helper method for *SetObject* tests. Check unsupported types behavior for the given PreparedStatement with a single placeholder. If this is a CallableStatement then the placeholder must coincide with a parameter named `param`.

Parameters:

prepStmt -

testCallStmtRegisterOutParameter

@Test
public void testCallStmtRegisterOutParameter()
                                            throws java.lang.Exception

Test for CallableStatement.registerOutParameter().

Throws:

java.lang.Exception

testCallStmtRegisterOutParameterWithMysqlType

@Test
public void testCallStmtRegisterOutParameterWithMysqlType()
                                                         throws java.lang.Exception

Test for CallableStatement.registerOutParameter(...MysqlType...).

Throws:

java.lang.Exception

testCallStmtRegisterOutParameterNewUnsupportedTypes

@Test
public void testCallStmtRegisterOutParameterNewUnsupportedTypes()
                                                               throws java.lang.Exception

Test for CallableStatement.registerOutParameter(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.

Throws:

java.lang.Exception

testServerPreparedStatementsCaching

@Test
public void testServerPreparedStatementsCaching()
                                               throws java.lang.Exception

WL#11101 - Remove de-cache and close of SSPSs on double call to close()

Throws:

java.lang.Exception

testResultSetProducingQueries

@Test
public void testResultSetProducingQueries()
                                         throws java.lang.Exception

Throws:

java.lang.Exception

testReadOnlySafeStatements

@Test
public void testReadOnlySafeStatements()
                                      throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingLoadData

@Test
public void testQueryInfoParsingAndRewrittingLoadData()
                                                     throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingInsertValuesStatic

@Test
public void testQueryInfoParsingAndRewrittingInsertValuesStatic()
                                                               throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingInsertValuesEroteme

@Test
public void testQueryInfoParsingAndRewrittingInsertValuesEroteme()
                                                                throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingInsertValuesRowEroteme

@Test
public void testQueryInfoParsingAndRewrittingInsertValuesRowEroteme()
                                                                   throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingInsertSetEroteme

@Test
public void testQueryInfoParsingAndRewrittingInsertSetEroteme()
                                                             throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingReplaceVauesEroteme

@Test
public void testQueryInfoParsingAndRewrittingReplaceVauesEroteme()
                                                                throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingReplaceValuesRowEroteme

@Test
public void testQueryInfoParsingAndRewrittingReplaceValuesRowEroteme()
                                                                    throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingReplaceSetEroteme

@Test
public void testQueryInfoParsingAndRewrittingReplaceSetEroteme()
                                                              throws java.lang.Exception

Throws:

java.lang.Exception

testQueryInfoParsingAndRewrittingSpecialCases

@Test
public void testQueryInfoParsingAndRewrittingSpecialCases()
                                                         throws java.lang.Exception

Throws:

java.lang.Exception