Re: Smart Blob/JDBC -> getBytes returns null!

Posted in 2004

Rajib Sarkar — Thu, 5 Aug 2004 16:50:46 -0700 — source: Usenet: comp.databases.informix

--0__=88BBE474DF1168AC8f9e8a93df938690918c88BBE474DF1168AC Content-type: multipart/alternative; Boundary="1__=88BBE474DF1168AC8f9e8a93df938690918c88BBE474DF1168AC" --1__=88BBE474DF1168AC8f9e8a93df938690918c88BBE474DF1168AC Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Probably you will require to do a JDBC trace in order to get to the bot= tom of it ..or maybe SQLIDEBUG to see what's happening .. Thanx much, Rajib Sarkar Advisory Software Engineer DB2/UDB Regional Advanced Support IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = Steve = <steve@nospam.net = > = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect Smart Blob/JDBC -> getBytes retu= rns 08/05/2004 12:05 null! = PM = = = Please respond to = Steve = = = I have an annoying rare problem. Infrequently, JDBC reads of a Smart Blob return null bytes. That is blob.getBytes() returns null without throwing any exception. Sometimes subsequent reads of the same blob returns valid bytes, leading me to believe the smart blob is valid within informix. Network and JDBC issues are my prime suspects. What is causing blob.getBytes() to return null without throwing an exception? Steve. = --1__=88BBE474DF1168AC8f9e8a93df938690918c88BBE474DF1168AC Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Probably you will require to do a JDBC trace in order to get to the = bottom of it ..or maybe SQLIDEBUG to see what's happening ..<br> <br> Thanx much,<br> <br> Rajib Sarkar<br> Advisory Software Engineer<br> DB2/UDB Regional Advanced Support<br> IBM Data Management Group<br> <br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for Steve <steve@nos= pam.net>">Steve <steve@nospam.net><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE47= 4DF1168AC8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">Steve <steve@nospam.net></font></b><font = size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">08/05/2004 12:05 PM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> Steve</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE474DF1168AC8f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Smart Blob/JDBC -> getBytes returns null!</font></t= d></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE474DF11= 68AC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE474DF1168AC8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>I have an annoying rare problem.<br> <br> Infrequently, JDBC reads of a Smart Blob return null bytes.<br> <br> That is blob.getBytes() returns null without throwing any exception.<br= > <br> Sometimes subsequent reads of the same blob returns valid bytes,<br> leading me to believe the smart blob is valid within informix.<br> <br> Network and JDBC issues are my prime suspects.<br> <br> What is causing blob.getBytes() to return null without throwing an <br>= exception?<br> <br> <br>