Search Discussions
-
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
Haifeng Liu
Dec 14, 2012 at 3:29 am
Dec 14, 2012 at 5:38 pm -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
--- 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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 Overview
group | pgsql-jdbc |
categories | postgresql |
discussions | 5,549 |
posts | 23,659 |
users | 3,461 |
website | postgresql.org |
irc | #postgresql |
Top users
Archives
- January 2013 (20)
- December 2012 (54)
- November 2012 (91)
- October 2012 (142)
- September 2012 (88)
- August 2012 (80)
- July 2012 (55)
- June 2012 (104)
- May 2012 (97)
- April 2012 (101)
- March 2012 (61)
- February 2012 (87)
- January 2012 (113)
- December 2011 (87)
- November 2011 (118)
- October 2011 (82)
- September 2011 (135)
- August 2011 (86)
- July 2011 (28)
- June 2011 (82)
- May 2011 (91)
- April 2011 (104)
- March 2011 (170)
- February 2011 (157)
- January 2011 (65)
- December 2010 (94)
- November 2010 (117)
- October 2010 (153)
- September 2010 (98)
- August 2010 (67)
- July 2010 (138)
- June 2010 (95)
- May 2010 (86)
- April 2010 (73)
- March 2010 (71)
- February 2010 (53)
- January 2010 (91)
- December 2009 (115)
- November 2009 (34)
- October 2009 (45)
- September 2009 (55)
- August 2009 (98)
- July 2009 (82)
- June 2009 (103)
- May 2009 (114)
- April 2009 (103)
- March 2009 (117)
- February 2009 (55)
- January 2009 (74)
- December 2008 (50)
- November 2008 (79)
- October 2008 (46)
- September 2008 (107)
- August 2008 (63)
- July 2008 (71)
- June 2008 (58)
- May 2008 (77)
- April 2008 (141)
- March 2008 (88)
- February 2008 (214)
- January 2008 (170)
- December 2007 (181)
- November 2007 (100)
- October 2007 (183)
- September 2007 (151)
- August 2007 (108)
- July 2007 (139)
- June 2007 (112)
- May 2007 (73)
- April 2007 (140)
- March 2007 (135)
- February 2007 (158)
- January 2007 (191)
- December 2006 (134)
- November 2006 (189)
- October 2006 (158)
- September 2006 (166)
- August 2006 (192)
- July 2006 (100)
- June 2006 (147)
- May 2006 (151)
- April 2006 (194)
- March 2006 (155)
- February 2006 (183)
- January 2006 (145)
- December 2005 (120)
- November 2005 (236)
- October 2005 (164)
- September 2005 (145)
- August 2005 (216)
- July 2005 (424)
- June 2005 (183)
- May 2005 (131)
- April 2005 (224)
- March 2005 (215)
- February 2005 (213)
- January 2005 (300)
- December 2004 (214)
- November 2004 (244)
- October 2004 (317)
- September 2004 (216)
- August 2004 (167)
- July 2004 (337)
- June 2004 (183)
- May 2004 (195)
- April 2004 (273)
- March 2004 (186)
- February 2004 (259)
- January 2004 (329)
- December 2003 (225)
- November 2003 (178)
- October 2003 (124)
- September 2003 (290)
- August 2003 (304)
- July 2003 (452)
- June 2003 (162)
- May 2003 (139)
- April 2003 (246)
- March 2003 (293)
- February 2003 (372)
- January 2003 (321)
- December 2002 (237)
- November 2002 (317)
- October 2002 (328)
- September 2002 (262)
- August 2002 (263)
- July 2002 (223)
- June 2002 (264)
- May 2002 (141)
- April 2002 (232)
- March 2002 (347)
- February 2002 (282)
- January 2002 (273)
- December 2001 (194)
- November 2001 (318)
- October 2001 (382)
- September 2001 (323)
- August 2001 (391)
- July 2001 (186)
- June 2001 (179)
- May 2001 (261)
- April 2001 (93)
- March 2001 (173)
- February 2001 (105)
- January 2001 (110)