problems with LONGVARCHAR in JDBC Oracle driver...

From: <seetharaman.n_at_usa.net>
Date: Wed, 12 May 1999 00:36:52 GMT
Message-ID: <7haif4$u60$1@nnrp1.deja.com>

Hi,

My environment is
Borland JDK1.1.6
Oracle7.3.4
Oracle JDBC Thin driver for Oracle7.3.4.0.2 / JDK1.1.1 (from Oracle) MS NT4.0

I'm having problems inserting and updating LONGVARCHAR fields. The Oracle JDBC docs recommend use of InputStream class, but when i call executeQuery, i get a NullPointerException. Any ideas?

      String MNGMTDISCUSSIONANALYSYS = a string with 70k chars
      java.io.StringBufferInputStream buff = new
java.io.StringBufferInputStream( MNGMTDISCUSSIONANALYSYS);
      int count = buff.available();
      callableStatement.setUnicodeStream(1,buff,count);

      callableStatement.executeQuery();//exception is thrown here!
      callableStatement.close();

situ

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 19:36:52 CDT