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
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 ? |