From: | Hernan Danielan <hernandanielan(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | LargeObject |
Date: | 2010-05-13 05:23:03 |
Message-ID: | AANLkTikPvFB_9Hs11OXVP8TdR2q81PFWBapoOjme28zA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello! I am using postgress 8.4. I am trying to save to my DB a Large Binary
Object, let's say 1.4MB. I read that LargeObjectAPI should be used.
I have a problem that sometimes i can store the file and some others i get
an exception of
>>org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
>>java.net.SocketException: Socket closed
I try to create a connection for each object but the errors perssist with
big files. For smaller files like 13KB this example works great. Does
anybody have this problem??? I debug the applcation and I am getting the
socket close exception during obj.write (....) here is a bit of the code
mDbConnector.setAutoCommit(false);
// Get the Large Object Manager to perform operations with
LargeObjectManager lobj =
((org.postgresql.PGConnection)mDbConnector).getLargeObjectAPI();
// Create a new large object
int oid = lobj.create(LargeObjectManager.READ | LargeObjectManager.WRITE);
// Open the large object for writing
LargeObject obj = lobj.open(oid, LargeObjectManager.WRITE);
byte []data = cont.getData();
obj.write(data,0,data.length);
obj.close();
PreparedStatement statement = mDbConnector.prepareStatement("INSERT INTO
publicitiescontent (IdPublicities,MimeType,FileName,Title,Data) VALUES
(?,?,?,?,?)");
statement.setBigDecimal(1, new BigDecimal(publicityId));
statement.setString(2, cont.getMimeType());
statement.setString(3, cont.getFileName());
statement.setString(4, cont.getNombre());
statement.setInt(5, oid);
statement.execute();
statement.close();
mDbConnector.commit();
Thanks in advance,
Hernan
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Northcott | 2010-05-13 08:46:51 | Re: Get details of user locking a record? |
Previous Message | Mladen Gogala | 2010-05-13 01:47:24 | Re: Interrupt |