Vishu Singhvi Vishu Singhvi - 1 year ago 136
Java Question

Queries returning multiple result sets

I have a

database and am running the following query:

select * from projects; select * from user

The above query returns two result sets at once, and I cannot fire both queries separately. How can I handle both the result set at once in a Java class?

Answer Source

The answer: it is NOT possible. The only way: Run them as separate queries.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download