Hi there !

I'm storing an array of objects in a table column, using Hibernate.
An array of entities to be exact.

Does anyone know, how these objects would be represented in the table column ? E.g. how would a long[] be stored in the DB ?

I need to use a SQL insert statement to insert the ARRAY values.

Thanks
- Michael

It will be saved as blob


rate it if you are satisfied

Thanks for the quick reply !

I found this package from Oracle: utl_raw
One can use it to insert RAW blob data to the DB.

It doesn't seem to help with inserting arrays though.
Either way, i'm still not sure if my entities would be stored as long[].

mm .. maybe i should just create a many-to-many mapping after all :(.

what is the relation between long[] and many-to-many? Can you explain your case?

Yes sure ...

I have an array of long values.
Each long value refers to an entry in a Lookup Table.

So Eg.

public class SubjectCertificateAudit extends BaseEntity {

public long[] errorCodeIDs;

// getter and setters

}


, where every errorCodeID is a long value refering
to an entry in a lookup table.

Instead of saving the ID's as an array,
I could instead create a many-to-many mapping.

First wrap the ID as an entity:

public class ErrorCode extends BaseEntity {

}

, and then create the many-to-many association:

public class class SubjectCertificateAudit extends BaseEntity {

public List<ErrorCode> errorCodeIDs;

// getter and setters

}

This would ultimately create a join table, which would be
easier to populate using SQL insert statements.

Mm .. would have been nice to know how hibernate
would store an array of long values though.

I know it gets stored as a BLOB, but how does Hibernate identify
each array element inside of that BLOB.

Maybe it gets stored as comma delimited values,
or maybe all the elements in the array are just appended
(so every 4'th byte would be the start of a new element in a long[])... ?

I've browsed through all the reference DOC's I have on Hibernate,
none clarifying how Hibernate would store RAW BLOB data.

I would think that all the array elements would just be appended
to form one large BLOB. But that's just a guess ...