com.querydsl.sql.oracle

Class AbstractOracleQuery<T,C extends AbstractOracleQuery<T,C>>

java.lang.Object

com.querydsl.core.support.QueryBase<Q>

com.querydsl.core.support.FetchableQueryBase<T,Q>

com.querydsl.core.support.FetchableSubQueryBase<T,Q>

com.querydsl.sql.ProjectableSQLQuery<T,Q>

com.querydsl.sql.AbstractSQLQuery<T,C>

com.querydsl.sql.oracle.AbstractOracleQuery<T,C>

Type Parameters:

T - result type

C - the concrete subtype

All Implemented Interfaces:

Fetchable<T>, FetchableQuery<T,C>, FilteredClause<C>, Query<C>, SimpleQuery<C>, ExtendedSubQuery<T>, Expression<T>, SubQueryExpression<T>, SQLCommonQuery<C>, java.io.Serializable

Direct Known Subclasses:

OracleQuery

public abstract class AbstractOracleQuery<T,C extends AbstractOracleQuery<T,C>>
extends AbstractSQLQuery<T,C>

OracleQuery provides Oracle specific extensions to the base SQL query type

Author:

tiwe

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	CONNECT_BY
protected static java.lang.String	CONNECT_BY_NOCYCLE_PRIOR
protected static java.lang.String	CONNECT_BY_PRIOR
protected static java.lang.String	ORDER_SIBLINGS_BY
protected static java.lang.String	START_WITH

Fields inherited from class com.querydsl.sql.AbstractSQLQuery

listeners, PARENT_CONTEXT, useLiterals

Fields inherited from class com.querydsl.sql.ProjectableSQLQuery

configuration, firstUnionSubQuery, union, unionAll

Fields inherited from class com.querydsl.core.support.QueryBase

MDC_PARAMETERS, MDC_QUERY, queryMixin

Constructor Summary

Constructors

Constructor and Description
AbstractOracleQuery(java.sql.Connection conn, Configuration configuration, QueryMetadata metadata)
AbstractOracleQuery(java.util.function.Supplier<java.sql.Connection> connProvider, Configuration configuration, QueryMetadata metadata)

Method Summary

Modifier and Type	Method and Description
C	connectBy(Predicate cond) CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.
C	connectByNocyclePrior(Predicate cond) CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.
C	connectByPrior(Predicate cond) CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.
C	orderSiblingsBy(Expression<?> path) ORDER SIBLINGS BY preserves any ordering specified in the hierarchical query clause and then applies the order_by_clause to the siblings of the hierarchy.
<A> C	startWith(Predicate cond) START WITH specifies the root row(s) of the hierarchy.

Methods inherited from class com.querydsl.sql.AbstractSQLQuery

addListener, as, as, clone, clone, clone, createSerializer, endContext, fetch, fetchCount, fetchResults, forShare, forShare, forUpdate, getConfiguration, getResults, getResults, iterate, logQuery, onException, setParameters, setStatementOptions, setUseLiterals, startContext

Methods inherited from class com.querydsl.sql.ProjectableSQLQuery

accept, addFlag, addFlag, addFlag, addFlag, addJoinFlag, addJoinFlag, fetchOne, from, from, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, getSQL, getSQL, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, on, on, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, serialize, toString, union, union, union, unionAll, unionAll, unionAll, with, with, with, withRecursive, withRecursive, withRecursive

Methods inherited from class com.querydsl.core.support.FetchableSubQueryBase

contains, contains, eq, eq, exists, getMetadata, getType, goe, goe, gt, gt, hashCode, in, in, isNotNull, isNull, loe, loe, lt, lt, ne, ne, notExists

Methods inherited from class com.querydsl.core.support.FetchableQueryBase

equals, fetchFirst, transform, uniqueResult

Methods inherited from class com.querydsl.core.support.QueryBase

distinct, groupBy, groupBy, having, having, limit, offset, orderBy, orderBy, restrict, set, where, where

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.querydsl.core.Query

groupBy, having

Methods inherited from interface com.querydsl.core.SimpleQuery

distinct, limit, offset, orderBy, restrict, set

Methods inherited from interface com.querydsl.core.FilteredClause

where

Methods inherited from interface com.querydsl.core.FetchableQuery

select, select, transform

Methods inherited from interface com.querydsl.core.Fetchable

fetchFirst, stream

Field Detail

CONNECT_BY

protected static final java.lang.String CONNECT_BY

See Also:

Constant Field Values

CONNECT_BY_NOCYCLE_PRIOR

protected static final java.lang.String CONNECT_BY_NOCYCLE_PRIOR

See Also:

Constant Field Values

CONNECT_BY_PRIOR

protected static final java.lang.String CONNECT_BY_PRIOR

See Also:

Constant Field Values

ORDER_SIBLINGS_BY

protected static final java.lang.String ORDER_SIBLINGS_BY

See Also:

Constant Field Values

START_WITH

protected static final java.lang.String START_WITH

See Also:

Constant Field Values

Constructor Detail

AbstractOracleQuery

public AbstractOracleQuery(java.sql.Connection conn,
                           Configuration configuration,
                           QueryMetadata metadata)

AbstractOracleQuery

public AbstractOracleQuery(java.util.function.Supplier<java.sql.Connection> connProvider,
                           Configuration configuration,
                           QueryMetadata metadata)

Method Detail

connectByPrior

public C connectByPrior(Predicate cond)

CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.

Parameters:

cond - condition

Returns:

the current object

connectBy

public C connectBy(Predicate cond)

CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.

Parameters:

cond - condition

Returns:

the current object

connectByNocyclePrior

public C connectByNocyclePrior(Predicate cond)

CONNECT BY specifies the relationship between parent rows and child rows of the hierarchy.

Parameters:

cond - condition

Returns:

the current object

startWith

public <A> C startWith(Predicate cond)

START WITH specifies the root row(s) of the hierarchy.

Parameters:

cond - condition

Returns:

the current object

orderSiblingsBy

public C orderSiblingsBy(Expression<?> path)

ORDER SIBLINGS BY preserves any ordering specified in the hierarchical query clause and then applies the order_by_clause to the siblings of the hierarchy.

Parameters:

path - path

Returns:

the current object