Skip site navigation (1) Skip section navigation (2)

Re: Socket close exception

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Hernan Danielan <hernandanielan(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Socket close exception
Date: 2010-05-14 15:57:23
Message-ID: AANLkTilhlP9JOpKsHTzx9ti3hUBcIbYWF4wThOusKt2l@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Anything interesting in the postgres log when this happens?
---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3501 F
www.truviso.com



On Fri, May 14, 2010 at 8:09 AM, Hernan Danielan
<hernandanielan(at)gmail(dot)com> wrote:
> 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

In response to

Responses

pgsql-jdbc by date

Next:From: Krutik FrankDate: 2010-05-15 16:13:44
Subject: Exception 'org.postgresql.util.PSQLException' could not be instantiated
Previous:From: Hernan DanielanDate: 2010-05-14 15:09:21
Subject: Socket close exception

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group