Getting transaction connection

[rmerizalde]

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

executeMethod

of

oracle.jbo.Transaction

. 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

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

 

[rmerizalde]

I already found a way to do it, using the methods <code> createStatement </code> and <code> createPreparedStatement </code> in the class <code> oracle.jbo.server.DBTransactionImpl </code>