Module org.eclipse.persistence.oracleddlparser

Package org.eclipse.persistence.tools.oracleddl.util

Class DatabaseTypeBuilder

java.lang.Object

org.eclipse.persistence.tools.oracleddl.util.DatabaseTypeBuilder

public class DatabaseTypeBuilder
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ALL_OBJECTS_OBJECT_TYPE_FIELD
static final String	BEGIN
static final String	DBMS_METADATA_GET_DDL_STMT_PREFIX
static final String	DBMS_METADATA_GET_DDL_STMT_STMT2
static final String	DBMS_METADATA_GET_DDL_STMT_STMT3
static final String	DBMS_METADATA_GET_DDL_STMT_SUFFIX
static final String	DBMS_METADATA_GET_DDL_STMT1
static final String	DOT
static final String	END
static final String	EXCLUDED_ADMIN_SCHEMAS
static final String	FORWARD_SLASH
static final String	GET_OBJECT_TYPE_STMT
static final String	NEW_LINE
static final String	NOT
static final String	OBJECT_TYPE_FUNCTION
static final int	OBJECT_TYPE_FUNCTION_CODE
static final String	OBJECT_TYPE_PACKAGE
static final int	OBJECT_TYPE_PACKAGE_CODE
static final String	OBJECT_TYPE_PROCEDURE
static final int	OBJECT_TYPE_PROCEDURE_CODE
static final String	OBJECT_TYPE_TABLE
static final int	OBJECT_TYPE_TABLE_CODE
static final String	OBJECT_TYPE_TYPE
static final int	OBJECT_TYPE_TYPE_CODE
static final int	OBJECT_TYPE_UNKNOWN_CODE
static final String	OR
static final String	PERCENT
static final String	RESULT
static final String	ROWTYPE_MACRO
static final String	TOPLEVEL
static final String	TRANSFORM_PREFIX
protected boolean	transformsSet
static final String	TYPE_MACRO

Constructor Summary

Constructors

Constructor	Description
DatabaseTypeBuilder()

Method Summary

Modifier and Type	Method	Description
protected String	buildDDLStmt(String objectType, List<String> schemaPatterns, List<String> namePatterns, List<String> copyOfSchemaPatterns, List<String> copyOfNamePatterns)
List<FunctionType>	buildFunctions(Connection conn, String schemaPattern, String functionPattern)
protected List<FunctionType>	buildFunctions(Connection conn, String schemaPattern, String functionPattern, boolean resolveTypes)
List<FunctionType>	buildFunctions(Connection conn, List<String> schemaPatterns, List<String> functionPatterns)
protected List<FunctionType>	buildFunctions(Connection conn, List<String> schemaPatterns, List<String> functionPatterns, boolean resolveTypes)
List<PLSQLPackageType>	buildPackages(Connection conn, String schemaPattern, String packagePattern)
protected List<PLSQLPackageType>	buildPackages(Connection conn, String schemaPattern, String packagePattern, boolean resolveTypes)
List<PLSQLPackageType>	buildPackages(Connection conn, List<String> schemaPatterns, List<String> packagePatterns)
protected List<PLSQLPackageType>	buildPackages(Connection conn, List<String> schemaPatterns, List<String> packagePatterns, boolean resolveTypes)
List<ProcedureType>	buildProcedures(Connection conn, String schemaPattern, String procedurePattern)
protected List<ProcedureType>	buildProcedures(Connection conn, String schemaPattern, String procedurePattern, boolean resolveTypes)
List<ProcedureType>	buildProcedures(Connection conn, List<String> schemaPatterns, List<String> procedurePatterns)
protected List<ProcedureType>	buildProcedures(Connection conn, List<String> schemaPatterns, List<String> procedurePatterns, boolean resolveTypes)
List<TableType>	buildTables(Connection conn, String schemaPattern, String tablePattern)
protected List<TableType>	buildTables(Connection conn, String schemaPattern, String tablePattern, boolean resolveTypes)
List<TableType>	buildTables(Connection conn, List<String> schemaPatterns, List<String> tablePatterns)
protected List<TableType>	buildTables(Connection conn, List<String> schemaPatterns, List<String> tablePatterns, boolean resolveTypes)
List<CompositeDatabaseType>	buildTypes(Connection conn, String schemaPattern, String namePattern)
protected List<CompositeDatabaseType>	buildTypes(Connection conn, String schemaPattern, String namePattern, boolean resolveTypes)
List<CompositeDatabaseType>	buildTypes(Connection conn, List<String> schemaPatterns, List<String> namePatterns)
protected List<CompositeDatabaseType>	buildTypes(Connection conn, List<String> schemaPatterns, List<String> namePatterns, boolean resolveTypes)
protected List<String>	getDDLs(Connection conn, String typeSpec, String getDDlStmt, List<String> schemaPatterns, List<String> typeNamePatterns)
protected int	getObjectType(Connection conn, String schema, String typeName)	Attempt to determine the database type (Function, Package, Table, etc.) for a given a Schema and Type name.
Properties	getTransformProperties()
protected DDLParser	newDDLParser(String ddl, List<String> schemaPatterns)
protected void	resolvedTypes(Connection conn, String schemaPattern, DDLParser parser, List<UnresolvedType> unresolvedTypes, DatabaseType databaseType)	Attempt to resolve any types that the DDLParser could not resolve.
protected void	resolvedTypes(Connection conn, String schemaPattern, DDLParser parser, List<UnresolvedType> unresolvedTypes, DatabaseType databaseType, List<PLSQLPackageType> processedPackages)	Attempt to resolve any types that the DDLParser could not resolve.
protected boolean	setDbmsMetadataSessionTransforms(Connection conn)

