I get an AccessShareLock in a simple select command and I am not using the FOR SHARE clause. The select is just "select * from controle". The connection is JDBC and the driver is postgresql-8.4-701.jar. What am I doing wrong?
This is the code: Class.forName(jdbc).newInstance(); Connection connection = DriverManager.getConnection(url, login, password); connection.setCatalog(database); connection.setAutoCommit(false); Statement st = connection.createStatement(); ResultSet rs = st.executeQuery("select * from controle"); while (rs.next()) { System.out.println(rs.getString(1)); } rs.close(); st.close(); Thanks, Clayton