Home » MySQL-JDBC-5.1.11 » com.mysql.jdbc » [javadoc | source]
com.mysql.jdbc
public class: ConnectionImpl [javadoc | source]
java.lang.Object
   com.mysql.jdbc.ConnectionPropertiesImpl
      com.mysql.jdbc.ConnectionImpl

All Implemented Interfaces:
    Connection, Serializable, ConnectionProperties

Direct Known Subclasses:
    JDBC4Connection

A Connection represents a session with a specific database. Within the context of a Connection, SQL statements are executed and results are returned.

A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is obtained with the getMetaData method.

Nested Class Summary:
class  ConnectionImpl.ExceptionInterceptorChain   
class  ConnectionImpl.CompoundCacheKey  Used as a key for caching callable statements which (may) depend on current catalog...In 5.0.x, they don't (currently), but stored procedure names soon will, so current catalog is a (hidden) component of the name. 
Field Summary
public static  Map charsetMap    The mapping between MySQL charset names and Java charset names. Initialized by loadCharacterSetMapping() 
protected static final  String DEFAULT_LOGGER_CLASS    Default logger class name 
protected  Properties props    Properties for this connection specified by user 
protected  LRUCache resultSetMetadataCache    Cache of ResultSet metadata 
Fields inherited from com.mysql.jdbc.ConnectionPropertiesImpl:
ZERO_DATETIME_BEHAVIOR_CONVERT_TO_NULL,  ZERO_DATETIME_BEHAVIOR_EXCEPTION,  ZERO_DATETIME_BEHAVIOR_ROUND,  largeRowSizeThreshold
Constructor:
 protected ConnectionImpl() 
 protected ConnectionImpl(String hostToConnectTo,
    int portToConnectTo,
    Properties info,
    String databaseToConnectTo,
    String url) throws SQLException 
    Creates a connection to a MySQL Server.
    Parameters:
    hostToConnectTo - the hostname of the database server
    portToConnectTo - the port number the server is listening on
    info - a Properties[] list holding the user and password
    databaseToConnectTo - the database to connect to
    url - the URL of the connection
    d - the Driver instantation of the connection
    Throws:
    SQLException - if a database access error occurs
    exception: SQLException - if a database access error occurs
