Retrieving a Java object stored in Oracle ?

From: Emmanuel BOURG <smanux-news_at_dream.club-internet.fr>
Date: Mon, 06 Sep 1999 15:25:25 +0200
Message-ID: <37D3C0C5.EA9B918B@dream.club-internet.fr>

Hello,

I'm trying to retrieve a Java object stored as a long raw in a table. I use this kind of syntax :

   stmt = con.createStatement();
   rs = stmt.executeQuery("SELECT obj FROM data WHERE id=1");    rs.next();

   ObjectInputStream ois = new

ObjectInputStream(rs.getBinaryStream(1));                      	 
   o=(myObject)ois.readObject();         	 	 

   ois.close();  

   rs.close();
   stmt.close();

But i get this weird EOFException :

   java.io.EOFException

     at java.io.DataInputStream.readFully(DataInputStream.java)
     at java.io.ObjectInputStream.readFully(ObjectInputStream.java)
     at java.io.ObjectInputStream.inputArray(ObjectInputStream.java)
     at java.io.ObjectInputStream.readObject(ObjectInputStream.java)
     at java.io.ObjectInputStream.readObject(ObjectInputStream.java)
     at
java.io.ObjectInputStream.inputClassFields(ObjectInputStream.java)
     at
java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java)
     at java.io.ObjectInputStream.inputObject(ObjectInputStream.java)
     at java.io.ObjectInputStream.readObject(ObjectInputStream.java)
     at java.io.ObjectInputStream.readObject(ObjectInputStream.java)
     at myClass.myFunction(myClass:123)
         

I already had some troubles with readFully() that can't load data larger than 32Kb, and only with the Oracle Java Machine.

Any ideas ?

Thanks

Emmanuel BOURG Received on Mon Sep 06 1999 - 08:25:25 CDT