|
Nuxeo Enterprise Platform 5.4 | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect org.nuxeo.ecm.core.storage.sql.jdbc.dialect.DialectOracle
public class DialectOracle
Oracle-specific dialect.
Nested Class Summary |
---|
Nested classes/interfaces inherited from class org.nuxeo.ecm.core.storage.sql.jdbc.dialect.Dialect |
---|
Dialect.FulltextMatchInfo, Dialect.FulltextQuery, Dialect.FulltextQueryAnalyzer, Dialect.JDBCInfo |
Constructor Summary | |
---|---|
DialectOracle(java.sql.DatabaseMetaData metadata,
BinaryManager binaryManager,
RepositoryDescriptor repositoryDescriptor)
|
Method Summary | |
---|---|
boolean |
connectionClosedByException(java.lang.Throwable t)
Checks if an exception received means that the low level connection has been trashed and must be reset. |
java.sql.Array |
createArrayOf(int type,
java.lang.Object[] elements,
java.sql.Connection connection)
Factory method for creating Array objects, suitable for passing to PreparedStatement.setArray(int, java.sql.Array) . |
boolean |
doesUpdateFromRepeatSelf()
When doing an UPDATE t SET ... |
java.lang.String |
getAddColumnString()
|
java.lang.String |
getCascadeDropConstraintsString()
|
java.lang.String |
getClobCast(boolean inOrderBy)
When using a CLOB field in an expression, is some casting required and with what pattern? |
java.lang.String |
getClusterDeleteInvalidations()
Gets the SQL to delete invalidations for this cluster node. |
java.lang.String |
getClusterGetInvalidations()
Gets the SQL to query invalidations for this cluster node. |
java.lang.String |
getClusterInsertInvalidations()
Gets the SQL to send an invalidation to the cluster. |
java.lang.String |
getConnectionSchema(java.sql.Connection connection)
Gets the schema to use to query metadata about existing tables. |
java.lang.String |
getCreateFulltextIndexSql(java.lang.String indexName,
java.lang.String quotedIndexName,
Table table,
java.util.List<Column> columns,
Model model)
Gets a CREATE INDEX statement for a fulltext index. |
java.lang.String |
getDialectFulltextQuery(java.lang.String query)
Get the dialect-specific version of a fulltext query. |
java.io.Serializable |
getFromResultSet(java.sql.ResultSet rs,
int index,
Column column)
|
int |
getFulltextIndexedColumns()
Specifies what columns of the fulltext table have to be indexed. |
Dialect.FulltextMatchInfo |
getFulltextScoredMatchInfo(java.lang.String fulltextQuery,
java.lang.String indexName,
int nthMatch,
Column mainColumn,
Model model,
Database database)
Gets the SQL information needed to do a a fulltext match, either with a direct expression in the WHERE clause, or using a join with an additional table. |
java.lang.String |
getInTreeSql(java.lang.String idColumnName)
Gets the expression to use to check tree membership. |
Dialect.JDBCInfo |
getJDBCTypeAndString(ColumnType type)
Gets the JDBC type and string from Nuxeo's type abstraction. |
boolean |
getMaterializeFulltextSyntheticColumn()
Does the fulltext synthetic column have to be materialized. |
java.lang.String |
getReadAclsCheckSql(java.lang.String idColumnName)
Gets the expression to check if access is allowed using read acl the dialect must suppportsReadAcl |
java.lang.String |
getRebuildReadAclsSql()
Gets the statement to rebuild the wall read acls |
java.lang.String |
getSecurityCheckSql(java.lang.String idColumnName)
Gets the expression to use to check security. |
java.lang.String |
getSQLStatementsFilename()
Gets the name of the file containing the SQL statements. |
java.util.Map<java.lang.String,java.io.Serializable> |
getSQLStatementsProperties(Model model,
Database database)
Gets the properties to use with the SQL statements. |
java.lang.String |
getTestSQLStatementsFilename()
|
java.lang.String |
getUpdateReadAclsSql()
Gets the statement to update the read acls |
boolean |
isAllowedConversion(int expected,
int actual,
java.lang.String actualName,
int actualSize)
Check mismatches between expected and actual JDBC types read from database introspection. |
boolean |
isClusteringDeleteNeeded()
Does clustering fetch of invalidations ( Dialect.getClusterGetInvalidations() ) need a separate delete for them (
Dialect.getClusterDeleteInvalidations() ). |
boolean |
isClusteringSupported()
Checks that clustering is supported. |
boolean |
needsOracleJoins()
Whether implicit Oracle joins (instead of explicit ANSI joins) are needed. |
boolean |
needsOriginalColumnInGroupBy()
Whether a GROUP BY can only be used with the original column name and not an alias. |
void |
setToPreparedStatement(java.sql.PreparedStatement ps,
int index,
java.io.Serializable value,
Column column)
|
boolean |
supportsArrays()
Does the dialect support passing ARRAY values (to stored procedures mostly). |
boolean |
supportsReadAcl()
Does the dialect support an optimized read security checks |
boolean |
supportsUpdateFrom()
Does the dialect support UPDATE t SET ... |
boolean |
supportsWith()
Does the dialect support SQL-99 WITH common table expressions. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DialectOracle(java.sql.DatabaseMetaData metadata, BinaryManager binaryManager, RepositoryDescriptor repositoryDescriptor) throws StorageException
StorageException
Method Detail |
---|
public java.lang.String getConnectionSchema(java.sql.Connection connection) throws java.sql.SQLException
Dialect
getConnectionSchema
in class Dialect
java.sql.SQLException
public java.lang.String getCascadeDropConstraintsString()
getCascadeDropConstraintsString
in class Dialect
public java.lang.String getAddColumnString()
getAddColumnString
in class Dialect
public Dialect.JDBCInfo getJDBCTypeAndString(ColumnType type)
Dialect
getJDBCTypeAndString
in class Dialect
public boolean isAllowedConversion(int expected, int actual, java.lang.String actualName, int actualSize)
Dialect
isAllowedConversion
in class Dialect
public void setToPreparedStatement(java.sql.PreparedStatement ps, int index, java.io.Serializable value, Column column) throws java.sql.SQLException
setToPreparedStatement
in class Dialect
java.sql.SQLException
public java.io.Serializable getFromResultSet(java.sql.ResultSet rs, int index, Column column) throws java.sql.SQLException
getFromResultSet
in class Dialect
java.sql.SQLException
public java.lang.String getCreateFulltextIndexSql(java.lang.String indexName, java.lang.String quotedIndexName, Table table, java.util.List<Column> columns, Model model)
Dialect
getCreateFulltextIndexSql
in class Dialect
public java.lang.String getDialectFulltextQuery(java.lang.String query)
Dialect
getDialectFulltextQuery
in class Dialect
query
- the CMIS-syntax-based fulltext query string
public Dialect.FulltextMatchInfo getFulltextScoredMatchInfo(java.lang.String fulltextQuery, java.lang.String indexName, int nthMatch, Column mainColumn, Model model, Database database)
Dialect
getFulltextScoredMatchInfo
in class Dialect
public boolean getMaterializeFulltextSyntheticColumn()
Dialect
getMaterializeFulltextSyntheticColumn
in class Dialect
public int getFulltextIndexedColumns()
Dialect
getFulltextIndexedColumns
in class Dialect
public boolean supportsUpdateFrom()
Dialect
supportsUpdateFrom
in class Dialect
public boolean doesUpdateFromRepeatSelf()
Dialect
doesUpdateFromRepeatSelf
in class Dialect
public boolean needsOriginalColumnInGroupBy()
Dialect
needsOriginalColumnInGroupBy
in class Dialect
public boolean needsOracleJoins()
Dialect
needsOracleJoins
in class Dialect
public java.lang.String getClobCast(boolean inOrderBy)
Dialect
Needed for Derby and H2.
getClobCast
in class Dialect
inOrderBy
- true
if the expression is for an ORDER BY column
null
if no cast is
requiredpublic boolean supportsReadAcl()
Dialect
supportsReadAcl
in class Dialect
public java.lang.String getReadAclsCheckSql(java.lang.String idColumnName)
Dialect
getReadAclsCheckSql
in class Dialect
idColumnName
- the quoted name of the read acl_id column to use
public java.lang.String getUpdateReadAclsSql()
Dialect
getUpdateReadAclsSql
in class Dialect
public java.lang.String getRebuildReadAclsSql()
Dialect
getRebuildReadAclsSql
in class Dialect
public java.lang.String getSecurityCheckSql(java.lang.String idColumnName)
Dialect
getSecurityCheckSql
in class Dialect
idColumnName
- the quoted name of the id column to use
public java.lang.String getInTreeSql(java.lang.String idColumnName)
Dialect
getInTreeSql
in class Dialect
idColumnName
- the quoted name of the id column to use
public boolean isClusteringSupported()
Dialect
isClusteringSupported
in class Dialect
public boolean isClusteringDeleteNeeded()
Dialect
Dialect.getClusterGetInvalidations()
) need a separate delete for them (
Dialect.getClusterDeleteInvalidations()
).
isClusteringDeleteNeeded
in class Dialect
public java.lang.String getClusterInsertInvalidations()
Dialect
getClusterInsertInvalidations
in class Dialect
public java.lang.String getClusterGetInvalidations()
Dialect
getClusterGetInvalidations
in class Dialect
public java.lang.String getClusterDeleteInvalidations()
Dialect
getClusterDeleteInvalidations
in class Dialect
public boolean supportsWith()
Dialect
supportsWith
in class Dialect
public boolean supportsArrays()
Dialect
If not, we'll simulate them using a string and a separator.
supportsArrays
in class Dialect
public java.sql.Array createArrayOf(int type, java.lang.Object[] elements, java.sql.Connection connection) throws java.sql.SQLException
Dialect
PreparedStatement.setArray(int, java.sql.Array)
.
(An equivalent method is defined by JDBC4 on the Connection
class.)
createArrayOf
in class Dialect
type
- the SQL type of the elementselements
- the elements of the arrayconnection
- the connection
java.sql.SQLException
public java.lang.String getSQLStatementsFilename()
Dialect
getSQLStatementsFilename
in class Dialect
public java.lang.String getTestSQLStatementsFilename()
getTestSQLStatementsFilename
in class Dialect
public java.util.Map<java.lang.String,java.io.Serializable> getSQLStatementsProperties(Model model, Database database)
Dialect
getSQLStatementsProperties
in class Dialect
public boolean connectionClosedByException(java.lang.Throwable t)
Dialect
connectionClosedByException
in class Dialect
|
Nuxeo Enterprise Platform 5.4 | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |