Re: persistence of java objects

On Sunday 31 October 2004 01:05, jessica xingzc_he wrote:
> hi,
>
> Does postgresql support this? if i want a column of a table for the
> persistence of instance of java objects, and use ResultSet.getObject() and
> ResultSet.updateObjecct() to access them. if so, what data type the column
> should be?

If you use a standard type like integer or varchar, you can do things like

setObject(1,new Integer(5));
setObject(2,"something");

which would be equivalent to

setInteger(1,new Integer(5));
setString(2,"something");

If you want to store complex objects in the database then they should
implement the java.io.serializable interface. Thereby you can store them in a
byteArray or push them into a bytearraystream and write the result with the
usual methods into the database.
A simple serialization example is here for java.io.File:

http://java.sun.com/j2se/1.3/docs/guide/serialization/spec/examples.doc1.html

Regards,

Uli