Re: Connections/Statements/ResultSets (Was: Re: Pooling

I found something in http://java.sun.com/products/jdbc/driverdevs.html

A.1.6 Support Multithreading
...
 Some drivers may allow more concurrent execution than others, but
developers should be able to assume fully concurrent execution. If the
driver requires some form of synchronization, then the driver should
provide it. In this situation, the only difference visible to the
developer should be that applications run with reduced concurrency.

For example, two Statement objects on the same connection can be
executed concurrently, and their ResultSets can be processed
concurrently (from the perspective of the developer). Some drivers will
provide this full concurrency. Others may execute one statement and wait
until it completes before sending the next one.


Regards.
JP

Michael Paesold wrote:

>João Paulo Caldas Ribeiro wrote:
>
>
>
>
>>I dont know about the JDBC specs but i remember that i used a Oracle
>>JDBC driver that only supported one 1 connection --> 1 resultset at time.
>>I will try to find something about the specs.
>>
>>
>
>
>Probably the specs really don't specify this, but they will require that
>the methods getResultSetConcurrency(), getResultSetHoldability() and
>getResultSetType() return the correct values.
>
>Regards.
>Michael
>
>
>
>
>


--
----------------------------------------------------------------------------
MobiComp - Mobile Computing & Wireless Solutions
phone: +351 253 305 250     fax: +351 253 305 251
web: http://www.mobicomp.com
----------------------------------------------------------------------------