com.mysql.jdbc
Interface Connection

All Superinterfaces:
java.sql.Connection, ConnectionProperties, java.sql.Wrapper

public interface Connection
extends java.sql.Connection, ConnectionProperties

This interface contains methods that are considered the "vendor extension" to the JDBC API for MySQL's implementation of java.sql.Connection. For those looking further into the driver implementation, it is not an API that is used for plugability of implementations inside our driver (which is why there are still references to ConnectionImpl throughout the code).


Field Summary
 
Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE
 
Method Summary
 void changeUser(java.lang.String userName, java.lang.String newPassword)
          Changes the user on this connection by performing a re-authentication.
 void clearHasTriedMaster()
           
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql, int autoGenKeyIndex)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql, int[] autoGenKeyIndexes)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql, java.lang.String[] autoGenKeyColNames)
          Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 int getActiveStatementCount()
          Returns the number of statements active on this connection, which haven't been .close()d.
 int getAutoIncrementIncrement()
          Returns the -session- value of 'auto_increment_increment' from the server if it exists, or '1' if not.
 long getIdleFor()
          Reports how long this connection has been idle.
 com.mysql.jdbc.log.Log getLog()
          Returns the log mechanism that should be used to log information from/for this Connection.
 java.util.Properties getProperties()
          Returns the parsed and passed in properties for this connection.
 java.lang.String getServerCharacterEncoding()
          Returns the server's character set
 java.util.TimeZone getServerTimezoneTZ()
          Returns the TimeZone that represents the configured timezone for the server.
 java.lang.String getStatementComment()
          Returns the comment that will be prepended to all statements sent to the server.
 boolean hasSameProperties(Connection c)
          Does this connection have the same properties as another?
 boolean hasTriedMaster()
          Has this connection tried to execute a query on the "master" server (first host in a multiple host list).
 void initializeExtension(Extension ex)
           
 boolean isAbonormallyLongQuery(long millisOrNanos)
           
 boolean isInGlobalTx()
          Is this connection currently a participant in an XA transaction?
 boolean isMasterConnection()
          Is this connection connected to the first host in the list if there is a list of servers in the URL?
 boolean isNoBackslashEscapesSet()
          Is the server in a sql_mode that doesn't allow us to use \\ to escape things?
 boolean isSameResource(Connection c)
          Does this connection have the same resource name as the given connection (for XA)?
 boolean lowerCaseTableNames()
          Is the server configured to use lower-case table names only?
 boolean parserKnowsUnicode()
          Does the server this connection is connected to support unicode?
 void ping()
          Detect if the connection is still good by sending a ping command to the server.
 void reportQueryTime(long millisOrNanos)
           
 void resetServerState()
          Resets the server-side state of this connection.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql, int autoGenKeyIndex)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql, int[] autoGenKeyIndexes)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql, java.lang.String[] autoGenKeyColNames)
          Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.
 void setFailedOver(boolean flag)
           
 void setInGlobalTx(boolean flag)
          Set the state of being in a global (XA) transaction.
 void setPreferSlaveDuringFailover(boolean flag)
           
 void setStatementComment(java.lang.String comment)
          Sets the comment that will be prepended to all statements sent to the server.
 void shutdownServer()
          Used by MiniAdmin to shutdown a MySQL server
 boolean supportsIsolationLevel()
          Does the server this connection is connected to support quoted isolation levels?
 boolean supportsQuotedIdentifiers()
          Does the server this connection is connected to support quoted identifiers?
 boolean supportsTransactions()
          Does the server this connection is connected to support quoted identifiers?
 boolean versionMeetsMinimum(int major, int minor, int subminor)
          Does the server this connection is connected to meet or exceed the given version?
 
Methods inherited from interface java.sql.Connection
clearWarnings, close, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setReadOnly, setSavepoint, setSavepoint, setTransactionIsolation, setTypeMap
 
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap
 
