Class StatementCreatorUtils

Field Detail

• IGNORE_GETPARAMETERTYPE_PROPERTY_NAME

  public static final String IGNORE_GETPARAMETERTYPE_PROPERTY_NAME

  System property that instructs Spring to ignore ParameterMetaData.getParameterType(int) completely, i.e. to never even attempt to retrieve PreparedStatement.getParameterMetaData() for setNull(java.sql.PreparedStatement, int, int, java.lang.String) calls.

  The default is "false", trying getParameterType calls first and falling back to PreparedStatement.setNull(int, int) / PreparedStatement.setObject(int, java.lang.Object, int) calls based on well-known behavior of common databases.

  Consider switching this flag to "true" if you experience misbehavior at runtime, e.g. with connection pool issues in case of an exception thrown from getParameterType (as reported on JBoss AS 7) or in case of performance problems (as reported on PostgreSQL).

  See Also:

  Constant Field Values

Constructor Detail

• StatementCreatorUtils

  public StatementCreatorUtils()

Method Detail

• javaTypeToSqlParameterType

  public static int javaTypeToSqlParameterType​(@Nullable
                                               Class<?> javaType)

  Derive a default SQL type from the given Java type.

  Parameters:

  javaType - the Java type to translate

  Returns:

  the corresponding SQL type, or SqlTypeValue.TYPE_UNKNOWN if none found

• setParameterValue

  public static void setParameterValue​(PreparedStatement ps,
                                       int paramIndex,
                                       SqlParameter param,
                                       @Nullable
                                       Object inValue)
                                throws SQLException

  Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

  Parameters:

  ps - the prepared statement or callable statement

  paramIndex - index of the parameter we are setting

  param - the parameter as it is declared including type

  inValue - the value to set

  Throws:

  SQLException - if thrown by PreparedStatement methods

• setParameterValue

  public static void setParameterValue​(PreparedStatement ps,
                                       int paramIndex,
                                       int sqlType,
                                       @Nullable
                                       Object inValue)
                                throws SQLException

  Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

  Parameters:

  ps - the prepared statement or callable statement

  paramIndex - index of the parameter we are setting

  sqlType - the SQL type of the parameter

  inValue - the value to set (plain value or an SqlTypeValue)

  Throws:

  SQLException - if thrown by PreparedStatement methods

  See Also:

  SqlTypeValue

• setParameterValue

  public static void setParameterValue​(PreparedStatement ps,
                                       int paramIndex,
                                       int sqlType,
                                       String typeName,
                                       @Nullable
                                       Object inValue)
                                throws SQLException

  Set the value for a parameter. The method used is based on the SQL type of the parameter and we can handle complex types like arrays and LOBs.

  Parameters:

  ps - the prepared statement or callable statement

  paramIndex - index of the parameter we are setting

  sqlType - the SQL type of the parameter

  typeName - the type name of the parameter (optional, only used for SQL NULL and SqlTypeValue)

  inValue - the value to set (plain value or an SqlTypeValue)

  Throws:

  SQLException - if thrown by PreparedStatement methods

  See Also:

  SqlTypeValue

• cleanupParameters

  public static void cleanupParameters​(@Nullable
                                       Object... paramValues)

  Clean up all resources held by parameter values which were passed to an execute method. This is for example important for closing LOB values.

  Parameters:

  paramValues - parameter values supplied. May be null.

  See Also:

  DisposableSqlTypeValue.cleanup(), SqlLobValue.cleanup()

• cleanupParameters

  public static void cleanupParameters​(@Nullable
                                       Collection<?> paramValues)

  Clean up all resources held by parameter values which were passed to an execute method. This is for example important for closing LOB values.

  Parameters:

  paramValues - parameter values supplied. May be null.

  See Also:

  DisposableSqlTypeValue.cleanup(), SqlLobValue.cleanup()