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