Hi Jan, Thanks for the bug report. I'm planning on making an update to this package to add JDBC4 support, so I'll update to version 8.4-702 at the same time.
Andy On 09/02/11 18:13, Jan Niehusmann wrote: > Package: libpg-java > Version: 8.4-701-1 > Severity: normal > > When calling AbstractJdbc2Statement.setNull on a timestamp value, the > driver assumes the field has a type of timestamp with timezone. > This usually works, but in some cases it has ill effects. One is described > at http://archives.postgresql.org/pgsql-jdbc/2010-02/msg00012.php > > I just found another case: When calling a stored procedure with a > "timestamp witout timezone" parameter, and setting that parameter to > null, I get an error message: > > 2011-02-09 18:28:51 CET ERROR: function my_function(numeric, numeric, > timestamp with time zone) does not exist at character 15 > 2011-02-09 18:28:51 CET HINT: No function matches the given name and > argument types. You might need to add explicit type casts. > > This behaviour is fixed with upstream version 8.4-702 (which I verified > by applying the following patch from CVS manually). > > So please consider upgrading to a more recent version. > > > =================================================================== > RCS file: > /cvsroot/jdbc/pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java,v > retrieving revision 1.114.2.1 > retrieving revision 1.114.2.2 > diff -u -p -r1.114.2.1 -r1.114.2.2 > --- jdbc/pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java > 2009/09/26 15:21:27 1.114.2.1 > +++ jdbc/pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java > 2010/05/01 16:08:00 1.114.2.2 > @@ -3,7 +3,7 @@ > * Copyright (c) 2004-2008, PostgreSQL Global Development Group > * > * IDENTIFICATION > -* $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java,v > 1.114 2009/05/27 23:55:19 jurka Exp $ > +* $PostgreSQL: pgjdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java,v > 1.114.2.1 2009/09/26 15:21:27 jurka Exp $ > * > *------------------------------------------------------------------------- > */ > @@ -1109,10 +1109,8 @@ public abstract class AbstractJdbc2State > oid = Oid.DATE; > break; > case Types.TIME: > - oid = Oid.TIME; > - break; > case Types.TIMESTAMP: > - oid = Oid.TIMESTAMPTZ; > + oid = Oid.UNSPECIFIED; > break; > case Types.BIT: > oid = Oid.BOOL; > > > > -- System Information: > Debian Release: 6.0 > APT prefers stable > APT policy: (990, 'stable'), (500, 'oldstable'), (500, 'unstable'), (1, > 'experimental') > Architecture: amd64 (x86_64) > > Kernel: Linux 2.6.37-smapi-x61s-amd64-03744-gcedf01f (SMP w/2 CPU cores) > Locale: LANG=C, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) > Shell: /bin/sh linked to /bin/dash > > Versions of packages libpg-java depends on: > ii default-jre-headless [java2 1:1.6-40 Standard Java or Java compatible > R > ii gcj-4.4-jre-headless [java2 4.4.5-2 Java runtime environment using > GIJ > ii gcj-jre-headless [java2-run 4:4.4.5-1 Java runtime environment using > GIJ > ii gij-4.3 [java2-runtime-head 4.3.2-2 The GNU Java bytecode interpreter > ii openjdk-6-jre-headless [jav 6b18-1.8.3-2 OpenJDK Java runtime, using > Hotspo > ii sun-java6-jre [java2-runtim 6.22-1 Sun Java(TM) Runtime Environment > ( > > libpg-java recommends no packages. > > Versions of packages libpg-java suggests: > ii postgresql 8.4.5-0squeeze2 object-relational SQL database > (su > > -- no debconf information > > > > __ > This is the maintainer address of Debian's Java team > <http://lists.alioth.debian.org/mailman/listinfo/pkg-java-maintainers>. > Please use > debian-j...@lists.debian.org for discussions and questions. > -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org