Home » Developer & Programmer » Precompilers, OCI & OCCI » problem with getFailedRowCount() in BatchSQLException
problem with getFailedRowCount() in BatchSQLException [message #608673] Fri, 21 February 2014 23:43
jenasatyabrata82@gmail.co
Messages: 1
Registered: February 2014
Junior Member
Hi,
found some bug ,with getFailedRowCount() method in BatchSQLException.
Using gcc3.4,redhat linux kernel 2.6,oracle db:11.2.0.1(64 bit)

Problem:
Suppose i am sending 10 rows to database in a batch
and suppose the record nos. from 0th to 4th got inserted in table succesfully
and record nos. 5th to 9th got failded ,due to violating unique constraint on table.

>Then while running program using OCCI library 11.2(instant client) against oracle db 11.2.0.1(64 bit)
then getFailedRowCount() returns only "ROWNO 5th failed" ,repeatedly 5 times.

But while running the same program using OCCI library 11.2 against oracle db 10.2,
getFailedRowCount() returns :
ROWNO FROM 5TH TO 9TH GOT FAILED(which is actually correct).

So with 11.2 oracle db,why getFailedRowCount() returning wrong result.

please provide some solution.
Previous Topic: Proc INTERNAL ERROR: Failed Assertion
Next Topic: What's the difference bwtween createConnectionPool and createStatelessConnectionPool in OCCI
Goto Forum:
  


Current Time: Thu Mar 28 07:09:04 CDT 2024