X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 73A9A9FA69A for ; Mon, 21 Aug 2006 09:25:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 18728-09 for ; Mon, 21 Aug 2006 09:25:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web56608.mail.re3.yahoo.com (web56608.mail.re3.yahoo.com [66.196.97.52]) by postgresql.org (Postfix) with SMTP id BA88A9FA21B for ; Mon, 21 Aug 2006 09:25:18 -0300 (ADT) Received: (qmail 92505 invoked by uid 60001); 21 Aug 2006 12:25:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=kP06W7/N6Vg6e/Kfq9Q+C+kF7uyvFr0g1ZZXetC4Q/g028/p91mVGXQxHsKNLgSbbt3p4KcOCoC0ka2rZnZUWz7Dt1ffIdYoFx8VixGgxv+RLifEFaOdnd6RYH1u6UHaUwGKsJOrsITVFFR7K9FE7q/YsR3r6RRxKH4uAfgmlvs= ; Message-ID: <20060821122516.92503.qmail@web56608.mail.re3.yahoo.com> Received: from [203.143.27.133] by web56608.mail.re3.yahoo.com via HTTP; Mon, 21 Aug 2006 05:25:16 PDT Date: Mon, 21 Aug 2006 05:25:16 -0700 (PDT) From: Thusitha Kodikara Subject: Correct JDBC driver for To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1283355457-1156163116=:90602" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.362 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_10_20, HTML_MESSAGE X-Spam-Level: **** X-Archive-Number: 200608/232 X-Sequence-Number: 22775 --0-1283355457-1156163116=:90602 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, One of our Java developers is having trouble inserting data to postgres 7.4.13 (running on Gentoo linux). The Java version being used is 1.4. The proble is with 'backslash_quote = off' the database is rejecting the data sent from the Java application. Within the application we don't use " \ " to escape. So we suspected that may be " \ " is being inserted by the JDBC driver. The driver we use is pg74.216.jdbc3.jar http://jdbc.postgresql.org/download/pg74.216.jdbc3.jar Could this be an issue with the driver? Thanks and regards, -Thusitha --0-1283355457-1156163116=:90602 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello,

One of our Java developers is having trouble inserting data to postgres 7.4.13 (running on Gentoo linux). The Java version being used is 1.4.

The proble is with 'backslash_quote = off' the database is rejecting the data sent from the Java application. Within the application we don't use " \ " to escape. So we suspected that may be " \ " is being inserted by the JDBC driver.

The driver we use is pg74.216.jdbc3.jar  http://jdbc.postgresql.org/download/pg74.216.jdbc3.jar

Could this be an issue with the driver?

Thanks and regards,
-Thusitha
--0-1283355457-1156163116=:90602--