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

Package org.springframework.jdbc.core.simple

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

      "{call " + NO_SUCH_PROC + "()}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall sproc = new SimpleJdbcCall(mockDataSource).withProcedureName(NO_SUCH_PROC);
    try {
      sproc.execute();
      fail("Shouldn't succeed in running stored procedure which doesn't exist");
    } catch (BadSqlGrammarException ex) {
      // OK
    }
  }

View Full Code Here

  public void testUnnamedParameterHandling() throws Exception {
    final String MY_PROC = "my_proc";


    replay();


    SimpleJdbcCall sproc = new SimpleJdbcCall(mockDataSource).withProcedureName(MY_PROC);
    try {
      sproc.addDeclaredParameter(new SqlParameter(1));
      fail("Shouldn't succeed in adding unnamed parameter");
    } catch (InvalidDataAccessApiUsageException ex) {
      // OK
    }
  }

View Full Code Here

      "{call add_invoice(?, ?, ?)}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withProcedureName("add_invoice");
    adder.declareParameters(new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER),
        new SqlOutParameter("newid", Types.INTEGER));
    Number newId = adder.executeObject(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());
  }

View Full Code Here

    ctrlConnection.setReturnValue(mockCallable);


    ctrlResultSet.replay();
    replay();


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


    ctrlResultSet.verify();

View Full Code Here

      "{? = call add_invoice(?, ?)}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withFunctionName("add_invoice");
    adder.declareParameters(new SqlOutParameter("return", Types.INTEGER),
        new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER));
    Number newId = adder.executeFunction(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());
  }

View Full Code Here

    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();

View Full Code Here

      "{call " + NO_SUCH_PROC + "()}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall sproc = new SimpleJdbcCall(mockDataSource).withProcedureName(NO_SUCH_PROC);
    try {
      sproc.execute();
      fail("Shouldn't succeed in running stored procedure which doesn't exist");
    } catch (BadSqlGrammarException ex) {
      // OK
    }
  }

View Full Code Here

      "{call add_invoice(?, ?, ?)}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withProcedureName("add_invoice");
    adder.declareParameters(new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER),
        new SqlOutParameter("newid", Types.INTEGER));
    Number newId = adder.executeObject(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());
  }

View Full Code Here

    ctrlConnection.setReturnValue(mockCallable);


    ctrlResultSet.replay();
    replay();


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


    ctrlResultSet.verify();

View Full Code Here

      "{? = call add_invoice(?, ?)}");
    ctrlConnection.setReturnValue(mockCallable);


    replay();


    SimpleJdbcCall adder = new SimpleJdbcCall(mockDataSource).withFunctionName("add_invoice");
    adder.declareParameters(new SqlOutParameter("return", Types.INTEGER),
        new SqlParameter("amount", Types.INTEGER),
        new SqlParameter("custid", Types.INTEGER));
    Number newId = adder.executeFunction(Number.class, new MapSqlParameterSource()
        .addValue("amount", amount)
        .addValue("custid", custid));
    assertEquals(4, newId.intValue());
  }

View Full Code Here

0 1

TOP

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

com.iisigroup.cap.jdbc.CapNamedJdbcTemplate

org.springframework.jdbc.core.simple.SimpleJdbcCallTests

ru.org.linux.spring.StatUpdater

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.