Long Raw data type

[Naveen Kumar]

HI,
I am currently working on a migration project, migrating from Weblogic to Websphere.
I am getting the following error while trying to insert data into the database, & this happens only in WebShere.
"Data size bigger than max size for this type:16390"
This is not specific for a size, but for all the sizes.
If any one can throw light on this issue, please do so, it is very URGENT for me.
The database is Oracle 9i, the Websphere App Server is Advanced Edition V4.0.1. JDBC thin driver is being used.
The same scenario is working fine in Weblogic.
Thanks & Regards
Naveen Kumar

[Vinod Bijlani]

Naveen
did u try to use thick driver?
Vinod
[ July 21, 2002: Message edited by: Vinod ]

[Naveen Kumar]

Hi,
I could solve this problem my self. This is a limitation of the THIN driver. The Oracles implementation of preparedstatement does not fully support the manipulation of large objects like BLOBs & CLOBs. Specifically the thin driver does not support this functionality.
The solution is to use the OCI driver from Oracle. There are a few limitations with the OCI as well, but they are limited to the functionality of SSL & NT operating system (Might be more not listed here). I am currently using the OCi driver.
So as I see now there is not much support from Websphere related to Oracle, as I am going hit across a similar problem of the driver during the performance of the application using the OCI driver.
If any one has any solutions or Suggestions please do so, I am quite open for all the Suggestions.
Vinod, thanks a lot for your suggesion. I had not tried this option as I had read from IBM documentation the limitation of the OCI driver, it hangs the Application server on NT. Well finally I had no choice to use the OCI driver. If you have any more details on this please pass them to me.
Thanks a lot.
Naveen Kumar
[ July 22, 2002: Message edited by: Naveen Kumar ]