Creating BLOB in Java

From: Arun (aruns_nj_at_yahoo.com)
Date: 03/09/04 

Date: 8 Mar 2004 20:44:48 -0800

We are using JDBC to call the stored procedures in the Backend
Mainframe DB2 Database. We are testing our procedures using DB2
Connect V8 jdbc driver/Java. One of the stored procedures uses a BLOB
parameter. DB2 Connect v7 accepted byte stream TYPE for a BLOB
parameter. So all we had to do was convert the input data(from file)
in to a byte stream and call the stored procedure.

         We are trying to move to DB2 Connect V8. However DB2 Connect
V8 does not accept a bytestream, it needs a BLOB object type for a
Blob Parameter. Can anyone give me some tips on how to create a BLOB
object?. I created a class by implementing the java.sql.blob
interface, but I am missing something because I don't see the data in
the DB2 stored procedure.

Thanks.

Relevant Pages

  • Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: DBD:: DB2 and bind [securi
    ... Manfred Beilfuss wrote: ... And I am also be able to connect to DB2 on OS/390 from windows in practice. ... > I have an additional question about the content of a BLOB of a DB2 ...
    (perl.dbi.users)
  • Stored procedure permissions cross database
    ... We granted execute permissions to a user for stored procedures in DB1, ... but some of the procedures reference tables in DB2, ... different logins. ...
    (microsoft.public.sqlserver.security)
  • load_file and blobs
    ... I cannot update the blobs correctly with mysql. ... I exported 3 rows from db2 to mysql database. ... When I want to add the blob objects back to mysql after the data was imported, ...
    (comp.databases.ms-sqlserver)
  • Re: load_file and blobs
    ... I have to split up the lob file from db2 using the offset and size of each lob into individual files and update each of the rows with the split load file. ... I exported 3 rows from db2 to mysql database. ... When I want to add the blob objects back to mysql after the data was imported, ...
    (comp.databases.ms-sqlserver)
  • Re: =?ISO-8859-1?Q?Bin=E4r_Daten_in_DB_einf=FCgen?=
    ... CONTENT ist der Blob. ... MS Sql Server: ... Für DB2 hab ichs noch nicht, ...
    (de.comp.lang.perl.misc)