Skip to Content.
Sympa Menu

freetds - Re: Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Schörk, Andreas" <andreas.schoerk AT infor.de>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)
  • Date: Mon, 10 Sep 2001 09:11:41 +0200


Just in Case:

create procedure spTestExec2 as
select 'Doesn't work!' as Result

the ' should be duplicated
Andreas

> -----Original Message-----
> From: Anton van Straaten [mailto:anton AT appsolutions.com]
> Sent: Montag, 10. September 2001 08:30
> To: TDS Development Group
> Subject: [freetds] Re: Why can't this stored procedure be called?
> (FreeTDS_JDBC and jtds)
>
>
> The query only fails with FreeTDS. It runs in all other
> environments I've
> tested, including other JDBC drivers (e.g. JTurbo, Sprinta),
> ODBC drivers,
> and in SQL Server 6.5 Enterprise Manager.
>
> I have tested that stored procedure execution is working. I
> have had no
> problems using FreeTDS for many other procedures and
> other kinds of queries. In fact, I can get the problem query
> to work if I
> replace the "insert...execute" statement with a simple
> "execute", in which
> case the query returns two result sets, the second one empty (which
> unfortunately doesn't provide the required behavior,
> otherwise I would just
> do that).
>
> Changing the name "Result" to something else doesn't make a
> difference. In
> any case, that was an artifact of the test, not the original
> code which
> triggered the problem.
>
> Thanks for your help, though...
>
> Anton
>
>
> > -----Original Message-----
> > From: bounce-freetds-132811 AT franklin.oit.unc.edu
> > [mailto:bounce-freetds-132811 AT franklin.oit.unc.edu]On Behalf Of
> > PMoore AT axa.com.au
> > Sent: Sunday, September 09, 2001 9:21 PM
> > To: TDS Development Group
> > Subject: [freetds] Re: Why can't this stored procedure be called?
> > (FreeTDS_JDBC and jtds)
> >
> >
> >
> > firstly i would have to ask the obvious question:
> > Does it run under the SQL Server Query Analyzer tool?
> > (i added it to my SQL 2000 database and apart from calling
> my temp table
> > #tmp2 i left your code intact and verfied that your SQL works)
> >
> >
> > i would recommend executing the sp_who procedure in your
> code as that is a
> > known working procedure. this will at least show you
> whether or not stored
> > procedure execution is working in your JDBC/TDS implementation.
> >
> > another thing to try - i would not use the word "Result" as the
> > name of the
> > column you are returning in case there is an issue with it being
> > a reserved
> > word.
> > cheers
> > peter
> >
> > Peter Moore
> > Contractor,
> > ITeG, Axa Australia
> >
>
>
> ---
> You are currently subscribed to freetds as: [andreas.schoerk AT infor.de]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>




Archive powered by MHonArc 2.6.24.

Top of Page