Co-incidentally I was testing Oracle Store with WebLogic and I came across
another issue with the storeContent implementation in OracleRDBMSAdapter.
The following line throws ClassCastException:
OutputStream out = ((oracle.sql.BLOB)
blob).getBinaryOutputStream();
Because weblogic is wrapping the blob in its own blob wrapper class:
"weblogic.jdbc.wrapper.Blob_oracle_sql_BLOB".
I think what Kiran did was test Oracle Store with storeContent
implementation of DB2RDBMSAdapter. I tried the same on Oracle 9i and it
worked fine.
So I think the storeContent implementation of DB2RDBMSAdapter should be
moved to CommonRDBMSAdapter and used by Oracle as well. This transition
would even remove the compile time dependency on oracle driver libs.
Also, another important thing... there was a patch applied by Davide for
Content-length to Oracle Adapter (storeContent method has the fix: bugId
30317). That fix should be applied to CommonRDBMSAdapter.
Regards,
Ritu
-----Original Message-----
From: Davide Savazzi [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 5:16 PM
To: Slide Users Mailing List
Subject: Re: OracleRDBMSAdapter no longer supportted?
On Friday 20 August 2004 02:14, Kiran Patchigolla wrote:
> We are able to store and retrieve data in blobs in Oracle 9i using the
> storeContent implementation in CommonRDBMSAdapter which uses JDBC API and
> does not rely on specific oracle API.
In CommonRDBMSAdapter there isn't a storeContent method...
If I remove the storeContent method in the Oracle adapter (thus using
storeContent in StandardRDBMSAdapter) with 10g and classes12.jar or
ojdbc14.jar I get this error:
ORA-01461: can bind a LONG value only for insert into a LONG column
I haven't 9i installed so I can't try with it.
--
Davide Savazzi
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
