com.serotonin.mango.db

Class DerbyAccess

java.lang.Object

com.serotonin.mango.db.DatabaseAccess

com.serotonin.mango.db.DerbyAccess

public class DerbyAccess
extends DatabaseAccess

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) class	DerbyAccess.IdentityStart

Nested classes/interfaces inherited from class com.serotonin.mango.db.DatabaseAccess

DatabaseAccess.DatabaseType

Field Summary

Fields

Modifier and Type	Field and Description
private org.apache.derby.jdbc.EmbeddedXADataSource40	dataSource
private static double	LARGEST_NEGATIVE
private static double	LARGEST_POSITIVE
private org.apache.commons.logging.Log	log
private static double	SMALLEST_NEGATIVE
private static double	SMALLEST_POSITIVE

Fields inherited from class com.serotonin.mango.db.DatabaseAccess

ctx

Constructor Summary

Constructors

Constructor and Description
DerbyAccess(javax.servlet.ServletContext ctx)

Method Summary

Modifier and Type	Method and Description
double	applyBounds(double value)
private void	compressTable(com.serotonin.db.spring.ExtendedJdbcTemplate ejt, java.lang.String tableName)
void	executeCompress(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
java.io.File	getDataDirectory()
javax.sql.DataSource	getDataSource()
DatabaseAccess.DatabaseType	getType()
private java.lang.String	getUrl(java.lang.String propertyPrefix)
protected void	initializeImpl(java.lang.String propertyPrefix)
protected void	initializeImpl(java.lang.String propertyPrefix, java.lang.String dataSourceName)
protected boolean	newDatabaseCheck(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
protected void	postInitialize(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
void	runScript(java.lang.String[] script, java.io.OutputStream out)
void	terminate()
private void	updateIndentityStarts(com.serotonin.db.spring.ExtendedJdbcTemplate ejt) This method updates the tables with identity autoincrement values that are the maximum of the current autoincrement value or max(id)+1.

Methods inherited from class com.serotonin.mango.db.DatabaseAccess

createDatabaseAccess, doInConnection, getDatabaseAccess, getDatabasePassword, initialize, prepareStatement

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

LARGEST_POSITIVE

private static final double LARGEST_POSITIVE

See Also:

Constant Field Values

SMALLEST_POSITIVE

private static final double SMALLEST_POSITIVE

See Also:

Constant Field Values

LARGEST_NEGATIVE

private static final double LARGEST_NEGATIVE

See Also:

Constant Field Values

SMALLEST_NEGATIVE

private static final double SMALLEST_NEGATIVE

See Also:

Constant Field Values

dataSource

private org.apache.derby.jdbc.EmbeddedXADataSource40 dataSource

Constructor Detail

DerbyAccess

public DerbyAccess(javax.servlet.ServletContext ctx)

Method Detail

getType

public DatabaseAccess.DatabaseType getType()

Specified by:

getType in class DatabaseAccess

initializeImpl

protected void initializeImpl(java.lang.String propertyPrefix)

Specified by:

initializeImpl in class DatabaseAccess

initializeImpl

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

Specified by:

initializeImpl in class DatabaseAccess

getUrl

private java.lang.String getUrl(java.lang.String propertyPrefix)

terminate

public void terminate()

Specified by:

terminate in class DatabaseAccess

getDataSource

public javax.sql.DataSource getDataSource()

Specified by:

getDataSource in class DatabaseAccess

newDatabaseCheck

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

Specified by:

newDatabaseCheck in class DatabaseAccess

postInitialize

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

Overrides:

postInitialize in class DatabaseAccess

runScript

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

Specified by:

runScript in class DatabaseAccess

Throws:

java.lang.Exception

getDataDirectory

public java.io.File getDataDirectory()

Specified by:

getDataDirectory in class DatabaseAccess

updateIndentityStarts

private void updateIndentityStarts(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)

This method updates the tables with identity autoincrement values that are the maximum of the current autoincrement value or max(id)+1. This ensures that updates to tables that may have occurred are handled, and prevents cases where inserts are attempted with identities that already exist.

applyBounds

public double applyBounds(double value)

Specified by:

applyBounds in class DatabaseAccess

executeCompress

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

Specified by:

executeCompress in class DatabaseAccess

compressTable

private void compressTable(com.serotonin.db.spring.ExtendedJdbcTemplate ejt,
                           java.lang.String tableName)