Hi Ranchers, i am using oracle 22.214.171.124.0, and using ojdbc14.jar for accessing in my java program. i have some process to be run which has batch update. sometimes when i run these process, i get exception which is pasted below.
The occurance is very very rare. i dont have any idea in which case its coming. i tried to follow this up, but sometimes it doesnt come for days and suddenly this problem may come.
I tried googling and am not able to figure out the solution for this. please help...
this method. Put a debug statement to print all the values that are bounded to the SQL, mostly one of the parameter will be "null". If so then you need to fix this by calling setNull(int,int) api of the prepared statement to actually set the null value.
Joined: Oct 03, 2005
Actually i found that there was a problem in ojdbc14.jar which gives the same error. so i was thinking if this could be because of that.
And there can be no null values for this update statement since this is working in most cases and not working in only very rare conditions. and in each case, its only one value thts updated.