Return-Path: 
 <users-return-8824-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org
Received: (qmail 39815 invoked from network); 28 Aug 2008 17:30:49 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Aug 2008 17:30:49 -0000
Received: (qmail 83623 invoked by uid 500); 28 Aug 2008 17:30:46 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 83611 invoked by uid 500); 28 Aug 2008 17:30:46 -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 83598 invoked by uid 99); 28 Aug 2008 17:30:46 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Aug 2008 10:30:46 -0700
X-ASF-Spam-Status: No, hits=3.2 required=10.0
	tests=HTML_MESSAGE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (athena.apache.org: local policy)
Received: from [143.209.238.162] (HELO audl953.usa.alcatel.com)
 (143.209.238.162)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Aug 2008 17:29:49 +0000
Received: from usdalsbhs02.ad3.ad.alcatel.com (usdalsbhs02.usa.alcatel.com
 [172.22.216.13])
	by audl953.usa.alcatel.com (ALCANET) with ESMTP id m7SHTDoN017553
	for <users@jackrabbit.apache.org>; Thu, 28 Aug 2008 12:29:17 -0500
Received: from USDALSMBS02.ad3.ad.alcatel.com ([172.22.216.9]) by
 usdalsbhs02.ad3.ad.alcatel.com with Microsoft SMTPSVC(6.0.3790.2499);
	 Thu, 28 Aug 2008 12:29:13 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C90933.96CB3BE8"
Subject: Using a proxy DB Connector to several MySql DBs
Date: Thu, 28 Aug 2008 12:29:08 -0500
Message-ID: 
 <01E8A990E317A1409EEC9E6858B09B95020489BB@USDALSMBS02.ad3.ad.alcatel.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Using a proxy DB Connector to several MySql DBs
Thread-Index: AckJM5QfzOLgXdM8RYe0zz+v8SnAiQ==
From: "MARTINEZ Antonio" <Antonio.Martinez@alcatel-lucent.com>
To: <users@jackrabbit.apache.org>
X-OriginalArrivalTime: 28 Aug 2008 17:29:13.0476 (UTC)
 FILETIME=[96CCDC40:01C90933]
X-Scanned-By: MIMEDefang 2.64 on 143.209.238.34
X-Virus-Checked: Checked by ClamAV on apache.org

------_=_NextPart_001_01C90933.96CB3BE8
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello,

In my deployment environment I need to use a proxy DB-connector to
MySql. In our case we have 2 MySql databases (they are kept in sync),
and this connector determines which DB is active and forwards commands
to it.

This is the way I use it (note that in url we actually use two)

  <Cluster id=3D"SOME_ID">
    <Journal =
class=3D"org.apache.jackrabbit.core.journal.DatabaseJournal">
      <param name=3D"revision" value=3D"${rep.home}/revision.log" />
      <param name=3D"driver"
value=3D"com.alu.cnm.infrastructure.hadbconnector.HaDriver" />
      <param name=3D"url"
value=3D"hapool:localhost:3307;sometherurl:3307;emlplatform?useUnicode=3D=
tru
e&characterEncoding=3DUTF-8" />
      <param name=3D"user" value=3D"root" />
      <param name=3D"password" value=3D"mysql" />
    </Journal>
  </Cluster>


The problem I'm facing (I guess) is that JackRabbit does not know this
driver is just a MySql proxy, and therefore writes code for other DB
instead of not MySql (see the "falling back to default.dll", which I do
not seen when directly using MySql)

     2008-09-22 17:16:16,317 INFO
[org.apache.jackrabbit.core.RepositoryImpl] Starting repository..."
     2008-09-22 17:16:18,048 INFO
[org.apache.jackrabbit.core.nodetype.NodeTypeRegistry] no custom node
type definitions found
     2008-09-22 17:16:18,163 INFO
[org.apache.jackrabbit.core.journal.DatabaseJournal] No schema-specific
DDL found: 'localhost.ddl', falling back to 'default.ddl'.
     2008-09-22 17:16:18,192 ERROR
[org.apache.jackrabbit.core.RepositoryImpl] failed to start Repository:
Unable to create connection.

Monitoring MySql with dtrace
   - When directly using MySql driver I see
          create table JOURNAL (REVISION_ID BIGINT NOT NULL, JOURNAL_ID
varchar(255), PRODUCER_ID varchar(255), REVISION_DATA longblob)

   - Using the proxy DB-connector I see other syntax, which throws a
MySql syntax error (varbinary is NOT correct for MySql)
          create table JOURNAL (REVISION_ID BIGINT NOT NULL, JOURNAL_ID
varchar(255), PRODUCER_ID varchar(255), REVISION_DATA varbinary)

=20
So I have 2 questions:
  1) Is there a way to make JackRabbit believe that for this proxy
DB-connector JackRabbit needs to write MySql code ? Hopefully only
modifying repository.xml
=20
  2) In case 1) is not possible, does Jackrabbit support 2 databases,
i.e, could I somehow specify two IPs in the url parameter? Will
JackRabbit be able to change to the second when there are problems with
the first one? and back?
=20
=20
Thanks,
Antonio


=20


------_=_NextPart_001_01C90933.96CB3BE8--