Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help with error: An internal error; Blob is null

Help with error: An internal error; Blob is null

From: Kei Takahashi <kxt158_at_psu.edu>
Date: Wed, 08 Sep 1999 16:01:21 -0400
Message-ID: <37D6C090.1DC2C9B5@psu.edu>


Hi,

I'm trying to write Java application to insert rows to the table in my Personal Oracle Lite DB. This table include a column with "LONG" type because one character string can exceed more than 2000 chars.

When I use "PreparedStatement" class in Java JDBC libraries, it throws a SQLException with "POL-5195: An internal error; Blob is null". I really wonder why this is happening and if someone can give me any insight.

If I hardcode PreparedStatement like;

PreparedStatement testStmt = con.prepareStatement ("INSERT INTO MTUBE
(PID, NAME, ANOTHERNAME, BEGLOC, ENDLOC, LENGTH, STRAND, PRODUCT,
SEQUENCE) VALUES ('T','e','st',1,2,3,'T','s','t')");

testStmt.executeUpdate();

It works!!

But once I use "set" functions like;

PreparedStatement loadDataStmt = con.prepareStatement("INSERT INTO MTUBE
(PID, NAME, ANOTHERNAME, BEGLOC, ENDLOC, LENGTH, STRAND, PRODUCT,
SEQUENCE) VALUES (?,?,?,?,?,?,?,?,?)");

loadDataStmt.setString(1, "1A");
loadDataStmt.setString(2, "GENE");
loadDataStmt.setString(3,  "GENE2");
loadDataStmt.setInt(4, 10);
loadDataStmt.setInt(5, 20);
loadDataStmt.setInt(6, 5);
loadDataStmt.setString(7,"+" );
loadDataStmt.setString(8, "A+");
loadDataStmt.setString(9, "TAKAHASHI");
loadDataStmt.executeUpdate();

It throws an exception with that message.

I really appreciate any insight into this problem. Thanks in advance!

Kei Received on Wed Sep 08 1999 - 15:01:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US