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 persist with big files. For smaller files like 13KB this example works great and several in simultaneous. 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 = "">
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
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Follow-Ups:
- Re: Connection lost
- From: Joshua Tolley
- Re: Connection lost
- Prev by Date: Re: use of IN() with literals
- Next by Date: How to return an Int4 when subtracting dates/timestamps
- Previous by thread: use of IN() with literals
- Next by thread: Re: Connection lost
- Index(es):
![]() |