ConnectionTest

java.lang.Object
- testsuite.BaseTestCase
- - testsuite.simple.ConnectionTest

public class ConnectionTest
extends BaseTestCase

Tests java.sql.Connection functionality

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`(package private) class`	`ConnectionTest.LocalSocketAddressCheckThread`
`(package private) class`	`ConnectionTest.SpawnedWorkerCounter`
`static class`	`ConnectionTest.TestEnableEscapeProcessingQueryInterceptor`

Nested classes/interfaces inherited from class testsuite.BaseTestCase
BaseTestCase.MockConnectionConfiguration

Field Summary

Fields
Modifier and Type Field and Description

private java.lang.String sslFreeBaseUrl
- Fields inherited from class testsuite.BaseTestCase
  conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Fields
Modifier and Type	Field and Description
`private java.lang.String`	`sslFreeBaseUrl`

Constructor Summary

Constructors
Constructor and Description

ConnectionTest()

Constructors
Constructor and Description
`ConnectionTest()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private void`	`checkInterfaceImplemented(java.lang.reflect.Method[] interfaceMethods, java.lang.Class<?> implementingClass, java.lang.Object invokeOn)`
`void`	`setupSecureSessionTest()`
`void`	`teardownConnectionTest()`
`void`	`testAllowLoadLocalInfileInPath()` Tests "LOAD DATA LOCAL INFILE" statements when enabled but restricted to a specific path, by specifying a path in the connection property 'allowLoadLocalInfileInPath'.
`private void`	`testAllowLoadLocalInfileInPathCheckAndDelete()`
`void`	`testCannedConfigs()`
`void`	`testCatalog()` Tests catalog functionality
`void`	`testClusterConnection()` Tests a cluster connection for failover, requires a two-node cluster URL specified in com.mysql.jdbc.testsuite.ClusterUrl system property.
`void`	`testCompression()`
`private void`	`testCompressionWith(java.lang.String useCompression, int maxPayloadSize)`
`void`	`testConnectionPropertiesTransform()` Tests functionality of the ConnectionPropertiesTransform interface.
`void`	`testCouplingOfCursorFetch()` Checks if setting useCursorFetch to "true" automatically enables server-side prepared statements.
`void`	`testCreateDatabaseIfNotExist()`
`void`	`testDeadlockDetection()` Old test was passing due to http://bugs.mysql.com/bug.php?id=989 which is fixed for 5.5+
`void`	`testDecoratorsChain()`
`void`	`testDontTrackOpenResources()` Checks implementation of 'dontTrackOpenResources' property.
`void`	`testDriverAcceptsURLNullArgument()` Test for Driver.acceptsURL() behavior clarification: - acceptsURL() throws SQLException if URL is null.
`void`	`testDriverConnectNullArgument()` Test for Driver.connect() behavior clarifications: - connect() throws SQLException if URL is null.
`void`	`testDriverConnectPropertiesPrecedence()` Test for Driver.connect() behavior clarifications: - connect() properties precedence is implementation-defined.
`void`	`testDumpQueriesOnException()`
`void`	`testEnableEscapeProcessing()` Test the new connection property 'enableEscapeProcessing', as well as the old connection property 'processEscapeCodesForPrepStmts' and interrelation between them.
`void`	`testFailoverConnection()` Tests whether re-connect with non-read-only connection can happen.
`void`	`testFallbackToSystemKeyStore()` Tests connection property 'testFallbackToSystemKeyStore' behavior.
`void`	`testFallbackToSystemTrustStore()` Tests connection property 'testFallbackToSystemTrustStore' behavior.
`void`	`testGatherPerfMetrics()` Tests if gatherPerfMetrics works.
`void`	`testInterfaceImplementation()`
`private void`	`testInterfaceImplementation(java.sql.Connection connToCheck)`
`void`	`testIPv6()` IPv6 Connection test.
`void`	`testIsLocal()`
`void`	`testIsolationLevel()` Tests isolation level functionality
`void`	`testLifecyleInterceptor()`
`void`	`testLocalInfileDisabled()`
`void`	`testLocalInfileWithUrl()` Tests functionality of using URLs in 'LOAD DATA LOCAL INFILE' statements.
`void`	`testLocalSocketAddress()` Tests feature of "localSocketAddress", by enumerating local IF's and trying each one in turn.
`void`	`testNewHostParsing()`
`void`	`testNonVerifyServerCert()`
`void`	`testPing()`
`void`	`testReadOnly56()`
`void`	`testSavepoint()` Tests the savepoint functionality in MySQL.
`void`	`testSelfDestruct()`
`void`	`testServerConfigurationCache()`
`void`	`testSessionVariables()`
`void`	`testSetProfileSql()` Tests setting profileSQL on/off in the span of one connection.
`void`	`testSslConnectionOptions()` Tests that given SSL/TLS related connection properties values are processed as expected.
`void`	`testSupportsRefCursors()` Test for REF_CURSOR support checking.
`void`	`testTimeoutErrors()` Tests WL#14392, Improve timeout error messages [classic].
`void`	`testTLSVersionRemoval()` Tests WL#14805, Remove support for TLS 1.0 and 1.1.
`void`	`testTSLConflictingOptions()` Tests WL#14835, Align TLS option checking across connectors
`void`	`testUsageAdvisorTooLargeResultSet()`
`void`	`testUseCompress()` Tests if useCompress works.
`void`	`testUseLocalSessionState()` Tests whether or not the configuration 'useLocalSessionState' actually prevents non-needed 'set autocommit=', 'set session transaction isolation ...' and 'show variables like tx_isolation' queries.
`void`	`testUseLocalSessionStateRollback()`
`void`	`testUserRequireSSL()` Test authentication with a user that requires an SSL connection.
`void`	`testUserRequireX509()` Test authentication with a user that requires an SSL connection and an authorized client certificate.

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
  - sslFreeBaseUrl
