Help with error: An internal error; Blob is null

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