Package com.adaptris.interlok.jdbc

Class JDBCQueryStatementBuilder

  • All Implemented Interfaces:
    AdaptrisComponent, ComponentLifecycle, ComponentLifecycleExtension, ConnectedService, MessageEventGenerator, Service, StateManagedComponent
    @ComponentProfile(summary="JDBC data query statement builder service",
                  tag="jdbc,query,build,statement",
                  since="4.1.0")
public class JDBCQueryStatementBuilder
extends JDBCStatementBuilder
    JDBC data query statement builder service.

    Build a JDBC data query service using the given statement to create the necessary parameter list. It turns:

     
 <jdbc-statement-service>
    <unique-id>7b18517b-017d-4741-8b5e-9e490bff6c51</unique-id>
    <statement>SELECT * FROM person WHERE id = %sql_payload{string:id}</statement>
 </jdbc-statement-service>

    into:

    
 <jdbc-data-query-service>
    <uniqueId>e99b6678-da08-4e25-810a-4d2cb59f0a44</uniqueId>
    <named-parameter-applicator>
        <parameterNamePrefix>#</parameterNamePrefix>
        <parameterNameRegex>#\w*</parameterNameRegex>
    </named-parameter-applicator>
    <statementParameters>
        <parameters>
            <jdbc-string-statement-parameter>
                <name>id</name>
                <queryString>id</queryString>
                <queryType>payload</queryType>
                <convertNull>false</convertNull>
            </jdbc-string-statement-parameter>
        </parameters>
    </statementParameters>
    <jdbc-configured-sql-statement>
        <statement>SELECT * FROM person WHERE id = #id</statement>
    </jdbc-configured-sql-statement>
    <jdbc-noop-result-set-translator/>
 </jdbc-data-query-service>