Methods inherited from class java.lang.Object

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

Field Details

BEGIN

public static final String BEGIN

See Also:

• Constant Field Values

END

public static final String END

See Also:

• Constant Field Values

FORWARD_SLASH

public static final String FORWARD_SLASH

See Also:

• Constant Field Values

NOT

public static final String NOT

See Also:

• Constant Field Values

OR

public static final String OR

See Also:

• Constant Field Values

RESULT

public static final String RESULT

See Also:

• Constant Field Values

PERCENT

public static final String PERCENT

See Also:

• Constant Field Values

NEW_LINE

public static final String NEW_LINE

See Also:

• Constant Field Values

TOPLEVEL

public static final String TOPLEVEL

See Also:

• Constant Field Values

ROWTYPE_MACRO

public static final String ROWTYPE_MACRO

See Also:

• Constant Field Values

TYPE_MACRO

public static final String TYPE_MACRO

See Also:

• Constant Field Values

DOT

public static final String DOT

See Also:

• Constant Field Values

TRANSFORM_PREFIX

public static final String TRANSFORM_PREFIX

See Also:

• Constant Field Values

DBMS_METADATA_GET_DDL_STMT_PREFIX

public static final String DBMS_METADATA_GET_DDL_STMT_PREFIX

See Also:

• Constant Field Values

DBMS_METADATA_GET_DDL_STMT1

public static final String DBMS_METADATA_GET_DDL_STMT1

See Also:

• Constant Field Values

EXCLUDED_ADMIN_SCHEMAS

public static final String EXCLUDED_ADMIN_SCHEMAS

See Also:

• Constant Field Values

DBMS_METADATA_GET_DDL_STMT_STMT2

public static final String DBMS_METADATA_GET_DDL_STMT_STMT2

See Also:

• Constant Field Values

DBMS_METADATA_GET_DDL_STMT_STMT3

public static final String DBMS_METADATA_GET_DDL_STMT_STMT3

See Also:

• Constant Field Values

DBMS_METADATA_GET_DDL_STMT_SUFFIX

public static final String DBMS_METADATA_GET_DDL_STMT_SUFFIX

See Also:

• Constant Field Values

OBJECT_TYPE_UNKNOWN_CODE

public static final int OBJECT_TYPE_UNKNOWN_CODE

See Also:

• Constant Field Values

ALL_OBJECTS_OBJECT_TYPE_FIELD

public static final String ALL_OBJECTS_OBJECT_TYPE_FIELD

See Also:

• Constant Field Values

OBJECT_TYPE_FUNCTION

public static final String OBJECT_TYPE_FUNCTION

See Also:

• Constant Field Values

OBJECT_TYPE_FUNCTION_CODE

public static final int OBJECT_TYPE_FUNCTION_CODE

See Also:

• Constant Field Values

OBJECT_TYPE_PACKAGE

public static final String OBJECT_TYPE_PACKAGE

See Also:

• Constant Field Values

OBJECT_TYPE_PACKAGE_CODE

public static final int OBJECT_TYPE_PACKAGE_CODE

See Also:

• Constant Field Values

OBJECT_TYPE_PROCEDURE

public static final String OBJECT_TYPE_PROCEDURE

See Also:

• Constant Field Values

OBJECT_TYPE_PROCEDURE_CODE

public static final int OBJECT_TYPE_PROCEDURE_CODE

See Also:

• Constant Field Values

OBJECT_TYPE_TABLE

public static final String OBJECT_TYPE_TABLE

See Also:

• Constant Field Values

OBJECT_TYPE_TABLE_CODE

public static final int OBJECT_TYPE_TABLE_CODE

See Also:

• Constant Field Values

OBJECT_TYPE_TYPE

public static final String OBJECT_TYPE_TYPE

See Also:

• Constant Field Values

OBJECT_TYPE_TYPE_CODE

public static final int OBJECT_TYPE_TYPE_CODE

See Also:

• Constant Field Values

GET_OBJECT_TYPE_STMT

public static final String GET_OBJECT_TYPE_STMT

See Also:

• Constant Field Values

transformsSet

protected boolean transformsSet

Constructor Details

DatabaseTypeBuilder

public DatabaseTypeBuilder()

Method Details

buildTables

public List<TableType> buildTables(Connection conn,
 String schemaPattern,
 String tablePattern)
                            throws ParseException

Throws:

ParseException

buildTables

protected List<TableType> buildTables(Connection conn,
 String schemaPattern,
 String tablePattern,
 boolean resolveTypes)
                               throws ParseException

Throws:

ParseException

buildTables

public List<TableType> buildTables(Connection conn,
 List<String> schemaPatterns,
 List<String> tablePatterns)
                            throws ParseException

Throws:

ParseException

buildTables

protected List<TableType> buildTables(Connection conn,
 List<String> schemaPatterns,
 List<String> tablePatterns,
 boolean resolveTypes)
                               throws ParseException

Throws:

ParseException

buildPackages

public List<PLSQLPackageType> buildPackages(Connection conn,
 String schemaPattern,
 String packagePattern)
                                     throws ParseException

Throws:

ParseException

buildPackages

protected List<PLSQLPackageType> buildPackages(Connection conn,
 String schemaPattern,
 String packagePattern,
 boolean resolveTypes)
                                        throws ParseException

Throws:

ParseException

buildPackages

public List<PLSQLPackageType> buildPackages(Connection conn,
 List<String> schemaPatterns,
 List<String> packagePatterns)
                                     throws ParseException

Throws:

ParseException

buildPackages

protected List<PLSQLPackageType> buildPackages(Connection conn,
 List<String> schemaPatterns,
 List<String> packagePatterns,
 boolean resolveTypes)
                                        throws ParseException

Throws:

ParseException

buildProcedures

public List<ProcedureType> buildProcedures(Connection conn,
 String schemaPattern,
 String procedurePattern)
                                    throws ParseException

Throws:

ParseException

buildProcedures

protected List<ProcedureType> buildProcedures(Connection conn,
 String schemaPattern,
 String procedurePattern,
 boolean resolveTypes)
                                       throws ParseException

Throws:

ParseException

buildProcedures

public List<ProcedureType> buildProcedures(Connection conn,
 List<String> schemaPatterns,
 List<String> procedurePatterns)
                                    throws ParseException

Throws:

ParseException

buildProcedures

protected List<ProcedureType> buildProcedures(Connection conn,
 List<String> schemaPatterns,
 List<String> procedurePatterns,
 boolean resolveTypes)
                                       throws ParseException

Throws:

