org.apache.james.util.sql

Class SqlResources

java.lang.Object

org.apache.james.util.sql.SqlResources

public class SqlResources
extends Object

Provides a set of SQL String resources (eg SQL Strings) to use for a database connection.
This class allows SQL strings to be customised to particular database products, by detecting product information from the jdbc DatabaseMetaData object.

Constructor Summary

Constructors

Constructor and Description
SqlResources()

Method Summary

Methods

Modifier and Type	Method and Description
String	getDbOption(String name) Returns the dbOption string value set for the specified dbOption name.
String	getSqlString(String name) Returns a named SQL string for the specified connection, replacing parameters with the values set.
String	getSqlString(String name, boolean required) Returns a named SQL string for the specified connection, replacing parameters with the values set.
protected void	init(Document sqlDoc, String sqlDefsSection, Connection conn, Map<String,String> configParameters) Configures a SqlResources object from an xml document.
void	init(File sqlFile, String sqlDefsSection, Connection conn, Map<String,String> configParameters) Configures a DbResources object to provide SQL statements from a file.
void	init(InputStream input, String sqlDefsSection, Connection conn, Map<String,String> configParameters) Configures a DbResources object to provide SQL statements from an InputStream.

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlResources

public SqlResources()

Method Detail

init

public void init(File sqlFile,
        String sqlDefsSection,
        Connection conn,
        Map<String,String> configParameters)
          throws Exception

Configures a DbResources object to provide SQL statements from a file.

SQL statements returned may be specific to the particular type and version of the connected database, as well as the database driver.

Parameters encoded as $(parameter} in the input file are replace by values from the parameters Map, if the named parameter exists. Parameter values may also be specified in the resourceSection element.

Parameters:

sqlFile - the input file containing the string definitions

sqlDefsSection - the xml element containing the strings to be used

conn - the Jdbc DatabaseMetaData, taken from a database connection

configParameters - a map of parameters (name-value string pairs) which are replaced where found in the input strings

Throws:

Exception

init

public void init(InputStream input,
        String sqlDefsSection,
        Connection conn,
        Map<String,String> configParameters)
          throws Exception

Configures a DbResources object to provide SQL statements from an InputStream.

SQL statements returned may be specific to the particular type and version of the connected database, as well as the database driver.

Parameters encoded as $(parameter} in the input file are replace by values from the parameters Map, if the named parameter exists. Parameter values may also be specified in the resourceSection element.

Parameters:

input - the input stream containing the xml

sqlDefsSection - the xml element containing the strings to be used

conn - the Jdbc DatabaseMetaData, taken from a database connection

configParameters - a map of parameters (name-value string pairs) which are replaced where found in the input strings

Throws:

Exception

init

protected void init(Document sqlDoc,
        String sqlDefsSection,
        Connection conn,
        Map<String,String> configParameters)
             throws SQLException

Configures a SqlResources object from an xml document.

Parameters:

sqlDoc -

sqlDefsSection -

conn -

configParameters -

Throws:

SQLException

getSqlString

public String getSqlString(String name)

Returns a named SQL string for the specified connection, replacing parameters with the values set.

Parameters:

name - the name of the SQL resource required.

Returns:

the requested resource

getSqlString

public String getSqlString(String name,
                  boolean required)

Returns a named SQL string for the specified connection, replacing parameters with the values set.

Parameters:

name - the name of the SQL resource required.

required - true if the resource is required

Returns:

the requested resource

Throws:

RuntimeException - if a required resource cannot be found.

getDbOption

public String getDbOption(String name)

Returns the dbOption string value set for the specified dbOption name.

Parameters:

name - the name of the dbOption required.

Returns:

the requested dbOption value