From users-return-13212-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Wed Nov 04 11:12:22 2009 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 91051 invoked from network); 4 Nov 2009 11:12:21 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 4 Nov 2009 11:12:21 -0000 Received: (qmail 13330 invoked by uid 500); 4 Nov 2009 11:12:21 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 13292 invoked by uid 500); 4 Nov 2009 11:12:20 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 13281 invoked by uid 99); 4 Nov 2009 11:12:20 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Nov 2009 11:12:20 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates 216.139.236.158 as permitted sender) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Nov 2009 11:12:17 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1N5dmO-0005Es-JA for users@jackrabbit.apache.org; Wed, 04 Nov 2009 03:11:56 -0800 Message-ID: <26194430.post@talk.nabble.com> Date: Wed, 4 Nov 2009 03:11:56 -0800 (PST) From: AnatoliyDilov To: users@jackrabbit.apache.org Subject: Re: Jackrabbit, JBoss, Oracle and JNDI Datasource lookup In-Reply-To: <91f3b2650911040239u639a3e12p5538785fefe9afbf@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: anatoliy@adilov.net References: <26029101.post@talk.nabble.com> <91f3b2650910280238u2555e076qb4812d3445e644c@mail.gmail.com> <26092064.post@talk.nabble.com> <91f3b2650911040239u639a3e12p5538785fefe9afbf@mail.gmail.com> Thomas M=C3=BCller-2 wrote: >=20 > Hi, >=20 > The problem is here: > org.jboss.resource.adapter.jdbc.WrappedConnection > at oracle.sql.BLOB.createTemporary(BLOB.java:587) >=20 > I can't get the repository.xml file you posted (I get Error 500). >=20 > It looks like you try to use a JNDI connection (some kind of JBoss > connection) with OracleFileSystem. This is not supported with this > file system, sorry. You need to use the the JDBC driver / database URL > in the file system configuration, or you need to use another > persistence manager (I'm not sure if DbFileSystem would work). >=20 > Regards, > Thomas >=20 >=20 Hi Thomas, I found a workaround. The solution is really in a custom class, that extend= s OracleFileSystem. Maybe in my first try I messed up something, but everything is OK now. Here is a working FS class file, used in the repository.xml (FileSystem class=3D"path.to.ExtendedOracleFileSystem"): public class ExtendedOracleFileSystem extends OracleFileSystem { @Override protected Connection getConnection() throws RepositoryException, SQLException { Connection connection =3D super.getConnection(); if (connection !=3D null && connection instanceof WrappedConnection= ) { return ((WrappedConnection) connection).getUnderlyingConnection(); } return connection; } } Many thanks for the replies. Cheers, Anatoliy --=20 View this message in context: http://old.nabble.com/Jackrabbit%2C-JBoss%2C-= Oracle-and-JNDI-Datasource-lookup-tp26029101p26194430.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.