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 and 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 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