Return-Path: 
 <users-return-1567-apmail-openjpa-users-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-users-archive@locus.apache.org
Received: (qmail 73123 invoked from network); 4 Feb 2008 03:11:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 4 Feb 2008 03:11:14 -0000
Received: (qmail 87229 invoked by uid 500); 4 Feb 2008 03:11:06 -0000
Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org
Received: (qmail 87209 invoked by uid 500); 4 Feb 2008 03:11:06 -0000
Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@openjpa.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@openjpa.apache.org>
List-Post: <mailto:users@openjpa.apache.org>
List-Id: <users.openjpa.apache.org>
Reply-To: users@openjpa.apache.org
Delivered-To: mailing list users@openjpa.apache.org
Delivered-To: moderator for users@openjpa.apache.org
Received: (qmail 33105 invoked by uid 99); 4 Feb 2008 00:55:03 -0000
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Mime-Version: 1.0 (Apple Message framework v753)
Message-Id: <AB6576B3-0B07-41A0-AB9D-55CF36A0D679@student.dei.uc.pt>
Content-Type: multipart/alternative; boundary=Apple-Mail-2-440965427
To: users@openjpa.apache.org
Subject: Oracle blob exception
From: =?ISO-8859-1?Q?R=FAben_Caba=E7o?= <rubend@student.dei.uc.pt>
Date: Mon, 4 Feb 2008 00:54:24 +0000
X-Mailer: Apple Mail (2.753)
X-FCTUC-DEI-SIC-MailScanner-Information: Please contact helpdesk@dei.uc.pt for
 more information
X-FCTUC-DEI-SIC-MailScanner: Not scanned: please contact helpdesk@dei.uc.pt
 for details
X-FCTUC-DEI-SIC-MailScanner-SpamCheck: not spam (whitelisted),
	SpamAssassin (not cached, score=-51.798, required 3,
	autolearn=not spam, ALL_TRUSTED -1.80, BAYES_50 0.00,
	HTML_MESSAGE 0.00, L_SMTP_AUTH -50.00)
X-FCTUC-DEI-SIC-MailScanner-From: rubend@student.dei.uc.pt
X-Virus-Checked: Checked by ClamAV on apache.org
X-Old-Spam-Status: No

--Apple-Mail-2-440965427
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=ISO-8859-1;
	delsp=yes;
	format=flowed

Hi,

I am trying to write a byte[] annotated as a Lob to an Oracle =20
database but I keep getting:
Caused by: <openjpa-1.0.0-r420667:568756 nonfatal general error> =20
org.apache.openjpa.persistence.PersistenceException: Exhausted Resultset
.....
NestedThrowables:
<openjpa-1.0.0-r420667:568756 nonfatal general error> =20
org.apache.openjpa.persistence.PersistenceException: oracle.sql.BLOB

Following the instructions on OpenJPA's website i defined the =20
following properties on my persistence.xml:

<property name=3D"openjpa.jdbc.DBDictionary" value=3D"oracle"/>
<property name=3D"openjpa.jdbc.DBDictionary.driverVendor" =
value=3D"oracle"/>
<property name=3D"openjpa.jdbc.SynchronizeMappings" value=3D"buildSchema=20=

(ForeignKeys=3Dtrue)" />
<property name=3D"openjpa.jdbc.DBDictionary.maxEmbeddedBlobSize" =20
value=3D"5242880"/>

But still the same exception occurs.

Any suggestions?

Regards,
R=FAben Caba=E7o




--Apple-Mail-2-440965427--