Hi Ishita,
You can create any number of statements using the same connections at a time. Each statement can have a resultset each at a time. There is no limit as such except the database level limits like max number of open cursors etc.
But I think you cant run two SQL statements using two statements at a time concurrently (possibly using different threads as in
servlets). I think this is restricted by database and not driver. If you fire two SQLs using different statements out of the same connection, the second one will wait for the first one to complete the execution.
I have based Oracle database in my explanation.
Does any one have any other explanation for this?