Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 7466 invoked from network); 2 Nov 2009 20:56:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Nov 2009 20:56:54 -0000 Received: (qmail 95496 invoked by uid 500); 2 Nov 2009 20:56:54 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 95445 invoked by uid 500); 2 Nov 2009 20:56:53 -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 95434 invoked by uid 99); 2 Nov 2009 20:56:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Nov 2009 20:56:53 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mrduguo@gmail.com designates 209.85.218.214 as permitted sender) Received: from [209.85.218.214] (HELO mail-bw0-f214.google.com) (209.85.218.214) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 Nov 2009 20:56:45 +0000 Received: by bwz6 with SMTP id 6so6902009bwz.11 for ; Mon, 02 Nov 2009 12:56:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=PND4VeK+Nc3jcPadM0OaIaIT9RYks28dDBn0XxEgWTQ=; b=hLSbIyNbam5LPa4Pw34s8Vl9hLCKlH82WoLIZE0JqPZN/FKgfhZ9xYATREnal+F5Yt RXGt+JojFMODiCrjwyKC5Y8EVQMQI2i9o8vMS5BSiVlsWekCuDHaoZLH9vFDA2PdCwLH jk9E4nqyo2+74S/dbZQ4z+nV4gauq9nETa6oM= 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; b=mmYmFqJ6+Ab4oGJbIFwyxgSbSVFK1dnq087GXTZXB++hhpP1Dh1fBVb2BbkTC2BE3I GFh4I9zQVr4vXlYDkLxDk9VZnz4ifA9qaQUekfmaptGuc8FTIISdlFxoFNKUNeecYy0s NKidbsHgDB+BhVtLXDxzsr3++ALFqyIkaQWrY= MIME-Version: 1.0 Received: by 10.204.154.155 with SMTP id o27mr4213271bkw.198.1257195384982; Mon, 02 Nov 2009 12:56:24 -0800 (PST) In-Reply-To: <26157796.post@talk.nabble.com> References: <26157796.post@talk.nabble.com> Date: Mon, 2 Nov 2009 20:56:24 +0000 Message-ID: Subject: Re: Finding NodeName using SQL Query Analyzer From: Guo Du To: users@jackrabbit.apache.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Checked: Checked by ClamAV on apache.org On Mon, Nov 2, 2009 at 7:57 PM, pkrishna wrote: > Is there a way for me to query the database for Node A using a where > criteria? Which table should I query against? Is this possible at all. You may have a look the ddl files in package org.apache.jackrabbit.core.persistence.db. Different db have different id implementation. If you have the id, in theory you could query the node. But it doesn't make too much sense as the data encoded as binary. -Guo