org.deegree.tools.datastore
Class OracleDDLGenerator

java.lang.Object
  org.deegree.tools.datastore.DDLGenerator
      org.deegree.tools.datastore.OracleDDLGenerator

public class OracleDDLGenerator
extends DDLGenerator

Generator for Oracle DDL (CREATE / DROP) operations to create Oracle database schemas from annotated GML schema files.

Version:

$Revision: 8252 $, $Date: 2007-10-05 11:54:33 +0200 (Fr, 05 Okt 2007) $

Author:

Markus Schneider, last edited by: $Author: aschmitz $

Nested Class Summary

Nested classes/interfaces inherited from class org.deegree.tools.datastore.DDLGenerator

DDLGenerator.ColumnDefinition, DDLGenerator.TableDefinition

Field Summary

(package private) int	currentId
(package private) Map<String,String>	idToTruncatedId

Fields inherited from class org.deegree.tools.datastore.DDLGenerator

FEATURE_TYPE_TABLE, FT_PREFIX, JOIN_TABLE, MULTI_PROPERTY_TABLE, schema, sequences, tables

Constructor Summary

OracleDDLGenerator(URL schemaURL)
Generates a new instance of OracleDDLGenerator, ready to generate DDL for the given schema.

Method Summary

protected StringBuffer	generateCreateIndexStmts(DDLGenerator.TableDefinition table) Generates the DDL statements necessary for the creation of standard indexes for the given table definition.
protected StringBuffer	generateCreateTableStmt(DDLGenerator.TableDefinition table) Generates the DDL statements necessary for the creation of the given table definition.
protected StringBuffer	generateDropIndexStmts(DDLGenerator.TableDefinition table) Generates the DDL statements necessary for the dropping of standard indexes for the given table definition.
protected StringBuffer	generateDropTableStmt(DDLGenerator.TableDefinition table) Generates the DDL statements necessary for the removal of the given table definition.
protected StringBuffer	generateSetSchemaStmt(String dbSchema) Generates the SQL statements necessary for setting the schema search path.

Methods inherited from class org.deegree.tools.datastore.DDLGenerator

generateCreateSchemaStmts, generateCreateScript, generateCreateScript, generateCreateSequenceStmt, generateDropSchemaStmt, generateDropScript, generateDropSequenceStmt, getTables, main, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

idToTruncatedId

Map<String,String> idToTruncatedId

currentId

int currentId

Constructor Detail

OracleDDLGenerator

public OracleDDLGenerator(URL schemaURL)
                   throws MalformedURLException,
                          IOException,
                          SAXException,
                          XMLParsingException,
                          XMLSchemaException,
                          UnknownCRSException

Generates a new instance of OracleDDLGenerator, ready to generate DDL for the given schema.

Parameters:

schemaURL -

Throws:

MalformedURLException

IOException

SAXException

XMLParsingException

XMLSchemaException

UnknownCRSException

Method Detail

generateSetSchemaStmt

protected StringBuffer generateSetSchemaStmt(String dbSchema)

Description copied from class: DDLGenerator

Generates the SQL statements necessary for setting the schema search path. Must be overwritten by the concrete implementation.

Specified by:

generateSetSchemaStmt in class DDLGenerator

Returns:

the SQL statements necessary for setting the schema search path accordingly

generateDropTableStmt

protected StringBuffer generateDropTableStmt(DDLGenerator.TableDefinition table)

Description copied from class: DDLGenerator

Generates the DDL statements necessary for the removal of the given table definition. May be overwritten by a concrete implementation.

Overrides:

generateDropTableStmt in class DDLGenerator

Returns:

the DDL statements necessary for the removal of the given table definition

generateCreateTableStmt

protected StringBuffer generateCreateTableStmt(DDLGenerator.TableDefinition table)

Description copied from class: DDLGenerator

Generates the DDL statements necessary for the creation of the given table definition. Must be overwritten by the concrete implementation.

Specified by:

generateCreateTableStmt in class DDLGenerator

Returns:

the DDL statements necessary for the creation of the given table definition

generateCreateIndexStmts

protected StringBuffer generateCreateIndexStmts(DDLGenerator.TableDefinition table)

Description copied from class: DDLGenerator

Generates the DDL statements necessary for the creation of standard indexes for the given table definition. Must be overwritten by the concrete implementation.

Specified by:

generateCreateIndexStmts in class DDLGenerator

Returns:

the DDL statements necessary for the creation of standard indexes for the given table definition

generateDropIndexStmts

protected StringBuffer generateDropIndexStmts(DDLGenerator.TableDefinition table)

Description copied from class: DDLGenerator

Generates the DDL statements necessary for the dropping of standard indexes for the given table definition. May be overwritten by a concrete implementation.

Overrides:

generateDropIndexStmts in class DDLGenerator

Returns:

the DDL statements necessary for the dropping of standard indexes for the given table definition