BLOB and Java

Waldo Tumanut

BLOB and Java
We are trying to use BLOB here in our shop and so far have not been
successful. Our environment: DB2 6.1 on OS/390, client is using Java and
DB2 Connect 7.1 on NT. The programmer was able to insert a row but is
getting an apparent datatype mismatch (shows 2001) when doing getBlob. Any
tips or stuff to try out would be appreciated.

Waldo Tumanut
DBA, American Century



Simon George

Re: BLOB and Java
(in response to Waldo Tumanut)

Last time I checked the current DB2/390 JDBC drives did not support the CLOB/BLOB datatypes. I don't know if that situation has changed but if it has I suspect tit will be implemented only on the DB2/390 V7 JDBC drivers


Cheers

Simon >From: Waldo Tumanut >Reply-To: DB2 Data Base Discussion List >To: [login to unmask email] >Subject: BLOB and Java >Date: Thu, 3 Jan 2002 16:19:15 -0600 > >We are trying to use BLOB here in our shop and so far have not been >successful. Our environment: DB2 6.1 on OS/390, client is using Java and >DB2 Connect 7.1 on NT. The programmer was able to insert a row but is >getting an apparent datatype mismatch (shows 2001) when doing getBlob. Any >tips or stuff to try out would be appreciated. > >Waldo Tumanut >DBA, American Century > > >

Chat with friends online, try MSN Messenger: Click Here

Roger Miller

Re: BLOB and Java
(in response to Simon George)
LOB support is available in DB2 V7 with APAR PQ51847, but not before that.

Roger Miller, DB2 for z/OS



Manas Dasgupta

Re: BLOB and Java
(in response to Roger Miller)
We use DB2 6.1 on OS/390 and store PDF files using BLOBs. We can both insert
and read BLOBs using programs running jdbc via DB2 Connect.
The Blob class is available only in jdbc 2, so remember to run usejdbc2
script located in the sqllib/java12 directory. Also make sure the developers
are using jdk 1.2 or above. Its does not work with jdk 1.1.8.

Thanks,
Manas.

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Waldo Tumanut
Sent: Thursday, January 03, 2002 5:19 PM
To: [login to unmask email]
Subject: BLOB and Java


We are trying to use BLOB here in our shop and so far have not been
successful. Our environment: DB2 6.1 on OS/390, client is using Java and
DB2 Connect 7.1 on NT. The programmer was able to insert a row but is
getting an apparent datatype mismatch (shows 2001) when doing getBlob. Any
tips or stuff to try out would be appreciated.

Waldo Tumanut
DBA, American Century








Waldo Tumanut

Re: BLOB and Java
(in response to Manas Dasgupta)
Thanks to Simon George's Rober Miller's and Manas Daguptas's responses,
although they seem to contradict each other or my question wasn't well
understood.

"DB2/390 JDBC drivers do not work before v7" -
We are preparing the program and executing using driver from DB2 Connect
v7, i.e. runs remotely from DB2.

"LOB support available in v7 with APAR PQ51847" -
Hmmm. I was able to create the table with BLOB columns in v6. What do you
mean when you say "support available"?

"JDBC access to v6.1 works" -
Great! I'll have the programmer check out the prerequisites you mentioned.



Simon George

Re: BLOB and Java
(in response to Waldo Tumanut)

Hi Waldo,

My mistake I miss read your original question and assumed that your "client" was on 390. The DB2/390 V6 and intial DB2/390 V7 JDBC drivers did not support BLOB/CLOBS so if your client program had been running on 390 you would have had a problem. Rogers comment refers to the revised DB2/390 JDBC driver which fixes a load of problems with SQLJ support and he suggests enables LOB/CLOB support (we are just about to apply it so I can't tell you if it works).

The non-390 DB2 JDBC drivers are a different product and have supported CLOBS etc for sometime.

Sorry for the confussion.
Cheers

Simon

Chat with friends online, try MSN Messenger: Click Here

Roger Miller

Re: BLOB and Java
(in response to Simon George)
LOBs are part of V6.

Java support for JDBC goes back to V5.

The combination of Java and LOBs has no support that I know of prior to V7
and APAR PQ51847. You can check the DB2 web Support page descriptions for
APARs PQ51846 (v6) and PQ51847 (v7).

DB2 should be followed immediately by a blank. Please avoid using the
terminology "DB2/390". Our lawyers have sensitized us that this is a
problem for the trademark. You also have more credibility if you spell the
product name correctly.

Roger Miller, DB2 for z/OS



Myron Miller

Re: BLOB and Java
(in response to Roger Miller)
Roger,
How does V7 of DB2 for OS/390 get around the limitations of JDBC
support that are documented for DB2 Connect? Or are you just talking
about Java on OS/390 accessing DB2?

Myron
--- Roger Miller <[login to unmask email]> wrote:
> LOBs are part of V6.
>
> Java support for JDBC goes back to V5.
>
> The combination of Java and LOBs has no support that I know of prior
> to V7
> and APAR PQ51847. You can check the DB2 web Support page
> descriptions for
> APARs PQ51846 (v6) and PQ51847 (v7).
>
> DB2 should be followed immediately by a blank. Please avoid using
> the
> terminology "DB2/390". Our lawyers have sensitized us that this is a
> problem for the trademark. You also have more credibility if you
> spell the
> product name correctly.
>
> Roger Miller, DB2 for z/OS
>
>
>
> visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
> the list can


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/