| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Hiltunen | 2010-04-23 12:46:44 | Problem with prepareStatement and Statement.RETURN_GENERATED_KEYS in PostgreSQL JDBC driver 8.4 |
| Previous Message | Kris Jurka | 2010-04-21 17:58:51 | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Eliot Gable | 2010-04-21 20:16:18 | Replacing Cursors with Temporary Tables |
| Previous Message | Kris Jurka | 2010-04-21 17:58:51 | 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 |