com.irisel.oms.dbh
Interface DBHandler

All Known Implementing Classes:

Dbh, DbhMySql, DbhMySqlDS, DbhOdbc, DbhOracle, DbhPointbase

public interface DBHandler

Method Summary

boolean	begin()
void	close() Returns the connection to the pool, for pool-based datasource-based implementations
boolean	commit()
void	connect(java.lang.String url)
void	connect(java.lang.String host, java.lang.String port, java.lang.String db, java.lang.String user, java.lang.String password)
void	disconnect()
boolean	execute(Query q)
boolean	execute(java.lang.String q)
java.lang.Object	executeQuery(Query q, boolean formattedValues, ResultsHandler processor)
java.lang.Object	executeQuery(Query q, ResultsHandler processor)
java.lang.Object	executeQuery(java.lang.String q, ResultsHandler processor)
int	executeUpdate(Query q)
int	executeUpdate(java.lang.String q)
java.sql.Connection	getConnection()
java.sql.DatabaseMetaData	getDatabaseMetaData()
java.lang.String	getDbName()
java.lang.String	getDbPasswd()
java.lang.String	getDbUser()
java.lang.String	getHost()
java.lang.String	getPort()
java.lang.String	getSchema()
java.util.Vector	getTableNames(java.lang.String tableNamePattern, java.lang.String[] types)
void	getTables(java.lang.String tableNamePattern, ResultsHandler rq)
boolean	isConnected()
void	loadDriver(java.lang.String driver)
void	reconnect()
boolean	rollback()
void	setSchema(java.lang.String schema)

Method Detail

loadDriver

void loadDriver(java.lang.String driver)
                throws java.lang.ClassNotFoundException

Throws:

java.lang.ClassNotFoundException

connect

void connect(java.lang.String url)
             throws ConnectionException

Throws:

ConnectionException

connect

void connect(java.lang.String host,
             java.lang.String port,
             java.lang.String db,
             java.lang.String user,
             java.lang.String password)
             throws ConnectionException

Throws:

ConnectionException

reconnect

void reconnect()
               throws ConnectionException

Throws:

ConnectionException

disconnect

void disconnect()

isConnected

boolean isConnected()
                    throws ConnectionException

Throws:

ConnectionException

getConnection

java.sql.Connection getConnection()
                                  throws ConnectionException

Throws:

ConnectionException

executeQuery

java.lang.Object executeQuery(Query q,
                              ResultsHandler processor)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

java.lang.Object executeQuery(Query q,
                              boolean formattedValues,
                              ResultsHandler processor)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

java.lang.Object executeQuery(java.lang.String q,
                              ResultsHandler processor)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

executeUpdate

int executeUpdate(Query q)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

executeUpdate

int executeUpdate(java.lang.String q)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

boolean execute(java.lang.String q)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

boolean execute(Query q)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getDatabaseMetaData

java.sql.DatabaseMetaData getDatabaseMetaData()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getTables

void getTables(java.lang.String tableNamePattern,
               ResultsHandler rq)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

getTableNames

java.util.Vector getTableNames(java.lang.String tableNamePattern,
                               java.lang.String[] types)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

begin

boolean begin()
              throws java.sql.SQLException

Throws:

java.sql.SQLException

commit

boolean commit()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

rollback

boolean rollback()

getHost

java.lang.String getHost()

getPort

java.lang.String getPort()

getDbName

java.lang.String getDbName()

getDbUser

java.lang.String getDbUser()

getDbPasswd

java.lang.String getDbPasswd()

getSchema

java.lang.String getSchema()

setSchema

void setSchema(java.lang.String schema)

close

void close()

Returns the connection to the pool, for pool-based datasource-based implementations