Yeah, I decided to just create a Cayenne standalone app to do it for me.
Turned out to be easier than I remembered :) Seems to be working.
-Mike
On 8/31/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
> Not sure if the newer versions of Oracle can handle it in a JDBC-
> compliant way, but the way we do it in Cayenne (also described here
> by Cris - http://www.objectstyle.org/cayenne/lists/cayenne-user/
> 2004/11/0071.html) is via using "EMPTY_BLOB()" proprietary Oracle
> function. Here is how you'd approach it using JDBC:
>
> // run this via PreparedStatement to insert a row with empty BLOB
> INSERT INTO BLOB_TEST (BLOB_COL, BLOB_TEST_ID) VALUES (EMPTY_BLOB(), ?)
>
> // select this row, get java.sql.Blob from ResultSet and write its
> contents using java.sql.Blob API:
> SELECT t0.BLOB_COL, t0.BLOB_TEST_ID FROM BLOB_TEST t0 WHERE
> BLOB_TEST_ID = ?
>
>
> Andrus
>
> On Aug 31, 2005, at 1:03 PM, Mike Kienenberger wrote:
>
> > This is off-topic, but I'd rather not write cayenne code to solve
> > it :)
> >
> > Are there any tools out there for inserting blob data? In specific,
> > inserting it into Oracle?
> >
> > I need to generate some testing data, and I'd rather not write code
> > to do it :)
> >
> > -Mike
> >
> >
>
>
This archive was generated by hypermail 2.0.0 : Wed Aug 31 2005 - 14:34:54 EDT