A B C D E G H I L N O P R S T U

A

anyRowExists(Connection, String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 

B

blockSize - Variable in class org.pfsw.db.util.ObjectIdentifierDB
 

C

categoryString() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
checkCategoryRowExists(Connection) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
checkTableExists(Connection) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
close() - Method in class org.pfsw.db.util.SQLExecutor
Closes all open connections.
closeConnection(Connection) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
closeStatement(Statement) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
closeStatement(Statement) - Method in class org.pfsw.db.util.SQLExecutor
Closes the given statement.
connection() - Method in class org.pfsw.db.util.SQLExecutor
 
connection(Connection) - Method in class org.pfsw.db.util.SQLExecutor
 
createOidTable(Connection) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
createRowForCategory(Connection) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
current() - Static method in class org.pfsw.db.util.DBUtil
Returns the only instance this class supports (design pattern "Singleton")

D

DataSourceProxy - Class in org.pfsw.db.util
This class is a datasource wrapper for other datasources or simple connections.
DataSourceProxy(Connection) - Constructor for class org.pfsw.db.util.DataSourceProxy
Initialize the new instance with a ready-to-use connection.
DataSourceProxy(String, String, String) - Constructor for class org.pfsw.db.util.DataSourceProxy
Initialize the new instance with all necessary connection information.
DataSourceProxy(String) - Constructor for class org.pfsw.db.util.DataSourceProxy
Initialize the new instance with an URL for the database connection.
DataSourceProxy(DataSource, String, String) - Constructor for class org.pfsw.db.util.DataSourceProxy
 
DataSourceProxy(DataSource) - Constructor for class org.pfsw.db.util.DataSourceProxy
 
DBUtil - Class in org.pfsw.db.util
Helper and convenience methods for Java database handling.
DBUtil() - Constructor for class org.pfsw.db.util.DBUtil
 

E

execute(String) - Method in class org.pfsw.db.util.SQLExecutor
Executes the given SQL command and returns the number of affected rows.
executeSQL(String) - Method in class org.pfsw.db.util.SQLExecutor
Executes the given SQL command and returns true if the execution was successful.
executeWriteStatement(PreparedStatement) - Method in class org.pfsw.db.util.SQLExecutor
Executes the given statement and returns the number of affected rows.

G

getBlockSize() - Method in class org.pfsw.db.util.ObjectIdentifierDB
Returns the block size this generator is using.
getCategory() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getConnection() - Method in class org.pfsw.db.util.DataSourceProxy
Attempt to establish a database connection
getConnection(String, String) - Method in class org.pfsw.db.util.DataSourceProxy
Attempt to establish a database connection
getConnection() - Method in class org.pfsw.db.util.SQLExecutor
 
getDataSource() - Method in class org.pfsw.db.util.DataSourceProxy
 
getDataSource() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getDataSource() - Method in class org.pfsw.db.util.SQLExecutor
 
getDataSourceConnection() - Method in class org.pfsw.db.util.DataSourceProxy
Attempt to establish a database connection using the wrapped datasource
getDbConnection() - Method in class org.pfsw.db.util.DataSourceProxy
 
getDbConnection() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getDbPassword() - Method in class org.pfsw.db.util.DataSourceProxy
 
getDbUrl() - Method in class org.pfsw.db.util.DataSourceProxy
 
getDbUserid() - Method in class org.pfsw.db.util.DataSourceProxy
 
getLastPrefetchedId() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getLogger() - Static method in class org.pfsw.db.LoggerProvider
Returns the current logger used by this component to report errors and exceptions.
getLoginTimeout() - Method in class org.pfsw.db.util.DataSourceProxy
Returns the maximum time in seconds that this data source can wait while attempting to connect to a database.
getLogWriter() - Method in class org.pfsw.db.util.DataSourceProxy
Returns the log writer for this data source
getNextId() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getQualifier() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getSelect() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getSelectAny() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getSelectCategory() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getTableName() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
getUpdate() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 

H

hasConnection() - Method in class org.pfsw.db.util.DataSourceProxy
 
hasDataSource() - Method in class org.pfsw.db.util.DataSourceProxy
 

I

idFromDB() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
INITIAL_BLOCKSIZE - Static variable in class org.pfsw.db.util.ObjectIdentifierDB
 
isClosed() - Method in class org.pfsw.db.util.SQLExecutor
 
isDriverRegistered(String) - Method in class org.pfsw.db.util.DBUtil
Returns true if the database driver with the specified class name is registered at the java.sql.DriverManager.
isWrapperFor(Class<?>) - Method in class org.pfsw.db.util.DataSourceProxy
Always returns false.

L

loadAndRegisterDriver(String) - Method in class org.pfsw.db.util.DBUtil
Loads the database driver with the given class name and registers it at the java.sql.DriverManager.
loadNextIdFromDB() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
logger() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
LoggerProvider - Class in org.pfsw.db
This is the central access point for the package's logger.

N

newConnection() - Method in class org.pfsw.db.util.SQLExecutor
 
nextIdentifier() - Method in interface org.pfsw.db.util.ObjectIdentifierProducer
Returns a new identifier which is different to the last one.

O

ObjectIdentifierDB - Class in org.pfsw.db.util
Instances of this class provide generation of unique identifiers backed by a specific database table.
ObjectIdentifierDB(DataSource) - Constructor for class org.pfsw.db.util.ObjectIdentifierDB
Initialize the new instance with the given data source.
ObjectIdentifierDB(String, DataSource) - Constructor for class org.pfsw.db.util.ObjectIdentifierDB
Initialize the new instance with the given data source.
ObjectIdentifierDB(DataSource, String) - Constructor for class org.pfsw.db.util.ObjectIdentifierDB
Initialize the new instance with the data source.
ObjectIdentifierDB(String, DataSource, String) - Constructor for class org.pfsw.db.util.ObjectIdentifierDB
Initialize the new instance with the data source.
ObjectIdentifierGenerator - Class in org.pfsw.db.util
This class provides identifiers by incrementing an internal counter, starting at 1.
ObjectIdentifierGenerator() - Constructor for class org.pfsw.db.util.ObjectIdentifierGenerator
Initialize the new instance with default values.
ObjectIdentifierGenerator(int) - Constructor for class org.pfsw.db.util.ObjectIdentifierGenerator
Initialize the new instance with the length for the generated identifiers.
ObjectIdentifierGenerator(long, int) - Constructor for class org.pfsw.db.util.ObjectIdentifierGenerator
Initialize the new instance with the length for the generated identifiers and the id to start with.
ObjectIdentifierProducer - Interface in org.pfsw.db.util
An object that generates new identifiers must implement this interface.
OID_CN_BLOCKSIZE - Static variable in class org.pfsw.db.util.ObjectIdentifierDB
 
OID_CN_CATEGORY - Static variable in class org.pfsw.db.util.ObjectIdentifierDB
 
OID_CN_NEXTID - Static variable in class org.pfsw.db.util.ObjectIdentifierDB
 
OID_TABLE_NAME - Static variable in class org.pfsw.db.util.ObjectIdentifierDB
 
org.pfsw.db - package org.pfsw.db
Database Utilities
Contains the logging interface for all classes in this component.
org.pfsw.db.util - package org.pfsw.db.util
Database Utility Classes
Contains classes for DataSource support and object ID generation based on a database table.

P

prepareWriteStatement(String) - Method in class org.pfsw.db.util.SQLExecutor
Returns a PreparedStatement for the given SQL command.

R

reportSQLException(String, SQLException) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 

S

setBlockSize(int) - Method in class org.pfsw.db.util.ObjectIdentifierDB
Set the block size this generator is using.
setCategory(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setDataSource(DataSource) - Method in class org.pfsw.db.util.DataSourceProxy
 
setDataSource(DataSource) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setDataSource(DataSource) - Method in class org.pfsw.db.util.SQLExecutor
 
setDbConnection(Connection) - Method in class org.pfsw.db.util.DataSourceProxy
 
setDbPassword(String) - Method in class org.pfsw.db.util.DataSourceProxy
 
setDbUrl(String) - Method in class org.pfsw.db.util.DataSourceProxy
 
setDbUserid(String) - Method in class org.pfsw.db.util.DataSourceProxy
 
setDriverClassName(String) - Method in class org.pfsw.db.util.DataSourceProxy
Creates an instance of the given class name in order to register the database driver.
setLastPrefetchedId(long) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setLogger(Logger) - Static method in class org.pfsw.db.LoggerProvider
Replace the logger by another one.
setLoginTimeout(int) - Method in class org.pfsw.db.util.DataSourceProxy
Sets the maximum time in seconds that this data source can wait while attempting to connect to a database.
setLogWriter(PrintWriter) - Method in class org.pfsw.db.util.DataSourceProxy
Sets the log writer for this data source
setNextId(long) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setNextIdInDB(Connection, long) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setQualifier(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setSelect(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setSelectAny(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setSelectCategory(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
setUpdate(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
sqlCreateOidTable() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
SQLExecutor - Class in org.pfsw.db.util
Provides an easy to use interface to execute SQL statements against a database.
SQLExecutor(DataSource) - Constructor for class org.pfsw.db.util.SQLExecutor
Initialize the new instance with default values.
sqlInsertCategoryRow(String) - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
sqlSelectAny() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
sqlSelectCategory() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
sqlSelectNextId() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 
sqlUpdateNextId() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 

T

tableInitialized - Variable in class org.pfsw.db.util.ObjectIdentifierDB
 
tableInitialized() - Method in class org.pfsw.db.util.ObjectIdentifierDB
 

U

unwrap(Class<T>) - Method in class org.pfsw.db.util.DataSourceProxy
Always throws SQLException, becaus eno interfaces are supported.

A B C D E G H I L N O P R S T U