How to acces BLOB field in postgres with JAVA ?

From: "dklee" <dklee(at)e4net(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: How to acces BLOB field in postgres with JAVA ?
Date: 2001-06-23 14:50:45
Message-ID: 9h2a7t$1q9q$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello? Please help me.
I have some problems using postgres SQL server.
Could you please help me ?

I will brefly explain my situation.

1) I am testing postgress ver 7.1.2

2) I am using
JDK1.3,
pgsql/jdbc/jdbc7.0-1.2.jar,
pgsql/share/java/postgresql.jar

3) I have created a table 'message like below

CREATE TABLE message (
mid int PRIMARY KEY,
message oid
);

4) I have prepared a program to access the table 'message' in JAVA.

ResultSet rs = s.executeStatement("SELECT * FROM message");

// Question ?
// How to access the field 'message' after executing the above statement
?
// As you know the field-type of 'message' is binary large object
type(BLOB).
// I have tested with rs.getBinaryStream(2), rs.getCharacterStream(2),
rs.getBytes(2)
// ,but all of them don't work well.
// Help me !

// If you know about question, please tell me how to read/write data to
BLOB field.

Browse pgsql-bugs by date

  From Date Subject
Next Message Micah Yoder 2001-06-23 17:33:48 Foreign keys don't work with inherited tables
Previous Message Hiroshi Inoue 2001-06-23 02:53:33 RE: Truncation Problems