Examples of org.springframework.jdbc.core.simple.SimpleJdbcCall

org.springframework.jdbc.core.simple.SimpleJdbcCall

A SimpleJdbcCall is a multi-threaded, reusable object representing a call to a stored procedure or a stored function. It provides meta data processing to simplify the code needed to access basic stored procedures/functions. All you need to provide is the name of the procedure/fumnction and a Map containing the parameters when you execute the call. The names of the supplied parameters will be matched up with in and out parameters declared when the stored procedure was created.

The meta data processing is based on the DatabaseMetaData provided by the JDBC driver. Since we rely on the JDBC driver this "auto-detection" can only be used for databases that are known to provide accurate meta data. These currently include Derby, MySQL, Microsoft SQL Server, Oracle and DB2. For any other databases you are required to declare all parameters explicitly. You can of course declare all parameters explictly even if the database provides the necessary meta data. In that case your declared parameters will take precedence. You can also turn off any mete data processing if you want to use parameter names that do not match what is declared during the stored procedure compilation.

The actual insert is being handled using Spring's {@link org.springframework.jdbc.core.JdbcTemplate}.

Many of the configuration methods return the current instance of the SimpleJdbcCall to provide the ablity to string multiple ones together in a "fluid" interface style. @author Thomas Risberg @since 2.5 @see java.sql.DatabaseMetaData @see org.springframework.jdbc.core.JdbcTemplate

    ctrlConnection.setReturnValue(mockCallable);


    ctrlResultSet.replay();
    replay();


    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withFunctionName("add_invoice");
    Number newId = adder.executeFunction(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());


    ctrlResultSet.verify();

    if (idx != -1) {
      schemaName = spName.substring(0, idx);
      spName = spName.substring(idx + 1);
    }


    SimpleJdbcCall jdbcCall = new SimpleJdbcCall(dataSource)
        .withProcedureName(spName).declareParameters(params);


    if (schemaName != null) {
      jdbcCall.setSchemaName(schemaName);
    }


    jdbcCall.setAccessCallParameterMetaData(false);


    Map<String, Object> out = jdbcCall.execute(inParams);
    return out;
  }// ;

  @Autowired
  UserEventService userEventService;


  @Autowired
  public void setDataSource(DataSource dataSource) {
    statUpdate = new SimpleJdbcCall(dataSource).withFunctionName("stat_update");
    statUpdate2 = new SimpleJdbcCall(dataSource).withFunctionName("stat_update2");
    statMonthly = new SimpleJdbcCall(dataSource).withFunctionName("update_monthly_stats");
  }

Examples of org.springframework.jdbc.core.simple.SimpleJdbcCall

Related Classes of org.springframework.jdbc.core.simple.SimpleJdbcCall