complexType "jdbcConnectorType"

Namespace:	http://www.mulesoft.org/schema/mule/jdbc
Content:	complex, 12 attributes, attr. wildcard, 8 elements
Defined:	globally in mule-jdbc.xsd; see XML source
Includes:	definitions of 6 attributes, 2 elements
Used:	at 1 location

Content Model Diagram

XML Representation Summary

<...

name	=	(xsd:string \| xsd:NMTOKEN)
dynamicNotification	=	(xsd:string \| xsd:boolean) : "false"
validateConnections	=	(xsd:string \| xsd:boolean) : "true"
dispatcherPoolFactory-ref	=	xsd:string
createMultipleTransactedReceivers	=	(xsd:string \| xsd:boolean)
numberOfConcurrentTransactedReceivers	=	(xsd:string \| xsd:int)
pollingFrequency	=	(xsd:string \| xsd:long)
dataSource-ref	=	xsd:string
queryRunner-ref	=	xsd:string
resultSetHandler-ref	=	xsd:string
transactionPerMessage	=	(xsd:string \| xsd:boolean)
queryTimeout	=	(xsd:string \| xsd:int) : "-1"

{any attribute with non-schema namespace}

Content:

mule:annotations?, spring:property*, mule:receiver-threading-profile?, mule:dispatcher-threading-profile?, mule:abstract-reconnection-strategy?, mule:service-overrides?, abstract-sqlStatementStrategyFactory?, abstract-query*

</...>

Content Model Elements (8):

abstract-query, abstract-sqlStatementStrategyFactory, mule:abstract-reconnection-strategy, mule:annotations, mule:dispatcher-threading-profile, mule:receiver-threading-profile, mule:service-overrides, spring:property

All Direct / Indirect Based Elements (1):

connector

Known Usage Locations

As direct type of elements (1):
connector

Annotation

The JDBC connector is used to configure the shared behavior for JDBC endpoints that reference the connector. DataSources, Queries, and Polling Intervals are some of the key properties configured on the JDBC connector.

Type Definition Detail

Type Derivation Tree

mule:annotatedType (extension)

mule:abstractConnectorType (extension)

mule:connectorType (extension)

mule:transactedConnectorType (extension)

jdbcConnectorType

XML Source (w/o annotations (9); see within schema source)

<xsd:complexType name="jdbcConnectorType">

<xsd:complexContent>

<xsd:extension base="mule:transactedConnectorType">

<xsd:sequence>

<xsd:element maxOccurs="1" minOccurs="0" ref="abstract-sqlStatementStrategyFactory"/>

<xsd:element maxOccurs="unbounded" minOccurs="0" ref="abstract-query"/>

</xsd:sequence>

<xsd:attribute name="pollingFrequency" type="mule:substitutableLong"/>

<xsd:attribute name="dataSource-ref" type="xsd:string" use="required"/>

<xsd:attribute name="queryRunner-ref" type="xsd:string"/>

<xsd:attribute name="resultSetHandler-ref" type="xsd:string"/>

<xsd:attribute name="transactionPerMessage" type="mule:substitutableBoolean"/>

<xsd:attribute default="-1" name="queryTimeout" type="mule:substitutableInt"/>

</xsd:extension>

</xsd:complexContent>

</xsd:complexType>

Attribute Detail (all declarations; defined within this component only; 6/13)

dataSource-ref

Type:	xsd:string, predefined
Use:	required

Reference to the JDBC DataSource object. This object is typically created using Spring. When using XA transactions, an XADataSource object must be provided.

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute name="dataSource-ref" type="xsd:string" use="required"/>

pollingFrequency

Type:	mule:substitutableLong
Use:	optional

The delay in milliseconds that will be used during two subsequent polls to the database. This is only applied to queries configured on inbound endpoints.

Attribute Value

xsd:string | xsd:long

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute name="pollingFrequency" type="mule:substitutableLong"/>

queryRunner-ref

Type:	xsd:string, predefined
Use:	optional

Reference to the QueryRunner object, which is the object that actually runs the Query. This object is typically created using Spring. Default is org.apache.commons.dbutils.QueryRunner.

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute name="queryRunner-ref" type="xsd:string"/>

queryTimeout

Type:	mule:substitutableInt
Use:	optional

The timeout in seconds that will be used as a query timeout for the SQL statement

Attribute Value

xsd:string | xsd:int

Default:

"-1"

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute default="-1" name="queryTimeout" type="mule:substitutableInt"/>

resultSetHandler-ref

Type:	xsd:string, predefined
Use:	optional

Reference to the ResultSetHandler object, which is the object that determines which java.sql.ResultSet gets handled. This object is typically created using Spring. Default is org.apache.commons.dbutils.handlers.MapListHandler, which steps through the ResultSet and stores records as Map objects on a List.

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute name="resultSetHandler-ref" type="xsd:string"/>

transactionPerMessage

Type:	mule:substitutableBoolean
Use:	optional

Whether each database record should be received in a separate transaction. If false, there will be a single transaction for the entire result set. Default is true.

Attribute Value

xsd:string | xsd:boolean

XML Source (w/o annotations (1); see within schema source)

<xsd:attribute name="transactionPerMessage" type="mule:substitutableBoolean"/>

Content Element Detail (all declarations; defined within this component only; 2/8)

abstract-query

Type:	abstractQueryType, empty content
Abstract:	(may not be used directly in instance XML documents)
Subst.Gr:	may be substituted with 1 element

Defines a set of queries. Each query has a key and a value (SQL statement). Queries are later referenced by key.

XML Source (w/o annotations (1); see within schema source)

<xsd:element maxOccurs="unbounded" minOccurs="0" ref="abstract-query"/>

abstract-sqlStatementStrategyFactory

Type:	abstractSqlStatementStrategyFactoryType, empty content
Abstract:	(may not be used directly in instance XML documents)
Subst.Gr:	may be substituted with 1 element

The factory that determines the execution strategy based on the SQL provided.

XML Source (w/o annotations (1); see within schema source)

<xsd:element maxOccurs="1" minOccurs="0" ref="abstract-sqlStatementStrategyFactory"/>

XML schema documentation generated with DocFlex/XML RE 1.8.5 using DocFlex/XML XSDDoc 2.5.0 template set. All content model diagrams generated by Altova XMLSpy via DocFlex/XML XMLSpy Integration.