Re: JPA: Exception saving CLOB

2009-01-09 Thread Donald Woods
It could be the OpenJPA level used in the 2.1.1 server.  Can you try 
using a 2.1.4-SNAPSHOT or 2.2-SNAPSHOT server build, which is using 
OpenJPA 1.2.0?


The latest 2.1.4-SNAPSHOT build that passed the integration testsuite is 
at -

http://people.apache.org/builds/geronimo/server/binaries/2.1/20090108/


-Donald



fishchips wrote:

I try to save data in the oracle CLOB field. I declared a field in my Entity
bean: 
 @Lob private String data;	

Ther#s not much to do wrong, isn't it?  But I have an exception thrown:

Caused by: 
org.apache.openjpa.persistence.PersistenceException: oracle.sql.CLOB in
classloader org.apache.geronimo.configs/openjpa/2.1.1/car
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3946)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:75)
at
org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
at
org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
... 37 more
Caused by: java.sql.SQLException: oracle.sql.CLOB in classloader
org.apache.geronimo.configs/openjpa/2.1.1/car
at
org.apache.openjpa.jdbc.sql.OracleDictionary.getEmptyClob(OracleDictionary.java:1016)
at
org.apache.openjpa.jdbc.sql.OracleDictionary.setNull(OracleDictionary.java:514)
at
org.apache.openjpa.jdbc.sql.DBDictionary.setTyped(DBDictionary.java:1090)
at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:888)
at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:848)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:95)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)

What's wrong about it?


JPA: Exception saving CLOB

2009-01-09 Thread fishchips

I try to save data in the oracle CLOB field. I declared a field in my Entity
bean: 
 @Lob private String data;  
Ther#s not much to do wrong, isn't it?  But I have an exception thrown:

Caused by: 
org.apache.openjpa.persistence.PersistenceException: oracle.sql.CLOB in
classloader org.apache.geronimo.configs/openjpa/2.1.1/car
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3946)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:75)
at
org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flushPrimaryRow(OperationOrderUpdateManager.java:203)
at
org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(OperationOrderUpdateManager.java:89)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:89)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:72)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:514)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
... 37 more
Caused by: java.sql.SQLException: oracle.sql.CLOB in classloader
org.apache.geronimo.configs/openjpa/2.1.1/car
at
org.apache.openjpa.jdbc.sql.OracleDictionary.getEmptyClob(OracleDictionary.java:1016)
at
org.apache.openjpa.jdbc.sql.OracleDictionary.setNull(OracleDictionary.java:514)
at
org.apache.openjpa.jdbc.sql.DBDictionary.setTyped(DBDictionary.java:1090)
at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:888)
at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:848)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:95)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:73)

What's wrong about it?
-- 
View this message in context: 
http://www.nabble.com/JPA%3A-Exception-saving-CLOB-tp21369295s134p21369295.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.