|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--superwaba.ext.xplat.sql.Connection | +--superwaba.ext.xplat.sql.db2e.Db2eConnection
Creates a connection with the IBM DB2everyplace client
Fields inherited from class superwaba.ext.xplat.sql.Connection |
TRANSACTION_NONE,
TRANSACTION_READ_COMMITTED,
TRANSACTION_READ_UNCOMMITTED,
TRANSACTION_REPEATABLE_READ,
TRANSACTION_SERIALIZABLE |
Constructor Summary | |
Db2eConnection(Driver driver,
Db2e db,
int envHandle,
String db2eURL,
Hashtable info)
|
Method Summary | |
void |
clearWarnings()
This method clears all warnings that have occurred on this connection. |
void |
close()
This method immediately closes this database connection. |
void |
commit()
This method commits any SQL statements executed on this connection since the last commit or rollback. |
Statement |
createStatement()
This method creates a new SQL statement. |
Statement |
createStatement(int resultSetType,
int resultSetConcurrency)
This method creates a new SQL statement with the specified type and concurrency. |
boolean |
getAutoCommit()
This method tests whether or not auto commit mode is currently enabled. |
String |
getCatalog()
This method returns the name of the catalog in use by this connection, if any. |
DatabaseMetaData |
getMetaData()
This method returns the meta data for this database connection. |
int |
getTransactionIsolation()
This method returns the current transaction isolation mode. |
SQLWarning |
getWarnings()
This method returns the first warning that occurred on this connection, if any. |
boolean |
isClosed()
This method tests whether or not this connection has been closed. |
PreparedStatement |
prepareStatement(String sql)
This method creates a new PreparedStatement for the specified
SQL string. |
PreparedStatement |
prepareStatement(String sql,
int resultSetType,
int resultSetConcurrency)
This method creates a new PreparedStatement for the specified
SQL string. |
void |
rollback()
This method rolls back any SQL statements executed on this connection since the last commit or rollback. |
void |
setAutoCommit(boolean autoCommit)
This method turns auto commit mode on or off. |
void |
setCatalog(String catalog)
This method sets the name of the catalog in use by this connection. |
void |
setTransactionIsolation(int level)
This method sets the current transaction isolation mode. |
Methods inherited from class java.lang.Object |
equals,
getClass,
hashCode,
notify,
toString,
wait,
wait |
Constructor Detail |
public Db2eConnection(Driver driver, Db2e db, int envHandle, String db2eURL, Hashtable info) throws SQLException
Method Detail |
public void clearWarnings() throws SQLException
public void close() throws SQLException
public void commit() throws SQLException
public Statement createStatement() throws SQLException
Statement
object.Statement
public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException
ResultSet
class.resultSetType
- The type of result set to use for this statement.resultSetConcurrency.
- The type of concurrency to be used in
the result set for this statement.Statement
object.Statement
,
ResultSet
public boolean getAutoCommit() throws SQLException
true
if auto commit mode is enabled,
false
otherwise.commit()
,
rollback()
public String getCatalog() throws SQLException
null
if one does not
exist or catalogs are not supported by this database.public DatabaseMetaData getMetaData() throws SQLException
DatabaseMetaData
public int getTransactionIsolation() throws SQLException
public SQLWarning getWarnings() throws SQLException
SQLWarning
that occurred, or
null
if there have been no warnings.public boolean isClosed() throws SQLException
true
if the connection is closed, false
otherwise.public PreparedStatement prepareStatement(String sql) throws SQLException
PreparedStatement
for the specified
SQL string. This method is designed for use with parameterized
statements. The default result set type and concurrency will be used.The
- SQL statement to use in creating this
PreparedStatement
.PreparedStatement
.PreparedStatement
public PreparedStatement prepareStatement(String sql, int resultSetType, int resultSetConcurrency) throws SQLException
PreparedStatement
for the specified
SQL string. This method is designed for use with parameterized
statements. The specified result set type and concurrency will be used.
Valid values for these parameters are specified in the
ResultSet
class.The
- SQL statement to use in creating this
PreparedStatement
.resultSetType
- The type of result set to use for this statement.resultSetConcurrency.
- The type of concurrency to be used in
the result set for this statement.PreparedStatement
.PreparedStatement
,
ResultSet
public void rollback() throws SQLException
public void setAutoCommit(boolean autoCommit) throws SQLException
autoCommit
- true
to enable auto commit mode,
false
to disable it.commit()
,
rollback()
public void setCatalog(String catalog) throws SQLException
catalog
- The name of the catalog to use for this connection.public void setTransactionIsolation(int level) throws SQLException
level
- The transaction isolation level.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |