.nabble.com/Strange-issue-with-JDBC-add-Postgres-tp5758548p5782983.html
Sent from the Camel - Users mailing list archive at Nabble.com.
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 wrote:
I
There is a resetAutoCommit option, you can try set that to false
On Mon, Nov 10, 2014 at 1:54 PM, Tim Dudgeon 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
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 se
I tracked it down a bit. Its something to do with auto commit.
There's something about it here:
http://www.postgresql.org/message-id/083dbfcc-8eac-4a5f-bd61-3a82dfc45...@visualdistortion.org
In my case I tried using the resetAutoCommit=false property on the JDBC
component, and thought it had wor
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?
No, it happens without maxRows. I was just
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 wrote:
> On 05/11/2014 19:07, Claus Ib
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 ver
On Wed, Nov 5, 2014 at 6:46 PM, Tim Dudgeon wrote:
> I'm encountering a strange problem with using the JDBC component with
> Postgresql.
> Postgresql by default fetches large result sets into memory. To avoid this
> you need to use
> statement.setFetchSize()
> to make it use a cursor.
> This works
I'm encountering a strange problem with using the JDBC component with
Postgresql.
Postgresql by default fetches large result sets into memory. To avoid
this you need to use
statement.setFetchSize()
to make it use a cursor.
This works fine in a simple Java example. But when I try to use it in
C
10 matches
Mail list logo
