|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.hibernate.dialect.Dialect org.hibernate.dialect.Oracle8iDialect org.hibernate.dialect.Oracle9iDialect
public class Oracle9iDialect
A dialect for Oracle 9i databases.
Unlike the older (deprecated)Oracle9Dialect
, this version specifies
to not use "ANSI join syntax" because 9i does not seem to properly
handle it in all cases.
Field Summary |
---|
Fields inherited from class org.hibernate.dialect.Oracle8iDialect |
---|
DEPRECATED_ORACLE_TYPES_CLASS_NAME, INIT_ORACLETYPES_CURSOR_VALUE, ORACLE_TYPES_CLASS_NAME |
Fields inherited from class org.hibernate.dialect.Dialect |
---|
CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE |
Constructor Summary | |
---|---|
Oracle9iDialect()
|
Method Summary | |
---|---|
CaseFragment |
createCaseFragment()
Map case support to the Oracle DECODE function. |
String |
getCurrentTimestampSelectString()
Retrieve the command used to retrieve the current timestamp from the database. |
String |
getCurrentTimestampSQLFunctionName()
The name of the database-specific SQL function for retrieving the current timestamp. |
String |
getForUpdateString()
Get the string to append to SELECT statements to acquire locks for this dialect. |
String |
getLimitString(String sql,
boolean hasOffset)
Apply s limit clause to the query. |
String |
getReadLockString(int timeout)
Get the string to append to SELECT statements to acquire WRITE locks for this dialect. |
String |
getSelectClauseNullString(int sqlType)
Given a Types type code, determine an appropriate
null value to use in a select clause. |
String |
getWriteLockString(int timeout)
Get the string to append to SELECT statements to acquire WRITE locks for this dialect. |
protected void |
registerCharacterTypeMappings()
|
protected void |
registerDateTimeTypeMappings()
|
boolean |
supportsRowValueConstructorSyntaxInInList()
HHH-4907, I don't know if oracle 8 supports this syntax, so I'd think it is better add this method here. |
boolean |
supportsTupleDistinctCounts()
Does this dialect support `count(distinct a,b)`? |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public Oracle9iDialect()
Method Detail |
---|
protected void registerCharacterTypeMappings()
registerCharacterTypeMappings
in class Oracle8iDialect
protected void registerDateTimeTypeMappings()
registerDateTimeTypeMappings
in class Oracle8iDialect
public CaseFragment createCaseFragment()
Oracle8iDialect
createCaseFragment
in class Oracle8iDialect
public String getLimitString(String sql, boolean hasOffset)
Dialect
variable
limit clauses when they support limits. Thus, when building the
select command we do not actually need to know the limit or the offest
since we will just be using placeholders.
Here we do still pass along whether or not an offset was specified
so that dialects not supporting offsets can generate proper exceptions.
In general, dialects will override one or the other of this method and
Dialect.getLimitString(String, int, int)
.
getLimitString
in class Oracle8iDialect
sql
- The query to which to apply the limit.hasOffset
- Is the query requesting an offset?
public String getSelectClauseNullString(int sqlType)
Dialect
Types
type code, determine an appropriate
null value to use in a select clause.
One thing to consider here is that certain databases might
require proper casting for the nulls here since the select here
will be part of a UNION/UNION ALL.
getSelectClauseNullString
in class Oracle8iDialect
sqlType
- The Types
type code.
public String getCurrentTimestampSelectString()
Dialect
getCurrentTimestampSelectString
in class Oracle8iDialect
public String getCurrentTimestampSQLFunctionName()
Dialect
getCurrentTimestampSQLFunctionName
in class Oracle8iDialect
public String getForUpdateString()
Dialect
getForUpdateString
in class Dialect
public String getWriteLockString(int timeout)
Dialect
getWriteLockString
in class Dialect
timeout
- in milliseconds, -1 for indefinite wait and 0 for no wait.
public String getReadLockString(int timeout)
Dialect
getReadLockString
in class Dialect
timeout
- in milliseconds, -1 for indefinite wait and 0 for no wait.
public boolean supportsRowValueConstructorSyntaxInInList()
supportsRowValueConstructorSyntaxInInList
in class Dialect
public boolean supportsTupleDistinctCounts()
Dialect
supportsTupleDistinctCounts
in class Dialect
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |