Reading bytes as a string from Db

Question

I have one table that has 2 fields one(container_id) for numeric type and another for byte type(coDearntainer_objects) . I would like to read the byte field(container_objects) as a string for corresponding (container_id) field.

How could I do this? I am using Postgresql Db Table Structure:

CREATE TABLE container
(
  ct_id numeric,
  container_object bytea
)

String sql="select container_objects from contanier where ct_id=232"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { ByteArrayOutputStream baos = new ByteArrayOutputStream(); ObjectOutputStream oout = new ObjectOutputStream(baos); Vector scontObject=new Vector(); scontObject.add("container_objects"); oout.writeObject(scontObject); System.out.println(oout.toString()); //System.out.println(baos.toString()); oout.close(); } i tried like this i got following result java.io.ObjectOutputStream@efd552 — Mohan
– Mohan, Commented Sep 22, 2010 at 9:45

Frank Heikens · Accepted Answer · 2010-09-22 09:34:47Z

4

Take a look at encode() to transform a bytea to a string.

answered Sep 22, 2010 at 9:34

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading bytes as a string from Db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related