Postgres Pro
Downloads
Home   >   mailing lists

Thread: ...

...

From
News Subsystem
Date:
Thu, 10 Jan 2013 08:48:00 -0800 (PST)
Received: by 10.182.47.4 with SMTP id z4mr918778obm.42.1357836480436; Thu, 10Jan 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@google.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@googlegroups.com>
Subject: Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented on9.2-1002-jdbc4 ???
From: Samuel Zarza Fernández <djava.es@gmail.com>
Cc: José Morales Mora <josete.morales@gmail.com>
Injection-Date: Thu, 10 Jan 2013 16:48:00 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgsql-jdbc@postgresql.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,

Re:

From
Dave Cramer
Date:
Well the line numbers don't even match up with my code. setQueryTimeout is on line 708 see https://github.com/pgjdbc/pgjdbc/blob/master/org/postgresql/jdbc2/AbstractJdbc2Statement.java#L708

I would expect that you have another copy of the driver on your classpath.

Dave

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Thu, Jan 10, 2013 at 11:48 AM, News Subsystem <news@news.hub.org> wrote:
        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@google.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@googlegroups.com>
Subject: Jdbc4PreparedStatement.setQueryTimeout(int) is not yet implemented on
 9.2-1002-jdbc4 ???
From: Samuel Zarza Fernández <djava.es@gmail.com>
Cc: José Morales Mora <josete.morales@gmail.com>
Injection-Date: Thu, 10 Jan 2013 16:48:00 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgsql-jdbc@postgresql.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,


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc