How do I store a Java ADT in a database?
843859Mar 30 2008 — edited Mar 30 2008Hey everyone,
I'm working on a java project and trying to implement persistent data using a java db database. One class I'm working with is a Room class and one of its fields is a list of all the people that are currently in that room. I'm new to databases so I'm not sure how to store an array like data structure in a database. Should I use a CLOB? I noticed ResultSet has a getArray() method but I can't find any documentation on an SQL ARRAY type. Is there an easy way to go about this or will I need to decide on a large fixed length field and read through that to construct my array?