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

Class SqlOracleArrayValue

java.lang.Object

com.github.ferstl.spring.jdbc.oracle.SqlOracleArrayValue

All Implemented Interfaces:

NamedSqlValue, org.springframework.jdbc.support.SqlValue

public final class SqlOracleArrayValue
extends Object
implements NamedSqlValue

Implementation of the SqlTypeValue interface, for convenient creation of provided scalar values as an Oracle Array.

A usage example from a JdbcTemplate:

 jdbcTemplate.queryForInt(SQL, new SqlOracleArrayValue("MYARRAYTYPE", values));
 

A usage example from a StoredProcedure:

storedProcedure.declareParameter(new SqlParameter("myarrayparameter", Types.ARRAY, "MYARRAYTYPE"));
 ...
 Map<String, Object> inParams = new HashMap<>();
 inParams.put("myarrayparameter", new SqlOracleArrayValue("MYARRAYTYPE", objectArray);
 Map<String, Object> out = storedProcedure.execute(inParams);
 

Similar to org.springframework.data.jdbc.support.oracle.SqlArrayValue but updated for Spring 5 and later and OJDBC 11.2g and later.

See Also:

OracleConnection#createOracleArray

Field Summary

Fields

Modifier and Type	Field	Description
private Array	array
private String	typeName
private Object[]	values

Constructor Summary

Constructors

Constructor	Description
SqlOracleArrayValue(String typeName, Object... values)	Constructor that takes two parameters, one parameter with the array of values passed in to the statement and one that takes the type name.

Method Summary

Modifier and Type	Method	Description
void	cleanup()
private Array	createArray(Connection conn)
void	setValue(PreparedStatement ps, int paramIndex)
void	setValue(PreparedStatement ps, String paramName)	Set the value on the given PreparedStatement.

Methods inherited from class java.lang.Object

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

Field Detail

values

private final Object[] values

typeName

private final String typeName

array

private Array array

Constructor Detail

SqlOracleArrayValue

public SqlOracleArrayValue(String typeName,
                           Object... values)

Constructor that takes two parameters, one parameter with the array of values passed in to the statement and one that takes the type name.

Parameters:

typeName - the type name

values - the array containing the values

Method Detail

setValue

public void setValue(PreparedStatement ps,
                     int paramIndex)
              throws SQLException

Specified by:

setValue in interface org.springframework.jdbc.support.SqlValue

Throws:

SQLException

setValue

public void setValue(PreparedStatement ps,
                     String paramName)
              throws SQLException

Set the value on the given PreparedStatement.

Specified by:

setValue in interface NamedSqlValue

Parameters:

ps - the PreparedStatement to work on

paramName - the name of the parameter for which we need to set the value

Throws:

SQLException - if a SQLException is encountered while setting parameter values

See Also:

SqlValue.setValue(PreparedStatement, int)

createArray

private Array createArray(Connection conn)
                   throws SQLException

Throws:

SQLException

cleanup

public void cleanup()

Specified by:

cleanup in interface org.springframework.jdbc.support.SqlValue