Uses of Interface org.ephman.abra.database.DatabaseSession (Abra

protected java.util.Vector

ManyToManyFactoryBase.executeQuery(DatabaseSession dbSess,
             java.lang.String query,
             int oid,
             FactoryBase fact)

protected void

ManyToManyFactoryBase.addRelationship(DatabaseSession dbSess,
                java.lang.String insert,
                int oid1,
                int oid2)

protected void

ManyToManyFactoryBase.removeRelationship(DatabaseSession dbSess,
                   java.lang.String delete,
                   int oid1,
                   int oid2)

protected void

ManyToManyFactoryBase.removeAllRelationships(DatabaseSession dbSess,
                       java.lang.String delete,
                       Identified item)

protected boolean

ManyToManyFactoryBase.hasRelationship(DatabaseSession dbSess,
                int oid1,
                int oid2)

void

JDBCDatabaseSessionPool.put(DatabaseSession session)
Return a session to the pool

java.util.Vector

EndDateFactoryBase.querySorted(DatabaseSession dbSess,
            QueryFilter query,
            SortCriteria sortBy)

Identified

EndDateFactoryBase.getObject(DatabaseSession dbSess,
          QueryFilter query)

DatabaseCursor

EndDateFactoryBase.cursorQuery(DatabaseSession dbSess,
            QueryFilter query,
            SortCriteria sortBy)

protected void

EndDateFactoryBase.deleteObject(DatabaseSession dbSess,
             Identified item)

void

DatabaseSessionPool.put(DatabaseSession session)
Return a session to the pool.

protected void

FactoryBase.setClob(DatabaseSession dbSess,
        java.sql.ResultSet rs,
        java.lang.String columnName,
        java.lang.String value)

a routine to get an oracle clob stream and set the value here

protected int

FactoryBase.getLastId(DatabaseSession dbSess)

protected java.sql.Connection

GenericFactoryBase.getConnection(DatabaseSession dbSess)

protected Identified

GenericFactoryBase.getObject(DatabaseSession dbSess,
          java.lang.String columnName,
          java.lang.String value)

protected Identified

GenericFactoryBase.getObject(DatabaseSession dbSess,
          java.lang.String columnName,
          int value)

protected void

GenericFactoryBase.storeObject(DatabaseSession dbSess,
            Identified item)

routine to store an object -- if new putNew is called else update is called

protected void

GenericFactoryBase.storeObject(DatabaseSession dbSess,
            Identified item,
            int storageDepth)

routine to store an object -- if new putNew is called else update is called

protected void

GenericFactoryBase.putNewObject(DatabaseSession dbSess,
             Identified item)

routine to place a new object in the db

protected void

GenericFactoryBase.putNewObject(DatabaseSession dbSess,
             Identified item,
             int storageDepth)

putNewObject stores an object for the first time using insert stmts

protected java.sql.PreparedStatement

GenericFactoryBase.makeInsertStmt(DatabaseSession dbSess)
generic.

protected java.sql.PreparedStatement

GenericFactoryBase.makeUpdateStmt(DatabaseSession dbSess)

protected void

GenericFactoryBase.deleteObject(DatabaseSession dbSess,
             Identified item)

protected int

GenericFactoryBase.deleteObjects(DatabaseSession dbSess,
              QueryFilter filter)

deleteObjects will delete all the rows which match the given filter

protected void

GenericFactoryBase.updateObject(DatabaseSession dbSess,
             Identified item)

protected void

GenericFactoryBase.updateObject(DatabaseSession dbSess,
             Identified item,
             int storageDepth)

java.util.Vector

GenericFactoryBase.queryObjects(DatabaseSession dbSess,
             java.lang.String column,
             int key)

java.util.Vector

GenericFactoryBase.queryObjects(DatabaseSession dbSess,
             ViewLookup lookup,
             QueryFilter filter)

a routine to get objects with a given DatabaseLookup..

java.util.Vector

GenericFactoryBase.queryObjects(DatabaseSession dbSess,
             ViewLookup lookup,
             QueryFilter filter,
             SortCriteria sortCriteria)

void

GenericFactoryBase.lock(DatabaseSession dbSess,
     Identified item)

A routine to lock an object and all of its sub parts in the database (thread locking) which is only released when this thread commits/rollsback

protected void

GenericFactoryBase.deepRetrieval(DatabaseSession dbSess,
              Identified item)

protected void

GenericFactoryBase.deepStorage(DatabaseSession dbSess,
            Identified item)

protected void

GenericFactoryBase.preStorage(DatabaseSession dbSess,
           Identified item)

java.util.Vector

GenericFactoryBase.getCollection(DatabaseSession dbSess,
              java.sql.ResultSet rs)

java.util.Vector

GenericFactoryBase.queryObjects(DatabaseSession dbSess,
             QueryFilter query)

A routine to get a hits given the filter

protected java.util.Vector

GenericFactoryBase.queryAll(DatabaseSession dbSess)
A routine to get a all from the table

protected java.util.Vector

GenericFactoryBase.queryAllSorted(DatabaseSession dbSess,
               SortCriteria sortBy)

A routine to get a all from the table - sorted

java.util.Vector

GenericFactoryBase.querySorted(DatabaseSession dbSess,
            QueryFilter query,
            SortCriteria sortBy)

A routine to get a objects from a table using the filter and sorted w/ the criteria

Identified

GenericFactoryBase.getObject(DatabaseSession dbSess,
          QueryFilter query)

A routine to get a single object given a filter

protected Identified

GenericFactoryBase.makeObject(DatabaseSession dbSess,
           java.sql.ResultSet rs)

protected GenericFactoryBase.QueryResult

GenericFactoryBase.getResults(DatabaseSession dbSess,
           java.lang.String sql,
           int key)

get results and set key in first arg..

protected GenericFactoryBase.QueryResult

GenericFactoryBase.getResults(DatabaseSession dbSess,
           java.lang.String sql,
           QueryFilter filter,
           SortCriteria sc)

a helper routine to build a query and execute

protected GenericFactoryBase.QueryResult

GenericFactoryBase.getResults(DatabaseSession dbSess,
           java.lang.String sql,
           QueryFilter filter,
           SortCriteria sc,
           boolean needsWhereLogic,
           java.lang.String tableName)

int

GenericFactoryBase.countRows(DatabaseSession dbSess,
          QueryFilter filter)

A routine to count the number of rows in a query which returns the count of hits

DatabaseCursor

GenericFactoryBase.cursorQuery(DatabaseSession dbSess,
            SortCriteria sortBy)

A routine to perform a search given an ordering which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction

DatabaseCursor

GenericFactoryBase.cursorQuery(DatabaseSession dbSess,
            QueryFilter query)

A routine to perform a search given a filter which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction

DatabaseCursor

GenericFactoryBase.cursorQuery(DatabaseSession dbSess,
            QueryFilter query,
            SortCriteria sortBy)

A routine to perform a search given a filter and an ordering which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction

protected DatabaseCursor

GenericFactoryBase.cursorRawQuery(DatabaseSession dbSess,
               java.lang.String sql)

Raw query returns DatabaseCursor - to be used in descendant classes

protected int

GenericFactoryBase.storedProcCall(DatabaseSession dbSess,
               java.lang.String procCall,
               java.util.Vector args)

Execute a stored proc with some arguments that returns an integer.

protected DatabaseCursor

GenericFactoryBase.cursorStoredProcCall(DatabaseSession dbSess,
                     java.lang.String procCall,
                     java.util.Vector args,
                     SortCriteria sort)

protected void

GenericFactoryBase.checkRefresh(DatabaseSession dbSess,
             Identified item)

protected void

GenericFactoryBase.checkRefresh(DatabaseSession dbSess,
             Identified item,
             java.sql.ResultSet rs)

routine to check if an object is up to date..

protected int

GenericFactoryBase.getLastId(DatabaseSession dbSess,
          java.sql.PreparedStatement stmt)

protected void

GenericFactoryBase.setClobs(DatabaseSession dbSess,
         java.sql.ResultSet rs,
         Identified item)

protected abstract void

GenericFactoryBase.setClob(DatabaseSession dbSess,
        java.sql.ResultSet rs,
        java.lang.String columnName,
        java.lang.String value)

need specific db type libraries to do see oracle/FactoryBase

protected abstract int

GenericFactoryBase.getLastId(DatabaseSession dbSess)

void

DatabaseCursor.refreshSearch(DatabaseSession dbSess)
a routine to refresh the cursor (in case of stale data)

java.util.Vector

DatabaseCursor.getObjects(DatabaseSession dbSess,
           int start,
           int count)

a routine to get a sub-set of objects from the last query

java.util.Vector

DatabaseCursor.getNextObjects(DatabaseSession dbSess)

java.util.Vector

DatabaseCursor.getNextObjects(DatabaseSession dbSess,
               SortCriteria sc)

Methods in org.ephman.abra.database that return DatabaseSession
`DatabaseSession`	`JDBCDatabaseSessionPool.get()` Get an available Database session
`DatabaseSession`	`DatabaseSessionPool.get()` Get an available session from the pool.
`DatabaseSession`	`DatabaseSessionFactory.createNewSession()` Create a new database session

Packages that use DatabaseSession
org.ephman.abra.database

Classes in org.ephman.abra.database that implement DatabaseSession
`class`	`JDBCDatabaseSession` JDBC based database connection.

Methods in org.ephman.abra.database with parameters of type DatabaseSession
`protected java.util.Vector`	`ManyToManyFactoryBase.executeQuery(DatabaseSession dbSess, java.lang.String query, int oid, FactoryBase fact)`
`protected void`	`ManyToManyFactoryBase.addRelationship(DatabaseSession dbSess, java.lang.String insert, int oid1, int oid2)`
`protected void`	`ManyToManyFactoryBase.removeRelationship(DatabaseSession dbSess, java.lang.String delete, int oid1, int oid2)`
`protected void`	`ManyToManyFactoryBase.removeAllRelationships(DatabaseSession dbSess, java.lang.String delete, Identified item)`
`protected boolean`	`ManyToManyFactoryBase.hasRelationship(DatabaseSession dbSess, int oid1, int oid2)`
`void`	`JDBCDatabaseSessionPool.put(DatabaseSession session)` Return a session to the pool
`java.util.Vector`	`EndDateFactoryBase.querySorted(DatabaseSession dbSess, QueryFilter query, SortCriteria sortBy)`
`Identified`	`EndDateFactoryBase.getObject(DatabaseSession dbSess, QueryFilter query)`
`DatabaseCursor`	`EndDateFactoryBase.cursorQuery(DatabaseSession dbSess, QueryFilter query, SortCriteria sortBy)`
`protected void`	`EndDateFactoryBase.deleteObject(DatabaseSession dbSess, Identified item)`
`void`	`DatabaseSessionPool.put(DatabaseSession session)` Return a session to the pool.
`protected void`	`FactoryBase.setClob(DatabaseSession dbSess, java.sql.ResultSet rs, java.lang.String columnName, java.lang.String value)` a routine to get an oracle clob stream and set the value here
`protected int`	`FactoryBase.getLastId(DatabaseSession dbSess)`
`protected java.sql.Connection`	`GenericFactoryBase.getConnection(DatabaseSession dbSess)`
`protected Identified`	`GenericFactoryBase.getObject(DatabaseSession dbSess, java.lang.String columnName, java.lang.String value)`
`protected Identified`	`GenericFactoryBase.getObject(DatabaseSession dbSess, java.lang.String columnName, int value)`
`protected void`	`GenericFactoryBase.storeObject(DatabaseSession dbSess, Identified item)` routine to store an object -- if new putNew is called else update is called
`protected void`	`GenericFactoryBase.storeObject(DatabaseSession dbSess, Identified item, int storageDepth)` routine to store an object -- if new putNew is called else update is called
`protected void`	`GenericFactoryBase.putNewObject(DatabaseSession dbSess, Identified item)` routine to place a new object in the db
`protected void`	`GenericFactoryBase.putNewObject(DatabaseSession dbSess, Identified item, int storageDepth)` putNewObject stores an object for the first time using insert stmts
`protected java.sql.PreparedStatement`	`GenericFactoryBase.makeInsertStmt(DatabaseSession dbSess)` generic.
`protected java.sql.PreparedStatement`	`GenericFactoryBase.makeUpdateStmt(DatabaseSession dbSess)`
`protected void`	`GenericFactoryBase.deleteObject(DatabaseSession dbSess, Identified item)`
`protected int`	`GenericFactoryBase.deleteObjects(DatabaseSession dbSess, QueryFilter filter)` deleteObjects will delete all the rows which match the given filter
`protected void`	`GenericFactoryBase.updateObject(DatabaseSession dbSess, Identified item)`
`protected void`	`GenericFactoryBase.updateObject(DatabaseSession dbSess, Identified item, int storageDepth)`
`java.util.Vector`	`GenericFactoryBase.queryObjects(DatabaseSession dbSess, java.lang.String column, int key)`
`java.util.Vector`	`GenericFactoryBase.queryObjects(DatabaseSession dbSess, ViewLookup lookup, QueryFilter filter)` a routine to get objects with a given DatabaseLookup..
`java.util.Vector`	`GenericFactoryBase.queryObjects(DatabaseSession dbSess, ViewLookup lookup, QueryFilter filter, SortCriteria sortCriteria)`
`void`	`GenericFactoryBase.lock(DatabaseSession dbSess, Identified item)` A routine to lock an object and all of its sub parts in the database (thread locking) which is only released when this thread commits/rollsback
`protected void`	`GenericFactoryBase.deepRetrieval(DatabaseSession dbSess, Identified item)`
`protected void`	`GenericFactoryBase.deepStorage(DatabaseSession dbSess, Identified item)`
`protected void`	`GenericFactoryBase.preStorage(DatabaseSession dbSess, Identified item)`
`java.util.Vector`	`GenericFactoryBase.getCollection(DatabaseSession dbSess, java.sql.ResultSet rs)`
`java.util.Vector`	`GenericFactoryBase.queryObjects(DatabaseSession dbSess, QueryFilter query)` A routine to get a hits given the filter
`protected java.util.Vector`	`GenericFactoryBase.queryAll(DatabaseSession dbSess)` A routine to get a all from the table
`protected java.util.Vector`	`GenericFactoryBase.queryAllSorted(DatabaseSession dbSess, SortCriteria sortBy)` A routine to get a all from the table - sorted
`java.util.Vector`	`GenericFactoryBase.querySorted(DatabaseSession dbSess, QueryFilter query, SortCriteria sortBy)` A routine to get a objects from a table using the filter and sorted w/ the criteria
`Identified`	`GenericFactoryBase.getObject(DatabaseSession dbSess, QueryFilter query)` A routine to get a single object given a filter
`protected Identified`	`GenericFactoryBase.makeObject(DatabaseSession dbSess, java.sql.ResultSet rs)`
`protected GenericFactoryBase.QueryResult`	`GenericFactoryBase.getResults(DatabaseSession dbSess, java.lang.String sql, int key)` get results and set key in first arg..
`protected GenericFactoryBase.QueryResult`	`GenericFactoryBase.getResults(DatabaseSession dbSess, java.lang.String sql, QueryFilter filter, SortCriteria sc)` a helper routine to build a query and execute
`protected GenericFactoryBase.QueryResult`	`GenericFactoryBase.getResults(DatabaseSession dbSess, java.lang.String sql, QueryFilter filter, SortCriteria sc, boolean needsWhereLogic, java.lang.String tableName)`
`int`	`GenericFactoryBase.countRows(DatabaseSession dbSess, QueryFilter filter)` A routine to count the number of rows in a query which returns the count of hits
`DatabaseCursor`	`GenericFactoryBase.cursorQuery(DatabaseSession dbSess, SortCriteria sortBy)` A routine to perform a search given an ordering which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction
`DatabaseCursor`	`GenericFactoryBase.cursorQuery(DatabaseSession dbSess, QueryFilter query)` A routine to perform a search given a filter which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction
`DatabaseCursor`	`GenericFactoryBase.cursorQuery(DatabaseSession dbSess, QueryFilter query, SortCriteria sortBy)` A routine to perform a search given a filter and an ordering which returns the Vector of oid hits in a DatabaseCursor object this allows small range retrievals with any type of data abstraction
`protected DatabaseCursor`	`GenericFactoryBase.cursorRawQuery(DatabaseSession dbSess, java.lang.String sql)` Raw query returns DatabaseCursor - to be used in descendant classes
`protected int`	`GenericFactoryBase.storedProcCall(DatabaseSession dbSess, java.lang.String procCall, java.util.Vector args)` Execute a stored proc with some arguments that returns an integer.
`protected DatabaseCursor`	`GenericFactoryBase.cursorStoredProcCall(DatabaseSession dbSess, java.lang.String procCall, java.util.Vector args, SortCriteria sort)`
`protected void`	`GenericFactoryBase.checkRefresh(DatabaseSession dbSess, Identified item)`
`protected void`	`GenericFactoryBase.checkRefresh(DatabaseSession dbSess, Identified item, java.sql.ResultSet rs)` routine to check if an object is up to date..
`protected int`	`GenericFactoryBase.getLastId(DatabaseSession dbSess, java.sql.PreparedStatement stmt)`
`protected void`	`GenericFactoryBase.setClobs(DatabaseSession dbSess, java.sql.ResultSet rs, Identified item)`
`protected abstract void`	`GenericFactoryBase.setClob(DatabaseSession dbSess, java.sql.ResultSet rs, java.lang.String columnName, java.lang.String value)` need specific db type libraries to do see oracle/FactoryBase
`protected abstract int`	`GenericFactoryBase.getLastId(DatabaseSession dbSess)`
`void`	`DatabaseCursor.refreshSearch(DatabaseSession dbSess)` a routine to refresh the cursor (in case of stale data)
`java.util.Vector`	`DatabaseCursor.getObjects(DatabaseSession dbSess, int start, int count)` a routine to get a sub-set of objects from the last query
`java.util.Vector`	`DatabaseCursor.getNextObjects(DatabaseSession dbSess)`
`java.util.Vector`	`DatabaseCursor.getNextObjects(DatabaseSession dbSess, SortCriteria sc)`

Uses of Interfaceorg.ephman.abra.database.DatabaseSession

Uses of Interface
org.ephman.abra.database.DatabaseSession