oracle.ifs.admin.tools.fingerprint.plugin

Class SqlPlugin

java.lang.Object

oracle.ifs.admin.tools.fingerprint.FingerprintPlugin

oracle.ifs.admin.tools.fingerprint.plugin.SqlPlugin

Direct Known Subclasses:

FunctionsPlugin, JavaClassesPlugin, PackagesPlugin, ProceduresPlugin, QueryPlugin, SequencesPlugin, SqlObjectCountPlugin, TablesAndIndexesPlugin, TypesPlugin, ViewsPlugin

public abstract class SqlPlugin
extends FingerprintPlugin

Base class for all SQL fingerprinting plugins.

Constructor Summary

Constructors

Constructor and Description
SqlPlugin()

Method Summary

Modifier and Type	Method and Description
protected static void	disableSegmentAttributes(Connection conn) Disable outputting the segment attributes in the DDL.
protected static void	endCDATA(ContentHandler out) End a CDATA section in the XML stream.
protected static CallableStatement	getCallableStatement(Connection conn, String sql) Gets a CallableStatement for the specified SQL.
protected static PreparedStatement	getPreparedStatement(Connection conn, String sql) Gets a PreparedStatement for the specified SQL.
protected static String	getSchemaName(Connection conn) Returns the schema name for the given connection.
protected static void	newLine(ContentHandler out)
protected static String	normalizeSpace(String str) Replaces all sequences of whitespace with a single space.
protected static String	replace(String str, String pattern, String repl) Replaces a regex pattern in a given string.
protected static String	replaceInDDL(String str, String schema) Replaces non-fixed strings in a DDL statement.
protected static String	replaceQuotedSchemaName(String str, String schema) Replaces quoted schema name in the given string with a fixed string.
protected static String	replaceSchemaNameInDDL(String str, String schema) Replaces the schema name in the given string with a fixed string.
protected static String	replaceTableOrViewName(String name) Replaces non-fixed strings in a table or view name.
protected static void	resetSegmentAttributes(Connection conn) Resets the changes made by calling disableSegmentAttributes(java.sql.Connection)
protected static void	startCDATA(ContentHandler out) Start a CDATA section in the XML stream.

Methods inherited from class oracle.ifs.admin.tools.fingerprint.FingerprintPlugin

execute, getConfiguration, getConfiguration, getName, setConfiguration

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlPlugin

public SqlPlugin()

Method Detail

getSchemaName

protected static String getSchemaName(Connection conn)
                               throws SQLException

Returns the schema name for the given connection.

Parameters:

conn - the JDBC connection

Returns:

the schema name

Throws:

SQLException - if the operation fails

(Unpublished)

disableSegmentAttributes

protected static void disableSegmentAttributes(Connection conn)
                                        throws IfsException,
                                               SQLException

Disable outputting the segment attributes in the DDL.

Parameters:

conn - the JDBC connection

Throws:

IfsException - if the operation fails

SQLException - if the operation fails

(Unpublished)

resetSegmentAttributes

protected static void resetSegmentAttributes(Connection conn)
                                      throws IfsException,
                                             SQLException

Resets the changes made by calling disableSegmentAttributes(java.sql.Connection)

Parameters:

conn - the JDBC connection

Throws:

IfsException - if the operation fails

SQLException - if the operation fails

(Unpublished)

replaceQuotedSchemaName

protected static String replaceQuotedSchemaName(String str,
                                                String schema)

Replaces quoted schema name in the given string with a fixed string.

Parameters:

str - the string to replace the pattern in

schema - the schema name

Returns:

the modified string

(Unpublished)

replaceSchemaNameInDDL

protected static String replaceSchemaNameInDDL(String str,
                                               String schema)

Replaces the schema name in the given string with a fixed string.

Parameters:

str - the string to replace the pattern in

schema - the schema name

Returns:

the modified string

(Unpublished)

replaceTableOrViewName

protected static String replaceTableOrViewName(String name)

Replaces non-fixed strings in a table or view name.

Parameters:

name - the table of view name

Returns:

the modified string

(Unpublished)

replaceInDDL

protected static String replaceInDDL(String str,
                                     String schema)

Replaces non-fixed strings in a DDL statement.

Parameters:

str - the DDL

schema - the schema name

Returns:

the modified string

(Unpublished)

normalizeSpace

protected static String normalizeSpace(String str)

Replaces all sequences of whitespace with a single space.

Parameters:

str - the string to replace whitespace in

Returns:

the modified string

(Unpublished)

replace

protected static String replace(String str,
                                String pattern,
                                String repl)

Replaces a regex pattern in a given string.

Parameters:

str - the string to replace the pattern in

pattern - the regex pattern

repl - the replacement string

Returns:

the modified string

(Unpublished)

startCDATA

protected static void startCDATA(ContentHandler out)
                          throws SAXException

Start a CDATA section in the XML stream.

Parameters:

out - the output stream

Throws:

SAXException - if the operation fails

(Unpublished)

endCDATA

protected static void endCDATA(ContentHandler out)
                        throws SAXException

End a CDATA section in the XML stream.

Parameters:

out - the output stream

Throws:

SAXException - if the operation fails

(Unpublished)

newLine

protected static void newLine(ContentHandler out)
                       throws SAXException

Throws:

SAXException

getPreparedStatement

protected static PreparedStatement getPreparedStatement(Connection conn,
                                                        String sql)
                                                 throws IfsException

Gets a PreparedStatement for the specified SQL.

If a PreparedStatement was previously created for the SQL, it is returned. Otherwise a new PreparedStatement is created and returned.

The caller should not close the returned PreparedStatement.

Parameters:

conn - the JDBC connection

sql - the SQL

Returns:

a PreparedStatement for the SQL

Throws:

IfsException - if the operation fails

(Unpublished)

getCallableStatement

protected static CallableStatement getCallableStatement(Connection conn,
                                                        String sql)
                                                 throws IfsException

Gets a CallableStatement for the specified SQL.

If a CallableStatement was previously created for the SQL, it is returned. Otherwise a new CallableStatement is created and returned.

The caller should not close the returned CallableStatement.

Parameters:

conn - the JDBC connection

sql - the SQL

Returns:

a CallableStatement for the SQL

Throws:

IfsException - if the operation fails

(Unpublished)