```
private java.lang.String sslFreeBaseUrl
```
- Constructor Detail
  - ConnectionTest
```
public ConnectionTest()
```
- Method Detail
  - setupSecureSessionTest
```
@BeforeEach
public void setupSecureSessionTest()
```
  - teardownConnectionTest
```
@AfterEach
public void teardownConnectionTest()
```
  - testCatalog
```
@Test
public void testCatalog()
                       throws java.lang.Exception
```
    Tests catalog functionality
    
    Throws:
    
    java.lang.Exception
  - testClusterConnection
```
@Test
public void testClusterConnection()
                                 throws java.lang.Exception
```
    Tests a cluster connection for failover, requires a two-node cluster URL specified in com.mysql.jdbc.testsuite.ClusterUrl system property.
    
    Throws:
    
    java.lang.Exception
  - testDeadlockDetection
```
@Test
public void testDeadlockDetection()
                                 throws java.lang.Exception
```
    Old test was passing due to http://bugs.mysql.com/bug.php?id=989 which is fixed for 5.5+
    
    Throws:
    
    java.lang.Exception
  - testIsolationLevel
```
@Test
public void testIsolationLevel()
                              throws java.lang.Exception
```
    Tests isolation level functionality
    
    Throws:
    
    java.lang.Exception
  - testSavepoint
```
@Test
public void testSavepoint()
                         throws java.lang.Exception
```
    Tests the savepoint functionality in MySQL.
    
    Throws:
    
    java.lang.Exception
  - testDumpQueriesOnException
```
@Test
public void testDumpQueriesOnException()
                                      throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testConnectionPropertiesTransform
```
@Test
public void testConnectionPropertiesTransform()
                                             throws java.lang.Exception
```
    Tests functionality of the ConnectionPropertiesTransform interface.
    
    Throws:
    
    java.lang.Exception
  - testLocalInfileWithUrl
```
@Test
public void testLocalInfileWithUrl()
                                  throws java.lang.Exception
```
    Tests functionality of using URLs in 'LOAD DATA LOCAL INFILE' statements.
    
    Throws:
    
    java.lang.Exception
  - testLocalInfileDisabled
```
@Test
public void testLocalInfileDisabled()
                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testServerConfigurationCache
```
@Test
public void testServerConfigurationCache()
                                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUseLocalSessionState
```
@Test
public void testUseLocalSessionState()
                                    throws java.lang.Exception
```
    Tests whether or not the configuration 'useLocalSessionState' actually prevents non-needed 'set autocommit=', 'set session transaction isolation ...' and 'show variables like tx_isolation' queries.
    
    Throws:
    
    java.lang.Exception
  - testFailoverConnection
```
@Test
public void testFailoverConnection()
                                  throws java.lang.Exception
```
    Tests whether re-connect with non-read-only connection can happen.
    
    Throws:
    
    java.lang.Exception
  - testCannedConfigs
```
@Test
public void testCannedConfigs()
                             throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testDontTrackOpenResources
```
@Test
public void testDontTrackOpenResources()
                                      throws java.lang.Exception
```
    Checks implementation of 'dontTrackOpenResources' property.
    
    Throws:
    
    java.lang.Exception
  - testPing
```
@Test
public void testPing()
                    throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testSessionVariables
```
@Test
public void testSessionVariables()
                                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testSetProfileSql
```
@Test
public void testSetProfileSql()
                             throws java.lang.Exception
```
    Tests setting profileSQL on/off in the span of one connection.
    
    Throws:
    
    java.lang.Exception
  - testCreateDatabaseIfNotExist
