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

Posted in 2004

Venkatesh Gopal — Thu, 5 Aug 2004 22:56:00 -0500 — source: Usenet: comp.databases.informix

--0__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: multipart/alternative; Boundary="1__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71" --1__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: text/plain; charset=US-ASCII I would suggest upgrading to the latest version of the JDBC driver and seeing whether the problem still occurs or not. The latest version is 2.21.JC5. Venkatesh. |---------+----------------------------> | | Steve | | | <steve@nospam.net| | | > | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 08/05/2004 02:05 | | | PM | | | Please respond to| | | Steve | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------------------------| | | | To: informix-list@iiug.org | | cc: | | Subject: Smart Blob/JDBC -> getBytes returns null! | >--------------------------------------------------------------------------------------------------------------------------------| 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__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> I would suggest upgrading to the latest version of the JDBC driver and seeing whether the problem still occurs or not. The latest version is 2.21.JC5. Venkatesh. <img src="cid:10__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for Steve <steve@nospam.net>">Steve <steve@nospam.net> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>Steve <steve@nospam.net> Sent by: owner-informix-list@iiug.org 08/05/2004 02:05 PM Please respond to Steve</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: Smart Blob/JDBC -> getBytes returns null!</td></tr> </table> <tt>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. </tt> </body></html> --1__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71-- --0__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=09BBE47BDF86EA718f9e8a93df938690918c09BBE47BDF86EA71 Content-type: image/gif; name="pic27502.gif" Content-Disposition: inline; filename="pic27502.gif" Content-ID: <30__=09BBE47BDF86EA718f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBK