Thank you for you attention and response. I'll have a look at the driver
version. I appreciate your help.
Carey
-----Original Message-----
From: Gordon Yorke [mailto:gordon.yorke_at_oracle.com]
Sent: Friday, May 04, 2007 4:01 PM
To: persistence_at_glassfish.dev.java.net
Subject: RE: CLOB saving
I would recommend trying the latest Oracle database drivers (10.2?).
The oracle specific LOB support was not migrated to TopLink Essentials
because of library dependancy issues. I have heard that support has
been added to the latest Oracle drivers to support LOBs through straight
JDBC calls which would be compatible with TopLink Essentials. If you
are still having issues on Monday I will track down the exact version
for you.
--Gordon
-----Original Message-----
From: Northrup, Carey T [mailto:Carey.T.Northrup_at_boeing.com]
Sent: Friday, May 04, 2007 4:45 PM
To: persistence_at_glassfish.dev.java.net
Subject: RE: CLOB saving
Using ojdbc14dms.jar
Packages with Jdeveloper 10.1.3.2
Thanks,
Carey
-----Original Message-----
From: Gordon Yorke [mailto:gordon.yorke_at_oracle.com]
Sent: Friday, May 04, 2007 3:41 PM
To: persistence_at_glassfish.dev.java.net
Subject: RE: CLOB saving
What version of the Oracle Driver are you using?
--Gordon
-----Original Message-----
From: Northrup, Carey T [mailto:Carey.T.Northrup_at_boeing.com]
Sent: Friday, May 04, 2007 4:27 PM
To: persistence_at_glassfish.dev.java.net
Subject: RE: CLOB saving
Yes, we are using the @lob annotation.
-----Original Message-----
From: Gordon Yorke [mailto:gordon.yorke_at_oracle.com]
Sent: Friday, May 04, 2007 3:21 PM
To: persistence_at_glassfish.dev.java.net
Subject: RE: CLOB saving
Are you marking the property with the @LOB annotation?
--Gordon
-----Original Message-----
From: Northrup, Carey T [mailto:Carey.T.Northrup_at_boeing.com]
Sent: Friday, May 04, 2007 4:19 PM
To: persistence_at_glassfish.dev.java.net
Subject: CLOB saving
Hi,
I'm using the persistance API to save data in a CLOB field. Saving
larger amounts of data results in this error.
java.sql.SQLException: setString can only process strings of less than
32766 chararacters
Is there any way of using CLOB types with toplink essentials and save
larger amounts of data?
Any direction on this would be greatly appreciated.
Thanks,
Carey Northrup
The Boeing Company