Contents | Package | Class | Tree | Deprecated | Index | Help
PREV | NEXT SHOW LISTS | HIDE LISTS

Class jora.Session

java.lang.Object
    |
    +----jora.Session

public class Session
extends java.lang.Object
This class is reposnsible for establishing connection with database and handling database errors.


Field Summary
java.sql.Connection  connection
 
 

Constructor Summary
 Session(java.lang.String driverClass)
Session consructor
 Session()
Session consructor for ODBC bridge driver
 

Method Summary
void  close()
Close database session and release all resources holded by session.
void  commit()
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
int  execute(java.lang.String sql)
Execute a SQL INSERT, UPDATE or DELETE statement.
void  handleSQLException(java.sql.SQLException ex)
Handler of database session errors.
boolean  open(java.lang.String dataSource, java.lang.String user, java.lang.String password)
Open database session.
void  rollback()
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.
 
Methods inherited from class java.lang.Object
 equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

connection

public java.sql.Connection connection
Constructor Detail

Session

public Session(java.lang.String driverClass)
Session consructor
Parameters:
driverClass - class of database driver

Session

public Session()
Session consructor for ODBC bridge driver
Method Detail

handleSQLException

public void handleSQLException(java.sql.SQLException ex)
Handler of database session errors. Programmer should override this method in derived class in order to provide application dependent error handling.
Parameters:
ex - exception thrown by some of JDBC methods

open

public boolean open(java.lang.String dataSource,
                    java.lang.String user,
                    java.lang.String password)
Open database session. Attempt to establish a connection to the given database URL. The DriverManager attempts to select an appropriate driver from the set of registered JDBC drivers.
Parameters:
url - a database url of the form jdbc:subprotocol:subname
user - the database user on whose behalf the Connection is being made
password - the user's password
Returns:
true if session is succesfully openned, false otherwise

close

public void close()
Close database session and release all resources holded by session.

execute

public int execute(java.lang.String sql)
Execute a SQL INSERT, UPDATE or DELETE statement. In addition, SQL statements that return nothing such as SQL DDL statements can be executed.
Parameters:
sql - a SQL INSERT, UPDATE or DELETE statement or a SQL statement that returns nothing
Returns:
either the row count for INSERT, UPDATE or DELETE or 0 for SQL statements that return nothing

commit

public void commit()
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.

rollback

public void rollback()
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection. This method should only be used when auto commit has been disabled.

Contents | Package | Class | Tree | Deprecated | Index | Help
PREV | NEXT SHOW LISTS | HIDE LISTS