testsuite.simple

Class ResultSetTest

java.lang.Object

testsuite.BaseTestCase

testsuite.simple.ResultSetTest

public class ResultSetTest
extends BaseTestCase

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields inherited from class testsuite.BaseTestCase

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

Constructor Summary

Constructors

Constructor and Description
ResultSetTest()

Method Summary

Modifier and Type	Method and Description
private void	testDateTimeRetrieval_internal(java.sql.Connection c)
void	testDateTimeRetrieval() Date and time retrieval tests with and without ssps.
void	testNonUpdResultSetUpdateObject() Test for ResultSet.updateObject(), non-updatable ResultSet behavior.
void	testPadding()
private void	testPaddingForConnection(java.sql.Connection paddedConn, int numChars, java.lang.StringBuilder selectBuf)
void	testUpdateForReadOnlyResultSet() Test exceptions thrown when trying to update a read-only result set.
void	testUpdResultSetUpdateObjectAndNewSupportedTypes() Test for (Updatable)ResultSet.[update|get]Object().
void	testUpdResultSetUpdateObjectAndNewUnsupportedTypes() Test for (Updatable)ResultSet.updateObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.
void	testWarningOnTimestampTruncation()

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

Constructor Detail

ResultSetTest

public ResultSetTest()

Method Detail

testPadding

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

Throws:

java.lang.Exception

testPaddingForConnection

@Test
private void testPaddingForConnection(java.sql.Connection paddedConn,
                                            int numChars,
                                            java.lang.StringBuilder selectBuf)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testWarningOnTimestampTruncation

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

Throws:

java.sql.SQLException

testDateTimeRetrieval

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

Date and time retrieval tests with and without ssps.

Throws:

java.lang.Exception

testDateTimeRetrieval_internal

@Test
private void testDateTimeRetrieval_internal(java.sql.Connection c)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

testNonUpdResultSetUpdateObject

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

Test for ResultSet.updateObject(), non-updatable ResultSet behavior.

Throws:

java.lang.Exception

testUpdResultSetUpdateObjectAndNewSupportedTypes

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

Test for (Updatable)ResultSet.[update|get]Object(). Note: ResultSet.getObject() is covered in methods TestJDBC42Statemet.validateTestData[Local|Offset]DTTypes.

Throws:

java.lang.Exception

testUpdResultSetUpdateObjectAndNewUnsupportedTypes

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

Test for (Updatable)ResultSet.updateObject(), unsupported SQL types TIME_WITH_TIMEZONE, TIMESTAMP_WITH_TIMEZONE and REF_CURSOR.

Throws:

java.sql.SQLException

testUpdateForReadOnlyResultSet

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

Test exceptions thrown when trying to update a read-only result set.

Throws:

java.sql.SQLException