How to get multiple result sets

From: "Guthrie, John" <JGuthrie(at)air(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to get multiple result sets
Date: 2002-06-21 21:03:17
Message-ID: F779B05379CAD2118BD20090273017BF03E79C4E@DC1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

what is the best way to send multiple queries into the database so that I
can run Statement.execute() and get back multiple result sets? i tried
something like:

PreparedStatement ps = "select * from table1; select * from table2";

running that I get back only a single result set...

thanks.
john

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Lockhart 2002-06-21 22:21:00 Re: timezone incompatibility
Previous Message Paul Bethe 2002-06-21 20:19:03 Re: New Patch For CallableStmt (against current CVS)