sending a CLOB to oracle via Websphere problem
From: Jon Roquet (jroquet_at_covad.net)
Date: 01/28/04
- Next message: Leigh: "Re: Slow-loading drop down boxes"
- Previous message: Umut Ceyhan: "Passing a Java collection object (List) to a SQLJ based stored procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 28 Jan 2004 07:54:40 -0600
I'm attempting to perform two different things with a Websphere 5.1
application connecting to an Oracle 9i database via JDBC.
First, I'm trying to send a large (approximately 500k) string to it to be
persisted as a CLOB. Unfortunately, I've been unable to find any method to
send this using Websphere datasources. The only method we've discovered that
works is to create our own connection pool, and then create the CLOB via the
temporary CLOB functions provided by Oracle.
However, we want to use Websphere datasources for this, not our own
connection pools.
The errors we received were all along the lines of "Too long".
Secondly, I'm trying to send even larger datablocks (about 1 meg) to a
stored procedure on our database. Same problem.
This appears to be a problem between JDBC and Oracle. Does anyone have any
insights into how I can send this data?
-- Jon "Adrenfreak" Roquet
- Next message: Leigh: "Re: Slow-loading drop down boxes"
- Previous message: Umut Ceyhan: "Passing a Java collection object (List) to a SQLJ based stored procedure"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
