Re: [castor-dev] Question about saving strings to Oracle as clob

[Martin, Margaret]

Xinyu, You will need to use Oracle's oci driver as the clob support is incomplete with the thin driver (I'm guessing that this is likely the cause of the Io Exception). Is your string really 20GB (max size of a clob = 4GB)? Based on the way clobs are implemented in the oracle driver, and the way Castor access the data from teh result set, you will certainly see better results if you could limit this to a single clob...   Hop this helps - Margaret -----Original Message----- From: yuanxinyu [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 4:21 AM To: [EMAIL PROTECTED] Subject: [castor-dev] Question about saving strings to Oracle as clob Say I want save five strings to Oracle database ,and there are five clob fields in the table. When I store these strings, I found that their order is incorrect in the database. And if some string is larger than 4KB, I get a error message "java.sql.SQLException: Io Exception: Connection reset by peer".   Thanks Xinyu Yuan