pgsql-jdbc@postgresql.org discussions

9	Re: [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

Ok, this is much more difficult than I thought. Turns out that there are at least two interfaces that expect an int not a long. BatchUpdateException executeBatch I'm thinking the only option here is ...

Dave Cramer
Jan 11, 2013 at 1:20 pm
Jan 12, 2013 at 8:57 am

1	[[No Subject]]

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 ...

News Subsystem
Jan 10, 2013 at 4:56 pm
Jan 11, 2013 at 11:23 am

2	setObject(int,Object) can not convert Java String object to backend's Integer type

Hi, According to JDBC Specification Java String object could be converted to backend's Integer type by setObject(). But in PostgreSQL JDBC, it's not true. It seems to be a bug. Sample ...

Chen Huajun
Jan 8, 2013 at 11:06 am
Jan 8, 2013 at 12:25 pm

1	Bug report: buggy implementation of setQueryTimeout() in latest JDBC drivers 9.2-100x (AbstractJdbc2Statement.java)

Hey guys, We have discovered a very weird issues caused by, it turned out, buggy implementation of setQueryTimeout() in latest JDBC drivers 9.2-100x. Database version is PostgreSQL 9.2.1 (PostgreSQL ...

Andriy Redko
Jan 4, 2013 at 1:50 pm
Jan 8, 2013 at 4:44 pm

1	Set read-only connection from a connect string parameter

Hi, I have a very simple (2 lines) patch which allows you to set ?readOnly=true on your connection string. https://github.com/pgjdbc/pgjdbc/pull/26 Hopefully someone finds this useful. Steven

Steven Schlansker
Dec 30, 2012 at 7:11 pm
Jan 11, 2013 at 1:49 pm

1	Extracting more useful information from PSQLException

Hi everyone, While designing web services that are backed by PostgreSQL, it is often helpful to report a more useful HTTP error than a generic "Something went wrong, sorry dude". The thrown ...

Steven Schlansker
Dec 28, 2012 at 10:12 pm
Dec 29, 2012 at 1:57 am

0	Class for specifying SSL client certificate via KeyStore

Hi there, For a project of mine, I needed to connect to Postgres using JDBC and also provide a self-signed SSL certificate for authentication. I noticed the following in the jdbc-postgres ...

Brendan Jurd
Dec 28, 2012 at 6:04 pm
Dec 28, 2012 at 6:04 pm

0	logging log4j to postgresql

Hello I've been trying to log log4j results to postgresql for hours with no success. I first started by an example I found here which is pasted below I get no error messages, when I use it but ...

Xpro6000
Dec 27, 2012 at 12:29 pm
Dec 27, 2012 at 12:29 pm

2	Re: [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception

Forwarding this to pgsql-jdbc list. FWIW, guys, the backend currently thinks that execution counts are unsigned ints. So I surmise that the problematic update count was actually between 2^31 and ...

Tom Lane
Dec 21, 2012 at 4:47 pm
Dec 21, 2012 at 8:17 pm

3	JPA + enum == Exception

I'm trying to use enum's in a database, but the java guys are telling me that they are having problems with inserts … reading from the database isn't a problem, but there appears to be an issue with ...

Marc G. Fournier
Dec 17, 2012 at 11:01 pm
Dec 18, 2012 at 2:26 pm

2	JDBC with PG 9.2 and large object permissions as they relate to blobs (after upgrade from 8.4)

We upgraded our PG from 8.4 to 9.2 and found that our pg_dump and pg_restore caused all of the large objects to be given permission to our db admin user, but not our application user. This resulted ...

David Wall
Dec 17, 2012 at 6:32 pm
Dec 17, 2012 at 6:55 pm

6	Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

Haifeng Liu
Dec 14, 2012 at 3:29 am
Dec 14, 2012 at 5:38 pm

1	Update translation for japanese(ja.po).

Hi, I'm using PostgreSQL JDBC Driver on Japanese environment. And I've realized some typo and unclear messages are in ja.po, so I tried to revise it. attached file is patch for ja.po. I want you to ...

Tomonari Katsumata
Dec 10, 2012 at 8:49 am
Jan 11, 2013 at 1:58 pm

13	Statement.setQueryTimeout() with autoCommit=false

Hi, does setQueryTimeout work with autoCommit=false? When autoCommit is true, this code timeouts after 5 seconds (as expected): -- Class.forName("org.postgresql.Driver"); String url = ...

Pavel Arnost
Dec 6, 2012 at 5:10 pm
Dec 6, 2012 at 11:44 pm

5	Problems with BIT datatype and preparedStatment

Hello, We are having problems when using BIT datatype. Mainly when using it on prepared statement. The code below is a copy of the one send at: pgsql-patches on 2003 ...

Ermengol Bota
Nov 26, 2012 at 1:01 pm
Nov 26, 2012 at 7:34 pm

1	Missing changelogs

Hello, Your site http://jdbc.postgresql.org appears to be missing the changelog for 9.2 releases. We have been deploying build 1000 and 1001 already. Now I see that there is 1002. Should we be ...

Toni Helenius
Nov 15, 2012 at 6:48 am
Nov 15, 2012 at 1:57 pm

1	Tags for 9.2 releases

None of the 9.2 releases seem to be tagged in git. https://github.com/pgjdbc/pgjdbc/tags Kris Jurka

Kris Jurka
Nov 14, 2012 at 9:12 pm
Nov 14, 2012 at 9:34 pm

10	postgresql-9.2-1002.jdbc4.jar does not work with Java6

Hi, when trying to use postgresql-9.2-1002.jdbc4.jar with Java6 I get the following exception: java.lang.UnsupportedClassVersionError: org/postgresql/Driver : Unsupported major.minor version 51.0 It ...

Thomas Kellerer
Nov 14, 2012 at 8:20 pm
Nov 15, 2012 at 5:09 pm

2	.jar file gives error

Greetings! This is probably a simple question because I have never before tried to run a .jar file. I just downloaded the latest PostgreSQL JDBC installation file. When I tried to run it using the ...

Rob Richardson
Nov 14, 2012 at 2:14 pm
Nov 14, 2012 at 2:27 pm

4	The column name <col> was not found in this ResultSet

Hello, In a query like this: select * form T1 a, T2 b where a.id='xx' and a.id=b.id calling the result set: rs.getString("o.id") I get: org.postgresql.util.PSQLException: The column name o.id was not ...

Zsolt Kúti
Nov 14, 2012 at 10:42 am
Nov 22, 2012 at 9:25 am

10	Packaging of 9.2-1001 source tarball

I find that postgresql-jdbc-9.2-1001.src.tar.gz doesn't contain a version-numbered top-level directory --- unpacking it just litters your current directory with a bunch of files. I hope this is a ...

Tom Lane
Nov 13, 2012 at 11:33 pm
Nov 14, 2012 at 9:26 pm

6	Website Todo List

Is the website todo list up to date? http://jdbc.postgresql.org/todo.html danap.

Dmp
Nov 12, 2012 at 7:17 pm
Jan 11, 2013 at 7:23 pm

2	does the JDBC driver offer a similar property to the ODBC Text As LongVarchar?

In the Postgres ODBC driver you can confirm Data Type Options:Text as LongVarChar = True and set Max properties for Varchar and LongVarChar. I did not see if the JDBC driver is providing similar ...

The6campbells
Nov 12, 2012 at 6:00 pm
Nov 12, 2012 at 6:30 pm

3	Error while returning auto-generated values

Hello, I'm trying to execute an insert statement against the following table, in which subscriber_id is auto incremented. subscriber_id | user_id | tenant_id | email_address | date_subscribed ...

Amila De Silva
Nov 8, 2012 at 8:00 am
Nov 13, 2012 at 6:22 pm

19	Possible bug / regression from generated keys

Summary: I'm getting an exception from the ResultSet returned from getGeneratedKey() from a batch insert PreparedStatement. When I use any of the postgresql-9.2-100X.jdbc4.jar drivers I get ...

Peter Cooner
Nov 7, 2012 at 3:19 pm
Nov 9, 2012 at 5:06 pm

0	[PATCH] Correct spelling - occured -> occurred

--- org/postgresql/Driver.java.in | 4 ++-- org/postgresql/core/ResultHandler.java | 2 +- org/postgresql/core/v2/ConnectionFactoryImpl.java | 4 ++-- org/postgresql/core/v2/QueryExecutorImpl.java | 8 ...

Craig Ringer
Nov 5, 2012 at 3:32 am
Nov 5, 2012 at 3:32 am

4	Buildfarm test failure

The buildfarm failed last night whilst performing the JDK 5 builds: testjar: [mkdir] Created dir: /home/ubuntu/buildarea/HEAD/pgjdbc/build/tests [javac] ...

Mike Fowler
Nov 1, 2012 at 8:52 pm
Nov 3, 2012 at 7:36 am

1	Misspelling in error message

Hi, Wanted to report a misspelling of a word on the error message which I got. Driver version: postgresql-9.1-901.jdbc4.jar Server: 9.1.6 Error: org.postgresql.util.PSQLException: An I/O error ...

Paul Chackola
Nov 1, 2012 at 5:12 pm
Nov 5, 2012 at 3:34 am

2	git gururs

I am trying to figure out a rational workflow with the branches here. I have cloned the project to my own repo so if I want add a patch my current workflow is 1) pull from the real jdbc remote repo ...

Dave Cramer
Nov 1, 2012 at 5:07 pm
Nov 3, 2012 at 7:34 am

0	Re: Please public the latest drivers to Maven Central

There's work currently in progress to automate the testing and deployment of drivers to Central. -- Craig Ringer

Craig Ringer
Nov 1, 2012 at 8:59 am
Nov 1, 2012 at 8:59 am

3

TableName

AbstractJdbc2ResultSetMetaData.java Whay this is default public String getTableName(int column) throws SQLException { return ""; } and not this public String getTableName(int column) throws ...

Goran Popov
Oct 29, 2012 at 3:30 pm
Oct 30, 2012 at 3:19 pm

0	Small bug: In 9.2-1000, PreparedStatement.toString shows byte[].toString for int types

Low priority (for me at least), but the PreparedStatement.toString for the most recent version of the driver looks funny when it prints a prepared statement that has an Int parameter. Looks like the ...

Larry Reeder
Oct 28, 2012 at 6:52 pm
Oct 28, 2012 at 6:52 pm

3	JDBC4 Postgresql Driver

Hello PostgreSQL Global Development Group: I'm in process of determining an export control tag (ECCN) for JDBC4. I'd appreciate if you could answer the below questions. How is JDBC4 different from ...

Boyer, Laura (GE Aviation, US)
Oct 26, 2012 at 8:03 pm
Oct 29, 2012 at 10:26 pm

8	commit problem

my Java developers are telling me, the recent JDBC drivers are throwing an exception if they inadvertantly issue a commit() on an autocommit connection. this is causing a bunch of problems for us, we ...

John R Pierce
Oct 25, 2012 at 8:13 pm
Oct 25, 2012 at 10:16 pm

5	Publish artifacts to Maven central

Hi, I would like to help get the jdbc driver jars uploaded to Maven central automatically. I have found a set of Maven Ant tasks that will do the job ( http://maven.apache.org/ant-tasks/index.html) ...

Stephen Nelson
Oct 25, 2012 at 10:29 am
Nov 1, 2012 at 7:24 pm

3	test will not be finished when i using 200 client threads

Hello all, I am trying to test postgresql using YCSB, and when i set client thread as 200, i found it will not be finished. and log likes -bash-3.2$ vi postgresql-Sun.log LOG: database system was ...

Colin
Oct 22, 2012 at 1:23 am
Oct 25, 2012 at 3:50 pm

2	Struct Support

Hi Dave, I am in process of implementing java.sql.Struct to support composite types as OUT/IN parameters in postgres JDBC Driver. I am almost done with that, but while writing test cases, I came ...

Muhammad Altaf
Oct 21, 2012 at 3:44 am
Oct 21, 2012 at 2:51 pm

23	9.1-903 JDBC 3 Download

Today I downloaded the postgresql-9.1-903.jdbc3.jar from the website, http://jdbc.postgresql.org/download/postgresql-9.1-903.jdbc3.jar. The jar once installed in replace of the older version crashed ...

Dmp
Oct 20, 2012 at 11:39 pm
Nov 2, 2012 at 8:11 pm

0	PGCopyOutputStream Doesn't Hold Connection

Something that might be worth noting (in documentation?) is that the PGCopyOutputStream class doesn't hold a reference to its Connection. We came across this because we were trying to keep our DB ...

Michael Daines
Oct 17, 2012 at 8:57 pm
Oct 17, 2012 at 8:57 pm

1	Parameters are not being setted in a copy statement

Hi all We need to copy from an arbitray query to a csv. We are using Postgresql 9.1 an we would use the copy statement We need to trigger this query from a java application. We are using Hibernate ...

Martin
Oct 17, 2012 at 3:52 pm
Oct 17, 2012 at 6:18 pm

1	New participator in JDBC driver developing

Hello everybody: I am a new developer here to participating in JDBC driver development,and what I want to ask is the positon of the TODO list we have,and what can I do for our JDBC driver. I will ...

Rugal Bernstein
Oct 12, 2012 at 12:53 pm
Oct 12, 2012 at 1:23 pm

2	ResultSetMetaData.isNullable(i) and outer joined columns

Hello, I've just noticed that ResultSetMetaData.isNullable(i) in the PostgreSQL JDBC driver doesn't reflect whether fields of result set column i may be null, but the nullability of the table column ...

Thor Michael Støre
Oct 11, 2012 at 5:25 pm
Oct 12, 2012 at 8:51 am

3	large object max size

What is the maximum size of large object supported by the latest JDBC driver ? Regards, Pramodh

Pramodh reddy
Oct 11, 2012 at 3:52 pm
Oct 16, 2012 at 10:21 am

5	drop in performance using jdbc driver version 9

Hello, We have been using postgreSQL for several years and we have just upgraded the jdbc driver (along with the db server) to version 9. As a result, we are getting poor performance with the new ...

BENHAMOU Mathieu
Oct 9, 2012 at 7:44 am
Oct 14, 2012 at 4:51 pm

0	Minor flaw: 9.2 driver identifies itself as "devel"

The driver "postgresql-9.2-1000.jdbc4.jar" returns PostgreSQL 9.2devel JDBC4 (build 1000) as its version number when using DatabaseMetaData.getDriverVersion(). Previous release versions did not ...

Thomas Kellerer
Oct 8, 2012 at 8:51 am
Oct 8, 2012 at 8:51 am

1	getMetaData().getUserName() implementation

Hello, I have been using Apache Derby as data base backend for an application over the past years and am looking into adding PostgreSQL as an additional backend the application could be run against ...

Thomas Hill
Oct 7, 2012 at 9:40 pm
Oct 7, 2012 at 10:33 pm

24	Severe performance degradation when using the 9.2-1000 JDBC 4 driver

Hi, after the upgrade the latest PortgreSQL 9.2-1000 JDBC 4 driver, we discovered a severe performance degradation when connecting to 8.4, 9.0, 9.1, and 9.2 servers. In a test application the ...

Emergency Shower
Oct 5, 2012 at 7:27 pm
Oct 23, 2012 at 3:00 pm

29	bug report: slow getColumnTypeName

ResultSetMetaData __md = __rs.getMetaData(); //this is fine String __sf1name = __md.getColumnName(1); //this is fine int __if1type = __md.getColumnType(1); //this is fine String __sf1type = ...

Eyal Wilde
Oct 4, 2012 at 11:08 pm
Oct 17, 2012 at 11:36 am

1	"Select * " on 12-18M row table from remote machine thru JDBC - Performance nose-dives after 10M-ish records

On machine 1 - a table that contains between 12 and 18 million rows On machine 2 - a Java app that calls Select * on the table, and writes it into a Lucene index Originally had a fetchSize of 10,000 ...

Antthelimey
Sep 28, 2012 at 2:05 pm
Sep 28, 2012 at 2:26 pm

1	isValid availability

Hello, The method isValid is implemented and committed since 2012-01-19 by Dave Cramer, however, it isn't available on the driver version 901 and 902. Any reason why? On the same subject, the ...

Luis Flores
Sep 27, 2012 at 11:33 am
Sep 27, 2012 at 11:49 am

group	pgsql-jdbc @
categories	postgresql
discussions	5,549
posts	23,659
users	3,461
website	postgresql.org
irc	#postgresql

summaries	on	Hotkey: s
users list	on	Hotkey: d
user style	avatars	Hotkey: a

PostgreSQL > pgsql-jdbc

Search Discussions

5,549 discussions - 23,659 posts

Top users

Content

People

Support

Translate