Rúben,

If it's Oracle 10g, it's fixed in the latest Oracle JDBC driver 10.2.0.3.0.
(I don't think you need to specify maxEmbeddedBlobSize)

-Frank



Rúben Cabaço wrote:
> 
> Hi,
> 
> I am trying to write a byte[] annotated as a Lob to an Oracle  
> database but I keep getting:
> Caused by: <openjpa-1.0.0-r420667:568756 nonfatal general error>  
> org.apache.openjpa.persistence.PersistenceException: Exhausted Resultset
> .....
> NestedThrowables:
> <openjpa-1.0.0-r420667:568756 nonfatal general error>  
> org.apache.openjpa.persistence.PersistenceException: oracle.sql.BLOB
> 
> Following the instructions on OpenJPA's website i defined the  
> following properties on my persistence.xml:
> 
> <property name="openjpa.jdbc.DBDictionary" value="oracle"/>
> <property name="openjpa.jdbc.DBDictionary.driverVendor" value="oracle"/>
> <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema 
> (ForeignKeys=true)" />
> <property name="openjpa.jdbc.DBDictionary.maxEmbeddedBlobSize"  
> value="5242880"/>
> 
> But still the same exception occurs.
> 
> Any suggestions?
> 
> Regards,
> Rúben Cabaço
> 
> 
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Oracle-blob-exception-tp15261459p15273463.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Reply via email to