AccessShareLock question

From: Clayton Graf <clayton(dot)graf(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: AccessShareLock question
Date: 2009-12-19 14:04:56
Message-ID: 7b2fe65d0912190604v671c2abjcf0f203ff028d5ac@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Ernst 2009-12-19 14:28:08 Re: Extracting SQL from logs in a usable format
Previous Message Filip Rembiałkowski 2009-12-19 11:59:33 Re: defining yuor own commands in PG ?