FreeTDS Development Group

[Andreas Tille <tillea AT rki.de>]

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.