Examples of org.springframework.jdbc.core.CallableStatementCreator

org.springframework.jdbc.core.CallableStatementCreator
One of the three central callback interfaces used by the JdbcTemplate class. This interface creates a CallableStatement given a connection, provided by the JdbcTemplate class. Implementations are responsible for providing SQL and any necessary parameters.
Implementations do not need to concern themselves with SQLExceptions that may be thrown from operations they attempt. The JdbcTemplate class will catch and handle SQLExceptions appropriately.
A PreparedStatementCreator should also implement the SqlProvider interface if it is able to provide the SQL it uses for PreparedStatement creation. This allows for better contextual information in case of exceptions. @author Rod Johnson @author Thomas Risberg @see JdbcTemplate#execute(CallableStatementCreator,CallableStatementCallback) @see JdbcTemplate#call @see SqlProvider

    BufferedOutputStream fos = null;
    try{
      List<SqlParameter> emptyOutParams = new LinkedList<SqlParameter>();
      
      // we ignore the result of the stored procedure
      jdbcTemplate_.call(new CallableStatementCreator() {
  
        @Override
        public CallableStatement createCallableStatement(Connection con) throws SQLException {
          CallableStatement cs = con.prepareCall("call o_logging_export(?,?,?,?,?,?)");
          cs.setString(1, outFile.getAbsolutePath());

View Full Code Here


  /**
   * Mathod to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map<String, ?> params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map<String, ?> args) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(args);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with " + args);
      int i = 1;
      for (SqlParameter param : getCallParameters()) {
        logger.debug(i + ": " +  param.getName() + ", SQL type "+ param.getSqlType() + ", type name " +

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map<String, ?> params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here


  /**
   * Method to perform the actual call processing
   */
  private Map<String, Object> executeCallInternal(Map<String, ?> params) {
    CallableStatementCreator csc = getCallableStatementFactory().newCallableStatementCreator(params);
    if (logger.isDebugEnabled()) {
      logger.debug("The following parameters are used for call " + getCallString() + " with: " + params);
      int i = 1;
      for (SqlParameter p : getCallParameters()) {
        logger.debug(i++ + ": " +  p.getName() + " SQL Type "+ p.getSqlType() + " Type Name " + p.getTypeName() + " " + p.getClass().getName());

View Full Code Here

  /**
   * Performs post-change database updates.
   */
  public void complete() {
    dbCtx.getJdbcTemplate().call(
        new CallableStatementCreator() {
          @Override
          public CallableStatement createCallableStatement(Connection con) throws SQLException {
            return con.prepareCall("{call osmosisUpdate()}");
          }
        }, new ArrayList<SqlParameter>());

View Full Code Here

TOP

Related Classes of org.springframework.jdbc.core.CallableStatementCreator

org.olat.course.statistic.export.UZHStoredProcedureLogExporter

org.openstreetmap.osmosis.pgsnapshot.v0_6.impl.ChangeWriter

org.springframework.jdbc.core.simple.AbstractJdbcCall

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.