Sometimes it's running ok and finished properly. Sometimes I got the following exception after running 2.5 hours.
Thanks a lot for any suggestion and help. We use oracle 10.2 and jdk1.4 library here.
> Exception: java.lang.NullPointerException
> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:669)
> at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
> at oracle.jdbc.driver.T2CConnection.createTemporaryBlob(T2CConnection.java:2039)
> at oracle.sql.BLOB.createTemporary(BLOB.java:590)
This isn't particularly helpful, but I always use the setBinaryStream() API on my BLOBs and not the Oracle specific APIs. As a debugging exercise, it might be useful to see if that API gives the problem too.
In case you're still looking for a solution: there's an Oracle specific way to set/update BLOBs and CLOBs without using a temporary BLOB/CLOB. I've described it previously here and here. I'm using this method for a long time without any problems.
This will lead to an Oracle-specific code, of course.
Joined: Oct 23, 2013
Thanks for your help, Martin and Muhammad. These suggestions are helpful. I'm changing the code and testing now.