Package org.apache.camel.component.sql

Interface SqlNamedProcessingStrategy

All Superinterfaces:
SqlProcessingStrategy
public interface SqlNamedProcessingStrategy extends SqlProcessingStrategy
Extended processing strategy for dealing with SQL when consuming, which uses a NamedParameterJdbcTemplate instead of plain JdbcTemplate.

  • Method Summary

    Modifier and Type
    Method
    Description
    int
    commit(DefaultSqlEndpoint endpoint, org.apache.camel.Exchange exchange, Object data, org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedJdbcTemplate, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, String query)
    Commit callback if there are a query to be run after processing.
    int
    commitBatchComplete(DefaultSqlEndpoint endpoint, org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedJdbcTemplate, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, String query)
    Commit callback when the batch is complete.

    Methods inherited from interface org.apache.camel.component.sql.SqlProcessingStrategy

    commit, commitBatchComplete

  • Method Details

    • commit

      int commit(DefaultSqlEndpoint endpoint, org.apache.camel.Exchange exchange, Object data, org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedJdbcTemplate, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, String query) throws Exception
      Commit callback if there are a query to be run after processing.
      Parameters:
      endpoint - the endpoint
      exchange - The exchange after it has been processed
      data - The original data delivered to the route
      namedJdbcTemplate - The JDBC template
      parameterSource - Parameter sources for the named JDBC template
      query - The SQL query to execute
      Returns:
      the update count if the query returned an update count
      Throws:
      Exception - can be thrown in case of error

    • commitBatchComplete

      int commitBatchComplete(DefaultSqlEndpoint endpoint, org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate namedJdbcTemplate, org.springframework.jdbc.core.namedparam.SqlParameterSource parameterSource, String query) throws Exception
      Commit callback when the batch is complete. This allows you to do one extra query after all rows has been processed in the batch.
      Parameters:
      endpoint - the endpoint
      namedJdbcTemplate - The JDBC template
      parameterSource - Parameter sources for the named JDBC template
      query - The SQL query to execute
      Returns:
      the update count if the query returned an update count
      Throws:
      Exception - can be thrown in case of error