```
@Test
public void testCreateDatabaseIfNotExist()
                                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testGatherPerfMetrics
```
@Test
public void testGatherPerfMetrics()
                                 throws java.lang.Exception
```
    Tests if gatherPerfMetrics works.
    
    Throws:
    
    java.lang.Exception
  - testUseCompress
```
@Test
public void testUseCompress()
                           throws java.lang.Exception
```
    Tests if useCompress works.
    
    Throws:
    
    java.lang.Exception
  - testCompressionWith
```
private void testCompressionWith(java.lang.String useCompression,
                                 int maxPayloadSize)
                          throws java.lang.Exception
```
    Parameters:
    
    useCompression -
    
    maxPayloadSize -
    
    Throws:
    
    java.lang.Exception
  - testLocalSocketAddress
```
@Test
public void testLocalSocketAddress()
                                  throws java.lang.Exception
```
    Tests feature of "localSocketAddress", by enumerating local IF's and trying each one in turn. This test might take a long time to run, since we can't set timeouts if we're using localSocketAddress. We try and keep the time down on the testcase by spawning the checking of each interface off into separate threads.
    
    Throws:
    
    java.lang.Exception - if the test can't use at least one of the local machine's interfaces to make an outgoing connection to the server.
  - testUsageAdvisorTooLargeResultSet
```
@Test
public void testUsageAdvisorTooLargeResultSet()
                                             throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUseLocalSessionStateRollback
```
@Test
public void testUseLocalSessionStateRollback()
                                            throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCouplingOfCursorFetch
```
@Test
public void testCouplingOfCursorFetch()
                                     throws java.lang.Exception
```
    Checks if setting useCursorFetch to "true" automatically enables server-side prepared statements.
    
    Throws:
    
    java.lang.Exception
  - testInterfaceImplementation
```
@Test
public void testInterfaceImplementation()
                                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testInterfaceImplementation
```
@Test
private void testInterfaceImplementation(java.sql.Connection connToCheck)
                                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - checkInterfaceImplemented
```
private void checkInterfaceImplemented(java.lang.reflect.Method[] interfaceMethods,
                                       java.lang.Class<?> implementingClass,
                                       java.lang.Object invokeOn)
                                throws java.lang.NoSuchMethodException
```
    Throws:
    
    java.lang.NoSuchMethodException
  - testNonVerifyServerCert
```
@Test
public void testNonVerifyServerCert()
                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testSelfDestruct
```
@Test
public void testSelfDestruct()
                            throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testLifecyleInterceptor
```
@Test
public void testLifecyleInterceptor()
                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testNewHostParsing
```
@Test
public void testNewHostParsing()
                              throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testCompression
```
@Test
public void testCompression()
                           throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testIsLocal
```
@Test
public void testIsLocal()
                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testReadOnly56
```
@Test
public void testReadOnly56()
                          throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testIPv6
```
@Test
public void testIPv6()
                    throws java.lang.Exception
```
    IPv6 Connection test.
    
    Throws:
    
    java.lang.Exception
  - testDriverAcceptsURLNullArgument
```
@Test
public void testDriverAcceptsURLNullArgument()
```
    Test for Driver.acceptsURL() behavior clarification: - acceptsURL() throws SQLException if URL is null.
  - testDriverConnectNullArgument
```
@Test
public void testDriverConnectNullArgument()
                                         throws java.lang.Exception
```
    Test for Driver.connect() behavior clarifications: - connect() throws SQLException if URL is null.
    
    Throws:
    
    java.lang.Exception
  - testDriverConnectPropertiesPrecedence
```
@Test
public void testDriverConnectPropertiesPrecedence()
                                                 throws java.lang.Exception
```
    Test for Driver.connect() behavior clarifications: - connect() properties precedence is implementation-defined.
    
    Throws:
    
    java.lang.Exception
  - testSupportsRefCursors
```
@Test
public void testSupportsRefCursors()
                                  throws java.lang.Exception
```
    Test for REF_CURSOR support checking.
    
    Throws:
    
    java.lang.Exception
  - testEnableEscapeProcessing
```
@Test
public void testEnableEscapeProcessing()
                                      throws java.lang.Exception
```
    Test the new connection property 'enableEscapeProcessing', as well as the old connection property 'processEscapeCodesForPrepStmts' and interrelation between them. This test uses a QueryInterceptor to capture the query sent to the server and assert whether escape processing has been done in the client side or if the query is sent untouched and escape processing will be done at server side, according to provided connection properties and type of Statement objects in use.
    
    Throws:
    
    java.lang.Exception
  - testDecoratorsChain
