www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "raja (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (INFRA-12212) jdbc resultSet streaming
Date Tue, 05 Jul 2016 16:49:10 GMT

    [ 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)

Mime
View raw message