Thu, 10 Jan 2013 08:48:00 -0800 (PST)
Received: by 10.182.47.4 with SMTP id z4mr918778obm.42.1357836480436; Thu, 10
Jan 2013 08:48:00 -0800 (PST)
X-Newsgroups: pgsql.interfaces.jdbc
Date: Thu, 10 Jan 2013 08:48:00 -0800 (PST)
Complaints-To: groups-abuse(at)google(dot)com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=80.81.122.114;
posting-account=f179swkAAADqk9gd_fVDPiDLQSzRUPrj
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d5d857ca-29c5-4231-bcc0-ac695cb8209f(at)googlegroups(dot)com>
Subject: Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented on
9.2-1002-jdbc4 ???
From: =?ISO-8859-1?Q?Samuel_Zarza_Fern=E1ndez?= <djava(dot)es(at)gmail(dot)com>
Cc: =?ISO-8859-1?Q?Jos=E9_Morales_Mora?= <josete(dot)morales(at)gmail(dot)com>
Injection-Date: Thu, 10 Jan 2013 16:48:00 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgsql-jdbc(at)postgresql(dot)org

Hello:

I've configured "Statement Timeout" on Glassfish Connection Pool with JDBC driver 9.2-1002 (theorically having that implemented), but gets:

Caused by: java.sql.SQLFeatureNotSupportedException: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented.
at org.postgresql.Driver.notImplemented(Driver.java:753)
at org.postgresql.jdbc2.AbstractJdbc2Statement.setQueryTimeout(AbstractJdbc2Statement.java:668)
at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:477)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.prepareStatement(DatabaseAccessor.java:1162)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseCall.prepareStatement(DatabaseCall.java:612)
at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:485)

Test info:
PostgreSQL 9.0 on Debian
Driver JDBC on pool over Glassfish 9.1
JDBC Driver Version 9.2-1002 jdbc4

Regards,