Package 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	Description
static final String	CONVERT_BLOBS_FOR_FILTERING_PROPERTY
static final String	DB_DESCRIPTION
static final String	DB_DESCRIPTOR
static final String	DB_DRIVER
static final String	DB_NAME

Constructor Summary

Constructors

Constructor	Description
Oracle(StupidOracleService sos, ConfigService configService)

Method Summary

Modifier and Type	Method	Description
String	createDummyQuery()
DatabaseHelper.ResultSetObjectHandler	createResultSetHandler(ResultSet resultSet, Connection con)
String	getDescription()
String	getDescriptor()	A unique descriptor that is not longer than 32 characters.
String	getDriver()
String	getName()
LimitQuery	getNewLimitQuery(Query nestedQuery, QueryBuilder queryBuilder)
OffsetQuery	getNewOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
OrderOffsetQuery	getNewOrderOffsetQuery(Query nestedQuery, QueryBuilder queryBuilder, ColumnNamingService columnNamingService)
String	prepareColumnForComparison(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).
String	prepareColumnForDistinctQuery(String name, Column column)
String	prepareColumnForSorting(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 Details

CONVERT_BLOBS_FOR_FILTERING_PROPERTY

public static final String CONVERT_BLOBS_FOR_FILTERING_PROPERTY

See Also:

• Constant Field Values

DB_NAME

public static final String DB_NAME

See Also:

• Constant Field Values

DB_DRIVER

public static final String DB_DRIVER

See Also:

• Constant Field Values

DB_DESCRIPTOR

public static final String DB_DESCRIPTOR

See Also:

• Constant Field Values

DB_DESCRIPTION

public static final String DB_DESCRIPTION

See Also:

• Constant Field Values

Constructor Details

Oracle

public Oracle(StupidOracleService sos,
 ConfigService configService)

Method Details

getDescriptor

public 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 String getDriver()

Specified by:

getDriver in class DatabaseHelper

getName

public String getName()

Specified by:

getName in class DatabaseHelper

createResultSetHandler

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

Overrides:

createResultSetHandler in class DatabaseHelper

Throws:

SQLException

prepareColumnForSorting

public String prepareColumnForSorting(String name,
 Column column)

Overrides:

prepareColumnForSorting in class DatabaseHelper

prepareColumnForComparison

public String prepareColumnForComparison(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

Parameters:

name -

column -

prepareColumnForDistinctQuery

public String prepareColumnForDistinctQuery(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 String getDescription()

Overrides:

getDescription in class DatabaseHelper

createDummyQuery

public String createDummyQuery()

Overrides:

createDummyQuery in class DatabaseHelper