Package org.frankframework.jdbc

Class XmlQuerySender

java.lang.Object

org.frankframework.jndi.JndiBase

org.frankframework.jdbc.JdbcFacade

org.frankframework.jdbc.AbstractJdbcSender<H>

org.frankframework.jdbc.AbstractJdbcQuerySender<Connection>

org.frankframework.jdbc.DirectQuerySender

org.frankframework.jdbc.XmlQuerySender

All Implemented Interfaces:

AdapterAware, HasPhysicalDestination, IBlockEnabledSender<Connection>, IConfigurable, IConfigurationAware, INamedObject, IScopeProvider, ISender, ISenderWithParameters, IWithParameters, IXAEnabled, HasStatistics, 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/interfaces inherited from class org.frankframework.jdbc.AbstractJdbcQuerySender

AbstractJdbcQuerySender.QueryType

Field Summary

Fields

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

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.jndi.JndiBase

log

Constructor Summary

Constructors

Constructor	Description
XmlQuerySender()

Method Summary

Modifier and Type	Method	Description
SenderResult	sendMessage(Connection blockHandle, Message message, PipeLineSession session)

Methods inherited from class org.frankframework.jdbc.DirectQuerySender

closeBlock, closeConnectionForSendMessage, configure, configure, configure, getQuery, openBlock, prepareStatementSet

Methods inherited from class org.frankframework.jdbc.AbstractJdbcQuerySender

adjustQueryAndParameterListForNamedParameters, buildDb2XMLWriter, closeStatementSet, convertQuery, executeOtherQuery, executeOtherQuery, executePackageQuery, executeSelectQuery, executeStatementSet, executeUpdateBlobQuery, executeUpdateClobQuery, fillParamArray, getBatchSize, getBlobBase64Direction, getBlobCharset, getBlobColumn, getBlobSessionKey, getCallWithRowIdReturned, getClobColumn, getClobSessionKey, getColumnsReturned, getColumnsReturnedList, getConnectionForSendMessage, getLockWait, getMaxRows, getNullValue, getOutputFormat, getPackageContent, getQueryExecutionContext, getQueryType, getResult, getResult, getResult, getResultQuery, getReturnedColumns, getRowIdSessionKey, getSqlDialect, getStartRow, getStatement, getStreamCharset, getUpdateStatementResult, getUseNamedParams, isAvoidLocking, isBlobsCompressed, isBlobSmartGet, isCloseInputstreamOnExit, isCloseOutputstreamOnExit, isIncludeFieldDefinition, isLockRows, isPrettyPrint, isScalar, isScalarExtended, isStreamResultToServlet, isSynchronous, isTrimSpaces, prepareQuery, prepareQueryWithColumnsReturned, prepareQueryWithResultSet, 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, start

Methods inherited from class org.frankframework.jdbc.AbstractJdbcSender

addParameter, getAdapter, getConnection, getParameterList, getTimeout, sendMessage, setAdapter, setConfigurationMetrics, setTimeout, stop, toString

Methods inherited from class org.frankframework.jdbc.JdbcFacade

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

Methods inherited from class org.frankframework.jndi.JndiBase

getApplicationContext, getAuthentication, getConfigurationClassLoader, getContext, getCredentials, getInitialContextFactoryName, getJmsRealmName, getJndiAuthAlias, getJndiContextPrefix, getJndiEnv, getJndiProperties, getName, getPrincipal, getProviderURL, getSecurityProtocol, getUrlPkgPrefixes, setApplicationContext, 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 org.springframework.context.ApplicationContextAware

setApplicationContext

Methods inherited from interface org.frankframework.core.IConfigurationAware

getApplicationContext, getName

Methods inherited from interface org.frankframework.core.INamedObject

getName, setName

Methods inherited from interface org.frankframework.core.IScopeProvider

getConfigurationClassLoader

Methods inherited from interface org.frankframework.core.ISender

sendMessageOrThrow

Methods inherited from interface org.frankframework.core.ISenderWithParameters

consumesSessionVariable

Field Details

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 Details

XmlQuerySender

public XmlQuerySender()

Method Details

sendMessage

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

Specified by:

sendMessage in interface IBlockEnabledSender<Connection>

Overrides:

sendMessage in class DirectQuerySender

Throws:

SenderException

TimeoutException