Nihar, based on your jdbc version you can use java.sql.Blob as the datatype to retrieve this data (jdbc 2.0). Regards, Ajith
-----Original Message----- From: Nihar Vaidya [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 10:40 PM To: '[EMAIL PROTECTED]' Subject: [DB2EUG] LONG RAW and BLOB. Hello, We have a java application which runs against Oracle. Recently we added DB2 support also. One of the Oracle tables we use has a field with datatype LONG RAW. For DB2, we defined the the equivalent table field as BLOB(2G). In the java application, we try to read this field into a byte[] array. However, this returns a ClassCastException for DB2. What is the best way to implement this field for DB2 ? Will using LONG VARCHAR FOR BIT DATA help ? Doesn't it have a limitation of 32700 bytes ? Thanks. - Nihar - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
