Overview  Package  Class   Use  Deprecated  Index
Home >> All >> javatools >> [ db overview ]	PREV  NEXT

---

Uses of Class
javatools.db.DbException

Uses of DbException in javatools.db

 

Fields in javatools.db declared as DbException
(package private)  DbException	DbTableIterator.lastException           Represents the last exception caught for this object.

 

Methods in javatools.db that throw DbException
java.lang.String	DbValueList.getQueryString()           Any DbExpr needs to be able to convert into the SQL string equivilent.
int	DbValueList.setSqlValues(java.sql.PreparedStatement ps, int i)           Any DbExpr needs to be able to substitute any parameters as per JDBC "?" substitutions.
int	DbUpdater.execute(DbConnection dbcon)           Execute this delete command on a specific connection.
int	DbUpdater.execute()           Execute this command on the default connection.
(package private)  int	DbUpdater.setSqlValues(java.sql.PreparedStatement stmt, int i)           Sets values for the statement.
(package private)  java.lang.String	DbUpdater.getQueryString()           Returns the query string for this object.
boolean	DbTableIterator.hasNextRow()           Are there more rows to iterator through?
(package private)  boolean	DbTableIterator.getNext()           Puts the pointer one step after.
DbRow	DbTableIterator.nextRow()           Get the next DbRow in the table.
void	DbTable.setResultSet(java.sql.PreparedStatement stmt, java.sql.ResultSet rs)           Sets the result set to take rows from.
DbColumn	DbTable.getColumn(java.lang.String name)           Get the DbColumn representing the column with this name.
DbColumn	DbTable.getColumn(int index)           Get the column of the given index.
void	DbTable.close()           Closes this table.
java.lang.Object	DbTable.getDefault(int index)           Returns the default value for this table.
java.lang.Object	DbTable.getDefault(java.lang.String name)           Returns the default value of a column.
(package private)  DbColumn	DbTable.getAddColumn()           Adds a column and returns it to the caller.
int	DbSequence.next()           Gets the next value.
int	DbSequence.next(DbConnection dbcon)           Returns the next value, with a specific connection.
int	DbSelector.setSqlValues(java.sql.PreparedStatement stmt, int i)           Puts data into statement.
void	DbSelector.setLimit(int n)           Don't get the whole result set, get only a limited number of rows.
void	DbSelector.setOffset(int n)           Don't get the first results, but skip n result rows.
java.lang.String	DbSelector.getQueryString()           Get the query string represented by this query.
DbColumn	DbSelector.addColumn(java.lang.Object col)           Add the given object to the select column list.
DbColumn	DbSelector.addColumn(java.lang.Object col, java.lang.String as)           Add the given object to the select column list with an "AS" alias.
void	DbSelector.addAll(DbAbstractTable table)           Add all the columns from the given table to the select list.
void	DbSelector.addAllExcept(DbAbstractTable table, DbColumn o)           Add all the columns from the given table to the select list.
void	DbSelector.addAllExcept(DbAbstractTable table, java.util.Set set)           Add all the columns from the given table to the select list.
void	DbSelector.executeToResultSet(DbConnection dbcon)           Execute and get a JDBC ResultSet.
DbTable	DbSelector.execute(DbConnection dbcon)           Execute and return a DbTable.
DbTable	DbSelector.execute()           Execute and return a DbTable with the default DbConnection.
(package private)  int	DbSelector.setSqlValues(java.sql.PreparedStatement stmt, int i, java.util.List intoList)           Substitute the literal values in the Prepared Statement.
(package private)  java.lang.String	DbSelector.orderByClause(java.util.List orderBy)           Generate the order by clause.
(package private)  java.lang.String	DbSelector.groupByClause(java.util.List groupBy)           Generates the GROUP Bye clause.
boolean	DbRowSetIterator.hasNextRow()           Are there more rows to iterator through?
DbRow	DbRowSetIterator.nextRow()           Get the next DbRow in the table.
DbRow	DbRowSet.get(int pos)           Returns a row at the specified position.
void	DbRowSet.remove(int pos)           Removes a row from the list.
void	DbRowSet.close()           Closes this table.
void	DbResult.close()           Closes this table.
int	DbReferencedUpdater.execute()           Execute this command on the default connection.
void	DbReferencedTable.setResultSet(java.sql.PreparedStatement stmt, java.sql.ResultSet rs)
DbInserter	DbReferencedTable.inserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbInserter	DbReferencedTable.inserter()           Return an inserter for inserting new data in the database.
DbUpdater	DbReferencedTable.updater()
DbDeleter	DbReferencedTable.deleter()
DbAbstractTable	DbReferencedTable.getFatherTable(int index)
DbAbstractTable	DbReferencedTable.getSonTable(int index)
int	DbReferencedTable.getSonFatherIndex(int index)
int	DbReferencedTable.getUpdateOperation(int index)
int	DbReferencedTable.getDeleteOperation(int index)
DbColumn[]	DbReferencedTable.getFatherColumns(int index)
DbColumn[]	DbReferencedTable.getRefColumns(int index)
private  void	DbReferencedTable.catchDefaults()
int	DbReferencedInserter.execute()           Execute this command on the default connection.
int	DbReferencedDeleter.execute()           Execute this command on the default connection.
int	DbParenthesis.setSqlValues(java.sql.PreparedStatement ps, int i)           Sets the sqlValues attribute of the DbParenthesis object
java.lang.String	DbParenthesis.getQueryString()           Gets the queryString attribute of the DbParenthesis object
java.lang.String	DbOrderBy.getQueryString()           Returns the query string related to these expression.
int	DbOrExpr.setSqlValues(java.sql.PreparedStatement ps, int i)           Puts data into a statement.
java.lang.String	DbOrExpr.getQueryString()           Returns the query string related to this expression.
java.lang.String	DbMiscExpr.getQueryString()           See DbFuncExpr
int	DbMiscExpr.setSqlValues(java.sql.PreparedStatement ps, int i)           See DbFuncExpr
DbDatabase	DbManager.getDatabase(java.lang.String name, java.lang.String driver, java.lang.String connectString, java.lang.String userName, java.lang.String password)           Return the database object associated with this name or parameters.
DbDatabase	DbManager.getDatabase(java.lang.String name)           Return the database associated with this name.
void	DbManager.commitClose()           Commit and close ALL connections associated with this database.
void	DbManager.rollbackClose()           Rollback and close ALL connections associated with this database.
void	DbManager.commit()           Perform a commit on ALL connections associated with this database.
void	DbManager.rollback()           Perform a rollback on ALL connections associated with this database.
void	DbManager.close()           Close ALL connections associated with this database.
int	DbLiteral.setSqlValues(java.sql.PreparedStatement ps, int i)           Sets the sqlValues attribute of the DbLiteral object
java.lang.Object	DbJoinedTable.getDefault(int index)           Returns the default value for the field at the given index.
java.lang.Object	DbJoinedTable.getDefault(java.lang.String name)           Returns the default value for the field whose name is specified.
DbColumn	DbJoinedTable.getColumn(java.lang.String name)           Get the DbColumn representing the column with this name.
DbDeleter	DbJoinedTable.deleter()           Returns a deleter for deleting rows in the database.
DbColumn	DbJoinedTable.getColumn(int index)           Get the column of the given index.
DbInserter	DbJoinedTable.inserter()           Return an inserter for inserting new data in the database.
DbInserter	DbJoinedTable.inserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbDeleter	DbJoinedTable.simpleDeleter()           Returns a deleter for deleting rows in the database.
DbInserter	DbJoinedTable.simpleInserter()           Return an inserter for inserting new data in the database.
DbInserter	DbJoinedTable.simpleInserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbUpdater	DbJoinedTable.simpleUpdater()           Return an updater for updating rows in the database.
DbUpdater	DbJoinedTable.updater()           Return an updater for updating rows in the database.
private  void	DbJoinedTable.buildTableName()
boolean	DbIterator.hasNextRow()           Are there more rows to iterator through?
DbRow	DbIterator.nextRow()           Get the next DbRow in the table.
int	DbInserter.setSqlValues(java.sql.PreparedStatement stmt, int i)           Puts data into a prepared statement.
int	DbInserter.execute(DbConnection dbcon)           Execute this command on a specific connection.
int	DbInserter.execute()           Execute this command on the default connection.
(package private)  java.lang.String	DbInserter.getQueryString()           Returns the complete query string.
DbColumn	DbFixedAbstractTable.getColumn(int index)           Get the column of the given index.
DbColumn	DbFixedAbstractTable.getColumn(java.lang.String name)           Get the DbColumn representing the column with this name.
java.lang.Object	DbFixedAbstractTable.getDefault(int index)           Returns the default value for the requested column.
java.lang.Object	DbFixedAbstractTable.getDefault(java.lang.String name)           Returns the default value for a given column.
DbInserter	DbFixedAbstractTable.inserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbInserter	DbFixedAbstractTable.simpleInserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbInserter	DbFixedAbstractTable.inserter()           Return an inserter for inserting new data in the database.
DbInserter	DbFixedAbstractTable.simpleInserter()           Return an inserter for inserting new data in the database.
DbUpdater	DbFixedAbstractTable.updater()           Returns an updater for this table.
DbUpdater	DbFixedAbstractTable.simpleUpdater()           Return an updater for updating rows in the database.
DbDeleter	DbFixedAbstractTable.deleter()           Returns a deleter for this table.
DbDeleter	DbFixedAbstractTable.simpleDeleter()           Returns a deleter for deleting rows in the database.
protected  void	DbFixedAbstractTable.buildUp()           Performs building of static lists.
protected  void	DbFixedAbstractTable.catchDefaults()           Finds defaults.
protected  void	DbFixedAbstractTable.loadStructure()           Loads table structure from a file: localConfigPath/TABLENAME.table.
protected  void	DbFixedAbstractTable.saveStructure()           Saves table structure into a file: localConfigPath/TABLENAME.table.
int	DbExprFuncDef.setSqlValues(java.sql.PreparedStatement ps, int i)           Sets the sqlValues attribute of the DbExprFuncDef object
java.lang.String	DbExprFuncDef.getQueryString()           Gets the queryString attribute of the DbExprFuncDef object
(package private) static int	DbExpr.setSqlValue(java.sql.PreparedStatement stmt, int i, java.lang.Object col, DbColumn intocol)           Substitute the literal value in the Prepared Statement.
(package private) static java.lang.String	DbExpr.getString(java.lang.Object o)           Utility function to turn o into an SQL expression.
abstract  int	DbExpr.setSqlValues(java.sql.PreparedStatement ps, int i)           Any DbExpr needs to be able to substitute any parameters as per JDBC "?" substitutions.
abstract  java.lang.String	DbExpr.getQueryString()           Any DbExpr needs to be able to convert into the SQL string equivilent.
DbExpr	DbExpr.dateTrunc()           Truncs the date? Obscure.
void	DbDynamicConstraint.check(int operation)           Performs checking in the table, after setting all dynamic and "static" data.
int	DbDynamicConstraint.update(int operation)           Performs actual update in the table and, eventually, cascades.
DbAbstractTable	DbDynamicConstraint.getFatherTable(int index)           Returns a father table whose index is specified.
DbAbstractTable	DbDynamicConstraint.getSonTable(int index)           Returns a son table whose index is specified.
int	DbDynamicConstraint.getSonFatherIndex(int index)           Returns the index that a son table uses to reference this table.
int	DbDynamicConstraint.getUpdateOperation(int index)           Returns the update operation that should be done for the father table whose index is specified.
int	DbDynamicConstraint.getDeleteOperation(int index)           Returns the delete operation that should be done for the father table whose index is specified.
DbColumn[]	DbDynamicConstraint.getFatherColumns(int index)           The referenced columns of father table whose index is specified.
DbColumn[]	DbDynamicConstraint.getRefColumns(int index)           Returns the referencing columns of THIS table to the father table whose index is specified.
void	DbDynamicConstraint.build()           Builds all static lists.
protected  void	DbDynamicConstraint.checkThis(int operation)           Performs base checking.
protected  void	DbDynamicConstraint.checkFathers()           Checks the fathers.
java.lang.Object[]	DbDynamicConstraint.getDefaultValues(int index)           Returns the default values of referenced father table whose index is specified.
int	DbDeleter.execute(DbConnection dbcon)           Execute this delete command on a specific connection.
int	DbDeleter.execute()           Execute this command on the default connection.
(package private)  java.lang.String	DbDeleter.getQueryString()           Returns the query string related to this deleter.
void	DbDatabaseAdmin.createDatabase(java.lang.String dbAddress, int port, java.lang.String dbName)           Creates a database.
void	DbDatabaseAdmin.createUser(java.lang.String userName, java.lang.String password)
void	DbDatabaseAdmin.dropDatabase(java.lang.String dbName)           Destroys a database.
void	DbDatabaseAdmin.dropTable(DbAbstractTable table)           Deletes a table from a database.
void	DbDatabaseAdmin.optimizeTable(DbAbstractTable table)           Make table optimization.
void	DbDatabaseAdmin.optimizeIndex(java.lang.String indexName)           Optimizes an index for the database.
void	DbDatabaseAdmin.createIndex(java.lang.String indexName, DbAbstractTable table, DbColumn[] cols)           Creates an index for a database.
void	DbDatabase.setProperty(java.lang.String pname, java.lang.String value)           Set a property for this database.
java.lang.String	DbDatabase.getProperty(java.lang.String pname)           A database can have a set of properties associated with it.
DbTable	DbDatabase.getTable(java.lang.String name)           Return an object representing a particular table in the database.
DbJoinedTable	DbDatabase.getJoinedTable(DbAbstractTable tableLeft, DbAbstractTable tableRight, int joinType, DbExpr joinCondition)           Returns a joined table.
DbConnection	DbDatabase.getThreadConnection()           Get a DbConnection that will be associated with this Thread.
DbConnection	DbDatabase.getExistingThreadConnection()           Get a DbConnection that will be associated with this Thread, but only if one exists already.
DbConnection	DbDatabase.getNewConnection()           Return a brand new DbConnection.
DbSelector	DbDatabase.selector()           Create a new DbSelector.
java.lang.String	DbCriterion.getQueryString()           Returns the query string related to this expression.
int	DbCriterion.setSqlValues(java.sql.PreparedStatement ps, int i)           Sets the real values in the passed statement.
DbAbstractTable	DbConstraint.getFatherTable(int index)           Returns a father table whose index is specified.
DbAbstractTable	DbConstraint.getSonTable(int index)           Returns a son table whose index is specified.
int	DbConstraint.getSonFatherIndex(int index)           Returns in which position a son table references THIS table in its constraint.
int	DbConstraint.getUpdateOperation(int index)           Returns what kind of operation will be done in case of an update of the father table specified by index.
int	DbConstraint.getDeleteOperation(int index)           Returns what kind of operation will be done in case of a deletion of the father table specified by index.
DbColumn[]	DbConstraint.getFatherColumns(int index)           Returns the referenced father columns of a father table whose index is specified.
DbColumn[]	DbConstraint.getRefColumns(int index)           Returns the referencing columns of THIS table for a father table whose index is specified.
java.lang.Object[]	DbConstraint.getDefaultValues(int index)           Returns an array containing the default values for fields of a father table whose index is specified.
void	DbConstraint.build()           After all settings, it finally builds all static references.
abstract  void	DbConstraint.check(int operation)           After setting all dynamic (i.e.
abstract  int	DbConstraint.update(int operation)           Actually updates the table and all of its son tables.
protected  int	DbConstraint.updateThis(int operation)           Performs base update.
protected  void	DbConstraint.checkThis(int operation)           Performs base checks.
protected  void	DbConstraint.checkFathers()           Performs checking for father tables.
protected  void	DbConstraint.checkChildren()           Checks recursively each son.
private  void	DbConstraint.buildReferences()
private  java.lang.Integer[]	DbConstraint.findRefPosition(int index)
private  java.util.TreeSet	DbConstraint.buildSet(java.lang.Integer[] refs, DbIterator it)
private  void	DbConstraint.cascade()
private  void	DbConstraint.buildSonColsList()
private  void	DbConstraint.buildFatherRecords()
private  void	DbConstraint.buildSearchSets()
private  DbTable	DbConstraint.buildSonRecords(int numSon)
private  void	DbConstraint.buildConstraints()
private  void	DbConstraint.buildDefaultValues()
private  void	DbConstraint.buildUpdateLists()
protected  void	DbConstraint.initStaticLists()           Inits static lists, like indexes of son tables, default values of father tables etc.
protected  void	DbConstraint.initLists()           Builds all dynamic lists (where clauses, constraints etc.).
boolean	DbConnection.isClosed()           Checks if this connection is closed.
void	DbConnection.commitClose()           Commits all the operations and closes the connection.
void	DbConnection.rollbackClose()           Rollbacks operations and closes the connection.
void	DbConnection.commit()           Commits all operations.
void	DbConnection.rollback()           Rollbacks operations.
void	DbConnection.close()           Closes the connection.
void	DbConnection.setAutoCommit(boolean value)
int	DbColumn.setSqlValues(java.sql.PreparedStatement ps, int i)           Sets, in a prepared statement, the value related to this column, that will be used, e.g., in an INSERT operation.
DbExpr	DbColumn.getSubExpr(DbColumn[] cols)           Currently unused.
DbExpr	DbColumn.substituteColumn(DbColumn oldCol, DbColumn newCol)           Currently unused.
void	DbCachedTable.setResultSet(java.sql.PreparedStatement stmt, java.sql.ResultSet rs)           Sets the result set to be representend in this class.
boolean	DbCachedIterator.hasNextRow()           Are there more rows to iterator through?
DbRow	DbCachedIterator.nextRow()           Get the next DbRow in the table.
java.lang.String	DbAndExpr.getQueryString()           Returns the query string related to this expression.
int	DbAndExpr.setSqlValues(java.sql.PreparedStatement ps, int i)           Obscure...
abstract  DbColumn	DbAbstractTable.getColumn(java.lang.String name)           Get the DbColumn representing the column with this name.
abstract  DbColumn	DbAbstractTable.getColumn(int index)           Get the column of the given index.
abstract  java.lang.Object	DbAbstractTable.getDefault(int index)           Returns the default value for the field at the given index.
abstract  java.lang.Object	DbAbstractTable.getDefault(java.lang.String name)           Returns the default value for the field whose name is specified.
DbInserter	DbAbstractTable.inserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbInserter	DbAbstractTable.simpleInserter(DbSelector selector)           Return an inserter for inserting new data in the database.
DbInserter	DbAbstractTable.inserter()           Return an inserter for inserting new data in the database.
DbInserter	DbAbstractTable.simpleInserter()           Return an inserter for inserting new data in the database.
DbUpdater	DbAbstractTable.updater()           Returns an updater for this table.
DbUpdater	DbAbstractTable.simpleUpdater()           Return an updater for updating rows in the database.
DbDeleter	DbAbstractTable.deleter()           Returns a deleter for this table.
DbDeleter	DbAbstractTable.simpleDeleter()           Returns a deleter for deleting rows in the database.
static java.lang.String	ConnectionString.build(DbManager manager, java.lang.String dbms, java.lang.String driver, java.lang.String dbmsAddress, int port, java.lang.String dbDir, java.lang.String dbName, java.lang.String userName, java.lang.String password)           Returns a connection string for given parameters
static java.lang.String	ConnectionString.build(DbManager manager, java.lang.String dbms, java.lang.String driver, java.lang.String dbmsAddress, int port, java.lang.String dbName, java.lang.String userName, java.lang.String password)           Returns a connection string for given parameters

 

Constructors in javatools.db that throw DbException

DbTable(DbDatabase db)           Creates a new DbTable.

DbSelector(DbDatabase db)           Create a new DbSelector.

DbReferencedTable(DbDatabase db)

DbJoinedTable(DbDatabase db, DbAbstractTable tabLeft, DbAbstractTable tabRight, int pJoinType, DbExpr pJoinCondition)           Creates a new instance of DbJoinedTable

DbFixedAbstractTable(DbDatabase db)           Creates new DbFixedAbstractTable

DbCachedTable(DbDatabase db)           Creates new DbCachedTable

 

---

Overview  Package  Class   Use  Deprecated  Index
Home >> All >> javatools >> [ db overview ]	PREV  NEXT

---