Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 64052 invoked from network); 6 Mar 2011 08:24:00 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 6 Mar 2011 08:24:00 -0000 Received: (qmail 65977 invoked by uid 500); 6 Mar 2011 08:23:59 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 65906 invoked by uid 500); 6 Mar 2011 08:23:59 -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 65893 invoked by uid 99); 6 Mar 2011 08:23:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Mar 2011 08:23:59 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,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 raliakbari@gmail.com designates 209.85.216.42 as permitted sender) Received: from [209.85.216.42] (HELO mail-qw0-f42.google.com) (209.85.216.42) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Mar 2011 08:23:54 +0000 Received: by qwd6 with SMTP id 6so4632432qwd.1 for ; Sun, 06 Mar 2011 00:23:33 -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:cc:content-type; bh=H7hNNCJsgYQnIDkpcNAN3R9hi7Z7at0yzmKGA/pWIkw=; b=C9yY4U4OeuP7YGb5O7mUPslGJUbtqJZADw8CD+Jk5ziMAOcmf0/tg3ebAlX5y3CUE3 X//6eBgIi9eRDPf0grZ0dp1odJQWJ4GFxsmNfn4FOFWjMMji9BrVnNenehLhChMLGGMd nizPCWORwARHZJ/b2fuelDb1BDV+tPLVH2bS0= 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 :cc:content-type; b=BUlU72E+uKVI9YzroWTlpg//4rDoQOPzW9yN6ptWets4lsG6b8zwaEyxWqeAg3MJ/R f1NPfhwVb5mcSxotuoBwxAKq0HSnamz/uLdzA6Q9F9KHIqjxkRcuCu2nQvLy3yNr6Lpo 3QZvRfAZVIlgKZH+UjOIpOSbBzSqnGjy+tU2U= MIME-Version: 1.0 Received: by 10.229.127.104 with SMTP id f40mr1737402qcs.272.1299399812955; Sun, 06 Mar 2011 00:23:32 -0800 (PST) Received: by 10.229.247.73 with HTTP; Sun, 6 Mar 2011 00:23:32 -0800 (PST) In-Reply-To: References: Date: Sun, 6 Mar 2011 11:53:32 +0330 Message-ID: Subject: Re: Jackrabbit & database From: Reza Aliakbari To: users@jackrabbit.apache.org Cc: Rakesh Vidyadharan Content-Type: multipart/alternative; boundary=000e0cdf9b4045bd75049dcc1892 --000e0cdf9b4045bd75049dcc1892 Content-Type: text/plain; charset=ISO-8859-1 Thanks Rakesh for the detailed answers. Actually I am not sure whether JCR and Jackrabbit with the Bundle model will satisfy all functional needs(complex queries for example) that we would face during development of our product. Also if it is possible, how would be the performance. So I thought the things should not be like a black box that whole things are in the hand of Jackrabbit. In real applications we would need complex queries and I have doubt Jackrabbit with Bundle model can response well to such usecases. So I thought to use Jackrabbit for write and simple reads and for complex queries we would directly use database. Thanks, Reza On Sun, Mar 6, 2011 at 1:47 AM, Rakesh Vidyadharan wrote: > > On 5 Mar 2011, at 15:26, Reza Aliakbari wrote: > > > Hi, > > > > I downloaded the Jackrabbit WAR file and configured it with a database(I > > defined PersistenceManager at repository.xml). I hoped to see my nodes > and > > main information there at my database but I saw there 4 tables BINVAL, > > BUNDLE, NAMES and REFS that couldn't find any meaning full information > > there. > > This is certainly the case if you use the Bundle persistence managers. > These persist the entire node (along with its properties) as one blob into > the data store (note I refer to it as data store and not database). You can > try using the non bundle PM's, which may give you more granular tables (I > have not used them so am not sure). > > > > > I want to know whether it is possible to query the database of Jackrabbit > > without using its API and see what's going on? for example is it possible > to > > see the list of actions that has applied on a node? Where are such infos > > persisted? > > That would be against the principles on which the JCR API was developed. > The goal was to develop a vendor and persistence neutral API that can be > used to access you content. The data store can be a relational database, a > file system, some other network storage, or a combination of these. If your > need is to access a regular RDBMS, I would question your decision to use > JCR/JackRabbit in the first place. > > > > > My goal is to be able to fetch all activities and data without needing to > > access Jackrabbit API. > > > Note that you should try as far as possible to not use the JackRabbit API, > and use only the JCR API. > > Rakesh --000e0cdf9b4045bd75049dcc1892--