Method from com.mysql.jdbc.ConnectionImpl Summary:
abortInternal,   appendMessageToException,   changeUser,   checkClosed,   clearHasTriedMaster,   clearWarnings,   clientPrepareStatement,   clientPrepareStatement,   clientPrepareStatement,   clientPrepareStatement,   clientPrepareStatement,   clientPrepareStatement,   clientPrepareStatement,   close,   commit,   createNewIO,   createStatement,   createStatement,   createStatement,   dumpTestcaseQuery,   duplicate,   execSQL,   execSQL,   extractSqlFromPacket,   finalize,   generateConnectionCommentBlock,   getActiveStatementCount,   getAutoCommit,   getAutoIncrementIncrement,   getCachedMetaData,   getCalendarInstanceForSessionOrNew,   getCancelTimer,   getCatalog,   getCharacterSetMetadata,   getCharsetConverter,   getCharsetNameForIndex,   getDefaultTimeZone,   getErrorMessageEncoding,   getExceptionInterceptor,   getHoldability,   getIO,   getId,   getIdleFor,   getInstance,   getLog,   getMaxBytesPerChar,   getMetaData,   getMetadataSafeStatement,   getMutex,   getNetBufferLength,   getProperties,   getRequiresEscapingEncoder,   getServerCharacterEncoding,   getServerMajorVersion,   getServerMinorVersion,   getServerSubMinorVersion,   getServerTimezoneTZ,   getServerVariable,   getServerVersion,   getSessionLockedCalendar,   getStatementComment,   getStatementInterceptorsInstances,   getTransactionIsolation,   getTypeMap,   getURL,   getUser,   getUtcCalendar,   getWarnings,   hasSameProperties,   hasTriedMaster,   incrementNumberOfPreparedExecutes,   incrementNumberOfPrepares,   incrementNumberOfResultSetsCreated,   initializeExtension,   initializeResultsMetadataFromCache,   initializeSafeStatementInterceptors,   isAbonormallyLongQuery,   isClientTzUTC,   isClosed,   isCursorFetchEnabled,   isInGlobalTx,   isMasterConnection,   isNoBackslashEscapesSet,   isReadInfoMsgEnabled,   isReadOnly,   isRunningOnJDK13,   isSameResource,   isServerTzUTC,   lowerCaseTableNames,   maxRowsChanged,   nativeSQL,   parserKnowsUnicode,   ping,   pingInternal,   prepareCall,   prepareCall,   prepareCall,   prepareStatement,   prepareStatement,   prepareStatement,   prepareStatement,   prepareStatement,   prepareStatement,   realClose,   recachePreparedStatement,   registerQueryExecutionTime,   registerStatement,   releaseSavepoint,   reportNumberOfTablesAccessed,   reportQueryTime,   resetServerState,   rollback,   rollback,   serverPrepareStatement,   serverPrepareStatement,   serverPrepareStatement,   serverPrepareStatement,   serverPrepareStatement,   serverPrepareStatement,   serverSupportsConvertFn,   setAutoCommit,   setCatalog,   setFailedOver,   setHoldability,   setInGlobalTx,   setPreferSlaveDuringFailover,   setReadInfoMsgEnabled,   setReadOnly,   setReadOnlyInternal,   setSavepoint,   setSavepoint,   setStatementComment,   setTransactionIsolation,   setTypeMap,   shutdownServer,   storesLowerCaseTableName,   supportsIsolationLevel,   supportsQuotedIdentifiers,   supportsTransactions,   throwConnectionClosedException,   transactionBegun,   transactionCompleted,   unSafeStatementInterceptors,   unregisterStatement,   unsetMaxRows,   useAnsiQuotedIdentifiers,   useMaxRows,   versionMeetsMinimum
Methods from com.mysql.jdbc.ConnectionPropertiesImpl:
exposeAsDriverPropertyInfo,   exposeAsDriverPropertyInfoInternal,   exposeAsProperties,   exposeAsXml,   getAllowLoadLocalInfile,   getAllowMultiQueries,   getAllowNanAndInf,   getAllowUrlInLocalInfile,   getAlwaysSendSetIsolation,   getAutoClosePStmtStreams,   getAutoDeserialize,   getAutoGenerateTestcaseScript,   getAutoReconnectForPools,   getAutoSlowLog,   getBlobSendChunkSize,   getBlobsAreStrings,   getCacheCallableStatements,   getCacheCallableStmts,   getCachePrepStmts,   getCachePreparedStatements,   getCacheResultSetMetadata,   getCacheServerConfiguration,   getCallableStatementCacheSize,   getCallableStmtCacheSize,   getCapitalizeTypeNames,   getCharacterSetResults,   getClientCertificateKeyStorePassword,   getClientCertificateKeyStoreType,   getClientCertificateKeyStoreUrl,   getClientInfoProvider,   getClobCharacterEncoding,   getClobberStreamingResults,   getCompensateOnDuplicateKeyUpdateCounts,   getConnectTimeout,   getConnectionCollation,   getConnectionLifecycleInterceptors,   getContinueBatchOnError,   getCreateDatabaseIfNotExist,   getDefaultFetchSize,   getDontTrackOpenResources,   getDumpMetadataOnColumnNotFound,   getDumpQueriesOnException,   getDynamicCalendars,   getElideSetAutoCommits,   getEmptyStringsConvertToZero,   getEmulateLocators,   getEmulateUnsupportedPstmts,   getEnablePacketDebug,   getEnableQueryTimeouts,   getEncoding,   getExceptionInterceptor,   getExceptionInterceptors,   getExplainSlowQueries,   getFailOverReadOnly,   getFunctionsNeverReturnBlobs,   getGatherPerfMetrics,   getGatherPerformanceMetrics,   getGenerateSimpleParameterMetadata,   getHighAvailability,   getHoldResultsOpenOverStatementClose,   getIgnoreNonTxTables,   getIncludeInnodbStatusInDeadlockExceptions,   getInitialTimeout,   getInteractiveClient,   getIsInteractiveClient,   getJdbcCompliantTruncation,   getJdbcCompliantTruncationForReads,   getLargeRowSizeThreshold,   getLoadBalanceBlacklistTimeout,   getLoadBalanceStrategy,   getLocalSocketAddress,   getLocatorFetchBufferSize,   getLogSlowQueries,   getLogXaCommands,   getLogger,   getLoggerClassName,   getMaintainTimeStats,   getMaxAllowedPacket,   getMaxQuerySizeToLog,   getMaxReconnects,   getMaxRows,   getMetadataCacheSize,   getNetTimeoutForStreamingResults,   getNoAccessToProcedureBodies,   getNoDatetimeStringSync,   getNoTimezoneConversionForTimeType,   getNullCatalogMeansCurrent,   getNullNamePatternMatchesAll,   getOverrideSupportsIntegrityEnhancementFacility,   getPacketDebugBufferSize,   getPadCharsWithSpace,   getParanoid,   getPasswordCharacterEncoding,   getPedantic,   getPinGlobalTxToPhysicalConnection,   getPopulateInsertRowWithDefaultValues,   getPrepStmtCacheSize,   getPrepStmtCacheSqlLimit,   getPreparedStatementCacheSize,   getPreparedStatementCacheSqlLimit,   getProcessEscapeCodesForPrepStmts,   getProfileSQL,   getProfileSql,   getProfilerEventHandler,   getPropertiesTransform,   getQueriesBeforeRetryMaster,   getQueryTimeoutKillsConnection,   getReconnectAtTxEnd,   getRelaxAutoCommit,   getReportMetricsIntervalMillis,   getRequireSSL,   getResourceId,   getResultSetSizeThreshold,   getRetainStatementAfterResultSetClose,   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,   getUseSSL,   getUseSSPSCompatibleTimezoneShift,   getUseServerPrepStmts,   getUseServerPreparedStmts,   getUseSqlStateCodes,   getUseStreamLengthsInPrepStmts,   getUseTimezone,   getUseUltraDevWorkAround,   getUseUnbufferedInput,   getUseUnicode,   getUseUsageAdvisor,   getUtf8OutsideBmpExcludedColumnNamePattern,   getUtf8OutsideBmpIncludedColumnNamePattern,   getVerifyServerCertificate,   getYearIsDateType,   getZeroDateTimeBehavior,   initializeFromRef,   initializeProperties,   postInitialization,   setAllowLoadLocalInfile,   setAllowMultiQueries,   setAllowNanAndInf,   setAllowUrlInLocalInfile,   setAlwaysSendSetIsolation,   setAutoClosePStmtStreams,   setAutoDeserialize,   setAutoGenerateTestcaseScript,   setAutoReconnect,   setAutoReconnectForConnectionPools,   setAutoReconnectForPools,   setAutoSlowLog,   setBlobSendChunkSize,   setBlobsAreStrings,   setCacheCallableStatements,   setCacheCallableStmts,   setCachePrepStmts,   setCachePreparedStatements,   setCacheResultSetMetadata,   setCacheServerConfiguration,   setCallableStatementCacheSize,   setCallableStmtCacheSize,   setCapitalizeDBMDTypes,   setCapitalizeTypeNames,   setCharacterEncoding,   setCharacterSetResults,   setClientCertificateKeyStorePassword,   setClientCertificateKeyStoreType,   setClientCertificateKeyStoreUrl,   setClientInfoProvider,   setClobCharacterEncoding,   setClobberStreamingResults,   setCompensateOnDuplicateKeyUpdateCounts,   setConnectTimeout,   setConnectionCollation,   setConnectionLifecycleInterceptors,   setContinueBatchOnError,   setCreateDatabaseIfNotExist,   setDefaultFetchSize,   setDetectServerPreparedStmts,   setDontTrackOpenResources,   setDumpMetadataOnColumnNotFound,   setDumpQueriesOnException,   setDynamicCalendars,   setElideSetAutoCommits,   setEmptyStringsConvertToZero,   setEmulateLocators,   setEmulateUnsupportedPstmts,   setEnablePacketDebug,   setEnableQueryTimeouts,   setEncoding,   setExceptionInterceptors,   setExplainSlowQueries,   setFailOverReadOnly,   setFunctionsNeverReturnBlobs,   setGatherPerfMetrics,   setGatherPerformanceMetrics,   setGenerateSimpleParameterMetadata,   setHighAvailability,   setHoldResultsOpenOverStatementClose,   setIgnoreNonTxTables,   setIncludeInnodbStatusInDeadlockExceptions,   setInitialTimeout,   setInteractiveClient,   setIsInteractiveClient,   setJdbcCompliantTruncation,   setJdbcCompliantTruncationForReads,   setLargeRowSizeThreshold,   setLoadBalanceBlacklistTimeout,   setLoadBalanceStrategy,   setLocalSocketAddress,   setLocatorFetchBufferSize,   setLogSlowQueries,   setLogXaCommands,   setLogger,   setLoggerClassName,   setMaintainTimeStats,   setMaxAllowedPacket,   setMaxQuerySizeToLog,   setMaxReconnects,   setMaxRows,   setMetadataCacheSize,   setNetTimeoutForStreamingResults,   setNoAccessToProcedureBodies,   setNoDatetimeStringSync,   setNoTimezoneConversionForTimeType,   setNullCatalogMeansCurrent,   setNullNamePatternMatchesAll,   setOverrideSupportsIntegrityEnhancementFacility,   setPacketDebugBufferSize,   setPadCharsWithSpace,   setParanoid,   setPasswordCharacterEncoding,   setPedantic,   setPinGlobalTxToPhysicalConnection,   setPopulateInsertRowWithDefaultValues,   setPrepStmtCacheSize,   setPrepStmtCacheSqlLimit,   setPreparedStatementCacheSize,   setPreparedStatementCacheSqlLimit,   setProcessEscapeCodesForPrepStmts,   setProfileSQL,   setProfileSql,   setProfilerEventHandler,   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,   setUseSSL,   setUseSSPSCompatibleTimezoneShift,   setUseServerPrepStmts,   setUseServerPreparedStmts,   setUseSqlStateCodes,   setUseStreamLengthsInPrepStmts,   setUseTimezone,   setUseUltraDevWorkAround,   setUseUnbufferedInput,   setUseUnicode,   setUseUsageAdvisor,   setUtf8OutsideBmpExcludedColumnNamePattern,   setUtf8OutsideBmpIncludedColumnNamePattern,   setVerifyServerCertificate,   setYearIsDateType,   setZeroDateTimeBehavior,   storeToRef,   useUnbufferedInput
Methods from java.lang.Object:
clone,   equals,   finalize,   getClass,   hashCode,   notify,   notifyAll,   toString,   wait,   wait,   wait
Method from com.mysql.jdbc.ConnectionImpl Detail:
 protected  void abortInternal() throws SQLException 
    Clobbers the physical network connection and marks this connection as closed.
 protected static SQLException appendMessageToException(SQLException sqlEx,
    String messageToAppend,
    ExceptionInterceptor interceptor) 
 public  void changeUser(String userName,
    String newPassword) throws 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.
 protected  void checkClosed() throws SQLException 
 public  void clearHasTriedMaster() 
 public  void clearWarnings() throws SQLException 
    After this call, getWarnings returns null until a new warning is reported for this connection.
 public PreparedStatement clientPrepareStatement(String sql) throws SQLException 
    DOCUMENT ME!
 public PreparedStatement clientPrepareStatement(String sql,
    int autoGenKeyIndex) throws SQLException 
 public PreparedStatement clientPrepareStatement(String sql,
    int[] autoGenKeyIndexes) throws SQLException 
 public PreparedStatement clientPrepareStatement(String sql,
    String[] autoGenKeyColNames) throws SQLException 
 public PreparedStatement clientPrepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency) throws SQLException 
    DOCUMENT ME!
 protected PreparedStatement clientPrepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency,
    boolean processEscapeCodesIfNeeded) throws SQLException 
 public PreparedStatement clientPrepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency,
    int resultSetHoldability) throws SQLException 
 public synchronized  void close() throws SQLException 
    In some cases, it is desirable to immediately release a Connection's database and JDBC resources instead of waiting for them to be automatically released (cant think why off the top of my head) Note: A Connection is automatically closed when it is garbage collected. Certain fatal errors also result in a closed connection.
 public  void commit() throws SQLException 
    The method commit() makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection. This method should only be used when auto-commit has been disabled.

    Note: MySQL does not support transactions, so this method is a no-op.

 protected  void createNewIO(boolean isForReconnect) throws SQLException 
    Creates an IO channel to the server
 public Statement createStatement() throws SQLException 
    SQL statements without parameters are normally executed using Statement objects. If the same SQL statement is executed many times, it is more efficient to use a PreparedStatement
 public Statement createStatement(int resultSetType,
    int resultSetConcurrency) throws SQLException 
    JDBC 2.0 Same as createStatement() above, but allows the default result set type and result set concurrency type to be overridden.
 public Statement createStatement(int resultSetType,
    int resultSetConcurrency,
    int resultSetHoldability) throws SQLException 
 protected  void dumpTestcaseQuery(String query) 
 protected Connection duplicate() throws SQLException 
 ResultSetInternalMethods execSQL(StatementImpl callingStatement,
    String sql,
    int maxRows,
    Buffer packet,
    int resultSetType,
    int resultSetConcurrency,
    boolean streamResults,
    String catalog,
    Field[] cachedMetadata) throws SQLException 
    Send a query to the server. Returns one of the ResultSet objects. This is synchronized, so Statement's queries will be serialized.
 ResultSetInternalMethods execSQL(StatementImpl callingStatement,
    String sql,
    int maxRows,
    Buffer packet,
    int resultSetType,
    int resultSetConcurrency,
    boolean streamResults,
    String catalog,
    Field[] cachedMetadata,
    boolean isBatch) throws SQLException 
 protected String extractSqlFromPacket(String possibleSqlQuery,
    Buffer queryPacket,
    int endOfQueryPacketPosition) throws SQLException 
 protected  void finalize() throws Throwable 
    DOCUMENT ME!
 protected StringBuffer generateConnectionCommentBlock(StringBuffer buf) 
 public int getActiveStatementCount() 
 public boolean getAutoCommit() throws SQLException 
    Gets the current auto-commit state
 public int getAutoIncrementIncrement() 
 protected CachedResultSetMetaData getCachedMetaData(String sql) 
    Returns cached metadata (or null if not cached) for the given query, which must match _exactly_. This method is synchronized by the caller on getMutex(), so if calling this method from internal code in the driver, make sure it's synchronized on the mutex that guards communication with the server.
 protected Calendar getCalendarInstanceForSessionOrNew() 
    Optimization to only use one calendar per-session, or calculate it for each call, depending on user configuration
 protected synchronized Timer getCancelTimer() 
 public String getCatalog() throws SQLException 
    Return the connections current catalog name, or null if no catalog name is set, or we dont support catalogs.

    Note: MySQL's notion of catalogs are individual databases.

 protected String getCharacterSetMetadata() 
 SingleByteCharsetConverter getCharsetConverter(String javaEncodingName) throws SQLException 
    Returns the locally mapped instance of a charset converter (to avoid overhead of static synchronization).
 protected String getCharsetNameForIndex(int charsetIndex) throws SQLException 
    Returns the Java character encoding name for the given MySQL server charset index
 protected TimeZone getDefaultTimeZone() 
    DOCUMENT ME!
 protected String getErrorMessageEncoding() 
 public ExceptionInterceptor getExceptionInterceptor() 
 public int getHoldability() throws SQLException 
 protected MysqlIO getIO() throws SQLException 
    Returns the IO channel to the server
 long getId() 
 public long getIdleFor() 
    NOT JDBC-Compliant, but clients can use this method to determine how long this connection has been idle. This time (reported in milliseconds) is updated once a query has completed.
 protected static Connection getInstance(String hostToConnectTo,
    int portToConnectTo,
    Properties info,
    String databaseToConnectTo,
    String url) throws SQLException 
    Creates a connection instance -- We need to provide factory-style methods so we can support both JDBC3 (and older) and JDBC4 runtimes, otherwise the class verifier complains when it tries to load JDBC4-only interface classes that are present in JDBC4 method signatures.
 public Log getLog() throws SQLException 
    Returns the log mechanism that should be used to log information from/for this Connection.
 protected int getMaxBytesPerChar(String javaCharsetName) throws SQLException 
 public DatabaseMetaData getMetaData() throws SQLException 
    A connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is made available through a DatabaseMetaData object.
 protected Statement getMetadataSafeStatement() throws SQLException 
 Object getMutex() throws SQLException 
    Returns the Mutex all queries are locked against
 int getNetBufferLength() 
    Returns the packet buffer size the MySQL server reported upon connection
 public Properties getProperties() 
 public boolean getRequiresEscapingEncoder() 
 public String getServerCharacterEncoding() 
    Returns the server's character set
 int getServerMajorVersion() 
 int getServerMinorVersion() 
 int getServerSubMinorVersion() 
 public TimeZone getServerTimezoneTZ() 
    DOCUMENT ME!
 String getServerVariable(String variableName) 
 String getServerVersion() 
 protected Calendar getSessionLockedCalendar() 
 public String getStatementComment() 
    Returns the comment that will be prepended to all statements sent to the server.
 protected List getStatementInterceptorsInstances() 
 public int getTransactionIsolation() throws SQLException 
    Get this Connection's current transaction isolation mode.
 public synchronized Map getTypeMap() throws SQLException 
    JDBC 2.0 Get the type-map object associated with this connection. By default, the map returned is empty.
 String getURL() 
 String getUser() 
 protected Calendar getUtcCalendar() 
 public SQLWarning getWarnings() throws SQLException 
    The first warning reported by calls on this Connection is returned. Note: Sebsequent warnings will be changed to this java.sql.SQLWarning
 public boolean hasSameProperties(Connection c) 
 public boolean hasTriedMaster() 
 protected  void incrementNumberOfPreparedExecutes() 
 protected  void incrementNumberOfPrepares() 
 protected  void incrementNumberOfResultSetsCreated() 
 public  void initializeExtension(Extension ex) throws SQLException 
 protected  void initializeResultsMetadataFromCache(String sql,
    CachedResultSetMetaData cachedMetaData,
    ResultSetInternalMethods resultSet) throws SQLException 
    Caches CachedResultSetMetaData that has been placed in the cache using the given SQL as a key. This method is synchronized by the caller on getMutex(), so if calling this method from internal code in the driver, make sure it's synchronized on the mutex that guards communication with the server.
 protected  void initializeSafeStatementInterceptors() throws SQLException 
 public synchronized boolean isAbonormallyLongQuery(long millisOrNanos) 
 protected boolean isClientTzUTC() 
 public boolean isClosed() 
    DOCUMENT ME!
 protected boolean isCursorFetchEnabled() throws SQLException 
 public boolean isInGlobalTx() 
 public synchronized boolean isMasterConnection() 
    Is this connection connected to the first host in the list if there is a list of servers in the URL?
 public boolean isNoBackslashEscapesSet() 
    Is the server in a sql_mode that doesn't allow us to use \\ to escape things?
 boolean isReadInfoMsgEnabled() 
 public boolean isReadOnly() throws SQLException 
    Tests to see if the connection is in Read Only Mode. Note that we cannot really put the database in read only mode, but we pretend we can by returning the value of the readOnly flag
 protected boolean isRunningOnJDK13() 
 public synchronized boolean isSameResource(Connection otherConnection) 
 protected boolean isServerTzUTC() 
 public boolean lowerCaseTableNames() 
    Is the server configured to use lower-case table names only?
  void maxRowsChanged(Statement stmt) 
    Has the maxRows value changed?
 public String nativeSQL(String sql) throws SQLException 
    A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; nativeSQL returns the native form of the statement that the driver would have sent.
 public boolean parserKnowsUnicode() 
    DOCUMENT ME!
 public  void ping() throws SQLException 
    Detect if the connection is still good
 protected  void pingInternal(boolean checkForClosedConnection,
    int timeoutMillis) throws SQLException 
 public CallableStatement prepareCall(String sql) throws SQLException 
    DOCUMENT ME!
 public CallableStatement prepareCall(String sql,
    int resultSetType,
    int resultSetConcurrency) throws SQLException 
    JDBC 2.0 Same as prepareCall() above, but allows the default result set type and result set concurrency type to be overridden.
 public CallableStatement prepareCall(String sql,
    int resultSetType,
    int resultSetConcurrency,
    int resultSetHoldability) throws SQLException 
 public PreparedStatement prepareStatement(String sql) throws SQLException 
    A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

    Note: This method is optimized for handling parametric SQL statements that benefit from precompilation if the driver supports precompilation. In this case, the statement is not sent to the database until the PreparedStatement is executed. This has no direct effect on users; however it does affect which method throws certain java.sql.SQLExceptions

    MySQL does not support precompilation of statements, so they are handled by the driver.

 public PreparedStatement prepareStatement(String sql,
    int autoGenKeyIndex) throws SQLException 
 public PreparedStatement prepareStatement(String sql,
    int[] autoGenKeyIndexes) throws SQLException 
 public PreparedStatement prepareStatement(String sql,
    String[] autoGenKeyColNames) throws SQLException 
 public PreparedStatement prepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency) throws SQLException 
    JDBC 2.0 Same as prepareStatement() above, but allows the default result set type and result set concurrency type to be overridden.
 public PreparedStatement prepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency,
    int resultSetHoldability) throws SQLException 
 protected  void realClose(boolean calledExplicitly,
    boolean issueRollback,
    boolean skipLocalTeardown,
    Throwable reason) throws SQLException 
    Closes connection and frees resources.
 protected  void recachePreparedStatement(ServerPreparedStatement pstmt) throws SQLException 
 protected  void registerQueryExecutionTime(long queryTimeMs) 
    DOCUMENT ME!
  void registerStatement(Statement stmt) 
    Register a Statement instance as open.
 public  void releaseSavepoint(Savepoint arg0) throws SQLException 
 protected  void reportNumberOfTablesAccessed(int numTablesAccessed) 
 public synchronized  void reportQueryTime(long millisOrNanos) 
 public  void resetServerState() throws 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.
 public  void rollback() throws SQLException 
    The method rollback() drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.
 public  void rollback(Savepoint savepoint) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql,
    int autoGenKeyIndex) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql,
    int[] autoGenKeyIndexes) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql,
    String[] autoGenKeyColNames) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency) throws SQLException 
 public PreparedStatement serverPrepareStatement(String sql,
    int resultSetType,
    int resultSetConcurrency,
    int resultSetHoldability) throws SQLException 
 protected boolean serverSupportsConvertFn() throws SQLException 
 public  void setAutoCommit(boolean autoCommitFlag) throws SQLException 
    If a connection is in auto-commit mode, than all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by either commit() or rollback(). By default, new connections are in auto- commit mode. The commit occurs when the statement completes or the next execute occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes when the last row of the ResultSet has been retrieved or the ResultSet has been closed. In advanced cases, a single statement may return multiple results as well as output parameter values. Here the commit occurs when all results and output param values have been retrieved.

    Note: MySQL does not support transactions, so this method is a no-op.

 public  void setCatalog(String catalog) throws SQLException 
    A sub-space of this Connection's database may be selected by setting a catalog name. If the driver does not support catalogs, it will silently ignore this request

    Note: MySQL's notion of catalogs are individual databases.

 public synchronized  void setFailedOver(boolean flag) 
 public  void setHoldability(int arg0) throws SQLException 
 public  void setInGlobalTx(boolean flag) 
 public  void setPreferSlaveDuringFailover(boolean flag) 
  void setReadInfoMsgEnabled(boolean flag) 
 public  void setReadOnly(boolean readOnlyFlag) throws SQLException 
    You can put a connection in read-only mode as a hint to enable database optimizations Note: setReadOnly cannot be called while in the middle of a transaction
 protected  void setReadOnlyInternal(boolean readOnlyFlag) throws SQLException 
 public Savepoint setSavepoint() throws SQLException 
 public synchronized Savepoint setSavepoint(String name) throws SQLException 
 public  void setStatementComment(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.
 public synchronized  void setTransactionIsolation(int level) throws SQLException 
    DOCUMENT ME!
 public synchronized  void setTypeMap(Map map) throws SQLException 
    JDBC 2.0 Install a type-map object as the default type-map for this connection
 public  void shutdownServer() throws SQLException 
    Used by MiniAdmin to shutdown a MySQL server
 public boolean storesLowerCaseTableName() 
 public boolean supportsIsolationLevel() 
    DOCUMENT ME!
 public boolean supportsQuotedIdentifiers() 
    DOCUMENT ME!
 public boolean supportsTransactions() 
    DOCUMENT ME!
  void throwConnectionClosedException() throws SQLException 
 protected  void transactionBegun() throws SQLException 
 protected  void transactionCompleted() throws SQLException 
 protected  void unSafeStatementInterceptors() throws SQLException 
  void unregisterStatement(Statement stmt) 
    Remove the given statement from the list of open statements
  void unsetMaxRows(Statement stmt) throws SQLException 
    Called by statements on their .close() to let the connection know when it is safe to set the connection back to 'default' row limits.
 boolean useAnsiQuotedIdentifiers() 
 boolean useMaxRows() 
    Has maxRows() been set?
 public boolean versionMeetsMinimum(int major,
    int minor,
    int subminor) throws SQLException