Re: serialized objects and JDBC driver - Mailing list pgsql-jdbc

From jlemcke@netspace.net.au
Subject Re: serialized objects and JDBC driver
Date
Msg-id 984525301.3aaea9f5a5b54@www.netspace.net.au
Whole thread Raw
In response to serialized objects and JDBC driver  (Stuart Barlow <sbarlow@peopledoc.com>)
List 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@peopledoc.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>


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


pgsql-jdbc by date:

Previous
From: "David Wall"
Date:
Subject: Re: SQL CHAR type using setByte()
Next
From: Corey Mosher
Date:
Subject: JDBC Errors