WebSphere and Oracle

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Tue, 25 Nov 2003 04:44:26 -0800
Message-ID: <F001.005D7C3F.20031125044426@fatcity.com>

All,

We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has three RAW columns that essentionally hold BLOB information.

The Application is connecting using the thin driver.

We are getting a java error. According to the IBM web site:

"When using the LOB columns (BLOBS and CLOBS) with Oracle 8i, you cannot use setCharacterStream or setBinaryStream to set BLOBS and CLOBS when the size of the LOB columns is greater than 4k. Oracle has lifted the restriction in the 9i R2 OCI driver (thick driver). If you have one of these error messages or you know that your data exceeds 4k, update to Oracle 9i R2 and use the OCI driver when connecting to Oracle server. If you cannot update to Oracle 9i R2, contact Oracle Support."

I will be contacting Oracle support, but was wondering if anyone else has experienced this and did they find an answer to the problem.

thanks

Tom Mercadante
Oracle Certified Professional
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 25 2003 - 06:44:26 CST