public inbox for [email protected]
help / color / mirror / Atom feed[Pljava-dev] How to read LargeObject with pljava?
4+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] How to read LargeObject with pljava?
@ 2009-06-13 08:53
0 siblings, 0 replies; 4+ messages in thread
From: @ 2009-06-13 08:53 UTC (permalink / raw)
Hi everybody!
Have some code to read LargeObject from db and create digest message for
the it content. The code generate an error attemtting to read a portion
of LO.
Could anybody give an example how to read LO from database?
I'm using jre1.6.0.13, pljava1.4.0, postgresql8.3.7.
Thanks.
import java.io.FileOutputStream;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Logger;
import org.postgresql.largeobject.LargeObject;
import org.postgresql.largeobject.LargeObjectManager;
public class ServerDigestCreator {
public static String
anotherCreateStrDigest(org.postgresql.pljava.internal.Oid lObjectId)
throws SQLException,NoSuchAlgorithmException
{
String digest = null;
java.sql.Savepoint sp = null;
if(lObjectId==null) return null;
java.sql.Connection aConnection =
DriverManager.getConnection("jdbc:default:connection");
try{
sp = aConnection.setSavepoint();
org.postgresql.pljava.internal.LargeObject lo =
org.postgresql.pljava.internal.LargeObject.open(lObjectId,
org.postgresql.pljava.internal.LargeObject.INV_READ);
MessageDigest aDigest = MessageDigest.getInstance("md5");
if(lo==null) {
aConnection.releaseSavepoint(sp);
return digest;
}
byte buf[] = new byte[2048];
int s=0;
while((s = lo.read(buf))!=0)
<---------------------- Error occurs here
=============================================================
aDigest.update(buf);
byte[] digestByteArray = aDigest.digest();
BigInteger tempBI = new BigInteger(digestByteArray);
digest = tempBI.toString();
lo.close();
aConnection.releaseSavepoint(sp);
}
catch(SQLException ex)
{
if(sp!=null)
aConnection.rollback(sp);
Logger.getAnonymousLogger().info("ERROR: " + ex.getMessage()
+ "\n");
throw new SQLException(ex.getMessage());
}
return digest;
}
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] How to read LargeObject with pljava?
@ 2009-06-13 09:43
2009-06-17 13:12 ` [Pljava-dev] How to read LargeObject with pljava?
0 siblings, 1 reply; 4+ messages in thread
From: @ 2009-06-13 09:43 UTC (permalink / raw)
Hi everybody!
Have some code to read LargeObject from db and create digest message for
the it content. The code generate an error attemtting to read a portion
of LO.
Could anybody give an example how to read LO from database?
I'm using jre1.6.0.13, pljava1.4.0, postgresql8.3.7.
Thanks.
import java.io.FileOutputStream;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.logging.Logger;
import org.postgresql.largeobject.LargeObject;
import org.postgresql.largeobject.LargeObjectManager;
public class ServerDigestCreator {
public static String
anotherCreateStrDigest(org.postgresql.pljava.internal.Oid lObjectId)
throws SQLException,NoSuchAlgorithmException
{
String digest = null;
java.sql.Savepoint sp = null;
if(lObjectId==null) return null;
java.sql.Connection aConnection =
DriverManager.getConnection("jdbc:default:connection");
try{
sp = aConnection.setSavepoint();
org.postgresql.pljava.internal.LargeObject lo =
org.postgresql.pljava.internal.LargeObject.open(lObjectId,
org.postgresql.pljava.internal.LargeObject.INV_READ);
MessageDigest aDigest = MessageDigest.getInstance("md5");
if(lo==null) {
aConnection.releaseSavepoint(sp);
return digest;
}
byte buf[] = new byte[2048];
int s=0;
while((s = lo.read(buf))!=0)
<---------------------- Error occurs here
=============================================================
aDigest.update(buf); byte[] digestByteArray
= aDigest.digest();
BigInteger tempBI = new BigInteger(digestByteArray);
digest = tempBI.toString(); lo.close();
aConnection.releaseSavepoint(sp);
}
catch(SQLException ex)
{ if(sp!=null)
aConnection.rollback(sp);
Logger.getAnonymousLogger().info("ERROR: " + ex.getMessage()
+ "\n");
throw new SQLException(ex.getMessage());
}
return digest;
}
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] How to read LargeObject with pljava?
2009-06-13 09:43 [Pljava-dev] How to read LargeObject with pljava?
@ 2009-06-17 13:12 `
2009-06-18 17:52 ` [Pljava-dev] How to read LargeObject with pljava?
0 siblings, 1 reply; 4+ messages in thread
From: @ 2009-06-17 13:12 UTC (permalink / raw)
Does org.postgresql.pljava.internal.LargeObject object and methods
read/write/open/close still being experimental or methods have to work
correctly in PLJava 1.4.0?
^ permalink raw reply [nested|flat] 4+ messages in thread
* [Pljava-dev] How to read LargeObject with pljava?
2009-06-13 09:43 [Pljava-dev] How to read LargeObject with pljava?
2009-06-17 13:12 ` [Pljava-dev] How to read LargeObject with pljava?
@ 2009-06-18 17:52 `
0 siblings, 0 replies; 4+ messages in thread
From: @ 2009-06-18 17:52 UTC (permalink / raw)
On Wed, 17 Jun 2009, Oleg Vasylenko wrote:
> Does org.postgresql.pljava.internal.LargeObject object and methods
> read/write/open/close still being experimental or methods have to work
> correctly in PLJava 1.4.0?
Looking at the source code, it doesn't work at all. With the attached
patch it mostly works. LargeObject.create still doesn't work and you will
get warnings about relcache reference leaks, but these are harmless and
can be ignored.
Kris Jurka
-------------- next part --------------
Index: src/C/pljava/type/LargeObject.c
===================================================================
RCS file: /cvsroot/pljava/org.postgresql.pljava/src/C/pljava/type/LargeObject.c,v
retrieving revision 1.14
diff -c -r1.14 LargeObject.c
*** src/C/pljava/type/LargeObject.c 28 May 2006 22:01:48 -0000 1.14
--- src/C/pljava/type/LargeObject.c 18 Jun 2009 17:07:49 -0000
***************
*** 23,38 ****
*/
jobject LargeObject_create(LargeObjectDesc* lo)
{
- jobject jlo;
- Ptr2Long loH;
-
if(lo == 0)
return 0;
! loH.longVal = 0L; /* ensure that the rest is zeroed out */
! loH.ptrVal = lo;
! jlo = JNI_newObject(s_LargeObject_class, s_LargeObject_init, loH.longVal);
! return jlo;
}
extern void LargeObject_initialize(void);
--- 23,32 ----
*/
jobject LargeObject_create(LargeObjectDesc* lo)
{
if(lo == 0)
return 0;
! return JNI_newObject(s_LargeObject_class, s_LargeObject_init, Invocation_createLocalWrapper(lo));
}
extern void LargeObject_initialize(void);
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-06-18 17:52 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-06-13 08:53 [Pljava-dev] How to read LargeObject with pljava?
2009-06-13 09:43 [Pljava-dev] How to read LargeObject with pljava?
2009-06-17 13:12 `
2009-06-18 17:52 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox