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

Version:

$Id: $

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.
long	getIdleFor() Reports how long this connection has been idle.
Log	getLog() Returns the log mechanism that should be used to log information from/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	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, getConnectionCollation, getConnectionLifecycleInterceptors, getConnectTimeout, getContinueBatchOnError, getCreateDatabaseIfNotExist, getDefaultFetchSize, getDontTrackOpenResources, getDumpMetadataOnColumnNotFound, getDumpQueriesOnException, getDynamicCalendars, getElideSetAutoCommits, getEmptyStringsConvertToZero, getEmulateLocators, getEmulateUnsupportedPstmts, getEnablePacketDebug, getEnableQueryTimeouts, getEncoding, getExplainSlowQueries, getFailOverReadOnly, getFunctionsNeverReturnBlobs, getGatherPerfMetrics, getGatherPerformanceMetrics, getGenerateSimpleParameterMetadata, getHoldResultsOpenOverStatementClose, getIgnoreNonTxTables, getIncludeInnodbStatusInDeadlockExceptions, getInitialTimeout, getInteractiveClient, getIsInteractiveClient, getJdbcCompliantTruncation, getJdbcCompliantTruncationForReads, getLargeRowSizeThreshold, getLoadBalanceStrategy, getLocalSocketAddress, getLocatorFetchBufferSize, getLogger, getLoggerClassName, getLogSlowQueries, getLogXaCommands, getMaintainTimeStats, getMaxQuerySizeToLog, getMaxReconnects, getMaxRows, getMetadataCacheSize, getNetTimeoutForStreamingResults, getNoAccessToProcedureBodies, getNoDatetimeStringSync, getNoTimezoneConversionForTimeType, getNullCatalogMeansCurrent, getNullNamePatternMatchesAll, getOverrideSupportsIntegrityEnhancementFacility, getPacketDebugBufferSize, getPadCharsWithSpace, getParanoid, getPedantic, getPinGlobalTxToPhysicalConnection, getPopulateInsertRowWithDefaultValues, getPreparedStatementCacheSize, getPreparedStatementCacheSqlLimit, getPrepStmtCacheSize, getPrepStmtCacheSqlLimit, getProcessEscapeCodesForPrepStmts, getProfilerEventHandler, getProfileSql, getProfileSQL, getPropertiesTransform, getQueriesBeforeRetryMaster, getReconnectAtTxEnd, getRelaxAutoCommit, getReportMetricsIntervalMillis, getRequireSSL, getResourceId, getResultSetSizeThreshold, 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, getUseBlobToStoreUTF8OutsideBMP, getUseCompression, getUseConfigs, getUseCursorFetch, getUseDirectRowUnpack, getUseDynamicCharsetInfo, getUseFastDateParsing, getUseFastIntParsing, getUseGmtMillisForDatetimes, getUseHostsInPrivileges, getUseInformationSchema, getUseJDBCCompliantTimezoneShift, getUseJvmCharsetConverters, getUseLegacyDatetimeCode, getUseLocalSessionState, 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, setConnectionCollation, setConnectionLifecycleInterceptors, setConnectTimeout, setContinueBatchOnError, setCreateDatabaseIfNotExist, setDefaultFetchSize, setDetectServerPreparedStmts, setDontTrackOpenResources, setDumpMetadataOnColumnNotFound, setDumpQueriesOnException, setDynamicCalendars, setElideSetAutoCommits, setEmptyStringsConvertToZero, setEmulateLocators, setEmulateUnsupportedPstmts, setEnablePacketDebug, setEnableQueryTimeouts, setEncoding, setExplainSlowQueries, setFailOverReadOnly, setFunctionsNeverReturnBlobs, setGatherPerfMetrics, setGatherPerformanceMetrics, setGenerateSimpleParameterMetadata, setHoldResultsOpenOverStatementClose, setIgnoreNonTxTables, setIncludeInnodbStatusInDeadlockExceptions, setInitialTimeout, setInteractiveClient, setIsInteractiveClient, setJdbcCompliantTruncation, setJdbcCompliantTruncationForReads, setLargeRowSizeThreshold, setLoadBalanceStrategy, setLocalSocketAddress, setLocatorFetchBufferSize, setLogger, setLoggerClassName, setLogSlowQueries, setLogXaCommands, setMaintainTimeStats, setMaxQuerySizeToLog, setMaxReconnects, setMaxRows, setMetadataCacheSize, setNetTimeoutForStreamingResults, setNoAccessToProcedureBodies, setNoDatetimeStringSync, setNoTimezoneConversionForTimeType, setNullCatalogMeansCurrent, setNullNamePatternMatchesAll, setOverrideSupportsIntegrityEnhancementFacility, setPacketDebugBufferSize, setPadCharsWithSpace, setParanoid, setPedantic, setPinGlobalTxToPhysicalConnection, setPopulateInsertRowWithDefaultValues, setPreparedStatementCacheSize, setPreparedStatementCacheSqlLimit, setPrepStmtCacheSize, setPrepStmtCacheSqlLimit, setProcessEscapeCodesForPrepStmts, setProfilerEventHandler, setProfileSql, setProfileSQL, setPropertiesTransform, setQueriesBeforeRetryMaster, setReconnectAtTxEnd, setRelaxAutoCommit, setReportMetricsIntervalMillis, setRequireSSL, setResourceId, setResultSetSizeThreshold, setRetainStatementAfterResultSetClose, 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, setUseBlobToStoreUTF8OutsideBMP, setUseCompression, setUseConfigs, setUseCursorFetch, setUseDirectRowUnpack, setUseDynamicCharsetInfo, setUseFastDateParsing, setUseFastIntParsing, setUseGmtMillisForDatetimes, setUseHostsInPrivileges, setUseInformationSchema, setUseJDBCCompliantTimezoneShift, setUseJvmCharsetConverters, setUseLegacyDatetimeCode, setUseLocalSessionState, 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

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