This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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.