oracle.spatial.network.nfe.io.jdbc

Class SQLValidator

java.lang.Object

oracle.spatial.network.nfe.io.jdbc.SQLValidator

public class SQLValidator
extends java.lang.Object

General validator for standard sql naming conventions.

Method Summary

Modifier and Type	Method and Description
static SQLValidator	getInstance() Method to get an instance from SQLValidator (Singleton).
java.lang.String	getValidatedQuery(java.sql.Connection conn, java.lang.String wildCardedQuery, java.lang.String... sqlNames) Receives a wildCarded SQL query and a list of SQL Names as parameters of the wildCards.

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static SQLValidator getInstance()

Method to get an instance from SQLValidator (Singleton).

Returns:

SQLValidator instance.

getValidatedQuery

public java.lang.String getValidatedQuery(java.sql.Connection conn,
                                          java.lang.String wildCardedQuery,
                                          java.lang.String... sqlNames)
                                   throws NFEIOException

Receives a wildCarded SQL query and a list of SQL Names as parameters of the wildCards. Validates if all the sql Names are valid ones, and if so, replaces the wildCards and returns the complete query.

Parameters:

conn - Connection to the Database

wildCardedQuery - Query with the wildCards in the form of :parameter

sqlNames - List of sql names

Returns:

the completed query with all the validates sql names

Throws:

NFEIOException - An exception listing the invalid names. Error Code: NFEIOException.INVALID_SQL_NAME.