www.element4solution.com

e4s.db
Interface E4DBConnection_Intf

All Known Implementing Classes:
E4DBConnectionDefault, E4DBConnectionTransactional

public interface E4DBConnection_Intf

Interface for database access.

E4DBConnectionDefaultA single statement transaction (SST) connection which is recommended to be used for common and almost reading tasks, created early after application startup and valid until end of the application. Only one entity per database.
E4DBConnectionTransactionalRecommended to be used whenever transactions (commit/rollback) are required. Multiple instances, may force database or JDBC license to run out of connections in some cases.


Method Summary
 void close()
           
 boolean connectionIsPooled()
           
 java.lang.String getCatalog()
          Get the catalog.
 java.sql.DatabaseMetaData getDatabaseMetaData()
          Get the database meta data.
 int getDatabaseType()
           
 java.lang.String getID()
           
 java.util.Vector getIndexes(E4DBTableName tablename)
          Retrieve all index names out of the current database connection for the specified table.
 E4DBStatement getStatement()
          Create a new JDBC/SQL Statement.
 java.util.Vector getTables()
          Retrieve all tables out of the current database connection.
 boolean istabledefined(E4DBTableName check_tablename)
          Check for existance of a table
 

Method Detail

getStatement

E4DBStatement getStatement()
                           throws E4DBException
Create a new JDBC/SQL Statement.

Returns:
the new created Statement, associated with this current connection.
Throws:
E4DBException

getDatabaseMetaData

java.sql.DatabaseMetaData getDatabaseMetaData()
                                              throws E4DBException
Get the database meta data.

Returns:
the metadata information
Throws:
E4DBException

getIndexes

java.util.Vector getIndexes(E4DBTableName tablename)
                            throws E4DBException
Retrieve all index names out of the current database connection for the specified table.

Parameters:
tablename - the table to lookup
Returns:
a Vector of elements of type String
Throws:
E4DBException

getTables

java.util.Vector getTables()
                           throws E4DBException
Retrieve all tables out of the current database connection.

Returns:
a Vector of elements of type e4s.db.dict
Throws:
E4DBException
See Also:
E4DBTableName, #istabledefined(TableName)

istabledefined

boolean istabledefined(E4DBTableName check_tablename)
                       throws E4DBException
Check for existance of a table

Parameters:
check_tablename - the table who's existance to be prooven
Returns:
true, if the table exists
Throws:
E4DBException
See Also:
E4DBTableName, getTables()

connectionIsPooled

boolean connectionIsPooled()

close

void close()
           throws E4DBException
Throws:
E4DBException

getCatalog

java.lang.String getCatalog()
                            throws E4DBException
Get the catalog.

Returns:
the catalog
Throws:
E4DBException

getDatabaseType

int getDatabaseType()

getID

java.lang.String getID()

www.element4solution.com