Methods inherited from interface com.mysql.jdbc.ConnectionProperties
exposeAsXml, getAllowLoadLocalInfile, getAllowMultiQueries, getAllowNanAndInf, getAllowUrlInLocalInfile, getAlwaysSendSetIsolation, getAutoClosePStmtStreams, getAutoDeserialize, getAutoGenerateTestcaseScript, getAutoReconnectForPools, getAutoSlowLog, getBlobsAreStrings, getBlobSendChunkSize, getCacheCallableStatements, getCacheCallableStmts, getCachePreparedStatements, getCachePrepStmts, getCacheResultSetMetadata, getCacheServerConfiguration, getCallableStatementCacheSize, getCallableStmtCacheSize, getCapitalizeTypeNames, getCharacterSetResults, getClientCertificateKeyStorePassword, getClientCertificateKeyStoreType, getClientCertificateKeyStoreUrl, getClientInfoProvider, getClobberStreamingResults, getClobCharacterEncoding, getCompensateOnDuplicateKeyUpdateCounts, getConnectionCollation, getConnectionLifecycleInterceptors, getConnectTimeout, getContinueBatchOnError, getCreateDatabaseIfNotExist, getDefaultFetchSize, getDontTrackOpenResources, getDumpMetadataOnColumnNotFound, getDumpQueriesOnException, getDynamicCalendars, getElideSetAutoCommits, getEmptyStringsConvertToZero, getEmulateLocators, getEmulateUnsupportedPstmts, getEnablePacketDebug, getEnableQueryTimeouts, getEncoding, getExceptionInterceptor, getExceptionInterceptors, getExplainSlowQueries, getFailOverReadOnly, getFunctionsNeverReturnBlobs, getGatherPerfMetrics, getGatherPerformanceMetrics, getGenerateSimpleParameterMetadata, getHoldResultsOpenOverStatementClose, getIgnoreNonTxTables, getIncludeInnodbStatusInDeadlockExceptions, getInitialTimeout, getInteractiveClient, getIsInteractiveClient, getJdbcCompliantTruncation, getJdbcCompliantTruncationForReads, getLargeRowSizeThreshold, getLoadBalanceBlacklistTimeout, getLoadBalanceStrategy, getLocalSocketAddress, getLocatorFetchBufferSize, getLogger, getLoggerClassName, getLogSlowQueries, getLogXaCommands, getMaintainTimeStats, getMaxQuerySizeToLog, getMaxReconnects, getMaxRows, getMetadataCacheSize, getNetTimeoutForStreamingResults, getNoAccessToProcedureBodies, getNoDatetimeStringSync, getNoTimezoneConversionForTimeType, getNullCatalogMeansCurrent, getNullNamePatternMatchesAll, getOverrideSupportsIntegrityEnhancementFacility, getPacketDebugBufferSize, getPadCharsWithSpace, getParanoid, getPasswordCharacterEncoding, getPedantic, getPinGlobalTxToPhysicalConnection, getPopulateInsertRowWithDefaultValues, getPreparedStatementCacheSize, getPreparedStatementCacheSqlLimit, getPrepStmtCacheSize, getPrepStmtCacheSqlLimit, getProcessEscapeCodesForPrepStmts, getProfilerEventHandler, getProfileSql, getProfileSQL, getPropertiesTransform, getQueriesBeforeRetryMaster, getQueryTimeoutKillsConnection, getReconnectAtTxEnd, getRelaxAutoCommit, getReportMetricsIntervalMillis, getRequireSSL, getResourceId, getResultSetSizeThreshold, getRetriesAllDown, getRewriteBatchedStatements, getRollbackOnPooledClose, getRoundRobinLoadBalance, getRunningCTS13, getSecondsBeforeRetryMaster, getSelfDestructOnPingMaxOperations, getSelfDestructOnPingSecondsLifetime, getServerTimezone, getSessionVariables, getSlowQueryThresholdMillis, getSlowQueryThresholdNanos, getSocketFactory, getSocketFactoryClassName, getSocketTimeout, getStatementInterceptors, getStrictFloatingPoint, getStrictUpdates, getTcpKeepAlive, getTcpNoDelay, getTcpRcvBuf, getTcpSndBuf, getTcpTrafficClass, getTinyInt1isBit, getTraceProtocol, getTransformedBitIsBoolean, getTreatUtilDateAsTimestamp, getTrustCertificateKeyStorePassword, getTrustCertificateKeyStoreType, getTrustCertificateKeyStoreUrl, getUltraDevHack, getUseAffectedRows, getUseBlobToStoreUTF8OutsideBMP, getUseColumnNamesInFindColumn, getUseCompression, getUseConfigs, getUseCursorFetch, getUseDirectRowUnpack, getUseDynamicCharsetInfo, getUseFastDateParsing, getUseFastIntParsing, getUseGmtMillisForDatetimes, getUseHostsInPrivileges, getUseInformationSchema, getUseJDBCCompliantTimezoneShift, getUseJvmCharsetConverters, getUseLegacyDatetimeCode, getUseLocalSessionState, getUseLocalTransactionState, getUseNanosForElapsedTime, getUseOldAliasMetadataBehavior, getUseOldUTF8Behavior, getUseOnlyServerErrorMessages, getUseReadAheadInput, getUseServerPreparedStmts, getUseServerPrepStmts, getUseSqlStateCodes, getUseSSL, getUseSSPSCompatibleTimezoneShift, getUseStreamLengthsInPrepStmts, getUseTimezone, getUseUltraDevWorkAround, getUseUnbufferedInput, getUseUnicode, getUseUsageAdvisor, getUtf8OutsideBmpExcludedColumnNamePattern, getUtf8OutsideBmpIncludedColumnNamePattern, getVerifyServerCertificate, getYearIsDateType, getZeroDateTimeBehavior, setAllowLoadLocalInfile, setAllowMultiQueries, setAllowNanAndInf, setAllowUrlInLocalInfile, setAlwaysSendSetIsolation, setAutoClosePStmtStreams, setAutoDeserialize, setAutoGenerateTestcaseScript, setAutoReconnect, setAutoReconnectForConnectionPools, setAutoReconnectForPools, setAutoSlowLog, setBlobsAreStrings, setBlobSendChunkSize, setCacheCallableStatements, setCacheCallableStmts, setCachePreparedStatements, setCachePrepStmts, setCacheResultSetMetadata, setCacheServerConfiguration, setCallableStatementCacheSize, setCallableStmtCacheSize, setCapitalizeDBMDTypes, setCapitalizeTypeNames, setCharacterEncoding, setCharacterSetResults, setClientCertificateKeyStorePassword, setClientCertificateKeyStoreType, setClientCertificateKeyStoreUrl, setClientInfoProvider, setClobberStreamingResults, setClobCharacterEncoding, setCompensateOnDuplicateKeyUpdateCounts, setConnectionCollation, setConnectionLifecycleInterceptors, setConnectTimeout, setContinueBatchOnError, setCreateDatabaseIfNotExist, setDefaultFetchSize, setDetectServerPreparedStmts, setDontTrackOpenResources, setDumpMetadataOnColumnNotFound, setDumpQueriesOnException, setDynamicCalendars, setElideSetAutoCommits, setEmptyStringsConvertToZero, setEmulateLocators, setEmulateUnsupportedPstmts, setEnablePacketDebug, setEnableQueryTimeouts, setEncoding, setExceptionInterceptors, setExplainSlowQueries, setFailOverReadOnly, setFunctionsNeverReturnBlobs, setGatherPerfMetrics, setGatherPerformanceMetrics, setGenerateSimpleParameterMetadata, setHoldResultsOpenOverStatementClose, setIgnoreNonTxTables, setIncludeInnodbStatusInDeadlockExceptions, setInitialTimeout, setInteractiveClient, setIsInteractiveClient, setJdbcCompliantTruncation, setJdbcCompliantTruncationForReads, setLargeRowSizeThreshold, setLoadBalanceBlacklistTimeout, setLoadBalanceStrategy, setLocalSocketAddress, setLocatorFetchBufferSize, setLogger, setLoggerClassName, setLogSlowQueries, setLogXaCommands, setMaintainTimeStats, setMaxQuerySizeToLog, setMaxReconnects, setMaxRows, setMetadataCacheSize, setNetTimeoutForStreamingResults, setNoAccessToProcedureBodies, setNoDatetimeStringSync, setNoTimezoneConversionForTimeType, setNullCatalogMeansCurrent, setNullNamePatternMatchesAll, setOverrideSupportsIntegrityEnhancementFacility, setPacketDebugBufferSize, setPadCharsWithSpace, setParanoid, setPasswordCharacterEncoding, setPedantic, setPinGlobalTxToPhysicalConnection, setPopulateInsertRowWithDefaultValues, setPreparedStatementCacheSize, setPreparedStatementCacheSqlLimit, setPrepStmtCacheSize, setPrepStmtCacheSqlLimit, setProcessEscapeCodesForPrepStmts, setProfilerEventHandler, setProfileSql, setProfileSQL, setPropertiesTransform, setQueriesBeforeRetryMaster, setQueryTimeoutKillsConnection, setReconnectAtTxEnd, setRelaxAutoCommit, setReportMetricsIntervalMillis, setRequireSSL, setResourceId, setResultSetSizeThreshold, setRetainStatementAfterResultSetClose, setRetriesAllDown, setRewriteBatchedStatements, setRollbackOnPooledClose, setRoundRobinLoadBalance, setRunningCTS13, setSecondsBeforeRetryMaster, setSelfDestructOnPingMaxOperations, setSelfDestructOnPingSecondsLifetime, setServerTimezone, setSessionVariables, setSlowQueryThresholdMillis, setSlowQueryThresholdNanos, setSocketFactory, setSocketFactoryClassName, setSocketTimeout, setStatementInterceptors, setStrictFloatingPoint, setStrictUpdates, setTcpKeepAlive, setTcpNoDelay, setTcpRcvBuf, setTcpSndBuf, setTcpTrafficClass, setTinyInt1isBit, setTraceProtocol, setTransformedBitIsBoolean, setTreatUtilDateAsTimestamp, setTrustCertificateKeyStorePassword, setTrustCertificateKeyStoreType, setTrustCertificateKeyStoreUrl, setUltraDevHack, setUseAffectedRows, setUseBlobToStoreUTF8OutsideBMP, setUseColumnNamesInFindColumn, setUseCompression, setUseConfigs, setUseCursorFetch, setUseDirectRowUnpack, setUseDynamicCharsetInfo, setUseFastDateParsing, setUseFastIntParsing, setUseGmtMillisForDatetimes, setUseHostsInPrivileges, setUseInformationSchema, setUseJDBCCompliantTimezoneShift, setUseJvmCharsetConverters, setUseLegacyDatetimeCode, setUseLocalSessionState, setUseLocalTransactionState, setUseNanosForElapsedTime, setUseOldAliasMetadataBehavior, setUseOldUTF8Behavior, setUseOnlyServerErrorMessages, setUseReadAheadInput, setUseServerPreparedStmts, setUseServerPrepStmts, setUseSqlStateCodes, setUseSSL, setUseSSPSCompatibleTimezoneShift, setUseStreamLengthsInPrepStmts, setUseTimezone, setUseUltraDevWorkAround, setUseUnbufferedInput, setUseUnicode, setUseUsageAdvisor, setUtf8OutsideBmpExcludedColumnNamePattern, setUtf8OutsideBmpIncludedColumnNamePattern, setVerifyServerCertificate, setYearIsDateType, setZeroDateTimeBehavior, useUnbufferedInput
 

Method Detail

changeUser

void changeUser(java.lang.String userName,
                java.lang.String newPassword)
                throws java.sql.SQLException
Changes the user on this connection by performing a re-authentication. If authentication fails, the connection will remain under the context of the current user.

Parameters:
userName - the username to authenticate with
newPassword - the password to authenticate with
Throws:
java.sql.SQLException - if authentication fails, or some other error occurs while performing the command.

clearHasTriedMaster

void clearHasTriedMaster()

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String)

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql,
                                                  int autoGenKeyIndex)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int)

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql,
                                                  int resultSetType,
                                                  int resultSetConcurrency)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int, int)

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql,
                                                  int[] autoGenKeyIndexes)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int[])

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql,
                                                  int resultSetType,
                                                  int resultSetConcurrency,
                                                  int resultSetHoldability)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int, int, int)

clientPrepareStatement

java.sql.PreparedStatement clientPrepareStatement(java.lang.String sql,
                                                  java.lang.String[] autoGenKeyColNames)
                                                  throws java.sql.SQLException
Prepares a statement on the client, using client-side emulation (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, String[])

getActiveStatementCount

int getActiveStatementCount()
Returns the number of statements active on this connection, which haven't been .close()d.


getIdleFor

long getIdleFor()
Reports how long this connection has been idle. This time (reported in milliseconds) is updated once a query has completed.

Returns:
number of ms that this connection has been idle, 0 if the driver is busy retrieving results.

getLog

com.mysql.jdbc.log.Log getLog()
                              throws java.sql.SQLException
Returns the log mechanism that should be used to log information from/for this Connection.

Returns:
the Log instance to use for logging messages.
Throws:
java.sql.SQLException - if an error occurs

getServerCharacterEncoding

java.lang.String getServerCharacterEncoding()
Returns the server's character set

Returns:
the server's character set.

getServerTimezoneTZ

java.util.TimeZone getServerTimezoneTZ()
Returns the TimeZone that represents the configured timezone for the server.


getStatementComment

java.lang.String getStatementComment()
Returns the comment that will be prepended to all statements sent to the server.

Returns:
the comment that will be prepended to all statements sent to the server.

hasTriedMaster

boolean hasTriedMaster()
Has this connection tried to execute a query on the "master" server (first host in a multiple host list).


isInGlobalTx

boolean isInGlobalTx()
Is this connection currently a participant in an XA transaction?


setInGlobalTx

void setInGlobalTx(boolean flag)
Set the state of being in a global (XA) transaction.

Parameters:
flag -

isMasterConnection

boolean isMasterConnection()
Is this connection connected to the first host in the list if there is a list of servers in the URL?

