From commits-return-6131-apmail-jackrabbit-commits-archive=jackrabbit.apache.org@jackrabbit.apache.org Wed Jul 16 23:29:40 2008 Return-Path: Delivered-To: apmail-jackrabbit-commits-archive@www.apache.org Received: (qmail 87660 invoked from network); 16 Jul 2008 23:29:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Jul 2008 23:29:39 -0000 Received: (qmail 34719 invoked by uid 500); 16 Jul 2008 23:29:39 -0000 Delivered-To: apmail-jackrabbit-commits-archive@jackrabbit.apache.org Received: (qmail 34687 invoked by uid 500); 16 Jul 2008 23:29:39 -0000 Mailing-List: contact commits-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@jackrabbit.apache.org Delivered-To: mailing list commits@jackrabbit.apache.org Received: (qmail 34678 invoked by uid 99); 16 Jul 2008 23:29:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jul 2008 16:29:38 -0700 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.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jul 2008 23:28:45 +0000 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id A29CA11158 for ; Wed, 16 Jul 2008 23:28:39 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: commits@jackrabbit.apache.org Date: Wed, 16 Jul 2008 23:28:39 -0000 Message-ID: <20080716232839.18366.56089@eos.apache.org> Subject: [Jackrabbit Wiki] Update of "QueryUsingJdbc" by ThomasMueller X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Jackrabbit Wiki" for change notification. The following page has been changed by ThomasMueller: http://wiki.apache.org/jackrabbit/QueryUsingJdbc ------------------------------------------------------------------------------ = Query a JCR Repository Using JDBC = Jackrabbit does not implement the JDBC API, however it is possible to run SQL queries against a JCR repository using a JDBC to JCR bridge. There is currently no generic bridge available, but it is relatively simple to build a custom bridge. Here is a sample application that does just that. This method can be used to generate reports with tools do not support the JCR API yet, but support he JDBC API, such as Crystal Reports. + + The example application uses the [http://h2database.com H2 Database Engine] which is a open source Java SQL database. {{{ import org.apache.jackrabbit.core.TransientRepository; @@ -132, +134 @@ } }}} + === Using the ODBC API === + H2 supports using the PostgreSQL ODBC driver by acting like a PostgreSQL server. + === Write Access === This example shows read access, but it is also possible to implement write access to a JCR repository, for example using database triggers.