Return-Path: 
 <users-return-11447-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 84479 invoked from network); 12 May 2009 06:12:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 12 May 2009 06:12:52 -0000
Received: (qmail 83392 invoked by uid 500); 12 May 2009 06:12:51 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 83333 invoked by uid 500); 12 May 2009 06:12:51 -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 83322 invoked by uid 99); 12 May 2009 06:12:51 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 May 2009 06:12:51 +0000
X-ASF-Spam-Status: No, hits=3.4 required=10.0
	tests=HTML_MESSAGE,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [209.85.222.125] (HELO mail-pz0-f125.google.com)
 (209.85.222.125)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 May 2009 06:12:42 +0000
Received: by pzk31 with SMTP id 31so80410pzk.15
        for <users@jackrabbit.apache.org>;
 Mon, 11 May 2009 23:12:21 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.114.208.20 with SMTP id f20mr6241014wag.46.1242108741128;
 Mon,
	11 May 2009 23:12:21 -0700 (PDT)
In-Reply-To: <7bd519ad0905112301j5bf0a81eo173ef7a9e84a6c6e@mail.gmail.com>
References: <7bd519ad0905112057v4b1e7187ud128be75bb447e3e@mail.gmail.com>
	 <7bd519ad0905112139w461ce803qaa7e8d8dd9c13bdd@mail.gmail.com>
	 <7bd519ad0905112301j5bf0a81eo173ef7a9e84a6c6e@mail.gmail.com>
Date: Tue, 12 May 2009 16:12:21 +1000
Message-ID: <7bd519ad0905112312j363212ds43a845fb70dd1909@mail.gmail.com>
Subject: Re: oracle bundle persistence manager
From: Torgeir Veimo <torgeir@netenviron.com>
To: users@jackrabbit.apache.org
Content-Type: multipart/alternative; boundary=00163646d97f4994060469b0faf7
X-Virus-Checked: Checked by ClamAV on apache.org

--00163646d97f4994060469b0faf7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Forgot to add;
Caused by: java.lang.ClassCastException:
org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper
at oracle.sql.BLOB.createTemporary(BLOB.java:587)
... 115 more

Finally managed to fix this by using an oracle specific data source

<Resource name="jdbc/JcrRepositoryDataSource" auth="Container"
        type="oracle.jdbc.pool.OracleDataSource"
        factory="oracle.jdbc.pool.OracleDataSourceFactory"
        connectionCachingEnabled="true"
        user="torgeir" password="torgeir"
        driverClassName="oracle.jdbc.OracleDriver"
        url="jdbc:oracle:thin:@defender.local.netenviron.com:1521:orc150"
        removeAbandoned="true"
        removeAbandonedTimeout="30"
        maxActive="20"
        maxIdle="10" maxwait="-1"/>

I really hate databases.

-- 
-Tor

--00163646d97f4994060469b0faf7--