I am using Java and JDBC and I would like to know if there would be a lock on the table if I use nested resultset on the same table? database is apache derby but i guess any other database is also the same. Please help.
Optional Information:
OS: Windows XP; Browser: Firefox