ORA-22835 using JPA (Buffer too small)

Posted by Kenneth on Stack Overflow See other posts from Stack Overflow or by Kenneth
Published on 2010-02-23T09:42:12Z Indexed on 2010/05/02 16:58 UTC
Read the original article Hit count: 506

Filed under:
|
|
|
|

I am trying to persist an Entity with a @Lob annotated String field. The content of that fiels if bigger than the 40k buffer size limit.

The first problem I had was related to the setString method used internally by the JPA implementation (Hibernate in my case) and the Oracle JDBC Driver. This problem was solved adding

<property name="hibernate.connection.SetBigStringTryClob" value="true"/>

to my persistence.xml file.

Then, the error changed to a ORA-22835 error (the buffer is too small). ¿Is there any way that JPA solves this problem without going to a low-level implementation? ¿Any suggestions?

© Stack Overflow or respective owner

Related posts about jpa

Related posts about Oracle