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

      All Methods Instance Methods Abstract Methods 
      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.

    • Method Detail

      • 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