How to Modify DB Records Using JDBC Connector FrameWork

33 Views

Hi everyone,

I am using the JDBC Connector Framework to connect to an Oracle database. To retrieve data from the database I am currently using the INativeQuery which works fine for me.

That's how I'm using it.

INativeQuery query = connection.newNativeQuery();

ResultSet result = (ResultSet)query.execute(sqlString);

Although I can use the same syntax to insert, update or delete records in the database, this same syntax does not give me information about how many records were modified.

In the Connection API there is a method that uses the IExecution object:

IExcution e = connection.newExecution();

int updatedRecs = e.execute(IOperation);

Although the syntax seems to be straightforward, I don't know how to define the IOperation object.

Does anyone have any idea how to do it or retrieve the number of updated records in a different way?