Package org.frankframework.jdbc
Class 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
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.JdbcQuerySenderBase
JdbcQuerySenderBase.QueryType
-
Field Summary
Modifier and TypeFieldDescriptionstatic final String
static final String
static final String
static final String
static final String
static final String
static final String
static final String
static final String
static final String
Fields inherited from class org.frankframework.jdbc.JdbcQuerySenderBase
UNP_END, UNP_START
Fields inherited from class org.frankframework.jdbc.JdbcSenderBase
connection, paramList
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionprotected PipeRunResult
sendMessageOnConnection
(Connection connection, Message message, PipeLineSession session, IForwardTarget next) Methods inherited from class org.frankframework.jdbc.DirectQuerySender
closeBlock, closeConnectionForSendMessage, configure, configure, configure, getQuery, openBlock, prepareStatementSet, sendMessage
Methods inherited from class org.frankframework.jdbc.JdbcQuerySenderBase
adjustQueryAndParameterListForNamedParameters, buildDb2XMLWriter, closeStatementSet, convertQuery, executeOtherQuery, executeOtherQuery, executePackageQuery, executeSelectQuery, 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, open, 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
Methods inherited from class org.frankframework.jdbc.JdbcSenderBase
addParameter, close, getAdapter, getConnection, getParameterList, getTimeout, sendMessage, setAdapter, setConfigurationMetrics, setTimeout, 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
- See Also:
-
TYPE_NUMBER
- See Also:
-
TYPE_INTEGER
- See Also:
-
TYPE_BLOB
- See Also:
-
TYPE_CLOB
- See Also:
-
TYPE_BOOLEAN
- See Also:
-
TYPE_FUNCTION
- See Also:
-
TYPE_DATETIME
- See Also:
-
TYPE_DATETIME_PATTERN
- See Also:
-
TYPE_XMLDATETIME
- See Also:
-
-
Constructor Details
-
XmlQuerySender
public XmlQuerySender()
-
-
Method Details
-
sendMessageOnConnection
protected PipeRunResult sendMessageOnConnection(Connection connection, Message message, PipeLineSession session, IForwardTarget next) throws SenderException, TimeoutException - Overrides:
sendMessageOnConnection
in classDirectQuerySender
- Throws:
SenderException
TimeoutException
-