com.serotonin.mango.db

Class Oracle11GAccess

java.lang.Object

com.serotonin.mango.db.DatabaseAccess

com.serotonin.mango.db.BasePooledAccess

com.serotonin.mango.db.Oracle11GAccess

public class Oracle11GAccess
extends BasePooledAccess

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private static class	Oracle11GAccess.ErrorCode

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

DatabaseAccess.DatabaseType

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	CREATE_SCHEMA_SCRIPT_PATH
private org.apache.commons.logging.Log	log
private static java.lang.String	ORACLE_DRIVER_CLASS

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

dataSource, dataSourceFound

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

ctx

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
double	applyBounds(double value)
protected void	createSchema(java.lang.String scriptFile)
void	executeCompress(com.serotonin.db.spring.ExtendedJdbcTemplate ejt)
protected java.lang.String	getDriverClassName()
DatabaseAccess.DatabaseType	getType()
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)
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

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

getDataDirectory, getDataSource, getUrl, runScript, terminate

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

createDatabaseAccess, doInConnection, getDatabaseAccess, getDatabasePassword, initialize, postInitialize

Methods inherited from class java.lang.Object

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

Field Detail

CREATE_SCHEMA_SCRIPT_PATH

private static final java.lang.String CREATE_SCHEMA_SCRIPT_PATH

See Also:

Constant Field Values

ORACLE_DRIVER_CLASS

private static final java.lang.String ORACLE_DRIVER_CLASS

See Also:

Constant Field Values

log

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

Constructor Detail

Oracle11GAccess

public Oracle11GAccess(javax.servlet.ServletContext ctx)

Method Detail

initializeImpl

protected void initializeImpl(java.lang.String propertyPrefix)

Overrides:

initializeImpl in class BasePooledAccess

initializeImpl

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

Overrides:

initializeImpl in class BasePooledAccess

getType

public DatabaseAccess.DatabaseType getType()

Specified by:

getType in class DatabaseAccess

getDriverClassName

protected java.lang.String getDriverClassName()

Specified by:

getDriverClassName in class BasePooledAccess

createSchema

protected void createSchema(java.lang.String scriptFile)

Overrides:

createSchema in class BasePooledAccess

newDatabaseCheck

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

Specified by:

newDatabaseCheck in class DatabaseAccess

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

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

Overrides:

prepareStatement in class DatabaseAccess

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