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

Class OracleNamedParameterJdbcTemplate

java.lang.Object

org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

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

All Implemented Interfaces:

org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations

public final class OracleNamedParameterJdbcTemplate
extends org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

A subclass of Spring's NamedParameterJdbcTemplate the uses Oracle named parameter to avoid parsing building a new query.

Limitations

• does not support SqlValue, instead NamedSqlValue has to be used
• does not support collections, instead arrays with a SqlOracleArrayValue or similar have to be used
• does not support SqlTypeValue
• does not support binding Calendar

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
(package private) static class	OracleNamedParameterJdbcTemplate.NamedPreparedStatementCreator	Binds named parameters using proprietary Oracle methods.

Field Summary

Fields inherited from class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

DEFAULT_CACHE_LIMIT

Constructor Summary

Constructors

Constructor	Description
OracleNamedParameterJdbcTemplate(DataSource dataSource)	Create a new NamedParameterJdbcTemplate for the given DataSource.
OracleNamedParameterJdbcTemplate(org.springframework.jdbc.core.JdbcOperations classicJdbcTemplate)	Create a new NamedParameterJdbcTemplate for the given classic Spring JdbcTemplate.

Method Summary

Modifier and Type	Method	Description
int[]	batchUpdate(String sql, org.springframework.jdbc.core.namedparam.SqlParameterSource[] batchArgs)
protected org.springframework.jdbc.core.namedparam.ParsedSql	getParsedSql(String sql)
protected org.springframework.jdbc.core.PreparedStatementCreator	getPreparedStatementCreator(String sql, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource)
int	update(String sql, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, org.springframework.jdbc.support.KeyHolder generatedKeyHolder, String[] keyColumnNames)

Methods inherited from class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

batchUpdate, execute, execute, execute, getCacheLimit, getJdbcOperations, getJdbcTemplate, getPreparedStatementCreator, query, query, query, query, query, query, query, query, query, queryForList, queryForList, queryForList, queryForList, queryForMap, queryForMap, queryForObject, queryForObject, queryForObject, queryForObject, queryForRowSet, queryForRowSet, setCacheLimit, update, update, update

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleNamedParameterJdbcTemplate

public OracleNamedParameterJdbcTemplate(DataSource dataSource)

Create a new NamedParameterJdbcTemplate for the given DataSource.

Creates a classic Spring JdbcTemplate and wraps it.

Parameters:

dataSource - the JDBC DataSource to access

OracleNamedParameterJdbcTemplate

public OracleNamedParameterJdbcTemplate(org.springframework.jdbc.core.JdbcOperations classicJdbcTemplate)

Create a new NamedParameterJdbcTemplate for the given classic Spring JdbcTemplate.

Parameters:

classicJdbcTemplate - the classic Spring JdbcTemplate to wrap

Method Detail

update

public int update(String sql,
                  org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource,
                  org.springframework.jdbc.support.KeyHolder generatedKeyHolder,
                  @Nullable
                  String[] keyColumnNames)

Specified by:

update in interface org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations

Overrides:

update in class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

batchUpdate

public int[] batchUpdate(String sql,
                         org.springframework.jdbc.core.namedparam.SqlParameterSource[] batchArgs)

Specified by:

batchUpdate in interface org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations

Overrides:

batchUpdate in class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

getPreparedStatementCreator

protected org.springframework.jdbc.core.PreparedStatementCreator getPreparedStatementCreator(String sql,
                                                                                             org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource)

Overrides:

getPreparedStatementCreator in class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate

getParsedSql

protected org.springframework.jdbc.core.namedparam.ParsedSql getParsedSql(String sql)

Overrides:

getParsedSql in class org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate