rmerizalde
Programmer
I have an application that needs to update thousands of
records. If I update the records within a while loop calling
setAttribute method of each row will take too much time.
I found a solution, use the
of
. The problems is I can't pass paremeters to the statement, for example if one of the attributes requires an input stream to be updated. Now, I can cast the transaction to a
records. If I update the records within a while loop calling
setAttribute method of each row will take too much time.
I found a solution, use the
Code:
executeMethod
Code:
oracle.jbo.Transaction
Code:
oracle.jbo.DBTransactionImpl [code] and get a connection using the method [code]getPersistendManagerConnection[code] and create a prepared statment, but this connection is not the one use by the transaction. Does anybody know how to get the transaction's connection or how to solve this problem? Note I have modified the parameters for tuning (including update batch)
Thanks