All Packages  Class Hierarchy  This Package  Previous  Next  Index

Interface ibs.ebf.db.IConnection

public interface IConnection

See Also:

EbfConnection, IResultSet

clearWarnings()

Clears SQL warnings generated by the connection.

createStatement()

SQL statements without parameters are normally executed using Statement objects.

getCatalog()

Returns current connections catalog name.

getConnectionTimeStamp()

Returns a java.util.Date object containing timestamp that indicates the date/time when this connection was established.

getUrl()

Returns a URL string of the url that was used for establishing this connection.

getWarnings()

Returns a SQLWarning object containing SQL warnings generated by the connection.

isClosed()

Check to see if current connection is closed.

isReadOnly()

Tests to see if this connection is set to ReadOnly.

nativeSQL(String)

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.

prepareCall(String)

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object.

prepareStatement(String)

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object.

setAutoCommit(boolean)

setReadOnly(boolean)

Set this connection to ReadOnly.

setTransactionIsolation(int)

Set transaction isolation level ....

 public abstract SimpleDate getConnectionTimeStamp()

Returns a java.util.Date object containing timestamp that indicates the date/time when this connection was established.

See Also:

EbfConnectionPool

 public abstract String getUrl()

Returns a URL string of the url that was used for establishing this connection.

See Also:

EbfConnectionPool

 public abstract void setTransactionIsolation(int level) throws SQLException

Set transaction isolation level .... TRANSACTION_NONE
- Transactions are not supported.

TRANSACTION_READ_COMMITTED
- Dirty reads are prevented; non-repeatable reads and phantom reads can occur.

TRANSACTION_READ_UNCOMMITTED
- Dirty reads, non-repeatable reads and phantom reads can occur.

TRANSACTION_REPEATABLE_READ
- Dirty reads and non-repeatable reads are prevented; phantom reads can occur.

TRANSACTION_SERIALIZABLE
- Dirty reads, non-repeatable reads and phantom reads are prevented.

Parameters:

level - Transaction isolation level

Throws: SQLException

In case of any sql errors.

See Also:

Connection

 public abstract SQLWarning getWarnings() throws SQLException

Returns a SQLWarning object containing SQL warnings generated by the connection.

See Also:

SQLWarning

 public abstract void clearWarnings() throws SQLException

Clears SQL warnings generated by the connection.

See Also:

SQLWarning

 public abstract boolean isReadOnly() throws SQLException

Tests to see if this connection is set to ReadOnly.

See Also:

Connection

 public abstract void setAutoCommit(boolean autoCommit) throws SQLException

 public abstract boolean isClosed() throws SQLException

Check to see if current connection is closed. Returns true if closed, otherwise false.

Returns:

A boolean value.

 public abstract String nativeSQL(String sql_string) 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.

Returns:

A String containing native form of the statement that the driver would have sent.

Throws: SQLException

In case of any sql errors.

See Also:

Connection

 public abstract String getCatalog() throws SQLException

Returns current connections catalog name.

Throws: SQLException

In case of any sql errors.

See Also:

Connection

 public abstract void setReadOnly(boolean read_only) throws SQLException

Set this connection to ReadOnly. This settings cannot be changed in the middle of a transaction.

Parameters:

read_only - A boolean value indicating whether to set current transaction read only or not.

Throws: SQLException

In case of any sql errors.

See Also:

Connection

 public abstract 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.

See Also:

Connection, PreparedStatement

 public abstract CallableStatement prepareCall(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.

See Also:

Connection, CallableStatement

 public abstract 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

See Also:

Connection, Statement

All Packages  Class Hierarchy  This Package  Previous  Next  Index