Putting Serializable Classes into SQL?

Question

Here's the situation. I have a bunch of objects that implement Serializable that I want to store in a SQL database. I have two questions

1. Is there a way to serialize the object directly into the database
2. Is that the best way to do it or should I
   2. Write the object out to a formatting String and put it in the database that way and then parse it back out
   3. Write each member to the database with a field that is unique to each object

Answer 1

Its generally not a good idea to try and put any sort of object (serialized/deliminated) in your SQL because modifying them is always a bitch.

It sounds like you're on the right track with idea 2. Is this a one-to-many situation? (because then a xref would obviously be the right answer) or even a foreign key would be better. cheers.