Yogesh Gandhi wrote:Even if it returns different connections...then is it a problem?
Yes, it is exactly the problem.
Connection doesn't see changes made by other connection until the other connection commits. It's the very basic of database processing, though even us old dogs get burned by it from time to time.
(And it seems you cannot commit the connections on your own, probably because transactions are managed by the data source.)