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

Re: Upgrading jdbc

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: hw(at)solvedirect(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Upgrading jdbc
Date: 2009-11-30 11:14:40
Message-ID: 87hbscl0wv.fsf@meuh.mnc.lan (view raw or flat)
Thread:
Lists: pgsql-jdbc
hw 'at' solvedirect.com writes:

> Hello!
>
> I'm trying to upgrade to the current jdbc.
> I tried both jdbc3 and jdbc4.
>
> Until now we've been using pg74.215.jdbc3.jar.
> The code is using methods that need a ResultSet with a Type different than
> TYPE_FORWARD_ONLY. In the 7.4-version this seems to be standard.
>
> For the new one I need to do:
> PreparedStatement stmnt = 
> connection.prepareStatement(JDBCEscSeq.convertEscSeq(sqlStmnt, objs), 
> java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, 
> java.sql.ResultSet.CONCUR_READ_ONLY);
> for the code to function as before.
>
> So far this works. Unfortunately the execution of some statements is
> extremly slow.

You may hit a problem with the protocol version 3 and prepared
statements with variable parameters.

http://archives.postgresql.org/pgsql-jdbc/2009-03/msg00027.php

-- 
Guillaume Cottenceau

In response to

pgsql-jdbc by date

Next:From: Mark KirkwoodDate: 2009-12-02 04:23:20
Subject: JDBC index metadata filter_condition
Previous:From: hwDate: 2009-11-30 09:52:14
Subject: Upgrading jdbc

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