net.datenwerke.rs.base.service.dbhelper.db.oracle

Class Oracle

java.lang.Object

net.datenwerke.rs.base.service.dbhelper.DatabaseHelper

net.datenwerke.rs.base.service.dbhelper.db.oracle.Oracle

public class Oracle
extends DatabaseHelper

Nested Class Summary

Nested classes/interfaces inherited from class net.datenwerke.rs.base.service.dbhelper.DatabaseHelper

DatabaseHelper.ResultSetObjectHandler

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	CONVERT_BLOBS_FOR_FILTERING_PROPERTY
static java.lang.String	DB_DESCRIPTION
static java.lang.String	DB_DESCRIPTOR
static java.lang.String	DB_DRIVER
static java.lang.String	DB_NAME

Constructor Summary

Constructors

Constructor and Description
Oracle(StupidOracleService sos, ConfigService configService)

Method Summary

Modifier and Type	Method and Description
java.lang.String	createDummyQuery()
DatabaseHelper.ResultSetObjectHandler	createResultSetHandler(java.sql.ResultSet resultSet, java.sql.Connection con)
java.lang.String	getDescription()
java.lang.String	getDescriptor() A unique descriptor that is not longer than 32 characters.
java.lang.String	getDriver()
java.lang.String	getName()
LimitQuery	getNewLimitQuery(Query nestedQuery, QueryBuilder queryBuilder)
OffsetQuery	getNewOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrderOffsetQuery	getNewOrderOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
java.lang.String	prepareColumnForComparison(java.lang.String name, Column column) Can be used to put a function on top of a column for comparision (for example clobs in oracle need a to_char).
java.lang.String	prepareColumnForDistinctQuery(java.lang.String name, Column column)
java.lang.String	prepareColumnForSorting(java.lang.String name, Column column)

Methods inherited from class net.datenwerke.rs.base.service.dbhelper.DatabaseHelper

aggregateFunction, buildQuery, buildQueryToString, canChangeReadOnlyFlagAfterConnectionCreation, conditionIn, containsWildcard, createNestedQuery, escapeString, getIdentifierQuoteChar, getNewAggregateHavingQuery, getNewAndQueryCondition, getNewColumnFilterQuery, getNewColumnQuery, getNewCountQuery, getNewEqualQueryCondition, getNewFilterWhereQuery, getNewGreaterEqualQueryCondition, getNewGreaterQueryCondition, getNewInnerFilterWhereQuery, getNewInQueryCondition, getNewIsNullQueryCndition, getNewLessEqualQueryCondition, getNewLessQueryCondition, getNewLikeQueryCondition, getNewNotQueryCondition, getNewOrderLimitQuery, getNewOrderQuery, getNewOrQueryCondition, getStringQuoteChar, mapSQLTypeToJava, nestedSelect, parseWildcardNumber, quoteAlias

Methods inherited from class java.lang.Object

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

Field Detail

CONVERT_BLOBS_FOR_FILTERING_PROPERTY

public static final java.lang.String CONVERT_BLOBS_FOR_FILTERING_PROPERTY

See Also:

Constant Field Values

DB_NAME

public static final java.lang.String DB_NAME

See Also:

Constant Field Values

DB_DRIVER

public static final java.lang.String DB_DRIVER

See Also:

Constant Field Values

DB_DESCRIPTOR

public static final java.lang.String DB_DESCRIPTOR

See Also:

Constant Field Values

DB_DESCRIPTION

public static final java.lang.String DB_DESCRIPTION

See Also:

Constant Field Values

Constructor Detail

Oracle

public Oracle(StupidOracleService sos,
              ConfigService configService)

Method Detail

getDescriptor

public java.lang.String getDescriptor()

Description copied from class: DatabaseHelper

A unique descriptor that is not longer than 32 characters.

Specified by:

getDescriptor in class DatabaseHelper

getDriver

public java.lang.String getDriver()

Specified by:

getDriver in class DatabaseHelper

getName

public java.lang.String getName()

Specified by:

getName in class DatabaseHelper

createResultSetHandler

public DatabaseHelper.ResultSetObjectHandler createResultSetHandler(java.sql.ResultSet resultSet,
                                                                    java.sql.Connection con)
                                                             throws java.sql.SQLException

Overrides:

createResultSetHandler in class DatabaseHelper

Throws:

java.sql.SQLException

prepareColumnForSorting

public java.lang.String prepareColumnForSorting(java.lang.String name,
                                                Column column)

Overrides:

prepareColumnForSorting in class DatabaseHelper

prepareColumnForComparison

public java.lang.String prepareColumnForComparison(java.lang.String name,
                                                   Column column)

Description copied from class: DatabaseHelper

Can be used to put a function on top of a column for comparision (for example clobs in oracle need a to_char).

Overrides:

prepareColumnForComparison in class DatabaseHelper

prepareColumnForDistinctQuery

public java.lang.String prepareColumnForDistinctQuery(java.lang.String name,
                                                      Column column)

Overrides:

prepareColumnForDistinctQuery in class DatabaseHelper

getNewLimitQuery

public LimitQuery getNewLimitQuery(Query nestedQuery,
                                   QueryBuilder queryBuilder)

Overrides:

getNewLimitQuery in class DatabaseHelper

getNewOffsetQuery

public OffsetQuery getNewOffsetQuery(Query nestedQuery,
                                     QueryBuilder queryBuilder,
                                     ColumnNamingService columnNamingService)

Overrides:

getNewOffsetQuery in class DatabaseHelper

getNewOrderOffsetQuery

public OrderOffsetQuery getNewOrderOffsetQuery(Query nestedQuery,
                                               QueryBuilder queryBuilder,
                                               ColumnNamingService columnNamingService)

Overrides:

getNewOrderOffsetQuery in class DatabaseHelper

getDescription

public java.lang.String getDescription()

Overrides:

getDescription in class DatabaseHelper

createDummyQuery

public java.lang.String createDummyQuery()

Overrides:

createDummyQuery in class DatabaseHelper