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

Reply via email to