com.elvyx.server.db
Interface Dao

All Known Implementing Classes:

HsqldbDaoImpl

public interface Dao

Dao interface includes how interact with the database .

Since:

1.0

Version:

$Revision: 1.3 $

Author:

Armando Perdomo

Method Summary

void	create() Create the database
void	eraseDatabase() Erase the database
java.util.List	getDifferences(java.lang.Integer clientId, java.lang.Integer statement_id) Return the differences between the two last time the sql statement was executed
java.util.Date	getLastTime(java.lang.Integer clientId, java.lang.Integer statement_id) Return last time some statement sql was executed
java.lang.Object	getMeanAndVariance(java.lang.Integer clientId, java.lang.String prepared, java.lang.String statement) Return mean and variance for this statement
java.util.List	getSQLDetails(java.lang.Integer clientId, java.lang.String prepared, java.lang.String statement) Return details about specific sql statement, it means all data for this sq statement
java.lang.Integer	getSQLPreparedId(java.lang.Integer clientId, java.lang.String prepared) Return the id for a sql prepared
java.lang.Integer	getSQLStatementId(java.lang.Integer clientId, java.lang.String statement) Return the id for a sql statement
java.util.List	getSQLStatements(java.lang.Object object) Return the sql statements following the filter rules.
java.util.List	getSQLStatementsWithoutBoundSql(java.lang.Object object) Return the sql statement without bound sql statements
void	insertSQLData(java.lang.Integer clientId, java.lang.String connectionId, java.lang.Integer prepared_id, java.lang.Integer statement_id, java.util.Date actual_time, java.util.Date last_time, java.lang.Integer elapsed, java.lang.Integer elapsedPStmt, java.lang.String category) Insert a sql data
void	insertSQLPrepared(java.lang.Integer clientId, java.lang.String prepared) Insert the sql prepared
void	insertSQLStatement(java.lang.Integer clientId, java.lang.String connectionId, java.lang.Integer prepared_id, java.lang.String statement) Insert a sql statement
void	stopDatabase() Stop the database.
void	updateSQLData(java.lang.Integer clientId, java.lang.String connectionId, java.lang.String prepared, java.lang.String statement, java.util.Date actual_time, java.util.Date last_time, java.lang.Integer elapsed, java.lang.Integer elapsedPStmt, java.lang.Integer rs_size, java.lang.Integer rs_elapsed, java.lang.String category) Update a sql data.

Method Detail

create

void create()
            throws java.sql.SQLException

Create the database

Throws:

java.sql.SQLException

insertSQLPrepared

void insertSQLPrepared(java.lang.Integer clientId,
                       java.lang.String prepared)
                       throws java.sql.SQLException

Insert the sql prepared

Parameters:

clientId -

prepared -

Throws:

java.sql.SQLException

getSQLPreparedId

java.lang.Integer getSQLPreparedId(java.lang.Integer clientId,
                                   java.lang.String prepared)
                                   throws java.sql.SQLException

Return the id for a sql prepared

Parameters:

clientId -

prepared -

Returns:

Throws:

java.sql.SQLException

insertSQLStatement

void insertSQLStatement(java.lang.Integer clientId,
                        java.lang.String connectionId,
                        java.lang.Integer prepared_id,
                        java.lang.String statement)
                        throws java.sql.SQLException

Insert a sql statement

Parameters:

clientId -

prepared_id -

statement -

Throws:

java.sql.SQLException

getSQLStatementId

java.lang.Integer getSQLStatementId(java.lang.Integer clientId,
                                    java.lang.String statement)
                                    throws java.sql.SQLException

Return the id for a sql statement

Parameters:

clientId -

statement -

Returns:

Throws:

java.sql.SQLException

insertSQLData

void insertSQLData(java.lang.Integer clientId,
                   java.lang.String connectionId,
                   java.lang.Integer prepared_id,
                   java.lang.Integer statement_id,
                   java.util.Date actual_time,
                   java.util.Date last_time,
                   java.lang.Integer elapsed,
                   java.lang.Integer elapsedPStmt,
                   java.lang.String category)
                   throws java.sql.SQLException

Insert a sql data

Parameters:

clientId -

prepared_id -

statement_id -

actual_time -

last_time -

elapsed -

category -

Throws:

java.sql.SQLException

updateSQLData

void updateSQLData(java.lang.Integer clientId,
                   java.lang.String connectionId,
                   java.lang.String prepared,
                   java.lang.String statement,
                   java.util.Date actual_time,
                   java.util.Date last_time,
                   java.lang.Integer elapsed,
                   java.lang.Integer elapsedPStmt,
                   java.lang.Integer rs_size,
                   java.lang.Integer rs_elapsed,
                   java.lang.String category)
                   throws java.sql.SQLException

Update a sql data. Used to update resultsets data

Parameters:

clientId -

prepared_id -

statement_id -

actual_time -

last_time -

elapsed -

category -

Throws:

java.sql.SQLException

getLastTime

java.util.Date getLastTime(java.lang.Integer clientId,
                           java.lang.Integer statement_id)
                           throws java.sql.SQLException

Return last time some statement sql was executed

Parameters:

clientId -

statement_id -

Returns:

Throws:

java.sql.SQLException

getSQLStatements

java.util.List getSQLStatements(java.lang.Object object)
                                throws java.sql.SQLException

Return the sql statements following the filter rules. Filter rules: All, Update , Insert, etc

Parameters:

object -

Returns:

Throws:

java.sql.SQLException

getSQLStatementsWithoutBoundSql

java.util.List getSQLStatementsWithoutBoundSql(java.lang.Object object)
                                               throws java.sql.SQLException

Return the sql statement without bound sql statements

Parameters:

object -

Returns:

Throws:

java.sql.SQLException

getSQLDetails

java.util.List getSQLDetails(java.lang.Integer clientId,
                             java.lang.String prepared,
                             java.lang.String statement)
                             throws java.sql.SQLException

Return details about specific sql statement, it means all data for this sq statement

Parameters:

clientId -

prepared -

statement -

Returns:

Throws:

java.sql.SQLException

getMeanAndVariance

java.lang.Object getMeanAndVariance(java.lang.Integer clientId,
                                    java.lang.String prepared,
                                    java.lang.String statement)
                                    throws java.sql.SQLException

Return mean and variance for this statement

Parameters:

clientId -

prepared -

statement -

Returns:

Throws:

java.sql.SQLException

getDifferences

java.util.List getDifferences(java.lang.Integer clientId,
                              java.lang.Integer statement_id)
                              throws java.sql.SQLException

Return the differences between the two last time the sql statement was executed

Parameters:

clientId -

statement_id -

Returns:

Throws:

java.sql.SQLException

stopDatabase

void stopDatabase()
                  throws java.sql.SQLException

Stop the database. Cases like hsqldb must be executed a shutdown.

Throws:

java.sql.SQLException

eraseDatabase

void eraseDatabase()
                   throws java.sql.SQLException

Erase the database

Throws:

java.sql.SQLException