Re: Non-blocking SQL Execution

It's probably easier to create a non-blocking thread which
encapsulates the driver

And yes, the postgres driver blocks on the execute.

Dave
On 31-Oct-05, at 7:06 PM, Logan Bowers wrote:

> Hello,
>
>
>
> (sorry if this comes through twice)
>
>
>
> I'm running a web application that needs to run several queries
> against several databases
>
> to satisfy a single request. To minimize latency I'd like to be
> able to issue
>
> "<PreparedStatement Object>.executeQuery()" on each connection,
> allow the servers to
>
> execute the queries in parallel, and then only block when I attempt
> to fetch the first
>
> row.
>
>
>
> My anecdotal experience with JDBC drivers in general are that they
> block when you attempt
>
> to execute the query, not when you attempt to retrieve data. Is
> this the case for the
>
> Postgres driver? Does anyone have a feel for how hard it would be
> to modify the driver
>
> allow queries to be executed in the background? Thanks!
>
>
>
> Logan Bowers
>
>
>
>