Re: serialized objects and JDBC driver

From: jlemcke(at)netspace(dot)net(dot)au
To: Stuart Barlow <sbarlow(at)peopledoc(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: serialized objects and JDBC driver
Date: 2001-03-13 23:15:01
Message-ID: 984525301.3aaea9f5a5b54@www.netspace.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


It might be worth your while having a look at JSX as an alternative to standard
Java serialization. JSX serializes Java objects to XML which, being plain text,
may be easier to manage.
I haven't done any serious work with JSX yet but it seems to work well in the
trials I've done.

Check out http://www.csse.monash.edu.au/~bren/JSX/

Have Fun,
John L.

Quoting Stuart Barlow <sbarlow(at)peopledoc(dot)com>:

>
> I am attempting to serialize objects into Postgresql using the
> JDBC driver. I am attempting to do this the standard way
> using Object and Byte streams.
>
> To store the object to the database in a text (blob) field I use the
> following code to turn my object into a byte[].
>
> // create the serialized object and store in the database
> EncryptionInfo serObj = new EncryptionInfo(32, 32);
> ByteArrayOutputStream bos = new ByteArrayOutputStream();
> ObjectOutputStream p = new ObjectOutputStream(bos);
> p.writeObject(serObj);
> p.flush();
> byte[] data = bos.toByteArray();
>
>
> This seems to go into the database with no errors.
> However when I retieeve the data using the following code...
>
> ByteArrayInputStream bis = new ByteArrayInputStream(data);
> ObjectInputStream p = new ObjectInputStream(bis);
> EncryptionInfo ei = (EncryptionInfo)p.readObject();
>
> I get the following error...
> InputStream does not contain a serialized object
>
>
> Thanks.
> Stuart Barlow.
>
> *************************************************************************
> Information in this email is confidential and may be privileged. It is
> intended for the named addressee(s) only. If you have received it in
> error please notify the sender immediately and delete it from your
> system. You should not otherwise copy, retransmit, use or disclose its
> contents to anyone.
> *************************************************************************
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

-------------------------------------------------
This mail sent through IMP: www.netspace.net.au

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Corey Mosher 2001-03-14 17:53:18 JDBC Errors
Previous Message David Wall 2001-03-13 22:15:18 Re: SQL CHAR type using setByte()