Your message dated Thu, 10 Mar 2011 12:49:19 +0000
with message-id <e1pxfit-0007v0...@franck.debian.org>
and subject line Bug#612643: fixed in libpgjava 8.4-702-1
has caused the Debian Bug report #612643,
regarding libpg-java: setNull on timestamp fields assumes timestamp with
timezone
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
612643: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=612643
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
Source: libpgjava
Source-Version: 8.4-702-1
We believe that the bug you reported is fixed in the latest version of
libpgjava, which is due to be installed in the Debian FTP archive:
libpg-java-doc_8.4-702-1_all.deb
to main/libp/libpgjava/libpg-java-doc_8.4-702-1_all.deb
libpg-java_8.4-702-1_all.deb
to main/libp/libpgjava/libpg-java_8.4-702-1_all.deb
libpgjava_8.4-702-1.debian.tar.gz
to main/libp/libpgjava/libpgjava_8.4-702-1.debian.tar.gz
libpgjava_8.4-702-1.dsc
to main/libp/libpgjava/libpgjava_8.4-702-1.dsc
libpgjava_8.4-702.orig.tar.gz
to main/libp/libpgjava/libpgjava_8.4-702.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to 612...@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Andrew Ross <ubu...@rossfamily.co.uk> (supplier of updated libpgjava package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmas...@debian.org)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Sat, 12 Feb 2011 16:41:22 +0000
Source: libpgjava
Binary: libpg-java libpg-java-doc
Architecture: source all
Version: 8.4-702-1
Distribution: unstable
Urgency: low
Maintainer: Debian Java Maintainers
<pkg-java-maintainers@lists.alioth.debian.org>
Changed-By: Andrew Ross <ubu...@rossfamily.co.uk>
Description:
libpg-java - Java database (JDBC) driver for PostgreSQL
libpg-java-doc - Java database (JDBC) driver for PostgreSQL (documentation)
Closes: 612643
Changes:
libpgjava (8.4-702-1) unstable; urgency=low
.
* New upstream release (closes: #612643)
* Build JDBC4 libraries in addition to JDBC3.
* Use debhelper and javahelper rather than cdbs
* Updated Standards-Version to 3.9.1.
* Don't depend on a jre (to match current java package policy)
* Added myself to Uploaders.
* Changed source format to 3.0 (quilt).
* Added a package containing the public API documentation.
Checksums-Sha1:
16a7108bcb8ba8cef4d8ce721f3b827cd26840b1 2125 libpgjava_8.4-702-1.dsc
ba064659c68c391de93f8193e93ceb9bf9904d09 609501 libpgjava_8.4-702.orig.tar.gz
30f0a97d8579de9a0182ab3b23ef20fba117641c 6981 libpgjava_8.4-702-1.debian.tar.gz
36397e6ab55bff46f805e0aea98c83ae18b630a3 1005922 libpg-java_8.4-702-1_all.deb
b65bd00515f155b50f90ba0a8906a18e1a17dc86 91018 libpg-java-doc_8.4-702-1_all.deb
Checksums-Sha256:
e49b86fa2890a01877e8d5948db7f8a4ea00c37c6beb9037db14ca3e2cb2a124 2125
libpgjava_8.4-702-1.dsc
c4c40b262df6505f374a05811439ef0722fd2b5a59d4af21ffd8959bf2ed40b8 609501
libpgjava_8.4-702.orig.tar.gz
8d8fd1a06bf11e37961f4aeeb0466f3dfea44e1c53ed35ad5b81a11621c76bcf 6981
libpgjava_8.4-702-1.debian.tar.gz
db5fa60994b767405d55b204a164ebd6c97367543e7e87be4e9db69fc0d6a596 1005922
libpg-java_8.4-702-1_all.deb
7a1ef247e2bfc31dc01947dfa951d7e61f3a7ee3d74a37d2040cda16b5f9a1c9 91018
libpg-java-doc_8.4-702-1_all.deb
Files:
e2ce84f31ab87c297e998ca6985f12df 2125 java optional libpgjava_8.4-702-1.dsc
badb1344322a6993405b5289738a6701 609501 java optional
libpgjava_8.4-702.orig.tar.gz
cbed740e89e45e2f2356aca5687c3e40 6981 java optional
libpgjava_8.4-702-1.debian.tar.gz
9191275fe934e0c6806d3804b5455fbe 1005922 java optional
libpg-java_8.4-702-1_all.deb
357b0cb86247bf7aac79af1f79394de6 91018 doc optional
libpg-java-doc_8.4-702-1_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
iQIcBAEBAgAGBQJNdF2qAAoJECHSBYmXSz6WGVAP/1VK1sjRBk9YURwr3GKVMuqy
YeEQ15SXviqwv+VrvC25jfO9X3eapVjuf00h/DJP3rAMnr0RU3xKIj1XlnXrsglG
gYZVveid+UArYtVQDW7qK+HcqgX1lgvrtfuzSm7RcRasmxFDa+/mWXlpPZUsGc20
7YOdLnOpD97r79RcPmZn7ST3DSXTTXr5XlG+tiu+PdDC9Ca0zO4jaMmCw2QPbrPX
k6rrNdbZXTes4R1vbtw2bA6lHtyR9dE6gjeUJPgxcz0X67WCho/2HX2690X4j+rP
ideh1jAPivuV/tP40VHUuLyUIVHlLMmv2GlN1gFbWh6hV+VATf6orEbh0Bb0OaQv
HaSu8LW+fIERDAmu7Jb+yp6sCNuOXKf/R0HO4+pcxpuTuZEl5KjgGTxXZ5al+pMu
BhRbmp6g9/9ZDkqA4qA2TsJFFucAFzegOVtr4ITEGlyGq+Iq1IQrR5WyC3j/e+62
IvPrBza3YSaP5AD+ZFgCKHBbhHt4H9vnKfLjFJO6uTq+iHmdICZpFMzE5kLXFo+1
4GMOVviO6pkAcqQhRcttGc7brFEocnJP0tnclpemzC65Hc+TzSllGJwjZqooeHLZ
qz9VwXZ0yCBHdbtk/ZBsIH7TuUgb9LvYdSFbUGUvqPoRHDGQHlXeBxDK+otBv1f3
vVCTmfzGKn687CMrZQ8a
=MfdT
-----END PGP SIGNATURE-----
--- End Message ---
__
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.
