Package org.frankframework.jdbc

Class DirectQuerySender

java.lang.Object

org.frankframework.jdbc.JdbcFacade

org.frankframework.jdbc.AbstractJdbcSender<Connection>

org.frankframework.jdbc.AbstractJdbcQuerySender<Connection>

org.frankframework.jdbc.DirectQuerySender

All Implemented Interfaces:

FrankElement, HasApplicationContext, HasName, HasPhysicalDestination, IBlockEnabledSender<Connection>, IConfigurable, IScopeProvider, ISender, ISenderWithParameters, IWithParameters, IXAEnabled, NameAware, ConfigurableLifecycle, org.springframework.beans.factory.Aware, org.springframework.context.ApplicationContextAware, org.springframework.context.Lifecycle, org.springframework.context.Phased, org.springframework.context.SmartLifecycle

Direct Known Subclasses:

JdbcIteratingPipeBase.MixedQuerySender, XmlQuerySender

public class DirectQuerySender
extends AbstractJdbcQuerySender<Connection>

QuerySender that interprets the input message as a query, possibly with attributes. Messages are expected to contain sql-text.

Since:

4.1

Author:

Gerrit van Brakel

Parameters

All parameters present are applied to the query to be executed.

Nested Class Summary

Nested classes/interfaces inherited from class org.frankframework.jdbc.AbstractJdbcQuerySender

AbstractJdbcQuerySender.QueryType

Field Summary

Fields inherited from class org.frankframework.jdbc.AbstractJdbcQuerySender

UNP_END, UNP_START

Fields inherited from class org.frankframework.jdbc.AbstractJdbcSender

connection, paramList

Fields inherited from class org.frankframework.jdbc.JdbcFacade

log

Fields inherited from interface org.springframework.context.SmartLifecycle

DEFAULT_PHASE

Constructor Summary

Constructors

Constructor	Description
DirectQuerySender()

Method Summary

Modifier and Type	Method	Description
void	closeBlock(Connection connection, PipeLineSession session)	close the resource that is opened by IBlockEnabledSender.openBlock(PipeLineSession).
protected void	closeConnectionForSendMessage(Connection connection, PipeLineSession session)
void	configure()	Configure this component.
void	configure(boolean ignoreSQLInjectionWarning)
void	configure(Adapter adapter)
protected String	getQuery(Message message)	Obtain a query to be executed.
Connection	openBlock(PipeLineSession session)	open a resource that can be used multiple times when IBlockEnabledSender.sendMessage(Object, Message, PipeLineSession) is called.
protected QueryExecutionContext	prepareStatementSet(Connection connection, Message message)
SenderResult	sendMessage(Connection connection, Message message, PipeLineSession session)

Methods inherited from class org.frankframework.jdbc.AbstractJdbcQuerySender

adjustQueryAndParameterListForNamedParameters, buildDb2XMLWriter, closeStatementSet, convertQuery, executeOtherQuery, executeOtherQuery, executePackageQuery, executeSelectQuery, executeStatementSet, executeUpdateBlobQuery, executeUpdateClobQuery, fillParamArray, getBatchSize, getCallWithRowIdReturned, getConnectionForSendMessage, getQueryExecutionContext, getResult, getResult, getReturnedColumns, getStatement, getUpdateStatementResult, prepareQuery, prepareQueryWithColumnsReturned, prepareQueryWithResultSet, setAvoidLocking, setBlobBase64Direction, setBlobCharset, setBlobColumn, setBlobsCompressed, setBlobSessionKey, setBlobSmartGet, setClobColumn, setClobSessionKey, setCloseOutputstreamOnExit, setColumnsReturned, setIncludeFieldDefinition, setLockRows, setLockWait, setMaxRows, setNullValue, setOutputFormat, setPackageContent, setPrettyPrint, setQueryType, setResultQuery, setRowIdSessionKey, setScalar, setScalarExtended, setSqlDialect, setStartRow, setStreamCharset, setSynchronous, setTrimSpaces, setUseNamedParams, start

