Return-Path: 
 <dev-return-24624-apmail-jackrabbit-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org
Received: (qmail 40588 invoked from network); 24 Jul 2009 05:07:41 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 24 Jul 2009 05:07:41 -0000
Received: (qmail 6036 invoked by uid 500); 24 Jul 2009 05:08:46 -0000
Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org
Received: (qmail 5940 invoked by uid 500); 24 Jul 2009 05:08:45 -0000
Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:dev@jackrabbit.apache.org>
List-Id: <dev.jackrabbit.apache.org>
Reply-To: dev@jackrabbit.apache.org
Delivered-To: mailing list dev@jackrabbit.apache.org
Received: (qmail 5932 invoked by uid 99); 24 Jul 2009 05:08:45 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jul 2009 05:08:45 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jul 2009 05:08:34 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id C14C1234C004
	for <dev@jackrabbit.apache.org>; Thu, 23 Jul 2009 22:08:14 -0700 (PDT)
Message-ID: <263181298.1248412094777.JavaMail.jira@brutus>
Date: Thu, 23 Jul 2009 22:08:14 -0700 (PDT)
From: "Rajiv Kasera (JIRA)" <jira@apache.org>
To: dev@jackrabbit.apache.org
Subject: [jira] Created: (JCR-2226) Exceptions using DB based repository
 with WAS 6.1
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org

Exceptions using DB based repository with WAS 6.1 
--------------------------------------------------

                 Key: JCR-2226
                 URL: https://issues.apache.org/jira/browse/JCR-2226
             Project: Jackrabbit Content Repository
          Issue Type: Bug
          Components: clustering
    Affects Versions: 1.5.4
            Reporter: Rajiv Kasera
            Priority: Blocker


We are using Jackrabbit 1.5.4 in a cluster deployment with DB based repository. Here is how the repository.xml looks like:
   <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
	<param name="driver" value="javax.naming.InitialContext"/>
	<param name="url" value="jdbc/dbjournal"/>	
	<param name="databaseType" value="oracle"/>
	<param name="minRecordLength" value="1024"/>
	<param name="copyWhenReading" value="true"/>
	<param name="tablePrefix" value="JR_"/>
	<param name="maxConnections" value="10"/>
    </DataStore>
Same datasource is being used for journal and persistence manager as well.

With this deployment we keep getting the following exceptions in the WAS logs:

org.apache.jackrabbit.core.cluster.ClusterNode:590)  - Unable to create log entry.
org.apache.jackrabbit.core.journal.JournalException: Unable to lock global revision table.
(org.apache.jackrabbit.core.persistence.bundle.util.ConnectionRecoveryManager:453)  - could not execute statement, reason: DSRA9110E: Statement is closed., state/code: null/0

[7/21/09 20:08:18:247 CDT] 0000003c SystemOut     O 2009-07-21 20:08:18,246 ERROR (org.apache.jackrabbit.core.persistence.db.OraclePersistenceManager:239)  - failed to write property state: 4d80415d-d65b-4e01-93da-b16d15883058/{http://www.jcp.org/jcr/1.0}data

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.

This is a big blocker for our project since in some cases the document fails to upload in the db. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.