com.serotonin.mango.db

Class DatabaseAccess

java.lang.Object

com.serotonin.mango.db.DatabaseAccess

Direct Known Subclasses:

BasePooledAccess, DerbyAccess

public abstract class DatabaseAccess
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DatabaseAccess.DatabaseType

Field Summary

Fields

Modifier and Type	Field and Description
protected javax.servlet.ServletContext	ctx
private org.apache.commons.logging.Log	log

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DatabaseAccess(javax.servlet.ServletContext ctx)

Method Summary

Modifier and Type	Method and Description
abstract double	applyBounds(double value)
static DatabaseAccess	createDatabaseAccess(javax.servlet.ServletContext ctx)
void	doInConnection(com.serotonin.db.spring.ConnectionCallbackVoid callback)
abstract void	executeCompress(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
static DatabaseAccess	getDatabaseAccess()
java.lang.String	getDatabasePassword(java.lang.String propertyPrefix)
abstract java.io.File	getDataDirectory()
abstract javax.sql.DataSource	getDataSource()
abstract DatabaseAccess.DatabaseType	getType()
void	initialize()
protected abstract void	initializeImpl(java.lang.String propertyPrefix)
protected abstract void	initializeImpl(java.lang.String propertyPrefix, java.lang.String dataSourceName)
protected abstract boolean	newDatabaseCheck(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
protected void	postInitialize(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
java.sql.PreparedStatement	prepareStatement(java.sql.Connection connection, java.lang.String sql, java.lang.String generatedKey) Prepares the statement to insert operation that returning the auto-generated key from the inserted row
abstract void	runScript(java.lang.String[] script, java.io.OutputStream out)
abstract void	terminate()

Methods inherited from class java.lang.Object

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

Field Detail

log

private final org.apache.commons.logging.Log log

ctx

protected final javax.servlet.ServletContext ctx

Constructor Detail

DatabaseAccess

protected DatabaseAccess(javax.servlet.ServletContext ctx)

Method Detail

createDatabaseAccess

public static DatabaseAccess createDatabaseAccess(javax.servlet.ServletContext ctx)

getDatabaseAccess

public static DatabaseAccess getDatabaseAccess()

initialize

public void initialize()

getType

public abstract DatabaseAccess.DatabaseType getType()

terminate

public abstract void terminate()

getDataSource

public abstract javax.sql.DataSource getDataSource()

applyBounds

public abstract double applyBounds(double value)

getDataDirectory

public abstract java.io.File getDataDirectory()

executeCompress

public abstract void executeCompress(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)

initializeImpl

protected abstract void initializeImpl(java.lang.String propertyPrefix)

initializeImpl

protected abstract void initializeImpl(java.lang.String propertyPrefix,
                                       java.lang.String dataSourceName)

postInitialize

protected void postInitialize(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)

newDatabaseCheck

protected abstract boolean newDatabaseCheck(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)

runScript

public abstract void runScript(java.lang.String[] script,
                               java.io.OutputStream out)
                        throws java.lang.Exception

Throws:

java.lang.Exception

doInConnection

public void doInConnection(com.serotonin.db.spring.ConnectionCallbackVoid callback)

getDatabasePassword

public java.lang.String getDatabasePassword(java.lang.String propertyPrefix)

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.sql.Connection connection,
                                                   java.lang.String sql,
                                                   java.lang.String generatedKey)
                                            throws java.sql.SQLException

Prepares the statement to insert operation that returning the auto-generated key from the inserted row

Parameters:

sql - an SQL statement that may contain one or more '?' IN parameter placeholders

generatedKey - name of the generated column that should be returned from the inserted row or rows

Returns:

a new PreparedStatement object, containing the pre-compiled statement, that is capable of returning the auto-generated key designated by the generated column name.

Throws:

java.sql.SQLException