Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
From: Luke Noel-Storr <luke.noel-storr@integrate.co.uk>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_A2D858EA-FD98-4A61-B3A3-C4B90A436E82"
Subject: Oracle 9i
Message-Id: <BC1A514C-FA0E-44AB-B075-BDCCBA66263B@integrate.co.uk>
Date: Fri, 8 Mar 2013 09:34:16 +0000
To: "users@jackrabbit.apache.org" <users@jackrabbit.apache.org>
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))

--Apple-Mail=_A2D858EA-FD98-4A61-B3A3-C4B90A436E82
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Hi, we are trying to get Jackrabbit working with Oracle 9i, and have hit =
a few snags.

They're around the area of BLOBs, so I'm wondering if it's because we're =
using the wrong persistence manager, etc.

We're currently using the OraclePersistenceManager, OracleFileStore, =
OracleDatabaseJournal and DbDataStore.

I'm aware there are Oracle9 versions of the first two of these, however, =
the API docs say:

"provides support for Oracle jdbc drivers prior to version 10 which =
require special handling of BLOB data"

As we are using the Oracle 11 jdbc driver (which is purportedly =
backwards compatible with Oracle 9i), my interpretation of the above was =
that we would not need to use the Oracle 9 classes from Jackrabbit.  =
They would seem to be driver specific, rather than database specific.

Is this just a case of misleading documentation, however?


There is then also, slightly confusingly, an Oracle10R1ConnectionHelper =
which says:

"The connection helper for Oracle databases of version up to 10.1. It =
has special blob handling."

Which would seem to imply that class is database version specific, =
rather than driver version specific.  This class is used by the Oracle9 =
classes.


So, basically, my question is, if I'm using Oracle 11 jdbc drivers, with =
Oracle 9i database, which should I use the vanilla Oracle classes or the =
Oracle9 classes?


Also, if I should be using the Oracle9 classes, what settings should I =
use for the DbDataStore?  I can't find any documentation about what =
valid "databaseType" strings can be used.  Do I just use "oracle" or =
should I use "oracle9" or "oracle10r1"?  I'm assuming it would need to =
know to use the Oracle10R1ConnectionHelper, but I can't see where in the =
source code it figures out to do that.

Also, what about the Journal? There only seems to be a =
OracleDatabaseJournal class, and no Oracle9DatabaseJournal.


Many Thanks,

Luke Noel-Storr.
----------------

Integrated Publishing Solutions Ltd.
Tel: +44 (0)1926 889199
http://www.integrate.co.uk


--Apple-Mail=_A2D858EA-FD98-4A61-B3A3-C4B90A436E82--