suppose i have 5 tables ...say: A , B , C ,D , E.
i wanna read from table A and B and update C. Then i have to read from C and D and insert in to E. and if there is exception i wanna rollback the entire process. Now is it possible to insert in to table C and read from it again without commiting it ? . i mean can i read from table C if i have not commited the data in table C. i need to clarify that i am using the SAME Connection object for getting the Statement object.
Also can you suggest me the best way of designing this in multithreaded environment >