Skip site navigation (1) Skip section navigation (2)

Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

From: Kris Jurka <books(at)ejurka(dot)com>
To: Nikolas Everett <nik9000(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Dave Crooke <dcrooke(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-jdbc(at)postgresql(dot)org, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, Scott Carey <scott(at)richrelevance(dot)com>
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set
Date: 2010-04-21 18:00:53
Message-ID: alpine.BSO.2.00.1004211359050.9190@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-performance

On Wed, 21 Apr 2010, Nikolas Everett wrote:

> More to the point is there some option that can shift you into method a? 
>  I'm thinking of warehousing type applications where you want to re-plan 
> a good portion of your queries.
>

This can be done by connecting to the database using the V2 protocol (use 
URL option protocolVersion=2).  This does remove some functionality of 
the driver that is only available for V3 protocol, but will work just 
fine for query execution.

Kris Jurka

In response to

pgsql-performance by date

Next:From: Eliot GableDate: 2010-04-21 20:16:18
Subject: Replacing Cursors with Temporary Tables
Previous:From: Kris JurkaDate: 2010-04-21 17:58:51
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

pgsql-jdbc by date

Next:From: Heikki HiltunenDate: 2010-04-23 12:46:44
Subject: Problem with prepareStatement and Statement.RETURN_GENERATED_KEYS in PostgreSQL JDBC driver 8.4
Previous:From: Kris JurkaDate: 2010-04-21 17:58:51
Subject: Re: SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: [PERFORM] Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group