nl.nn.adapterframework.jdbc

Class XmlQuerySender

java.lang.Object

nl.nn.adapterframework.jndi.JndiBase

nl.nn.adapterframework.jdbc.JdbcFacade

nl.nn.adapterframework.jdbc.JdbcSenderBase<H>

nl.nn.adapterframework.jdbc.JdbcQuerySenderBase<Connection>

nl.nn.adapterframework.jdbc.DirectQuerySender

nl.nn.adapterframework.jdbc.XmlQuerySender

All Implemented Interfaces:

HasPhysicalDestination, IBlockEnabledSender<Connection>, IConfigurable, IConfigurationAware, INamedObject, IScopeProvider, ISender, ISenderWithParameters, IWithParameters, IXAEnabled, HasStatistics, IOutputStreamingSupport, IStreamingSender, org.springframework.beans.factory.Aware, org.springframework.context.ApplicationContextAware

public class XmlQuerySender
extends DirectQuerySender

QuerySender that transforms the input message to a query.

  select
  delete
  insert
  update - tableName
         - columns [0..1] - column [1..n] - name
                                          - value [0..1]
                                          - type [0..1] one of {string;function;number;datetime;blob;clob;xmldatetime}, string by default
                                          - decimalSeparator [0..1] only applicable for type=number
                                          - groupingSeparator [0..1] only applicable for type=number
                                          - formatString [0..1] only applicable for type=datetime, yyyy-MM-dd HH:mm:ss.SSS by default 
         - where [0..1]
         - order [0..1]
 

  alter - sequenceName
        - startWith
 

  sql   - type [0..1] one of {select;ddl;other}, other by default
        - query
 

 

Author:

Peter Leeuwenburgh

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	XmlQuerySender.Column

Nested classes/interfaces inherited from class nl.nn.adapterframework.jdbc.JdbcQuerySenderBase

JdbcQuerySenderBase.QueryType

Nested classes/interfaces inherited from interface nl.nn.adapterframework.statistics.HasStatistics

HasStatistics.Action

Field Summary

Fields

Modifier and Type	Field and Description
static String	TYPE_BLOB
static String	TYPE_BOOLEAN
static String	TYPE_CLOB
static String	TYPE_DATETIME
static String	TYPE_DATETIME_PATTERN
static String	TYPE_FUNCTION
static String	TYPE_INTEGER
static String	TYPE_NUMBER
static String	TYPE_STRING
static String	TYPE_XMLDATETIME

Fields inherited from class nl.nn.adapterframework.jdbc.JdbcQuerySenderBase

UNP_END, UNP_START

Fields inherited from class nl.nn.adapterframework.jdbc.JdbcSenderBase

connection, paramList

Fields inherited from class nl.nn.adapterframework.jndi.JndiBase

log

Constructor Summary

Constructors

Constructor and Description
XmlQuerySender()

Method Summary

Modifier and Type	Method and Description
protected PipeRunResult	sendMessageOnConnection(Connection connection, Message message, PipeLineSession session, IForwardTarget next)

Methods inherited from class nl.nn.adapterframework.jdbc.DirectQuerySender

closeBlock, closeConnectionForSendMessage, configure, configure, configure, getConnectionForSendMessage, getQuery, openBlock, sendMessage, sendMessage

Methods inherited from class nl.nn.adapterframework.jdbc.JdbcQuerySenderBase

