[Squirrel-sql-users] Squirrel locks DB2?

[Rasmus W. <ras...@gm...>]

Hi, everyone.

Our DBA dislikes that I use Squirrel-SQL. He says that it creates locks in
the db. I don't understand this, it's extremely rare that I forget to
commit (we are not allowed to use autocommit, regardless of what client we
use) a transaction. We use DB2 and I connect to the databases using the IBM
DB2 Net driver. I don't do anything people using other clients (AQT is
popular here) don't do.

How can I stop these locks from occurring? According to the DBA it's a
generic JDBC issue that has no solution, is he right?

Thanks,
Rasmus