Received: from ext16.sra.co.jp (IDENT:root@ykh28DS15.kng.mesh.ad.jp
	[133.205.214.15]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA33565
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 20 Jun 1999 01:47:10 -0400 (EDT)
	(envelope-from t-ishii@ext16.sra.co.jp)
Received: from ext16.sra.co.jp (t-ishii@localhost [127.0.0.1])
	by ext16.sra.co.jp (8.8.8/8.8.8) with ESMTP id OAA01611;
	Sun, 20 Jun 1999 14:41:57 +0900
Message-Id: <199906200541.OAA01611@ext16.sra.co.jp>
To: Ellen Spertus <spertus@ella.mills.edu>
cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] NullPointerException in blobtest (JDBC) 
From: Tatsuo Ishii <t-ishii@sra.co.jp>
Reply-To: t-ishii@sra.co.jp
In-reply-to: Your message of 19 Jun 1999 21:11:41 MST.
	<19990620041141.44173.qmail@ella.mills.edu>
Date: Sun, 20 Jun 1999 14:41:57 +0900
Sender: t-ishii@ext16.sra.co.jp

> I am getting a NullPointerException when running blobtest.  I am using the latest version of everything:
> 
> - postgresql 6.5
> - jdk 1.2
> - jdbc6.5-1.2 
> - the version of blobtest.java that came with postgresql 6.5
> - OS: RH6.0
> - x86 (AMD K6)
[snip]

6.5 Large Objects requires each access to LO being inside a
transaction. Try following patches.  Peter, can you check them?
---
Tatsuo Ishii
----------------------------------------------------------
*** blobtest.java~	Tue Jan 13 11:19:16 1998
--- blobtest.java	Sun Jun 20 14:10:59 1999
***************
*** 40,45 ****
--- 40,46 ----
      // Connect to database
      System.out.println("Connecting to Database URL = " + url);
      db = DriverManager.getConnection(url, usr, pwd);
+     db.setAutoCommit(false);
      System.out.println("Connected...Now creating a statement");
      s = db.createStatement();
      
***************
*** 52,57 ****
--- 53,60 ----
      // Now run tests using JDBC methods
      //jdbcapi(db,s);
      
+     s.executeUpdate("commit");
+ 
      // Finally close the database
      System.out.println("Now closing the connection");
      s.close();