Hi,
In the J2EE project I work now we are using DB2 databases and we interact with them through DB Visualizer 4.1, with auto-commit set to true. Third parties in the project said that we are causing tables locking problems due to the fact that we are using DB Visualizer. They say we should use the command line (db2 console prompt) or command editor, provided by IBM with the installation of DB2 client. But I think these are too rudimentary. Also, they said that a team member in our team has definitively locked a table with a simple select and that their database admin has to manually type some commands in an administration tool to release the lock!! I do not think that DB Visualizer is that dummy and that it does not make locking management by itself!
That is why I think that the real problem is that the database is not well configured, but before checking that with them, I would like to know if possible, if anyone experienced locking issues in a team due to use of DB Visualizer (in particular DB Visualizer 4.1)?