SQL Component
Page edited by Christian Posta
Changes (1)
...
| {{outputClass}} | {{String}} | {{null}} | *Camel 2.12.0:* Specify the full packa
SQL Component
Page edited by Zemian Deng
Changes (1)
...
d) If the query resulted in more than one rows, it throws an non-unique result excepti
SQL Component
Page edited by Zemian Deng
Changes (1)
...
d) If the query resulted in more than one rows, it throws an non-unique result excepti
SQL Component
Page edited by Claus Ibsen
Changes (5)
...
From *Camel 2.12* onwards you can turn on {{optimisticLocking}} and use this JDBC base
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
| {{storeBodyAsText}} | boolean | *Camel 2.11:* Whether to store the message body as S
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
| {{consumer.breakBatchOnConsumeFail}} | {{boolean}} | {{false}} | *Camel 2.11:* *SQL
SQL Component
Page edited by Christian Mueller
Changes (1)
...
|| Option || Type || Default || Description || | {{batch}} | {{boolean}} | {{fal
SQL Component
Page edited by Christian Mueller
Changes (1)
...
{code}
sql:select * from table where id=# order by name?dataSource
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
|| Option || Type || Default || Description || | {{batch}} | {{boolean}} | {{false}} |
SQL Component
Page edited by Christian Mueller
Changes (2)
...
|| Option || Type || Default || Description || | {{batch}} | {{boolean}} | {{fal
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
| {{consumer.expectedUpdateCount}} | {{int}} | {{-1}} | *Camel 2.11:* *SQL consumer on
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
| {{consumer.useIterator}} | {{boolean}} | {{true}} | *Camel 2.11:* *SQL consumer only
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
| {{template.}} | | {{null}} | Sets additional options on the Spring {{JdbcTemplate}}
SQL Component
Page edited by Claus Ibsen
Changes (3)
...
| {{maximumRedeliveries}} | int | Allows you to limit the maximum number of redelivery
SQL Component
Page edited by Claus Ibsen
Changes (3)
...
| {{batch}} | {{boolean}} | {{false}} | *Camel 2.7.5, 2.8.4 and 2.9:* Execute SQL batc
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
{code}
From Camel 2.11 onwards you can use named parameters by using {{#
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
| {{consumer.useIterator}} | {{boolean}} | {{true}} | *Camel 2.11:* *SQL consumer only
SQL Component
Page edited by Claus Ibsen
Changes (1)
...
| {{maxMessagesPerPoll}} | {{int}} | {{0}} | *Camel 2.11:* *SQL consumer only:* An int
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
{warning}
The SQL component can only be used to define producer endpoint
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
h3. Options
{div:class=confluenceTableSmall}
|| Option || T
SQL Component
Page edited by Christian Mueller
Comment:
Removed the deprecated Camel 1.x documentations
Changes (1)
...
SQL Component
Page edited by Christian Mueller
Comment:
Removed the deprecated Camel 1.x documentations
Changes (5)
...
SQL Component
Page edited by Christian Mueller
Changes (2)
...
In the sample below we execute a query and retrieve the result as a {{List}} of
SQL Component
Page edited by Christian Mueller
Changes (1)
...
{snippet:id=e2|lang=xml|url=""
h4. Customize the JdbcMessageIdRepo
SQL Component
Page edited by Claus Ibsen
Changes (2)
...
*Available as of Camel 2.7*: In this section we will use the JDBC based idempotent rep
SQL Component
Page edited by Daniel Gredler
Comment:
enhance documentation of batching feature (CAMEL-4662)
Changes (7)
...
SQL Component
Page edited by Christian Mueller
Changes (1)
...
|| Option || Type || Default || Description ||
| {{batch}} | {{boo
SQL Component
Page edited by Christian Mueller
Changes (2)
...
*Available as of Camel 2.7*: In this section we will use the JDBC based idempote
SQL Component
Page edited by Christian Mueller
Comment:
Described the CAMEL_MESSAGEPROCESSED database table
Changes (2)
...
SQL Component
Page edited by Christian Mueller
Changes (1)
...
{warning}
{info} This component can be used as a [Transactional Cl
SQL Component
Page edited by Richard Kettelerij
Comment:
CAMEL-3800
Changes (1)
...
| {{CamelSqlUpdateCount}} | C
SQL Component
Page edited by Claus Ibsen
Changes (3)
...
Maven users will need to add the following dependency to their {{pom.xml}} for this c
SQL Component
Page edited by Christian Mueller
Changes (3)
...
{code}
h4. Using a JDBC based idempotent repository
h
SQL Component
Page edited by Christian Mueller
Changes (1)
...
h4. Using a JDBC based idempotent repository
*Available as of Came
SQL Component
Page edited by Christian Mueller
Changes (1)
...
{code}
h4. Using a JDBC based idempotent repository In this sectio
SQL Component
Page edited by Roman Kalukiewicz
Changes (3)
...
{code}
Notice that the standard {{?}} symbol that denotes the parameters to an
SQL Component
Page edited by willem jiang
SQL Component
The sql: component allows you to work with databases using JDBC queries. The difference between this component and JDBC component is that in case of SQL the query is a property
SQL Component
Page edited by Fintan Bolton
Minor copy edits and re-wrote the section, 'Rules of treating message body' (renamed to 'Treatment of the message body')
Minor copy edits and re-wrote the section, 'Rules of treating message body' (ren
43 matches
Mail list logo
