Skip to Content.
Sympa Menu

freetds - Re: Stored procedure and JDBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Emmanuel Blot" <eblot AT jijia12.grenoble.hp.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Stored procedure and JDBC
  • Date: Wed, 5 Apr 2000 11:05:20 +0200


Hello Bob,

THANKS, it works !

Emmanuel.

----- Original Message -----
From: "Bob Kline" <bkline AT rksystems.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Tuesday, April 04, 2000 4:34 PM
Subject: [freetds] Re: Stored procedure and JDBC


> On Tue, 4 Apr 2000, Emmanuel Blot wrote:
>
> > Hello,
> >
> > I am looking for hours to get FreeTDS to work with SQL server 7.0
> > stored procedure.
>
> Here's an example of a call to a stored procedure which takes one input
> parameter and produces a result set with two columns (INT and VARCHAR):
>
> Connection c = DriverManager.getConnection(url, uid, pwd);
> Statement s = c.createStatement();
> ResultSet rs = Stmt.executeQuery("exec sp_t 50");
> while (rs.next())
> System.out.println(rs.getInt(1) + ", " + rs.getString(2));
>
> Hope this helps.
>
> --
> Bob Kline
> mailto:bkline AT rksystems.com
> http://www.rksystems.com
>
>
>
> ---
> You are currently subscribed to freetds as: eblot AT sablet.grenoble.hp.com
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page