| 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: | Whole Thread | Raw Message | 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
| 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 ? |