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

largeobjects deadlock ?

From: andy petrella <andy(dot)petrella(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: largeobjects deadlock ?
Date: 2005-10-25 23:49:41
Message-ID: 7159e12c0510251649r48a52bady@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
HI all,

I have somme problem with largeobjects setting in a preparedstatement, here
is the code with the problem in comment // :

[...]
 db.setAutoCommit(false);
[...]
 LargeObjectManager lobj = pgdb.getLargeObjectAPI(); //pgdb is a
PGConnection
 int loid = lobj.create();
 System.out.println("loid : " + loid); //this give 359648
 LargeObject image = lobj.open(loid);
 int s, count = 0;
 byte buf[] = new byte[2048];
 while ((s = affiche.read(buf, 0, buf.length)) > 0){ //affiche is an
InputStream
 count += s;
 image.write(buf, 0, s);
 }
 BlobInputStream b = new BlobInputStream(image);
 addDVD.setBinaryStream(4, b, count); //addDVD is an PreparedStatement
 //addDVD.setNull(4, java.sql.Types.BINARY); // --> all work well if I
decomment this and comment the preceding
 image.close();
 affiche.close();
[...]
System.out.println("addDVD : " + addDVD.toString()); //<stream of 6503
bytes> for the fourth prm (bytea)

 int update = addDVD.executeUpdate(); // -->deadlocking here !!!
 System.out.println("update = " + update); //never pass here
 db.setAutoCommit(true);
[...]

Am I setting the bytea in the rigth manner ? Else, how may I do that , where
are my mistakes ?

Thx u all.

andy

Responses

pgsql-jdbc by date

Next:From: andy petrellaDate: 2005-10-26 00:42:22
Subject: Re: largeobjects deadlock ?
Previous:From: Oliver JowettDate: 2005-10-25 20:58:44
Subject: Re: patch: ResultSetTest.java

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