Methods inherited from class org.frankframework.jdbc.AbstractJdbcSender

addParameter, getConnection, getParameterList, sendMessage, setTimeout, stop, toString

Methods inherited from class org.frankframework.jdbc.JdbcFacade

getConnectionWithTimeout, getDatasource, getDatasourceName, getDbmsSupport, getLogPrefix, getPassword, getPhysicalDestinationName, isConnectionsArePooled, isRunning, isTransacted, setAuthAlias, setConnectionsArePooled, setDatasourceName, setDbmsSupportFactory, setName, setPassword, setTransacted, setUsername

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.springframework.context.ApplicationContextAware

setApplicationContext

Methods inherited from interface org.frankframework.lifecycle.ConfigurableLifecycle

getPhase, isAutoStartup, isConfigured

Methods inherited from interface org.frankframework.core.FrankElement

addConfigWarning

Methods inherited from interface org.frankframework.core.HasApplicationContext

getApplicationContext, getConfigurationClassLoader

Methods inherited from interface org.frankframework.core.HasName

getName

Methods inherited from interface org.frankframework.core.ISender

isSynchronous, sendMessageOrThrow

Methods inherited from interface org.frankframework.core.ISenderWithParameters

consumesSessionVariable

Methods inherited from interface org.frankframework.core.NameAware

setName

Methods inherited from interface org.springframework.context.SmartLifecycle

stop

Constructor Details

DirectQuerySender

public DirectQuerySender()

Method Details

configure

public void configure()
               throws ConfigurationException

Description copied from interface: IConfigurable

Configure this component.

configure() is called once at startup of the framework in the configure method of the owner of this IConfigurable. Purpose of this method is to check whether the static configuration of the object is correct. As much as possible class-instantiating should take place in the configure(), to improve performance.

In the case of a container, this will propagate the configure signal to all components that apply.

Specified by:

configure in interface IConfigurable

Overrides:

configure in class AbstractJdbcQuerySender<Connection>

Throws:

ConfigurationException - in case it was not able to configure the component.

configure

public void configure(boolean ignoreSQLInjectionWarning)
               throws ConfigurationException

Throws:

ConfigurationException

configure

public void configure(Adapter adapter)
               throws ConfigurationException

Throws:

ConfigurationException

getQuery

protected String getQuery(Message message)
                   throws SenderException

Description copied from class: AbstractJdbcQuerySender

Obtain a query to be executed. Method-stub to be overridden in descender-classes.

Specified by:

getQuery in class AbstractJdbcQuerySender<Connection>

Throws:

SenderException

openBlock

public Connection openBlock(PipeLineSession session)
                     throws SenderException,
TimeoutException

Description copied from interface: IBlockEnabledSender

open a resource that can be used multiple times when IBlockEnabledSender.sendMessage(Object, Message, PipeLineSession) is called.

Throws:

SenderException

TimeoutException

closeBlock

public void closeBlock(Connection connection,
 PipeLineSession session)
                throws SenderException

Description copied from interface: IBlockEnabledSender

close the resource that is opened by IBlockEnabledSender.openBlock(PipeLineSession). It is important that this method is always called after processing with the blockHandle ends. It should effectively be called in a finally clause of a try around the openBlock.

Throws:

SenderException

closeConnectionForSendMessage

protected void closeConnectionForSendMessage(Connection connection,
 PipeLineSession session)

Overrides:

closeConnectionForSendMessage in class AbstractJdbcQuerySender<Connection>

sendMessage

public SenderResult sendMessage(Connection connection,
 Message message,
 PipeLineSession session)
                         throws SenderException,
TimeoutException

Throws:

SenderException

TimeoutException

prepareStatementSet

protected QueryExecutionContext prepareStatementSet(Connection connection,
 Message message)
                                             throws SenderException

Throws:

SenderException