I would like to debug the database connection that my application is using.
The scenario is very simple:
1- My application connects to a Database and get a connection.
2- My applications sends SQL commands the database and changes the data
3- Now I would like to query the database and see the changes, but my applications did not perform a commit yet.
If I use the integrated database explorer to connect to the database, I will get a new connection, so I can not see the pending changes.
I would like to be able to use the connection adquired by my application in order to have a nice tool to analise the database state, to help me track bugs.
It could be as simple has a connection pool with one connection, that always returns the same connection even if it is still in use.
You can call this feature, Connection Debugger 🙂
Can it be done with the current MyEclipse version? If not, could you consider adding this marvelous feature?
Thanks