Package com.github.ferstl.spring.jdbc.oracle

Class OracleNamedParameterJdbcTemplate.NamedPreparedStatementCreator

java.lang.Object

com.github.ferstl.spring.jdbc.oracle.OracleNamedParameterJdbcTemplate.NamedPreparedStatementCreator

All Implemented Interfaces:

org.springframework.jdbc.core.ParameterDisposer, org.springframework.jdbc.core.PreparedStatementCreator, org.springframework.jdbc.core.PreparedStatementSetter, org.springframework.jdbc.core.SqlProvider

Enclosing class:

OracleNamedParameterJdbcTemplate

static final class OracleNamedParameterJdbcTemplate.NamedPreparedStatementCreator
extends Object
implements org.springframework.jdbc.core.PreparedStatementCreator, org.springframework.jdbc.core.PreparedStatementSetter, org.springframework.jdbc.core.SqlProvider, org.springframework.jdbc.core.ParameterDisposer

Binds named parameters using proprietary Oracle methods.

Field Summary

Fields

Modifier and Type	Field	Description
private String[]	generatedKeysColumnNames
private org.springframework.jdbc.core.namedparam.SqlParameterSource	parameterSource
private boolean	returnGeneratedKeys
private String	sql

Constructor Summary

Constructors

Constructor	Description
NamedPreparedStatementCreator(String sql, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource)
NamedPreparedStatementCreator(String sql, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, boolean returnGeneratedKeys, String[] generatedKeysColumnNames)

Method Summary

Modifier and Type	Method	Description
void	cleanupParameters()
private static Object	convertToBindable(Object object)	OJDBC does not support binding common Java types most notably Date this method converts some of the to bindable types.
private static Object	convertToSqlTemporal(Date date)	Converts a Date that is not a java.sql type to a Timestamp.
private static Object	copyDate(Date date)
PreparedStatement	createPreparedStatement(Connection connection)
String	getSql()
private static void	setNull(oracle.jdbc.OraclePreparedStatement oracleStatement, String parameterName, int sqlType, String typeName)
private static void	setValue(oracle.jdbc.OraclePreparedStatement oracleStatement, String parameterName, Object value, int sqlType)
void	setValues(PreparedStatement ps)
private static void	validateValue(Object value)

Methods inherited from class java.lang.Object

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

Field Detail

sql

private final String sql

parameterSource

private final org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource

returnGeneratedKeys

private final boolean returnGeneratedKeys

generatedKeysColumnNames

@Nullable
private final String[] generatedKeysColumnNames

Constructor Detail

NamedPreparedStatementCreator

NamedPreparedStatementCreator(String sql,
                              org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource)

NamedPreparedStatementCreator

NamedPreparedStatementCreator(String sql,
                              org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource,
                              boolean returnGeneratedKeys,
                              String[] generatedKeysColumnNames)

Method Detail

createPreparedStatement

public PreparedStatement createPreparedStatement(Connection connection)
                                          throws SQLException

Specified by:

createPreparedStatement in interface org.springframework.jdbc.core.PreparedStatementCreator

Throws:

SQLException

setValues

public void setValues(PreparedStatement ps)
               throws SQLException

Specified by:

setValues in interface org.springframework.jdbc.core.PreparedStatementSetter

Throws:

SQLException

validateValue

private static void validateValue(Object value)

setValue

private static void setValue(oracle.jdbc.OraclePreparedStatement oracleStatement,
                             String parameterName,
                             Object value,
                             int sqlType)
                      throws SQLException

Throws:

SQLException

convertToBindable

private static Object convertToBindable(Object object)

OJDBC does not support binding common Java types most notably Date this method converts some of the to bindable types.

Parameters:

object - the object to bind with may need conversion

Returns:

an equivalent value that hopefully ojdbc support

See Also:

StatementCreatorUtils.setValue(PreparedStatement, int, int, String, Integer, Object)

convertToSqlTemporal

private static Object convertToSqlTemporal(Date date)

Converts a Date that is not a java.sql type to a Timestamp.

Parameters:

date - the date to convert, not null

Returns:

The SQL Timestamp.

See Also:

StatementCreatorUtils.isDateValue(Class)

copyDate

private static Object copyDate(Date date)

setNull

private static void setNull(oracle.jdbc.OraclePreparedStatement oracleStatement,
                            String parameterName,
                            int sqlType,
                            String typeName)
                     throws SQLException

Throws:

SQLException

getSql

public String getSql()

Specified by:

getSql in interface org.springframework.jdbc.core.SqlProvider

cleanupParameters

public void cleanupParameters()

Specified by:

cleanupParameters in interface org.springframework.jdbc.core.ParameterDisposer