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: Henry Lu <zhlu AT umich.edu>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Stored procedure and JDBC
  • Date: Tue, 4 Apr 2000 08:02:12 -0400 (EDT)


I sent out a similar question last week and I have not got any detailed
answer how to do. I am very interested to see if someone can help us
out on this issue.


---------------------------------------------------------------------------
Henry Lu
Computer Systems Programmer III e-mail: zhlu AT umich.edu
MCIT phone: (734) 936-2063
University of Michigan Medical Center fax: (734) 763-4372

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.
>
> I would like to place a call like:
> {sp_procedure_name param1, param2, param3} (params are always input
> parameters)
> and get the output parameters from the result set, for example:
>
> ResultSet rs = st.executeQuery();
>
> int i;
>
> if (rs.next())
> {
> i = rs.getInt("output_parameter")
> }
>
> I do not find a correct syntax to call the procedure.
>
> I tried, with connection.prepareCall():
>
> {call sp_procedure_name param1, param2, param3}
> {exec sp_procedure_name param1, param2, param3}
> {call sp_procedure_name(param1, param2, param3)}
> {sp_procedure_name param1, param2, param3}
> {sp_procedure_name (param1, param2, param3)}
> {call sp_procedure_nam(?,?,?)} + statement.setXXX(1, value) [etc]
>
> I really do not know how to get it to work.
>
> Thank for your help,
>
> Emmanuel.
>
> ---
> You are currently subscribed to freetds as: zhlu AT umich.edu
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page