|
||||||||||
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) {@Link Oracl9Dialect), 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 timestammp from the database. |
String |
getCurrentTimestampSQLFunctionName()
The name of the database-specific SQL function for retrieving the current timestamp. |
String |
getLimitString(String sql,
boolean hasOffset)
Apply s limit clause to the query. |
String |
getSelectClauseNullString(int sqlType)
Given a Types type code, determine an appropriate
null value to use in a select clause. |
protected void |
registerCharacterTypeMappings()
|
protected void |
registerDateTimeTypeMappings()
|
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 caluses 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
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |