oracle.pg.rdbms.pgql

Class BindValueInfo

java.lang.Object

oracle.pg.rdbms.pgql.BindValueInfo

public class BindValueInfo
extends java.lang.Object

This class manages information about bind values used in a PGQL query.

Method Summary

Modifier and Type	Method and Description
static BindValueInfo	getBindValueInfo() Factory method for getting a BindValueInfo instance
oracle.pgql.lang.ir.QueryExpression.ExpressionType	getBindVarType(oracle.pgql.lang.ir.QueryExpression.BindVariable bv) Returns the value type for this bind variable determined from the set method previously used for this bind variable's parameter index.
static java.lang.String	getBvEncoding(oracle.pgql.lang.ir.QueryExpression.BindVariable bv) Generates a string encoding of a bind variable for easy replacement in the generated SQL.
java.util.List<java.lang.Object>	getSqlBvList(int idx) Returns the SQL bind value list for this processed query
java.lang.String	processBindVariables(java.lang.String pgqlToSqlString, int bvListIdx) Returns a new String that is the result of replacing all encoded bind variables in pgqlToSqlString with "?".
void	setBoolean(int parameterIndex, boolean x) Sets the designated parameter to the given Java boolean value.
void	setDouble(int parameterIndex, double x) Sets the designated parameter to the given Java double value.
void	setFloat(int parameterIndex, float x) Sets the designated parameter to the given Java float value.
void	setInt(int parameterIndex, int x) Sets the designated parameter to the given Java int value.
void	setLong(int parameterIndex, long x) Sets the designated parameter to the given Java long value.
void	setString(int parameterIndex, java.lang.String x) Sets the designated parameter to the given Java String value.
void	setTimestamp(int parameterIndex, java.sql.Timestamp x) Sets the designated parameter to the given Java Timestamp value.

Methods inherited from class java.lang.Object

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

Method Detail

getBindValueInfo

public static BindValueInfo getBindValueInfo()

Factory method for getting a BindValueInfo instance

Returns:

an instance of BindValueInfo

getBindVarType

public oracle.pgql.lang.ir.QueryExpression.ExpressionType getBindVarType(oracle.pgql.lang.ir.QueryExpression.BindVariable bv)
                                                                  throws PgqlToSqlException

Returns the value type for this bind variable determined from the set method previously used for this bind variable's parameter index.

Parameters:

bv - the bind variable to return the type for

Returns:

the type for bv

Throws:

PgqlToSqlException

getBvEncoding

public static java.lang.String getBvEncoding(oracle.pgql.lang.ir.QueryExpression.BindVariable bv)

Generates a string encoding of a bind variable for easy replacement in the generated SQL.

Parameters:

bv - the BindVariable instance to encode

Returns:

the encoded bind variable string

getSqlBvList

public java.util.List<java.lang.Object> getSqlBvList(int idx)

Returns the SQL bind value list for this processed query

Parameters:

idx - the index of the SQL bind value list

Returns:

the SQL bind value list at the given position

processBindVariables

public java.lang.String processBindVariables(java.lang.String pgqlToSqlString,
                                             int bvListIdx)

Returns a new String that is the result of replacing all encoded bind variables in pgqlToSqlString with "?". In addition, a list of SQL bind values and a mapping of PGQL bind value index positions to SQL bind value index positions is constructed.

Parameters:

pgqlToSqlString - a SQL string that contains encoded bind variables

bvListIdx - index of list/mapping where bind value info should be stored

Returns:

a new String that is the result of replacing all encoded bind variables in pgqlToSqlString with "?"

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)

Sets the designated parameter to the given Java boolean value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setDouble

public void setDouble(int parameterIndex,
                      double x)

Sets the designated parameter to the given Java double value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setFloat

public void setFloat(int parameterIndex,
                     float x)

Sets the designated parameter to the given Java float value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setInt

public void setInt(int parameterIndex,
                   int x)

Sets the designated parameter to the given Java int value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setLong

public void setLong(int parameterIndex,
                    long x)

Sets the designated parameter to the given Java long value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setString

public void setString(int parameterIndex,
                      java.lang.String x)

Sets the designated parameter to the given Java String value.

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)

Sets the designated parameter to the given Java Timestamp value. Timestamp values are assumed to be in Coordinated Universal Time (UTC).

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value