camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tim Dudgeon <tdudgeon...@gmail.com>
Subject Re: Strange issue with JDBC add Postgres
Date Wed, 12 Nov 2014 19:39:55 GMT
I already did. Described here:
http://camel.465427.n5.nabble.com/Strange-issue-with-JDBC-add-Postgres-tp5758548p5758657.html


Tim

On 12/11/2014 19:26, Claus Ibsen wrote:
> There is a resetAutoCommit option, you can try set that to false
>
> On Mon, Nov 10, 2014 at 1:54 PM, Tim Dudgeon <tdudgeon.ml@gmail.com> wrote:
>> I dug a bit deeper here and I think that Camel is doing something with the
>> connection, possibly related to autoCommit.
>> I worked around the problem by writing my own Processor that sets autoCommit
>> to false, sets maxRows on the statement and then iterates through the
>> ResultSet and a cursor does seem to be used as expected.
>> But trying to do the same with the Camel JDBC component fails for reasons
>> described earlier.
>>
>> Tim
>>
>> On 06/11/2014 18:57, Claus Ibsen wrote:
>>> So maybe its your maxRows=1000 that is the problem, so when you are
>>> trying to get rows > 1000 then it throws that exception.
>>>
>>> What is your use case? You want to select * from a table, but only the
>>> first 1000 rows?
>>>
>>> On Wed, Nov 5, 2014 at 10:05 PM, Tim Dudgeon <tdudgeon.ml@gmail.com>
>>> wrote:
>>>> On 05/11/2014 19:07, Claus Ibsen wrote:
>>>>> maxRowSize ??? do you mean fetchSize?
>>>>
>>>> Sorry, I mean maxRows (as in the example here:
>>>> http://camel.apache.org/jdbc.html).
>>>> So something like:
>>>>
>>>>
>>>> .to('jdbc:myDataSoruce?outputType=StreamList&statement.fetchSize=100&statement.maxRows=1000')
>>>>
>>>>
>>>>> Also which version of Camel do you use?
>>>>
>>>> 2.14
>>>>
>>>> Tim
>>>>
>>>
>
>


Mime
View raw message