org.apache.camel.component.sql

Class SqlEndpoint

java.lang.Object

org.apache.camel.support.service.BaseService

org.apache.camel.support.service.ServiceSupport

org.apache.camel.support.DefaultEndpoint

org.apache.camel.support.ScheduledPollEndpoint

org.apache.camel.support.DefaultPollingEndpoint

org.apache.camel.component.sql.DefaultSqlEndpoint

org.apache.camel.component.sql.SqlEndpoint

All Implemented Interfaces:

AutoCloseable, org.apache.camel.CamelContextAware, org.apache.camel.Endpoint, org.apache.camel.IsSingleton, org.apache.camel.Service, org.apache.camel.ShutdownableService, org.apache.camel.spi.HasId, org.apache.camel.StatefulService, org.apache.camel.SuspendableService

@UriEndpoint(firstVersion="1.4.0",
             scheme="sql",
             title="SQL",
             syntax="sql:query",
             label="database,sql")
public class SqlEndpoint
extends DefaultSqlEndpoint

The sql component allows you to work with databases using JDBC SQL queries.

Field Summary

Fields inherited from class org.apache.camel.support.service.BaseService

BUILDED, FAILED, INITIALIZED, INITIALIZING, lock, NEW, SHUTDOWN, SHUTTINGDOWN, STARTED, STARTING, status, STOPPED, STOPPING, SUSPENDED, SUSPENDING

Constructor Summary

Constructors

Constructor and Description
SqlEndpoint()
SqlEndpoint(String uri, org.apache.camel.Component component, org.springframework.jdbc.core.JdbcTemplate jdbcTemplate, String query)

Method Summary

Modifier and Type	Method and Description
org.apache.camel.Consumer	createConsumer(org.apache.camel.Processor processor)
protected String	createEndpointUri()
org.apache.camel.Producer	createProducer()
String	getQuery()
void	setQuery(String query) Sets the SQL query to perform.

Methods inherited from class org.apache.camel.component.sql.DefaultSqlEndpoint

getDataSource, getDataSourceRef, getExpectedUpdateCount, getJdbcTemplate, getMaxMessagesPerPoll, getOnConsume, getOnConsumeBatchComplete, getOnConsumeFailed, getOutputClass, getOutputHeader, getOutputType, getParametersCount, getPlaceholder, getPrepareStatementStrategy, getProcessingStrategy, getSeparator, getTemplateOptions, isAllowNamedParameters, isAlwaysPopulateStatement, isBatch, isBreakBatchOnConsumeFail, isNoop, isRouteEmptyResultSet, isTransacted, isUseIterator, isUseMessageBodyForSql, isUsePlaceholder, queryForList, queryForObject, queryForStreamList, setAllowNamedParameters, setAlwaysPopulateStatement, setBatch, setBreakBatchOnConsumeFail, setDataSource, setDataSourceRef, setExpectedUpdateCount, setJdbcTemplate, setMaxMessagesPerPoll, setNoop, setOnConsume, setOnConsumeBatchComplete, setOnConsumeFailed, setOutputClass, setOutputHeader, setOutputType, setParametersCount, setPlaceholder, setPrepareStatementStrategy, setProcessingStrategy, setRouteEmptyResultSet, setSeparator, setTemplateOptions, setTransacted, setUseIterator, setUseMessageBodyForSql, setUsePlaceholder

Methods inherited from class org.apache.camel.support.ScheduledPollEndpoint

configureConsumer, configureProperties, configureScheduledPollConsumerProperties, doConfigureConsumer, doStart, doStop, getBackoffErrorThreshold, getBackoffIdleThreshold, getBackoffMultiplier, getDelay, getInitialDelay, getPollStrategy, getRepeatCount, getRunLoggingLevel, getScheduledExecutorService, getScheduler, getSchedulerProperties, getTimeUnit, isGreedy, isSendEmptyMessageWhenIdle, isStartScheduler, isUseFixedDelay, setBackoffErrorThreshold, setBackoffIdleThreshold, setBackoffMultiplier, setDelay, setGreedy, setInitialDelay, setPollStrategy, setRepeatCount, setRunLoggingLevel, setScheduledExecutorService, setScheduler, setSchedulerProperties, setSendEmptyMessageWhenIdle, setStartScheduler, setTimeUnit, setUseFixedDelay

Methods inherited from class org.apache.camel.support.DefaultEndpoint

configurePollingConsumer, createAsyncProducer, createExchange, createExchange, createPollingConsumer, doInit, equals, getCamelContext, getComponent, getEndpointKey, getEndpointUri, getExceptionHandler, getExchangePattern, getId, getPollingConsumerBlockTimeout, getPollingConsumerQueueSize, hashCode, isBasicPropertyBinding, isBridgeErrorHandler, isLazyStartProducer, isLenientProperties, isPollingConsumerBlockWhenFull, isSingleton, isSynchronous, setBasicPropertyBinding, setBridgeErrorHandler, setCamelContext, setComponent, setEndpointUri, setEndpointUriIfNotSpecified, setExceptionHandler, setExchangePattern, setLazyStartProducer, setPollingConsumerBlockTimeout, setPollingConsumerBlockWhenFull, setPollingConsumerQueueSize, setProperties, setSynchronous, toString

Methods inherited from class org.apache.camel.support.service.BaseService

build, doBuild, doFail, doLifecycleChange, doResume, doShutdown, doSuspend, fail, getStatus, init, isBuild, isInit, isNew, isRunAllowed, isShutdown, isStarted, isStarting, isStartingOrStarted, isStopped, isStopping, isStoppingOrStopped, isSuspended, isSuspending, isSuspendingOrSuspended, resume, shutdown, start, stop, suspend

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.apache.camel.Endpoint

getEndpointBaseUri, isSingletonProducer

Methods inherited from interface org.apache.camel.Service

build, close, init, start, stop

Methods inherited from interface org.apache.camel.CamelContextAware

trySetCamelContext

Methods inherited from interface org.apache.camel.StatefulService

getStatus, isRunAllowed, isStarted, isStarting, isStopped, isStopping, isSuspending

Methods inherited from interface org.apache.camel.SuspendableService

isSuspended, resume, suspend

Methods inherited from interface org.apache.camel.ShutdownableService

shutdown

Constructor Detail

SqlEndpoint

public SqlEndpoint()

SqlEndpoint

public SqlEndpoint(String uri,
                   org.apache.camel.Component component,
                   org.springframework.jdbc.core.JdbcTemplate jdbcTemplate,
                   String query)

Method Detail

createConsumer

public org.apache.camel.Consumer createConsumer(org.apache.camel.Processor processor)
                                         throws Exception

Specified by:

createConsumer in interface org.apache.camel.Endpoint

Overrides:

createConsumer in class org.apache.camel.support.DefaultPollingEndpoint

Throws:

Exception

createProducer

public org.apache.camel.Producer createProducer()
                                         throws Exception

Throws:

Exception

createEndpointUri

protected String createEndpointUri()

Overrides:

createEndpointUri in class org.apache.camel.support.DefaultEndpoint

getQuery

public String getQuery()

setQuery

public void setQuery(String query)

Sets the SQL query to perform. You can externalize the query by using file: or classpath: as prefix and specify the location of the file.