|
| |
|
| java.lang.Object
 workbench.db.WbConnection
| CONNECTION_CLOSED | | final public static String CONNECTION_CLOSED(Code) | | |
| CONNECTION_OPEN | | final public static String CONNECTION_OPEN(Code) | | |
| PROP_AUTOCOMMIT | | final public static String PROP_AUTOCOMMIT(Code) | | |
| PROP_CONNECTION_STATE | | final public static String PROP_CONNECTION_STATE(Code) | | |
| clearWarnings | | public void clearWarnings()(Code) | | This will clear the warnings from the connection object.
Some drivers will not replace existing warnings until clearWarnings()
is called, thus SQL Workbench would show the same error message over and
over again.
This method also works around a bug in the Oracle JDBC driver, because
that does not properly clear the warnings list.
|
| close | | public void close()(Code) | | This will actually close the connection to the DBMS.
It will also free an resources from the DbMetadata object and
shutdown the keep alive thread.
|
| createStatementForQuery | | public Statement createStatementForQuery() throws SQLException(Code) | | Create a statement that produces ResultSets that
are read only and forward only (for performance reasons)
If the profile defined a default fetch size, this
will be set as well.
throws:
java.sql.SQLException - |
| disconnect | | public void disconnect()(Code) | | Disconnect this connection. This is delegated to the Connection Manager
because for certain DBMS some cleanup works needs to be done.
And the ConnectionMgr is the only one who knows if there are more connections
around, which might influence what needs to be cleaned up
(Currently this is only HSQLDB, but who knows...)
|
| getAutoCommit | | public boolean getAutoCommit()(Code) | | |
| getCurrentUser | | public String getCurrentUser()(Code) | | Return the name of the current user.
Wrapper for DatabaseMetaData.getUserName() that throws no Exception
|
| getDDLNeedsCommit | | protected boolean getDDLNeedsCommit()(Code) | | Some DBMS need to commit DDL (CREATE, DROP, ...) statements.
If the current connection needs a commit for a DDL, this will return true.
The metadata class reads the names of those DBMS from the Settings object!
|
| getDatabaseInfoAsXml | | public StrBuffer getDatabaseInfoAsXml(StrBuffer indent, String namespace)(Code) | | Returns information about the DBMS and the JDBC driver
in the XML format used for the XML export
|
| getDatabaseProductName | | public String getDatabaseProductName()(Code) | | |
| getId | | public String getId()(Code) | | Returns the internal ID of this connection.
the internal id of this connection. |
| getIgnoreDropErrors | | public boolean getIgnoreDropErrors()(Code) | | |
| getWarnings | | public String getWarnings()(Code) | | Return any warnings that are stored in the underlying SQL Connection.
The warnings are then cleared from the connection object.
See Also: WbConnection.clearWarnings() any warnings reported from the server, null if no warnings are available. |
| hashCode | | public int hashCode()(Code) | | |
| isBusy | | public boolean isBusy()(Code) | | |
| isClosed | | public boolean isClosed()(Code) | | |
| releaseSavepoint | | public void releaseSavepoint(Savepoint sp)(Code) | | A non-exception throwing wrapper around Connection.releaseSavepoint(Savepoint)
|
| rollback | | public void rollback(Savepoint sp)(Code) | | A non-exception throwing wrapper around Connection.rollback(Savepoint)
|
| rollback | | public void rollback() throws SQLException(Code) | | Execute a rollback on the connection.
|
| runPostConnectScript | | void runPostConnectScript()(Code) | | |
| runPreDisconnectScript | | void runPreDisconnectScript()(Code) | | |
| setBusy | | public void setBusy(boolean flag)(Code) | | |
| shouldCommitDDL | | public boolean shouldCommitDDL()(Code) | | Checks if DDL statement need a commit for this connection.
false if autocommit is on or the DBMS does not support DDL transactions
See Also: WbConnection.getDdlNeedsCommit() |
| supportsQueryTimeout | | public boolean supportsQueryTimeout()(Code) | | |
| supportsSavepoints | | public boolean supportsSavepoints()(Code) | | |
| toggleAutoCommit | | public void toggleAutoCommit()(Code) | | |
| useJdbcCommit | | public boolean useJdbcCommit()(Code) | | |
|
|
|