adjustQueryAndParameterListForNamedParameters, canProvideOutputStream, closeStatementSet, convertQuery, executeOtherQuery, executeOtherQuery, executePackageQuery, executeSelectQuery, executeSelectQuery, executeStatementSet, executeUpdateBlobQuery, executeUpdateClobQuery, fillParamArray, getBatchSize, getCallWithRowIdReturned, getQueryExecutionContext, getQueryTypeEnum, getResult, getResult, getResult, getReturnedColumns, getStatement, open, prepareQuery, prepareStatementSet, provideOutputStream, setAvoidLocking, setBlobBase64Direction, setBlobCharset, setBlobColumn, setBlobsCompressed, setBlobSessionKey, setBlobSmartGet, setClobColumn, setClobSessionKey, setCloseInputstreamOnExit, setCloseOutputstreamOnExit, setColumnsReturned, setIncludeFieldDefinition, setLockRows, setLockWait, setMaxRows, setNullValue, setOutputFormat, setPackageContent, setPrettyPrint, setQueryType, setResultQuery, setRowIdSessionKey, setScalar, setScalarExtended, setSqlDialect, setStartRow, setStreamCharset, setStreamResultToServlet, setSynchronous, setTrimSpaces, setUseNamedParams, supportsOutputStreamPassThrough

Methods inherited from class nl.nn.adapterframework.jdbc.JdbcSenderBase

addParameter, close, getParameterList, getTimeout, sendMessage, setTimeout, toString

Methods inherited from class nl.nn.adapterframework.jdbc.JdbcFacade

getAuthAlias, getConnection, getConnectionWithTimeout, getDatasource, getDatasourceInfo, getDatasourceName, getDbmsSupport, getLogPrefix, getPassword, getPhysicalDestinationName, getUsername, isConnectionsArePooled, isTransacted, iterateOverStatistics, setAuthAlias, setConnectionsArePooled, setDatasourceName, setDbmsSupportFactory, setJmsRealm, setPassword, setTransacted, setUsername

Methods inherited from class nl.nn.adapterframework.jndi.JndiBase

getContext, getJndiEnv, setAuthentication, setCredentials, setInitialContextFactoryName, setJndiAuthAlias, setJndiContextPrefix, setJndiProperties, setName, setPrincipal, setProviderURL, setSecurityProtocol, setUrlPkgPrefixes

Methods inherited from class java.lang.Object

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

Methods inherited from interface nl.nn.adapterframework.core.ISenderWithParameters

consumesSessionVariable

Methods inherited from interface nl.nn.adapterframework.core.ISender

isSynchronous, sendMessageOrThrow

Methods inherited from interface nl.nn.adapterframework.core.INamedObject

getName, setName

Methods inherited from interface nl.nn.adapterframework.core.IConfigurationAware

getApplicationContext, getName

Methods inherited from interface nl.nn.adapterframework.core.IScopeProvider

getConfigurationClassLoader

Methods inherited from interface org.springframework.context.ApplicationContextAware

setApplicationContext

Methods inherited from interface nl.nn.adapterframework.core.HasPhysicalDestination

getDomain

Field Detail

TYPE_STRING

public static final String TYPE_STRING

See Also:

Constant Field Values

TYPE_NUMBER

public static final String TYPE_NUMBER

See Also:

Constant Field Values

TYPE_INTEGER

public static final String TYPE_INTEGER

See Also:

Constant Field Values

TYPE_BLOB

public static final String TYPE_BLOB

See Also:

Constant Field Values

TYPE_CLOB

public static final String TYPE_CLOB

See Also:

Constant Field Values

TYPE_BOOLEAN

public static final String TYPE_BOOLEAN

See Also:

Constant Field Values

TYPE_FUNCTION

public static final String TYPE_FUNCTION

See Also:

Constant Field Values

TYPE_DATETIME

public static final String TYPE_DATETIME

See Also:

Constant Field Values

TYPE_DATETIME_PATTERN

public static final String TYPE_DATETIME_PATTERN

See Also:

Constant Field Values

TYPE_XMLDATETIME

public static final String TYPE_XMLDATETIME

See Also:

Constant Field Values

Constructor Detail

XmlQuerySender

public XmlQuerySender()

Method Detail

sendMessageOnConnection

protected PipeRunResult sendMessageOnConnection(Connection connection,
                                                Message message,
                                                PipeLineSession session,
                                                IForwardTarget next)
                                         throws SenderException,
                                                TimeoutException

Overrides:

sendMessageOnConnection in class JdbcQuerySenderBase<Connection>

Throws:

SenderException

TimeoutException