Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 38973 invoked from network); 9 Jan 2009 09:56:26 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Jan 2009 09:56:26 -0000 Received: (qmail 4978 invoked by uid 500); 9 Jan 2009 09:56:24 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 4968 invoked by uid 500); 9 Jan 2009 09:56:24 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 4959 invoked by uid 99); 9 Jan 2009 09:56:24 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 09 Jan 2009 01:56:24 -0800 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG 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; Fri, 09 Jan 2009 09:56:17 +0000 Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1LLE5r-0008Rp-0b for user@geronimo.apache.org; Fri, 09 Jan 2009 01:55:55 -0800 Message-ID: <21369295.post@talk.nabble.com> Date: Fri, 9 Jan 2009 01:55:55 -0800 (PST) From: fishchips To: user@geronimo.apache.org Subject: JPA: Exception saving CLOB MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: andre.lubensky@accumio.de X-Virus-Checked: Checked by ClamAV on apache.org 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.