Lists: | pgsql-jdbc |
---|
From: | "jessica xingzc_he" <xingzc_he(at)hotmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | persistence of java objects |
Date: | 2004-10-30 23:05:44 |
Message-ID: | BAY24-F1bpH71yEXUIE00031b91@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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?
thanks
zhenchang
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | jessica xingzc_he <xingzc_he(at)hotmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: persistence of java objects |
Date: | 2004-10-31 15:38:33 |
Message-ID: | 418506F9.6010607@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Hi,
postgresql doesn't support this they way I suspect you are thinking of it.
How do other databases do this ?
dave
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?
>
> thanks
> zhenchang
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
From: | Ulrich Meis <kenobi(at)halifax(dot)rwth-aachen(dot)de> |
---|---|
To: | jessica xingzc_he <xingzc_he(at)hotmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: persistence of java objects |
Date: | 2004-10-31 20:29:57 |
Message-ID: | 200410312129.57710.kenobi@halifax.rwth-aachen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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
From: | Markus Schaber <schabios(at)logi-track(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Cc: | "jessica xingzc_he" <xingzc_he(at)hotmail(dot)com> |
Subject: | Re: persistence of java objects |
Date: | 2004-11-09 16:48:57 |
Message-ID: | 20041109174857.0a56cfb8@kingfisher.intern.logi-track.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
Hi, Jessica,
On Sat, 30 Oct 2004 17:05:44 -0600
"jessica xingzc_he" <xingzc_he(at)hotmail(dot)com> wrote:
> 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?
Currently, there's no support for general Java objects.
But maybe what you really need is a persistance framework. Hibernate
currently seems to be a reasonable one, and it supports PostgreSQL.
HTH,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com