I am in a process of developing a web application. I am just thinking of what would be the best way to use Connection object.
I am currently adding the connection object to the user's session and using it, but I encounter some problem (Connection is busy error) when I execute a query inside a while loop of the resultset of the first query, so in those cases, I am creating a new connection and executing the outer query, so that the inner query can use the connection object from the Session.
Could you guys give me a better in sight on how to handle this?
I am using jdbc odbc bridge to connect to my SQL server.
Note, I am not facing any issues with the code when I was using Ms-Access as a database.