org.openrdf.sesame.sailimpl.rdbms
Class Oracle

java.lang.Object
  org.openrdf.sesame.sailimpl.rdbms.RDBMS
      org.openrdf.sesame.sailimpl.rdbms.Oracle

public class Oracle

extends RDBMS

Defines Oracle specific SQL syntax. tested with oracle 9.2.0.1.0

Version:

$Revision: 1.9.4.2 $

Author:

Holger Lausen

Field Summary

Fields inherited from class org.openrdf.sesame.sailimpl.rdbms.RDBMS

BOOLEAN, BOOLEAN_TYPE, FALSE, ID_INT, ID_INT_TYPE, INFOFIELD, INFOFIELD_TYPE, LABEL, LABEL_HASH, LABEL_HASH_TYPE, LABEL_TYPE, LANGUAGE, LANGUAGE_TYPE, LOCALNAME, LOCALNAME_TYPE, MAX_PREFIX_LENGTH, NAME, NAME_TYPE, PREFIX, PREFIX_TYPE, TRUE

Constructor Summary

Oracle()
Initializes Oracle specific SQL syntax.

Method Summary

boolean	emptyStringIsNull() within Oracle '' gets converted to null
String	escapeString(String s) Replaces any occurences of ' with ''.
String	getIndexName(String table, String[] columns) Creates an index name based on the name of the columns and table that it's supposed to index.
void	optimizeTable(String tableName) Optimizes a table.

Methods inherited from class org.openrdf.sesame.sailimpl.rdbms.RDBMS

clearTable, convertBoolean, copyDistinctRows, copyRows, createIndex, createIndex, createInstance, createUniqueIndex, disconnect, dropIndex, dropIndex, dropTable, executeUpdate, getConnection, getIndexName, getPatternMatchExpr, getPatternMatchOperator, getSearchStringEscape, optimizeTable, queryHasResults, renameTable, renameTableColumn, setConnectionInfo, supportsLikeEscapeClause, supportsPatternMatches, tableExists

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Oracle

public Oracle()

Initializes Oracle specific SQL syntax.

Method Detail

emptyStringIsNull

public boolean emptyStringIsNull()

within Oracle '' gets converted to null

Overrides:

emptyStringIsNull in class RDBMS

getIndexName

public String getIndexName(String table,
                           String[] columns)

Creates an index name based on the name of the columns and table that it's supposed to index. This method overrides the implementation in the superclass because some index names get to long for Oracle.

Overrides:

getIndexName in class RDBMS

optimizeTable

public void optimizeTable(String tableName)
                   throws SQLException

Description copied from class: RDBMS

Optimizes a table. The actual action taken depends on the database.

Overrides:

optimizeTable in class RDBMS

Throws:

SQLException

escapeString

public String escapeString(String s)

Replaces any occurences of ' with ''.

Overrides:

escapeString in class RDBMS

Returns:

The original string with quotes escaped to two quotes.