BLOB / byte[]

I see that if I have an ERD for MySQL which contains a table with a field with a BLOB type, it converts to a class with a field of a sql.blob type. Is there a way to tell the system to use byte[] as to eliminate any dependency of SQL on the bean/dto object that is generated or am I force to change the DB datatype to VARBINARY even though BLOB is more appropriate?

Is there a global conversion table (modifiable?) where I tell the system to always use this translation or something of that sort.?

This is for Java based project using MySQL.

Thanks in advance
JP

Hello JPCoder,

I’m sorry that currently we do not support mapping blob to byte[] (at the moment byte[] can only map to binary data). We will investigate on the possibility on supporting this and let you know once there are any feedback. If you need any help, please do not hesitate to contact me again.

Best regards,
Rain

Hello JPCoder,

Our engineers had review this issue and confirm this cannot be supported. The reason is hibernate not support mapping BLOB to byte[]. We are sorry about this. If you need any help, please do not hesitate to contact me again.

Best regards,
Rain Wong