Questions on connection pooling and concurrent transactions
 

Hi,

I have a transaction with , lets say, 5 INSERT/UPDATE statements with some SELECT statements in between. I am using one connection for all the update/insert statements and another connection for SELECT statements from connection pool. Is there any problem doing do? Should I use the connection intended for UPDATE/INSERT statements for SELECT statements also?

Thanks,
IC