```
@Test
public void testDecoratorsChain()
                               throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUserRequireSSL
```
@Test
public void testUserRequireSSL()
                              throws java.lang.Exception
```
    Test authentication with a user that requires an SSL connection. This test requires the CA truststore and the client keystore available in src/test/config/ssl-test-certs. The server needs to be configured with the CA and server certificates from src/test/config/ssl-test-certs.
    
    Throws:
    
    java.lang.Exception
  - testUserRequireX509
```
@Test
public void testUserRequireX509()
                               throws java.lang.Exception
```
    Test authentication with a user that requires an SSL connection and an authorized client certificate. This test requires the CA truststore and the client keystore available in src/test/config/ssl-test-certs. The server needs to be configured with the CA and server certificates from src/test/config/ssl-test-certs.
    
    Throws:
    
    java.lang.Exception
  - testSslConnectionOptions
```
@Test
public void testSslConnectionOptions()
                                    throws java.lang.Exception
```
    Tests that given SSL/TLS related connection properties values are processed as expected.
    
    Throws:
    
    java.lang.Exception
  - testFallbackToSystemTrustStore
```
@Test
public void testFallbackToSystemTrustStore()
                                          throws java.lang.Exception
```
    Tests connection property 'testFallbackToSystemTrustStore' behavior.
    
    Throws:
    
    java.lang.Exception
  - testFallbackToSystemKeyStore
```
@Test
public void testFallbackToSystemKeyStore()
                                        throws java.lang.Exception
```
    Tests connection property 'testFallbackToSystemKeyStore' behavior.
    
    Throws:
    
    java.lang.Exception
  - testAllowLoadLocalInfileInPath
```
@Test
public void testAllowLoadLocalInfileInPath()
                                          throws java.lang.Exception
```
    Tests "LOAD DATA LOCAL INFILE" statements when enabled but restricted to a specific path, by specifying a path in the connection property 'allowLoadLocalInfileInPath'.
    
    Throws:
    
    java.lang.Exception
  - testAllowLoadLocalInfileInPathCheckAndDelete
```
private void testAllowLoadLocalInfileInPathCheckAndDelete()
                                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testTimeoutErrors
```
@Test
public void testTimeoutErrors()
                             throws java.lang.Exception
```
    Tests WL#14392, Improve timeout error messages [classic].
    
    Throws:
    
    java.lang.Exception
  - testTLSVersionRemoval
```
@Test
public void testTLSVersionRemoval()
                                 throws java.lang.Exception
```
    Tests WL#14805, Remove support for TLS 1.0 and 1.1.
    
    Throws:
    
    java.lang.Exception
  - testTSLConflictingOptions
```
@Test
public void testTSLConflictingOptions()
                                     throws java.lang.Exception
```
    Tests WL#14835, Align TLS option checking across connectors
    
    Throws:
    
    java.lang.Exception

Class ConnectionTest

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

Field Summary

Fields inherited from class testsuite.BaseTestCase

Constructor Summary

Method Summary

Methods inherited from class testsuite.BaseTestCase

Methods inherited from class java.lang.Object

Field Detail

sslFreeBaseUrl

Constructor Detail

ConnectionTest

Method Detail

setupSecureSessionTest

teardownConnectionTest

testCatalog

testClusterConnection

testDeadlockDetection

testIsolationLevel

testSavepoint

testDumpQueriesOnException

testConnectionPropertiesTransform

testLocalInfileWithUrl

testLocalInfileDisabled

testServerConfigurationCache

testUseLocalSessionState

testFailoverConnection

testCannedConfigs

testDontTrackOpenResources

testPing

testSessionVariables

testSetProfileSql

testCreateDatabaseIfNotExist

testGatherPerfMetrics

testUseCompress

testCompressionWith

testLocalSocketAddress

testUsageAdvisorTooLargeResultSet

testUseLocalSessionStateRollback

testCouplingOfCursorFetch

testInterfaceImplementation

testInterfaceImplementation

checkInterfaceImplemented

testNonVerifyServerCert

testSelfDestruct

testLifecyleInterceptor

testNewHostParsing

testCompression

testIsLocal

testReadOnly56

testIPv6

testDriverAcceptsURLNullArgument

testDriverConnectNullArgument

testDriverConnectPropertiesPrecedence

testSupportsRefCursors

testEnableEscapeProcessing

testDecoratorsChain

testUserRequireSSL

testUserRequireX509

testSslConnectionOptions

testFallbackToSystemTrustStore

testFallbackToSystemKeyStore

testAllowLoadLocalInfileInPath

testAllowLoadLocalInfileInPathCheckAndDelete

testTimeoutErrors

testTLSVersionRemoval

testTSLConflictingOptions