ParseException

buildFunctions

public List<FunctionType> buildFunctions(Connection conn,
 String schemaPattern,
 String functionPattern)
                                  throws ParseException

Throws:

ParseException

buildFunctions

protected List<FunctionType> buildFunctions(Connection conn,
 String schemaPattern,
 String functionPattern,
 boolean resolveTypes)
                                     throws ParseException

Throws:

ParseException

buildFunctions

public List<FunctionType> buildFunctions(Connection conn,
 List<String> schemaPatterns,
 List<String> functionPatterns)
                                  throws ParseException

Throws:

ParseException

buildFunctions

protected List<FunctionType> buildFunctions(Connection conn,
 List<String> schemaPatterns,
 List<String> functionPatterns,
 boolean resolveTypes)
                                     throws ParseException

Throws:

ParseException

buildTypes

public List<CompositeDatabaseType> buildTypes(Connection conn,
 String schemaPattern,
 String namePattern)
                                       throws ParseException

Throws:

ParseException

buildTypes

protected List<CompositeDatabaseType> buildTypes(Connection conn,
 String schemaPattern,
 String namePattern,
 boolean resolveTypes)
                                          throws ParseException

Throws:

ParseException

buildTypes

public List<CompositeDatabaseType> buildTypes(Connection conn,
 List<String> schemaPatterns,
 List<String> namePatterns)
                                       throws ParseException

Throws:

ParseException

buildTypes

protected List<CompositeDatabaseType> buildTypes(Connection conn,
 List<String> schemaPatterns,
 List<String> namePatterns,
 boolean resolveTypes)
                                          throws ParseException

Throws:

ParseException

buildDDLStmt

protected String buildDDLStmt(String objectType,
 List<String> schemaPatterns,
 List<String> namePatterns,
 List<String> copyOfSchemaPatterns,
 List<String> copyOfNamePatterns)

newDDLParser

protected DDLParser newDDLParser(String ddl,
 List<String> schemaPatterns)

getDDLs

protected List<String> getDDLs(Connection conn,
 String typeSpec,
 String getDDlStmt,
 List<String> schemaPatterns,
 List<String> typeNamePatterns)

resolvedTypes

protected void resolvedTypes(Connection conn,
 String schemaPattern,
 DDLParser parser,
 List<UnresolvedType> unresolvedTypes,
 DatabaseType databaseType)
                      throws ParseException

Attempt to resolve any types that the DDLParser could not resolve.

Parameters:

conn - Database connection

schemaPattern - Database schemas where to resolve types

parser - Parser to get types repository from

unresolvedTypes - List of types to be resolved

databaseType - Type possibly containing or referring type to be resolved

Throws:

ParseException - if parsing error appears

resolvedTypes

protected void resolvedTypes(Connection conn,
 String schemaPattern,
 DDLParser parser,
 List<UnresolvedType> unresolvedTypes,
 DatabaseType databaseType,
 List<PLSQLPackageType> processedPackages)
                      throws ParseException

Attempt to resolve any types that the DDLParser could not resolve.

Parameters:

conn - Database connection

schemaPattern - Database schemas where to resolve types

parser - Parser to get types repository from

unresolvedTypes - List of types to be resolved

databaseType - Type possibly containing or referring type to be resolved

processedPackages - List of already processed packages, may be null

Throws:

ParseException - if parsing error appears

getObjectType

protected int getObjectType(Connection conn,
 String schema,
 String typeName)

Attempt to determine the database type (Function, Package, Table, etc.) for a given a Schema and Type name. Types are translated to integer values as follows:

• FUNCTION = 1
• PACKAGE = 2
• PROCEDURE = 3
• TABLE = 4
• TYPE = 5

Parameters:

conn - Database connection

schema - Database schema containing type definition

typeName - Name of the type to resolve database type for

Returns:

Integer value of resolved type

getTransformProperties

public Properties getTransformProperties()
                                  throws DatabaseTypeBuilderException

Throws:

DatabaseTypeBuilderException

setDbmsMetadataSessionTransforms

protected boolean setDbmsMetadataSessionTransforms(Connection conn)