Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: domain of todd.seiber@gmail.com
 designates 209.85.198.235 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=On7l2jmYOLfE9kx/O7Er9zj4FimFoWecCpr2+7d4TvTimn6lT6puVg0oG2v7SB8Hkb
         87fxSHQCOHx0n4Eap6bkESaT5YC/0Nonb8vtbkE2uaqjGhFXulnsL8TrdBS/Hbp9LcrR
         QxCmpMuGYYySp+nYysmfBpFyPAzqtT9DZ9OPE=
Message-ID: <8ce7e61c0812240901t46fa8b00ia31e802773e05cfd@mail.gmail.com>
Date: Wed, 24 Dec 2008 12:01:32 -0500
From: "Todd Seiber" <todd.seiber@gmail.com>
To: users@jackrabbit.apache.org
Subject: Re: Jackrabbit integration with MySQL
In-Reply-To: <49D10073EBAB7B4D9DC1FC75DE2EB9FB090150@blr-m3-msg.wipro.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_52618_16533381.1230138092887"
References: <49D10073EBAB7B4D9DC1FC75DE2EB9FB090150@blr-m3-msg.wipro.com>

------=_Part_52618_16533381.1230138092887
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Checkout Jackrabbit config info at
http://jackrabbit.apache.org/jackrabbit-configuration.html and use the
following example to setup values for MySQL. I personally found that if you
are working on a Windows platform and transferring over to a *nix platform
that it is best to change the Windows MySQL setting. Setup MySQL to use case
sensitive table names and the MyISAM engine. This way if you load up data on
you local machine and restore it to a remote machine (hopefully setup the
same) you will not have naming problems...since Jackrabbit seems to use all
uppercase names.


Example mysql:

<FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="url" value="jdbc:mysql://127.0.0.1:3306/myRepository"/>
    <param name="user" value="myUser"/>
    <param name="password" value="myPassword"/>
    <param name="schema" value="mysql"/>
    <param name="schemaObjectPrefix" value="fs_"/>
</FileSystem>


On Wed, Dec 24, 2008 at 1:34 AM, <pinky.muralidhar@wipro.com> wrote:

> Hi,
>
>
> I just started working in Jackrabbit. My requirement is to configure
> Jackrabbit with MySQL. Can anyone provide the steps how to do it.
>
>
> Thanks in Advance,
> Pinky Muralidhar.
>
>
> Please do not print this email unless it is absolutely necessary.
>
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient
> should check this email and any attachments for the presence of viruses. The
> company accepts no liability for any damage caused by any virus transmitted
> by this email.
>
> www.wipro.com
>


-- 
Todd Seiber
830 Fishing Creek Rd.
New Cumberland, PA 17070

h. 717-938-5778
c. 717-497-1742
e. todd.seiber@gmail.com

------=_Part_52618_16533381.1230138092887--