[jira] [Commented] (INFRA-12212) jdbc resultSet streaming

["raja (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/INFRA-12212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15362758#comment-15362758 ] 

raja commented on INFRA-12212:
------------------------------

I am using JDBC with Camel blueprint XML.I want to stream the JDBC resultSet database by
using blueprint XML. Could you please suggest the solution.
The below is the select statement and currently reading from database readSize is "25000"
<cm:property name="jdbc-URI" value="jdbc://systemDb?useHeadersAsParameters=true&amp;readSize=25000" />
<cm:property name="sql-query" value="SELECT * FROM [TableName] WHERE [XmitTimeSeqNumber] > CAST(CAST(:?DaVitaControlValue AS BIGINT) AS BINARY(8))"/>

how to stream the high volume data from JDBC database.


> jdbc resultSet streaming
> ------------------------
>
>                 Key: INFRA-12212
>                 URL: https://issues.apache.org/jira/browse/INFRA-12212
>             Project: Infrastructure
>          Issue Type: Task
>          Components: Blogs
>            Reporter: raja
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)