You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@camel.apache.org by "rajach1978@gmail.com" <ra...@gmail.com> on 2016/07/05 20:28:17 UTC

SQL jdbc resultSet streaming with blueprint XML

Hi,

I am using SQL JDBC  with Camel blueprint XML.I am new of blue print 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
[TimeSeqNumber] > CAST(CAST(:?DaVitaControlValue AS BIGINT) AS BINARY(8))"/>

how to stream the high volume data from SQL JDBC database. 



--
View this message in context: http://camel.465427.n5.nabble.com/SQL-jdbc-resultSet-streaming-with-blueprint-XML-tp5784809.html
Sent from the Camel - Users mailing list archive at Nabble.com.