Returns:
true if this connection is connected to the first in the list.

isNoBackslashEscapesSet

boolean isNoBackslashEscapesSet()
Is the server in a sql_mode that doesn't allow us to use \\ to escape things?

Returns:
Returns the noBackslashEscapes.

isSameResource

boolean isSameResource(Connection c)
Does this connection have the same resource name as the given connection (for XA)?

Parameters:
c -
Returns:

lowerCaseTableNames

boolean lowerCaseTableNames()
Is the server configured to use lower-case table names only?

Returns:
true if lower_case_table_names is 'on'

parserKnowsUnicode

boolean parserKnowsUnicode()
Does the server this connection is connected to support unicode?


ping

void ping()
          throws java.sql.SQLException
Detect if the connection is still good by sending a ping command to the server.

Throws:
java.sql.SQLException - if the ping fails

resetServerState

void resetServerState()
                      throws java.sql.SQLException
Resets the server-side state of this connection. Doesn't work for MySQL versions older than 4.0.6 or if isParanoid() is set (it will become a no-op in these cases). Usually only used from connection pooling code.

Throws:
java.sql.SQLException - if the operation fails while resetting server state.

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String)

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql,
                                                  int autoGenKeyIndex)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int)

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql,
                                                  int resultSetType,
                                                  int resultSetConcurrency)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int, int)

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql,
                                                  int resultSetType,
                                                  int resultSetConcurrency,
                                                  int resultSetHoldability)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int, int, int)

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql,
                                                  int[] autoGenKeyIndexes)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, int[])

serverPrepareStatement

java.sql.PreparedStatement serverPrepareStatement(java.lang.String sql,
                                                  java.lang.String[] autoGenKeyColNames)
                                                  throws java.sql.SQLException
Prepares a statement on the server (irregardless of the configuration property 'useServerPrepStmts') with the same semantics as the java.sql.Connection.prepareStatement() method with the same argument types.

Throws:
java.sql.SQLException
See Also:
Connection.prepareStatement(String, String[])

setFailedOver

void setFailedOver(boolean flag)
Parameters:
failedOver - The failedOver to set.

setPreferSlaveDuringFailover

void setPreferSlaveDuringFailover(boolean flag)
Parameters:
preferSlaveDuringFailover - The preferSlaveDuringFailover to set.

setStatementComment

void setStatementComment(java.lang.String comment)
Sets the comment that will be prepended to all statements sent to the server. Do not use slash-star or star-slash tokens in the comment as these will be added by the driver itself.

Parameters:
comment - the comment that will be prepended to all statements sent to the server.

shutdownServer

void shutdownServer()
                    throws java.sql.SQLException
Used by MiniAdmin to shutdown a MySQL server

Throws:
java.sql.SQLException - if the command can not be issued.

supportsIsolationLevel

boolean supportsIsolationLevel()
Does the server this connection is connected to support quoted isolation levels?


supportsQuotedIdentifiers

boolean supportsQuotedIdentifiers()
Does the server this connection is connected to support quoted identifiers?


supportsTransactions

boolean supportsTransactions()
Does the server this connection is connected to support quoted identifiers?


versionMeetsMinimum

boolean versionMeetsMinimum(int major,
                            int minor,
                            int subminor)
                            throws java.sql.SQLException
Does the server this connection is connected to meet or exceed the given version?

Throws:
java.sql.SQLException

reportQueryTime

void reportQueryTime(long millisOrNanos)

isAbonormallyLongQuery

boolean isAbonormallyLongQuery(long millisOrNanos)

initializeExtension

void initializeExtension(Extension ex)
                         throws java.sql.SQLException
Throws:
java.sql.SQLException

getAutoIncrementIncrement

int getAutoIncrementIncrement()
Returns the -session- value of 'auto_increment_increment' from the server if it exists, or '1' if not.


hasSameProperties

boolean hasSameProperties(Connection c)
Does this connection have the same properties as another?


getProperties

java.util.Properties getProperties()
Returns the parsed and passed in properties for this connection.

Returns: