Skip navigation links

com.sigmadynamics.server.DataServices.DatabaseProvider
Class DatabaseTable

java.lang.Object
com.sigmadynamics.server.DataServices.DatabaseProvider.DatabaseTable

All Implemented Interfaces:

BatchUpdaterClient

Direct Known Subclasses:

TableWithPuts

public abstract class DatabaseTable

extends java.lang.Object

implements BatchUpdaterClient

Field Summary

protected DatabaseProviderInterface	database
protected static SDCategory	log
protected java.lang.String	sqlString
protected TableCacheEntry	tableCacheEntry
protected java.lang.String	tableName

Method Summary

DeadlockHandler	getDeadlockHandler()
java.lang.String	getName() Returns the name of the database object, which can be a table or a stored procedure.
abstract java.lang.String	getOperationName() Returns SQL operation name, which can be INSERT, UPDATE, DELETE for a table, or EXECUTE for a stored procedure.
DatabaseProviderInterface	getProvider()
java.lang.String	getQualifiedName() Returns a string like "table table_name" or "stored procedure stored_procedure_name".
java.lang.String	getSql()
java.lang.String	getSQLStatement() Returns the SQL string that was prepared.
void	initializeFromRefreshedCache() Tells the object that it needs to refresh itself from cache because an error occurred and maybe newer cache information will help it succeed.
java.sql.PreparedStatement	prepareStatement(java.sql.Connection conn)
abstract void	rebuildSql()
void	reportRetries(int retryCount) Generates a warning that execution was successful but required at least one retry.
void	setSqlString(java.lang.String sqlString)
java.lang.String[]	translateColumnNames(java.lang.String[] colNames) Translate column names so that they will work on databases that are or are not case sensitive.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

database

protected final DatabaseProviderInterface database

sqlString

protected java.lang.String sqlString

tableName

protected java.lang.String tableName

tableCacheEntry

protected TableCacheEntry tableCacheEntry

log

protected static final SDCategory log

Method Detail

getName

public java.lang.String getName()

Description copied from interface: BatchUpdaterClient

Returns the name of the database object, which can be a table or a stored procedure.

Specified by:

getName in interface BatchUpdaterClient

getQualifiedName

public java.lang.String getQualifiedName()

Description copied from interface: BatchUpdaterClient

Returns a string like "table table_name" or "stored procedure stored_procedure_name".

Specified by:

getQualifiedName in interface BatchUpdaterClient

Returns:

the qualified name of the object.

getProvider

public DatabaseProviderInterface getProvider()

Specified by:

getProvider in interface BatchUpdaterClient

getSql

public java.lang.String getSql()

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.sql.Connection conn)

Specified by:

prepareStatement in interface BatchUpdaterClient

translateColumnNames

public java.lang.String[] translateColumnNames(java.lang.String[] colNames)

Translate column names so that they will work on databases that are or are not case sensitive.

The solution used here is to do a case insensitive match of the columns with the names of the columns in the database and then use the names from the database.

Parameters:

colNames - the names of the columns to translate

Returns:

a new array of column names

getDeadlockHandler

public DeadlockHandler getDeadlockHandler()

setSqlString

public void setSqlString(java.lang.String sqlString)

reportRetries

public void reportRetries(int retryCount)

Description copied from interface: BatchUpdaterClient

Generates a warning that execution was successful but required at least one retry.

Specified by:

reportRetries in interface BatchUpdaterClient

initializeFromRefreshedCache

public void initializeFromRefreshedCache()

Description copied from interface: BatchUpdaterClient

Tells the object that it needs to refresh itself from cache because an error occurred and maybe newer cache information will help it succeed.

Specified by:

initializeFromRefreshedCache in interface BatchUpdaterClient

rebuildSql

public abstract void rebuildSql()

Specified by:

rebuildSql in interface BatchUpdaterClient

getOperationName

public abstract java.lang.String getOperationName()

Description copied from interface: BatchUpdaterClient

Returns SQL operation name, which can be INSERT, UPDATE, DELETE for a table, or EXECUTE for a stored procedure.

Specified by:

getOperationName in interface BatchUpdaterClient

getSQLStatement

public java.lang.String getSQLStatement()

Description copied from interface: BatchUpdaterClient

Returns the SQL string that was prepared.

Specified by:

getSQLStatement in interface BatchUpdaterClient

Skip navigation links