Skip to Content.
Sympa Menu

freetds - Re: stored procedure call in jdbc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Andreas Tille <tillea AT rki.de>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: stored procedure call in jdbc
  • Date: Wed, 29 Mar 2000 08:41:40 +0200 (CEST)


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.





Archive powered by MHonArc 2.6.24.

Top of Page