How do you write a Java object to MSAccess database?

[rjstanley]

Hi,

Let's assume I have an object created in Java from a class called Person with attributes name, address and age.

How might I write the entire object to a MS-Access table, rather than writing the individual attributes?

Any help would be appreciated including links to relevant websites, etc.

Thanks.

Robin.

[masijade]

Serialise the object to a ByteArrayOutputStream, then store that in a BLOB field.

Or, use XMLEncoder and write that to a text field. In either case, the object must be serialisable. Of course, the only thing you are saving is having to write a few lines of code yourself. Performance wise, it is almost guaranteed to be slower than simply saving the relevant bits of information. Restoring it through deserialisation will probably also be slower than simply initiating a new object using the bits of information read from the db.

And, storage-wise it is also, probably, less efficient.

[rjstanley]

Thank you very much for your help and advice. Much appreciated.

Robin.