void |
DBAccessProvider.addColumn(ExtendedConnection con,
String tableName,
String columnName,
String correspondingDbType) |
Adds an additional column to the designated table of the designated type.
|
String |
DBAccessProvider.createRecursionTable(ExtendedConnection connection,
String[] selectAttributes,
String[] rootAttributes,
String tableName,
String startCondition,
ParentToChildConnection[] parentToChildConnections) |
|
String |
DBAccessProvider.createRecursionTable(ExtendedConnection connection,
String[] selectAttributes,
String tableName,
String startCondition,
ParentToChildConnection[] parentToChildConnections,
int maxDepth) |
Creates a (temporary) table or view containing tuples that match a
recursive/hierarchical SQL-query which is based on the specified
parameters.
|
void |
DBAccessProvider.createSequence(ExtendedConnection connection,
String sequenceName,
long start,
long increment) |
Creates a new sequence in the database.
|
void |
DBAccessProvider.dropAllRecursionTables(ExtendedConnection connection) |
All tables that have been created via createRecursionTable(String[],
String, String, String[], int) are dropped.
|
void |
DBAccessProvider.dropColumn(ExtendedConnection con,
String tableName,
String columnName) |
Drops the specified column from the table which corresponds to an
ALTER TABLE DROP COLUMN statement.
|
void |
DBAccessProvider.dropRecursionTable(ExtendedConnection connection,
String tableName) |
The specified table that has been created via
createRecursionTable(String[], String, String, String[], int)
is dropped.
|
void |
DBAccessProvider.dropSequence(ExtendedConnection connection,
String sequenceName) |
Drop the sequence with the given name.
|
String |
DBAccessProvider.getAddForeignKey(ExtendedConnection con,
de.aristaflow.adept2.base.dbaccess.model.ForeignKey fk,
boolean quoteIdentifiers) |
Gets an SQL string for ALTER TABLE which adds the designated
foreign key.
|
int |
DBAccessProvider.getColumnType(ExtendedConnection con,
String columnName,
String tableName) |
Gets the type of a specific column as java.sql.Types.
|
Timestamp |
DBAccessProvider.getCurrentTime(ExtendedConnection con) |
Gets the current time (as timestamp) from the underlying DBMS in UTC timezone.
|
void |
DBAccessProvider.lockTable(ExtendedConnection con,
String tableName,
long timeout) |
Locks the designated table exclusively until the end of the corresponding
transaction.
|
long |
DBAccessProvider.nextID(ExtendedConnection connection,
String sequenceName) |
Returns the next ID from the sequence with the given name.
|
void |
DBAccessProvider.renameColumn(ExtendedConnection con,
String tableName,
String oldColumnName,
String newColumnName) |
Renames the designated column from the table which corresponds to an
ALTER TABLE RENAME COLUMN statement.
|
void |
DBAccessProvider.renameTable(ExtendedConnection con,
String oldName,
String newName) |
Renames the designated table using the designated new name.
|
boolean |
DBAccessProvider.sequenceExists(ExtendedConnection connection,
String sequenceName) |
Returns whether a sequence with the given name exists.
|
void |
DBAccessProvider.setDefaultLockTimeout(ExtendedConnection con) |
Sets the default value for the lock timeout.
|
long |
DBAccessProvider.setLockTimeout(ExtendedConnection con,
long timeout) |
Sets the lock timeout for the current transaction or connection in the
designated connection to the designated timeout (in milliseconds) and
returns the current lock timeout.
|
void |
DBAccessProvider.terminate(ExtendedConnection con) |
Terminates this access provider allowing it to do some clean-up if
required.
|
void |
DBAccessProvider.updateColumnDefault(ExtendedConnection con,
String tableName,
String columnName,
Object defaultValue) |
Sets the designated value as default value for the designated column.
|
void |
DBAccessProvider.updateColumnsNullable(ExtendedConnection con,
String tableName,
boolean nullable,
String... columns) |
Sets the designated columns of the designated table nullable (not
nullable).
|
void |
DBAccessProvider.updateColumnsType(ExtendedConnection con,
Map<String,Collection<String>> columns,
String correspondingDbType) |
Sets the type of the designated columns of the designated tables to the provided one.
|
void |
DBAccessProvider.updateColumnType(ExtendedConnection con,
String tableName,
String columnName,
String correspondingDbType) |
Sets the type of the designated column of the designated table to the
provided one.
|
String |
DBAccessProvider.useLockTimeout(ExtendedConnection con,
String query,
long timeout) |
Appends the designated lock timeout in milliseconds to the designated query
(DDL and DML are not supported!).
|