Dave Cramer wrote:
> AFAIK Postgres doesn't allow concurrent statements on the same
> connection, so I don't see how using multiple threads would work ?
The statements wouldn't need to be concurrent in the sense of happening
at the same time:
// stupid query
String sql = "SELECT * FROM quicklychangingtable";
PreparedStatement p1 = connection.prepareStatement(sql);
PreparedStatement p2 = connection.prepareStatement(sql);
ResultSet r1 = p1.executeQuery();
// do something else for a while
ResultSet r2 = p2.executeQuery();
What happens with r1? Might be ok, but i'm not sure if this is always true.
Till