Return-Path: 
 <users-return-17102-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 332 invoked from network); 18 Feb 2011 09:22:32 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 18 Feb 2011 09:22:32 -0000
Received: (qmail 12603 invoked by uid 500); 18 Feb 2011 09:22:31 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 12245 invoked by uid 500); 18 Feb 2011 09:22:27 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 12228 invoked by uid 99); 18 Feb 2011 09:22:26 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Feb 2011 09:22:26 +0000
X-ASF-Spam-Status: No, hits=-0.7 required=5.0
	tests=FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of stefan.guggisberg@gmail.com
 designates 209.85.213.170 as permitted sender)
Received: from [209.85.213.170] (HELO mail-yx0-f170.google.com)
 (209.85.213.170)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Feb 2011 09:22:20 +0000
Received: by yxt33 with SMTP id 33so1400252yxt.1
        for <users@jackrabbit.apache.org>;
 Fri, 18 Feb 2011 01:22:00 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:in-reply-to:references:date
         :message-id:subject:from:to:content-type:content-transfer-encoding;
        bh=23z1pV+rNP1p1gPJhQ+VHuetHUTd8CZaUnmTFuAifm0=;
        b=mAhYl31Hi7JLqm4EQQLcty/C8oYA5kfG71XjzLdevkHkPXfKw1aUDC8yTuds1M5kyK
         wDMJ1gahkXUrGnNtkFaxc+klDHe78EIDYSGjfDv8BcXt43Kh5uB9/qNp1VzoCOLkenmm
         MExs7T5UfWFsGGMmjN/0XhnK89Rh8VkL64euw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=dgWZGRapIz83ymfkTzXQMjmYDrPveC2PDznqcr+Af5hoqpzUWk/7ng/TvMvoZhsgov
         iSjuGS7T7Jy3qAjyphpd/pA0RQqVnhh1yKOMt+ds38ev+N3MMVubZnV2zMYeL7lgrAaN
         X4xW67mkzNMLiRnhjQLX8Mld3f5yEnZa007Lk=
MIME-Version: 1.0
Received: by 10.101.207.19 with SMTP id j19mr238099anq.55.1298020918383; Fri,
 18 Feb 2011 01:21:58 -0800 (PST)
Received: by 10.100.144.2 with HTTP; Fri, 18 Feb 2011 01:21:58 -0800 (PST)
In-Reply-To: <AANLkTimZiM+hM4YaNRRNDpWXtkZ0pgVO=NnpWYvAFT4k@mail.gmail.com>
References: <AANLkTimZiM+hM4YaNRRNDpWXtkZ0pgVO=NnpWYvAFT4k@mail.gmail.com>
Date: Fri, 18 Feb 2011 10:21:58 +0100
Message-ID: <AANLkTikFibQ5rBxE9gRJvLFg5i=NQsfNMSD5_tYM5d+z@mail.gmail.com>
Subject: Re: A PersistanceManager for DB2 (i-series)?
From: Stefan Guggisberg <stefan.guggisberg@gmail.com>
To: users@jackrabbit.apache.org
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

On Fri, Feb 18, 2011 at 4:13 AM, J S <quartz700@gmail.com> wrote:
> Hi
>
> I am using a database PM and connecting to an external DB2 (i-series)
> database. Access rights for the Jackrabbit database user are enough to al=
low
> the creation of tables at server start up. Data is also persisted
> successfully. However, at server restart, Jackrabbit tries to recreate th=
e
> tables again and it fails because the tables are already there. The end
> result is Jackrabbit fails to initialize the file system, and the
> application is unusable (the data can=92t be accessed). The workaround is=
 to
> add <param name=3D"schemaCheckEnabled" value=3D"false"/> to stop the sche=
ma
> check. This is not necessary with MySql though, somehow, Jackrabbit reali=
zes
> that tables are there and just use them without trying to create them aga=
in.
>
> With MySql, I am using MySqlPersistenceManager, but =A0with DB2 I am usin=
g the
> BundleDbPersistenceManager. Do you think there is something particular fo=
r
> DB2 that requires its own PersistentManager implementation?

no, i don't think so. it's most likely a permission issue (the db user lack=
s the
permission to read the meta data). see [0] and [1] for related information.
you might also want to have a look at the following method:

o.a.jackrabbit.core.util.db.ConnectionHelper#tableExists

cheers
stefan

[0] http://jackrabbit.markmail.org/message/jtq2sqis2aceh7ro
[1] https://issues.apache.org/jira/browse/JCR-2034

>
>
> Cheers,
>
> JS
>