From: | Ole Streicher <ole-usenet-spam(at)gmx(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Appending to a large object |
Date: | 2003-07-29 12:43:44 |
Message-ID: | 16166.27648.356737.926607@ebp00439.ebp.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
sorry for bothering you again.
I want to append some data to a LargeObject, but I could not find out
how to do that. When I simply do
ResultSet rs = queryStmt.executeQuery();
try {
if (rs.next()) {
int oid = rs.getInt(1); // or wherever my Id is
LargeObject obj = lobj.open(oid);
System.out.println("SIze is " + obj.size();
OutputStream os = obj.getOutputStream();
os.write(...); // here I want to append to the existing stream
obj.close();
dbConn.commit();
}
} catch (SQLException e) {
dbConn.rollBack();
} finally {
rs.close();
}
It is not appended to the stream but overwritten from the beginning.
The LargeObject defines some variables SEEK_SET, SEEK_END, SEEK_CUR
that seem to be useful for my purpose; however I could not find the
method to use them.
Can you give me a hint how I can append to an existing LargeObject
(using the OutputStream interface)?
Ciao
Ole
P.S. Is there a Java standard API documentation (javadoc-converted)
of the extensions (es. LargeObject handling) available?
From | Date | Subject | |
---|---|---|---|
Next Message | Johann Uhrmann | 2003-07-29 13:46:17 | Asynchronous NOTIFY available? |
Previous Message | Peter Eisentraut | 2003-07-29 12:20:18 | Re: Passing server_encoding to the client is not future-proof |