Thread: java object store
Helooo! i am a new user of postgres system. I am trying to store a java object into a postgresql table. I try but i didn;t succeed! my question is: Can I store a java object into a postgres table an execute query relative to it's methods in the database? | |||
IncrediMail - Email has finally evolved - Click Here
Attachment
dragos wrote: > i am a new user of postgres system. I am trying to store a java object > into a postgresql table. I try but i didn;t succeed! > > my question is: > Can I store a java object into a postgres table an execute query > relative to it's methods in the database? You can serialize the object and then store the serialized form of the object into a BLOB column. However, you will not be able to query the database on methods. Perhaps you can investigate object/relational mapping (JDO, OJB, Torque, Hibernate, etc). > *Email has finally evolved* - *_Click Here_* A blinking image in an email is "evolution"? ;) Erik Erik
You could also store the object in an bytea field... And to call the methods, you could use reflection. You just have to get these bytes from the database and call ClassLoader.defineClass()...very nice :-) On Mon, 04 Aug 2003 10:02:39 -0400 Erik Price <eprice@ptc.com> wrote: > > > dragos wrote: > > > i am a new user of postgres system. I am trying to store a java object > > into a postgresql table. I try but i didn;t succeed! > > > > my question is: > > Can I store a java object into a postgres table an execute query > > relative to it's methods in the database? > > You can serialize the object and then store the serialized form of the > object into a BLOB column. However, you will not be able to query the > database on methods. Perhaps you can investigate object/relational > mapping (JDO, OJB, Torque, Hibernate, etc). > > > *Email has finally evolved* - *_Click Here_* > > A blinking image in an email is "evolution"? > > ;) > > > > Erik > > > Erik > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- /~\ The ASCII Felipe Schnack (felipes@ritterdosreis.br) \ / Ribbon Campaign Analista de Sistemas X Against HTML Cel.: 51-91287530 / \ Email! Linux Counter #281893 Centro Universitário Ritter dos Reis http://www.ritterdosreis.br ritter@ritterdosreis.br Fone: 51-32303341