Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Want to send CLOB/CLOB to Oracle AQ from Java

Thread Tools

Want to send CLOB/CLOB to Oracle AQ from Java
Posts: n/a
I have an Oracle type which includes a CLOB field. I have, in Java, a
class which implements SQLData & defines writeSQL & readSQL, etc
methods. I can receive all data types (including CLOB/BLOB), but
cannot send CLOB/BLOB objects to an AQ.

The interface defines writeClob(Clob c), but my question is how to
construct the Clob object in java?

Using Oracle's implementation of JDBC, I can do:

CLOB c=CLOB.empty_lob();
c.putString(0, "foobar");

But get an "Invalid empty LOB operation" error since the LOB was not
previous saved to the database.

Do I need to INSERT the data into a database table first, then SELECT
it from the table, just to publish it to an AQ? Then go back & DELETE
it from the table?

All of the examples I have found do not include CLOB/BLOB objects being
saved to an AQ.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to send a mail using mailx(unix) in java code aemi Java 3 01-07-2007 04:50 PM
I want to create a link "e-mail this page to a friend" on clicking this link i want to send the URL of that current page to a friend pavi Javascript 0 01-13-2006 12:10 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Exception thrown while accessing Oracle through oracle client =?Utf-8?B?TmVv?= ASP .Net 2 07-12-2005 06:59 PM
Oracle adapter don't work with Oracle v. Client vaidas gudas ASP .Net 1 10-11-2004 01:11 PM