Interface JdbcPrepareStatementStrategy

All Known Implementing Classes:
DefaultJdbcPrepareStatementStrategy

public interface JdbcPrepareStatementStrategy
Strategy for preparing statements when executing SQL queries.
  • Method Summary

    Modifier and Type
    Method
    Description
    createPopulateIterator(String query, String preparedQuery, int expectedParams, org.apache.camel.Exchange exchange, Object value)
    Creates the iterator to use when setting query parameters on the prepared statement.
    void
    populateStatement(PreparedStatement ps, Iterator<?> iterator, int expectedParams)
    Populates the query parameters on the prepared statement
    prepareQuery(String query, boolean allowNamedParameters)
    Prepares the query to be executed.
  • Method Details

    • prepareQuery

      String prepareQuery(String query, boolean allowNamedParameters) throws SQLException
      Prepares the query to be executed.
      Parameters:
      query - the query which may contain named query parameters
      allowNamedParameters - whether named parameters is allowed
      Returns:
      the query to actually use, which must be accepted by the JDBC driver.
      Throws:
      SQLException
    • createPopulateIterator

      Iterator<?> createPopulateIterator(String query, String preparedQuery, int expectedParams, org.apache.camel.Exchange exchange, Object value) throws SQLException
      Creates the iterator to use when setting query parameters on the prepared statement.
      Parameters:
      query - the original query which may contain named parameters
      preparedQuery - the query to actually use, which must be accepted by the JDBC driver.
      expectedParams - number of expected parameters
      exchange - the current exchange
      value - the message body that contains the data for the query parameters
      Returns:
      the iterator
      Throws:
      SQLException - is thrown if error creating the iterator
    • populateStatement

      void populateStatement(PreparedStatement ps, Iterator<?> iterator, int expectedParams) throws SQLException
      Populates the query parameters on the prepared statement
      Parameters:
      ps - the prepared statement
      iterator - the iterator to use for getting the parameter data
      expectedParams - number of expected parameters
      Throws:
      SQLException - is thrown if error populating parameters