Interface SqlTypeValue

All Known Subinterfaces:
All Known Implementing Classes:
AbstractSqlTypeValue, SqlLobValue

public interface SqlTypeValue

Interface to be implemented for setting values for more complex database specific types not supported by the standard setObject method.

Implementations perform the actual work of setting the actual values. They must implement the callback method setTypeValue which can throw SQLExceptions that will be caught and translated by the calling code. This callback method has access to the underlying Connection via the given PreparedStatement object, if that should be needed to create any database-specific objects.

Thomas Risberg, Juergen Hoeller
See Also:
Types, PreparedStatement.setObject(int, java.lang.Object), JdbcTemplate.update(String, Object[], int[]), SqlUpdate.update(Object[]), StoredProcedure.execute(java.util.Map)

Field Summary
static int TYPE_UNKNOWN
          Constant that indicates an unknown (or unspecified) SQL type.
Method Summary
 void setTypeValue(PreparedStatement ps, int paramIndex, int sqlType, String typeName)
          Set the type value on the given PreparedStatement.

Field Detail


public static final int TYPE_UNKNOWN
Constant that indicates an unknown (or unspecified) SQL type. Passed into setTypeValue if the original operation method does not specify a SQL type.

See Also:
Types, JdbcOperations.update(String, Object[]), Constant Field Values
Method Detail


public void setTypeValue(PreparedStatement ps,
                         int paramIndex,
                         int sqlType,
                         String typeName)
                  throws SQLException
Set the type value on the given PreparedStatement.

ps - the PreparedStatement to work on
paramIndex - the index of the parameter for which we need to set the value
sqlType - SQL type of the parameter we are setting
typeName - the type name of the parameter (optional)
SQLException - if a SQLException is encountered setting parameter values (that is, there's no need to catch SQLException)
See Also:
Types, PreparedStatement.setObject(int, java.lang.Object)

Copyright (C) 2003-2004 The Spring Framework Project.