Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 30910 invoked from network); 25 Apr 2007 18:26:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 25 Apr 2007 18:26:17 -0000 Received: (qmail 16017 invoked by uid 500); 25 Apr 2007 18:26:23 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 16001 invoked by uid 500); 25 Apr 2007 18:26:22 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 15992 invoked by uid 99); 25 Apr 2007 18:26:22 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2007 11:26:22 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=HTML_00_10,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of miguel.js@gmail.com designates 64.233.184.233 as permitted sender) Received: from [64.233.184.233] (HELO wr-out-0506.google.com) (64.233.184.233) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2007 11:26:15 -0700 Received: by wr-out-0506.google.com with SMTP id 76so337698wra for ; Wed, 25 Apr 2007 11:25:54 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=LNj0gLIpW2OkhlnQHMS1YVv9zG8d6ugLG5RRywt2jZfLzOhXNNsPqRY6vfakfzj78XJt7+0R7OJQI4TSslJDZs18IqGqNgooWb0AvvMx8OsLI+UspwfcXjCkqKmgfmnpFG9WDdOGUDYTeglt9XvGIlw3GAIVCQZXO+xchLd2eds= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=VP81luoiJ5DJNtnXnlZ+w868b5FkOLPVbvbFm2hSCw5OW01nN1Fr9MGJzAKtbZ55hEWjRz1qKx5g1SBn9YDwyqQEzILIoDeLrOYyBH0aawMEcGSYn953UdHVPrsfQPfIncc2rXPstf5tuBTsTjoertpGlWuMbS6sT7PtTCAr2dE= Received: by 10.78.187.17 with SMTP id k17mr276438huf.1177525553722; Wed, 25 Apr 2007 11:25:53 -0700 (PDT) Received: by 10.78.50.17 with HTTP; Wed, 25 Apr 2007 11:25:53 -0700 (PDT) Message-ID: <2192b1170704251125k311e1bb1vf647482ab6134187@mail.gmail.com> Date: Wed, 25 Apr 2007 20:25:53 +0200 From: "=?ISO-8859-1?Q?Miguel_=C1ngel_Jim=E9nez?=" To: users@jackrabbit.apache.org Subject: Bundle support for PostgreSQL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_173884_7699827.1177525553581" X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_173884_7699827.1177525553581 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I've managed to create the DDL file needed to support bundle persistence manager with PostgreSQL, but found some issues. I've mapped the id column of table ${schemaObjectPrefix}NAMES to a serial datatype (equivalent to an auto-increment column in MySQL). However, starting the repository yields a exception in class org.apache.jackrabbit.core.persistence.bundle.util.DbNameIndex, line 76: . nameInsert = con.prepareStatement("insert into " + schemaObjectPrefix + "NAMES (NAME) values (?)", Statement.RETURN_GENERATED_KEYS); . It seems that PostgreSQL JDBC driver does not support RETURN_GENERATED_KEYS feature. Is there a plan to add bundling support to PostgreSQL? Before PostgreSQL 8.2the only way I remember to get the auto-generated key is by means of a further select to get the last assigned value of the sequence but it does not mean there are other alternatives. -- Miguel. ------=_Part_173884_7699827.1177525553581--