stored procedure call in jdbc
Andreas Tille
tillea at rki.de
Wed Mar 29 01:41:40 EST 2000
On Tue, 28 Mar 2000, Jon Pounder wrote:
> not sure on the jdbc part, but in general your sql statement just looks
> like this:
>
> "exec sp_whatever parm1, parm2, parm3"
>
> the driver should be smart enough to figure out whether this has a select
> in it or not and act accordingly based on the results that come back.
What about
query = "sp_whatever parm1, parm2, parm3";
rs = stmt.executeQuery(query);
This works for me in all FreeTDS-JDBC snapshots I used.
Kind regards
Andreas.
More information about the FreeTDS
mailing list