| java.lang.Object
 hu.netmind.persistence.GenericDatabase
hu.netmind.persistence.OracleDatabaseImpl
| OracleDatabaseImpl | | public class OracleDatabaseImpl extends GenericDatabase (Code) | | Oracle database implementation.
Limitations:
- Strings are limited to 1024 characters.
author:
Brautigam Robert
version:
CVS Revision: $Revision$ |
| Method Summary | |
| protected String | getAddColumnStatement(String tableName, String columnName, String columnType)
Get the statement to add a column to a table. | | protected String | getCountStatement(String stmt)
Get the count statement for the given statement. | | protected String | getCreateIndexName(Connection connection, String tableName, String field)
Get an unused index name. | | protected Object | getJavaValue(Object value, int type, Class javaType)
Convert incoming value from database into java format. | | protected String | getLimitStatement(String statement, Limits limits, List types)
Get the limit component of statement, if it can be expressed in
the current database with simple statement part. | | protected String | getSQLTypeName(int sqltype)
Override to correct type conflicts an unsupported types. | | protected Object | getSQLValue(Object value)
Throw exception when String is longer than Oracle can handle. | | protected int | getTableAttributeType(ResultSet rs)
Fix custom data types not supported by database. | | protected HashMap | getTableAttributeTypes(Connection connection, String tableName)
Get the data types of a given table. | | protected String | getTableDeclaration(String tableName, String alias)
Get the table declaration for a select statment. | | protected void | prepareStatement(PreparedStatement pstmt, Limits limits)
Set the limits of the prepared statement if offset is 0. | | protected Expression | transformExpression(Expression expr)
Transform 'ilike' to upper case like.
Parameters:
expr - The expression to possibly transform. |
| OracleDatabaseImpl | | public OracleDatabaseImpl()(Code) | | |
| getAddColumnStatement | | protected String getAddColumnStatement(String tableName, String columnName, String columnType)(Code) | | Get the statement to add a column to a table.
|
| getCountStatement | | protected String getCountStatement(String stmt)(Code) | | Get the count statement for the given statement.
|
| getJavaValue | | protected Object getJavaValue(Object value, int type, Class javaType)(Code) | | Convert incoming value from database into java format.
|
| getLimitStatement | | protected String getLimitStatement(String statement, Limits limits, List types)(Code) | | Get the limit component of statement, if it can be expressed in
the current database with simple statement part.
Parameters:
limits - The limits to apply. |
| getSQLTypeName | | protected String getSQLTypeName(int sqltype)(Code) | | Override to correct type conflicts an unsupported types.
|
| getSQLValue | | protected Object getSQLValue(Object value)(Code) | | Throw exception when String is longer than Oracle can handle.
|
| getTableAttributeType | | protected int getTableAttributeType(ResultSet rs) throws SQLException(Code) | | Fix custom data types not supported by database.
|
| getTableAttributeTypes | | protected HashMap getTableAttributeTypes(Connection connection, String tableName) throws SQLException(Code) | | Get the data types of a given table.
A map of names with the sql type number as value. |
| getTableDeclaration | | protected String getTableDeclaration(String tableName, String alias)(Code) | | Get the table declaration for a select statment.
|
| prepareStatement | | protected void prepareStatement(PreparedStatement pstmt, Limits limits) throws SQLException(Code) | | Set the limits of the prepared statement if offset is 0. This
is to avoid using complicated limit+offset inner selects, when
the first page is queried.
|
| transformExpression | | protected Expression transformExpression(Expression expr)(Code) | | Transform 'ilike' to upper case like.
Parameters:
expr - The expression to possibly transform. A transformed expression. |
| Methods inherited from hu.netmind.persistence.GenericDatabase | protected DatabaseStatistics addColumn(Connection connection, String tableName, String columnName, String columnType)(Code)(Java Doc)
protected DatabaseStatistics alterTable(Connection connection, String tableName, List removedAttributes, List addedAttributes, Map attributeTypes, List keyAttributeNames)(Code)(Java Doc)
protected DatabaseStatistics createIndexes(Connection connection, String tableName, Map attributeTypes)(Code)(Java Doc)
protected DatabaseStatistics createTable(Connection connection, String tableName, Map attributeTypes, List keyAttributeNames)(Code)(Java Doc)
protected DatabaseStatistics dropColumn(Connection connection, String tableName, String columnName)(Code)(Java Doc)
protected DatabaseStatistics dropTable(Connection connection, String tableName)(Code)(Java Doc)
public DatabaseStatistics ensureTable(Connection connection, String tableName, Map attributeTypes, List keyAttributeNames, boolean create)(Code)(Java Doc)
protected void executeUpdate(Connection connection, String statement)(Code)(Java Doc)
protected String getAddColumnStatement(String tableName, String columnName, String columnType)(Code)(Java Doc)
protected Class getAttributeType(String tableName, String attributeName)(Code)(Java Doc)
protected Map getAttributes(String tableName)(Code)(Java Doc)
protected String getCountStatement(String stmt)(Code)(Java Doc)
protected String getCreateIndexName(Connection connection, String tableName, String field)(Code)(Java Doc)
protected String getCreateIndexStatement(String indexName, String tableName, String field, Class fieldClass)(Code)(Java Doc)
protected String getCreateTableStatement(Connection connection, String tableName)(Code)(Java Doc)
protected String getDropColumnStatement(String tableName, String columnName)(Code)(Java Doc)
protected String getInsertStatement(String tableName, List attributeNames)(Code)(Java Doc)
protected Object getJavaValue(Object value, int type, Class javaType)(Code)(Java Doc)
protected String getLimitStatement(String statement, Limits limits, List types)(Code)(Java Doc)
protected String getQuerySource(TableTerm term, Set queryColumns, List types)(Code)(Java Doc)
protected String getQuerySource(QueryStatement stmt, List types)(Code)(Java Doc)
protected String getRemoveStatement(String tableName, List attributeNames)(Code)(Java Doc)
protected int getSQLType(Class type)(Code)(Java Doc)
protected String getSQLTypeName(int sqltype)(Code)(Java Doc)
protected Object getSQLValue(Object value)(Code)(Java Doc)
protected String getSaveStatement(String tableName, List keyNames, List attributeNames, Map keys)(Code)(Java Doc)
protected int getTableAttributeType(ResultSet rs) throws SQLException(Code)(Java Doc)
protected HashMap getTableAttributeTypes(Connection connection, String tableName) throws SQLException(Code)(Java Doc)
protected String getTableDeclaration(String tableName, String alias)(Code)(Java Doc)
public DatabaseStatistics insert(Connection connection, String tableName, Map attributes)(Code)(Java Doc)
protected void prepareResultSet(ResultSet rs, Limits limits) throws SQLException(Code)(Java Doc)
protected void prepareStatement(PreparedStatement pstmt, Limits limits) throws SQLException(Code)(Java Doc)
public void release(ConnectionSource source)(Code)(Java Doc)
public DatabaseStatistics remove(Connection connection, String tableName, Map attributes)(Code)(Java Doc)
public DatabaseStatistics save(Connection connection, String tableName, Map keys, Map attributes)(Code)(Java Doc)
public DatabaseStatistics search(Connection connection, QueryStatement stmt, Limits limits, SearchResult searchResult)(Code)(Java Doc)
protected Expression transformExpression(Expression expr)(Code)(Java Doc)
|
|
|