[Info-vax] Storing LOBV values via Java

CodeAmazon shastaw at gmail.com
Sat Jan 3 18:29:31 EST 2009


I am trying to copy records from an Oracle9i database to an Oracle/RDB
database on an OpenVMS server.  A Java program collects the data from
the former and inserts the records into the latter if they match
various criteria.  For the most part, this goes well.

However, in the source there is a table of comments which are to be
entered as a concatenated String with some timestamp information in
the destination.  The db admin set the target up as an LOBV:
CAD      LIST OF BYTE VARYING
                Segment Length: 80

I currently create a row with everything but the comments, then
concatenate per the requirements, and finally want to update the new
record with the prettified comment.  I have utterly failed to insert
this value into the database as a LOBV (or by pretending it's a
BLOB.)  Can someone tell me how to insert my data -- currently a large
String -- into the LOBV field (or point me to a tutorial?)

- Shasta



More information about the Info-vax mailing list