Hi,

I try to do a criteria search on a byte[] field persisted in mysql with @Lob annotation.
I always get an empty result :( Is there a special way for submitting binary data to the criteria api?

The byte[] field is persisting a mac address (6 bytes)

Here the example:

======== annotated class ==========
public class DhcpEntry {

@Id
@GeneratedValue
private long id;

@Lob
@Column(length=6)
private byte[] bootMac;
...
}
================================

== Entry in mysql is persisted ok! (this is an export) ==

INSERT INTO `netboot_DhcpEntry` (`id`, `bootMac`, ..) VALUES (1, 0x002257a078e0, ..);
=================================

== Search is done this way ==

mac is byte[] and filled up right: mac[0] = 0x00; mac[1] = 0x22; mac[2] = 0x57,...

..
crit.add(Restrictions.eq("bootMac", mac));
..

I already tried Restrictions.like but nothing found :(
=======================


Thanks for any help!

muffinman, you'll get lots of problems trying to query lobs and clobs (most DBs don't support this). A healthy suggestion: Change the type to be a string, and save the mac as an HEX string.

Dont know if this would help but still see if you can try.



Cheers!!!

Also what augusto.rodriguez says is true.. even i faced issues with it