Skip Menu |
 

This queue is for tickets about the DBD-DB2 CPAN distribution.

Report information
The Basics
Id: 84490
Status: open
Priority: 0/
Queue: DBD-DB2

People
Owner: Nobody in particular
Requestors: andriy [...] ca.ibm.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 1.85
Fixed in: (no value)



The driver fails silently while fetching clob column. This problem manifest itself on DB2 Server: v.9.7 fp7, 64 bit, installed on Linux SuSe 11 fp2 DB2 Client: same instance as server DBI : originally 1.607, upgraded to 1.625, but the problem persists DBD::DB2 : 1.85 Perl: 5.10.0 However, if I catalog the same database on DB2 v.9.5 fp5 running on WinXp, the error disappears: DB2 Server: v.9.7 fp7, 64 bit, installed on Linux SuSe 11 fp2 DB2 Client: v.9.5 fp5, 32 bit, installed on WinXP DBI : 1.607 DBD::DB2 : 1.74 Perl: 5.8.9 (Activestate) Please let me know if you need any additional information. Here is an excerpt from the DBI trace log. Row 18 is fetched correctly, row 19 is causing an error: DBI_TRACE=9=dbitrace_3.log perl my_script.pl #Normal fetch: -> fetchrow_array for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010 dbd_st_fetch 5 fields 0: rc=0 '94608' 1: rc=0 '010' 2: rc=0 '618' 3: rc=0 'O04/01/21' 4: rc=0 'clob text goes here' [5 items] row18 at my_script.pl line 194 #Abnormal fetch: -> fetchrow_array for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010 dbd_st_fetch 5 fields 0: rc=0 '94630' 1: rc=0 '010' 2: rc=0 '618' 3: rc=0 'O04/01/22' !! info: '' 'SQL_NO_DATA returned from Diagnostic Information. There might be no diagnostic records for this handle. Please see Infocentre for more details!!' (err#0) <- fetchrow_array= ( ) [0 items] row19 at my_script.pl line 194 Show quoted text
>> err DISPATCH (DBI::st=HASH(0xcfed38) rc1/1 @1 g0 ima4 pid#14321) at my_script.pl line 201
-> err in DBD::_::common for DBD::DB2::st (DBI::st=HASH(0xcfed38)~0xc7c590) thr#78e010 info: '' 'SQL_NO_DATA returned from Diagnostic Information. There might be no diagnostic records for this handle. Please see Infocentre for more details!!' (err#0) <- err= '' at my_script.pl line 201 Show quoted text
>> finish DISPATCH (DBI::st=HASH(0xcfed38) rc1/1 @1 g0 ima1 pid#14321) at my_script.pl line 203
!! info: '' CLEARED by call to finish method
Subject: DBD::DB2 fails silently when fetching CLOB
Download (untitled) / with headers
text/plain 539b
Hi Andriy, Could you let us know what error are you seeing, like you expected some data but data is not retrieved. Does the data retrieved include some special characters? Also, could you get us the CLI traces for the runs on both the machines (where it runs fine and where it fails). You can refer to http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.trb.doc/doc/c0008936.html for obtaining CLI traces. -- Thanks Praveen IBM OpenSource Application Development Team India Software Labs, Bangalore (India)


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.