Thread: NullPointerException in blobtest (JDBC)

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)

Here's what happens when I run the program:

[ellen@ellen Work]$ jdb blobtest "jdbc:postgresql://localhost:5432/webdb" ellen foo debug
Initializing jdb...
0xb0:class(blobtest)
> run
run blobtest jdbc:postgresql://localhost:5432/webdb ellen foo debug 
PostgreSQL blobtest v6.3 rev 1
running ...
main[1] 
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=postgresql.Driver,postgresql.Driver@3f720c84]
Connecting to Database URL = jdbc:postgresql://localhost:5432/webdb
DriverManager.getConnection("jdbc:postgresql://localhost:5432/webdb")   trying
driver[className=postgresql.Driver,postgresql.Driver@3f720c84]
-- listing properties --
password=foo
PGHOST=localhost
user=ellen
PGDBNAME=webdb
Protocol=postgresql
PGPORT=5432
Using postgresql.jdbc2.Connection
getConnection returning driver[className=postgresql.Driver,postgresql.Driver@3f720c84]
Connected...Now creating a statement

----------------------------------------------------------------------
Testing postgresql large object api

Gaining access to large object api
Large Object initialised
Test 1 Creating a large object

Creating a large object
got large object oid=19521
got large object obj=postgresql.largeobject.LargeObject@c2ae0c84
Opening test source object
Copying file to large object
Block size=2048 offset=0
Exception caught.
java.lang.NullPointerException
java.lang.NullPointerExceptionat java.io.Writer.write(Writer.java:130)at
java.io.PrintStream.write(PrintStream.java:271)atjava.io.PrintStream.print(PrintStream.java:426)at
java.io.PrintStream.println(PrintStream.java:545)atjava.lang.Throwable.printStackTrace(Throwable.java:195)at
java.sql.SQLException.<init>(SQLException.java:103)atpostgresql.util.PSQLException.<init>(PSQLException.java:42)at
postgresql.fastpath.Fastpath.fastpath(Fastpath.java:141)atpostgresql.fastpath.Fastpath.fastpath(Fastpath.java:188)at
postgresql.largeobject.LargeObject.write(LargeObject.java:173)at
postgresql.largeobject.LargeObject.write(LargeObject.java:188)atblobtest.ownapi_test1(blobtest.java:105)at
blobtest.ownapi(blobtest.java:76)atblobtest.<init>(blobtest.java:50)at blobtest.main(blobtest.java:187)at
sun.tools.agent.MainThread.runMain(NativeMethod)at sun.tools.agent.MainThread.run(MainThread.java:49)
 

Current thread "main" died. Execution continuing...
> 
blobtest exited

The line that generates the exception (blobtest.java:105) is indicated below:
   // copy the data   System.out.println("Copying file to large object");   byte buf[] = new byte[2048];   int s,tl=0;
while((s=fis.read(buf,0,2048))>0) {     System.out.println("Block size="+s+" offset="+tl);
 
***   obj.write(buf,0,s);     tl+=s;   }  
Any ideas?
            Ellen

> 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();

At 08:41 +0300 on 20/06/1999, Tatsuo Ishii wrote:


> +     s.executeUpdate("commit");
> +

Shouldn't this be db.commit() instead?

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

>> +     s.executeUpdate("commit");
>> +
>
>Shouldn't this be db.commit() instead?

Thanks for the correction!
--
Tatsuo Ishii

hello, i've tried unsubscribing to this list many times and it's not
ywt happened. Is there any reason for this? thanks.
--
jeff eidsness
-------------------------------------
webmaster: http://thatmusicplace.com/
--