com.redhat.rhn.common.db

Class NamedPreparedStatement

java.lang.Object

com.redhat.rhn.common.db.NamedPreparedStatement

public final class NamedPreparedStatement
extends java.lang.Object

Our own preparedStatement class. RHN wants to use named bind variables, but jdbc doesn't provide them. This class takes a SQL query to be prepared, and converts all named variables to "?". It also keeps a hash so that we can find the correct variable when trying to bind the correct values. This should extend PreparedStatement, but it isn't possible to get OracleConnection to return a subclass of OraclePreparedStatement. Oracle 10g introduces this feature natively. When we migrate to 10g, we should move to Oracle's version.

Method Summary

Modifier and Type	Method and Description
static boolean	execute(java.sql.CallableStatement cs, java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap, java.util.Map<java.lang.String,?> inParams, java.util.Map<java.lang.String,java.lang.Integer> outParams) Execute the CallableStatement using the given values for bind parameters.
static boolean	execute(java.sql.PreparedStatement ps, java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap, java.util.Map<java.lang.String,?> parameters) Execute the PreparedStatement using the given values for bind parameters.
static java.util.Iterator<java.lang.Integer>	getPositions(java.lang.String name, java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap) get position for named bind variable.
static java.lang.String	replaceBindParams(java.lang.String rawSQL, java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap) Given a SQL query with named bind parameters convert it to a format that can be used with JDBC.

Methods inherited from class java.lang.Object

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

Method Detail

replaceBindParams

public static java.lang.String replaceBindParams(java.lang.String rawSQL,
                                                 java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap)

Given a SQL query with named bind parameters convert it to a format that can be used with JDBC.

Parameters:

rawSQL - the SQL statement to create.

parameterMap - a result map representing named parameters and their positions in the SQL statement.

Returns:

a SQL statement that can be used with JDBC

execute

public static boolean execute(java.sql.CallableStatement cs,
                              java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap,
                              java.util.Map<java.lang.String,?> inParams,
                              java.util.Map<java.lang.String,java.lang.Integer> outParams)
                       throws java.lang.RuntimeException

Execute the CallableStatement using the given values for bind parameters.

Parameters:

cs - The CallableStatement to execute

parameterMap - The Map returned setup by replaceBindParams

inParams - A map of parameter name to input value to bind to the statement.

outParams - A map of parameter name to Integer object of SQL Types representing the type of data to be returned.

Returns:

true if CallableStatement executed without error, false otherwise.

Throws:

java.lang.RuntimeException - in case of SQLException

execute

public static boolean execute(java.sql.PreparedStatement ps,
                              java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap,
                              java.util.Map<java.lang.String,?> parameters)

Execute the PreparedStatement using the given values for bind parameters.

Parameters:

ps - The PreparedStatement to execute

parameterMap - The Map returned setup by replaceBindParams

parameters - The values to substitute for the named bind parameters

Returns:

true if PreparedStatement received a result set false if PreparedStatement received an update count

Throws:

java.lang.RuntimeException - in case of SQLException

See Also:

PreparedStatement.execute()

getPositions

public static java.util.Iterator<java.lang.Integer> getPositions(java.lang.String name,
                                                                 java.util.Map<java.lang.String,java.util.List<java.lang.Integer>> parameterMap)
                                                          throws BindVariableNotFoundException

get position for named bind variable. This method should NOT be public, but I need it for datasource, which is in a subpackage of db, so this must become public.

Parameters:

name - Name of the bind variable

parameterMap - Map of parameters.

Returns:

The iterator for the list of data returned.

Throws:

BindVariableNotFoundException - couldn't find bind variable