March 2011

Discussions Analytics Info

Search Discussions

18 discussions - 170 posts

Newest Active Popular

64
JDBC gripe list

Just got back from pgeast. Seems everyone seems to have a gripe about the JDBC driver. My sense is that for basic read/write/update/delete the driver works just fine. However I'd like to compile a ...

Dave Cramer
Mar 25, 2011 at 12:36 am
Apr 4, 2011 at 7:14 pm
19
Re: JDBC gripe list (the autocommit subthread)

I agree with that. But a batch with autocommit=true is "many" statements, as per the doc. If addBatch was not meant to be called when autocommit=true, then it would have thrown an exception. The ...

Quartz
Mar 30, 2011 at 1:49 pm
Apr 6, 2011 at 9:35 pm
18
Problems with Hibernate Discriminators and 9.0-801.jdbc4

Hi, I have a problem with Hibernate's "single tables" and the last postgres jdbc driver. It seems that now it includes a returning * when there is an Insert, instead of a returning [identifier] that ...

Sdavidr
Mar 23, 2011 at 11:36 pm
Dec 7, 2011 at 3:10 pm
15
Problem with executeBatch and "A result was returned when none was expected"

I've been trying to batch create a bunch of records using stored procedures and the executeBatch() method (so I can get back the generated PKID's) with no luck. I've tried PostgreSQL 8.4.2 with the ...

Sean Bowman
Mar 16, 2011 at 9:14 am
Mar 19, 2011 at 9:22 am
10
idea to have driver return immediately after a query

It was suggested by Robert Haas that it would be possible to return from a query immediately instead of reading the entire result set. Instead of reading it we just let the O/S buffer the results ...

Dave Cramer
Mar 25, 2011 at 12:41 am
Apr 10, 2011 at 4:31 pm
7
SSL connection failure

The server I am connecting to is Redhat with postgres 8.2, running with ssl enabled. The client I am connecting from is Windows 2003 with ColdFusion 8 Enterprise (runs on a Java engine). I set up all ...

David Patricola
Mar 30, 2011 at 3:28 pm
Apr 4, 2011 at 5:06 pm
7
How to retrieve column names for tables with underscores

Hi, this is probably more of a generic JDBC question, but since I'm trying to solve this with Postgres I'm posting it here: I have two tables table1_ (yes there is an underscore at the end) table12 ...

Thomas Kellerer
Mar 24, 2011 at 1:13 pm
Mar 24, 2011 at 10:52 pm
6
JDK1.7 support

I have committed support for building JDBC4.1 with the JDK 1.7 developer preview to CVS. Kris Jurka

Kris Jurka
Mar 31, 2011 at 6:34 am
Apr 4, 2011 at 11:53 am
6
PreparedStatement batch statement impossible

Hi, when using addBatch() and executeBatch() it is impossible to get the generated keys. addBatch() fails with an BatchUpdateException because it isn't expecting results. I am using postgres 9.0 and ...

Hans wulf
Mar 2, 2011 at 2:44 pm
Apr 2, 2011 at 8:46 am
3
Invalid PSQLState used in connection classes

I have noted in the Java code; File: /org/postgresql/core/v3/ConnectionFactoryImpl.java Class: ConnectionFactoryImpl <code snipit catch (ConnectException cex) { // Added by Peter Mount ...

Donald Fraser
Mar 8, 2011 at 4:27 pm
Mar 31, 2011 at 3:10 am
3
[Postgis][javax.sql.DataSource] Failed

Hi, I'm developping an application on Tomcat7. I'm using the DataSource for pooling my connection : <Context reloadable="false" <Resource name="jdbc/TestPool" auth="Container" ...

Micka
Mar 16, 2011 at 12:30 pm
Mar 17, 2011 at 3:01 pm
2
Re-read of updated row using scrollable ResultSet returns old data

It appears that the PG driver returns the original rather than the updated data values for an updatable ResultSet. This is where the updates are applied to a single table ResultSet in a single ...

Andrew Hastie
Mar 31, 2011 at 2:35 pm
Apr 1, 2011 at 3:20 pm
2
Type OID search does not support search_path and multiple schemas

When searching for OID of a Type, current search_path is not considered and if type with the same name exists in several schemas, not a valid OID is fetched to be cached in TypeInfoCache class. One ...

Valentine Gogichashvili
Mar 1, 2011 at 11:51 am
Mar 8, 2011 at 6:37 pm
1
Link to the documentation on jdbc.postgresql.org

Hi, just a minor thing: the link on http://jdbc.postgresql.org/documentation/docs.html still reads "9.0devel". As 9.0 has long be released, I think it would be better to remove the "devel" part from ...

Thomas Kellerer
Mar 27, 2011 at 10:40 am
Apr 8, 2011 at 12:44 am
1
Cannot open connection while insert much data.

My application is using JBOSS 5.1.0.GA, hibernate for connection to PostgreSQL 9.0 database. Application inserts into database rows regularly. But when it attempts insert row with 11Mb (11511828 ...

BozhkoKA
Mar 31, 2011 at 7:16 am
Mar 31, 2011 at 10:24 pm
1
[[No Subject]]

unsubsribe

Tereschenkova
Mar 25, 2011 at 6:34 am
Mar 25, 2011 at 6:34 am
1
imlicit varchar truncation

Hello. I meet the difficulties with insert/update commands using Postgresql JDBC driver. Due to problems described previously at I have to perform an additional call to ...

Pavel B. Milovantsev
Mar 21, 2011 at 2:10 pm
Mar 21, 2011 at 3:55 pm
1
unwrapping InvocationTargetException in PGXAConnection.ConnectionHandler

Hi, Using a Connection from an XAConnection, we've come across some stack traces looking like: Caused by: java.lang.reflect.UndeclaredThrowableException at $Proxy26.prepareStatement(Unknown Source) ...

Florent Guillaume
Mar 11, 2011 at 5:27 pm
Mar 19, 2011 at 10:57 pm