Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 324D79FB66B for ; Tue, 20 Feb 2007 06:48:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 62105-01 for ; Tue, 20 Feb 2007 06:48:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s41.bay0.hotmail.com (bay0-omc1-s41.bay0.hotmail.com [65.54.246.113]) by postgresql.org (Postfix) with ESMTP id 5B31E9FB554 for ; Tue, 20 Feb 2007 06:48:49 -0400 (AST) Received: from hotmail.com ([64.4.11.17]) by bay0-omc1-s41.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Tue, 20 Feb 2007 02:48:47 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 20 Feb 2007 02:48:48 -0800 Message-ID: Received: from 80.24.52.85 by by7fd.bay7.hotmail.msn.com with HTTP; Tue, 20 Feb 2007 10:48:43 GMT X-Originating-IP: [80.24.52.85] X-Originating-Email: [im-james@hotmail.com] X-Sender: im-james@hotmail.com From: "James Im" To: pgsql-jdbc@postgresql.org Subject: invalid byte sequence for encoding "UTF8": 0x00 Date: Tue, 20 Feb 2007 10:48:43 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 20 Feb 2007 10:48:48.0073 (UTC) FILETIME=[B3480B90:01C754DC] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.815 tagged_above=0 required=5 tests=AWL, BAYES_40, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: * X-Archive-Number: 200702/103 X-Sequence-Number: 16659 Hi, I've got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Exception: org.postgresql.util.PSQLException org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308) By the way, the insert is done with a PreparedStatement and I use only setLong(), setString(), setTimestamp() and setInt(). I don't understand it very well. It is obviously an encoding exception but I don't know why it happens and what I could do avoid it. Any idea? _________________________________________________________________ Opret en personlig blog og del dine billeder på MSN Spaces: http://spaces.msn.com/