Thread: java object store

java object store

From
"dragos"
Date:
   
 
 
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

Re: java object store

From
Erik Price
Date:

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


Re: java object store

From
Felipe Schnack
Date:
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