Skip to Content.
Sympa Menu

freetds - Stored procedure and JDBC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Emmanuel Blot" <eblot AT sablet.grenoble.hp.com>
  • To: freetds
  • Subject: Stored procedure and JDBC
  • Date: Tue, 4 Apr 2000 7:50:5


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.




Archive powered by MHonArc 2.6.24.

Top of Page