The problem that I am facing is that, My connection has autoCommit set to false. I execute a Stored proc which inserts a row in the table. Furthur down I fire a select query which tries to read the row which has just been inserted. But the select query returns me zero rows.
But if I give the database name similar to the user id and then add it inside my properties file then this select query fires and returns me a row which was inserted by the stored proc.