FreeTDS Development Group

[Jon Pounder <pounder AT inline.net>]

hmmm - not sure what would be "not implemented" there.

the driver should not be parsing the sql, just dumping it to the tds
stream, and the results are either going to look like a select or
insert/delete/update depending what the sp does, and presumably all of
those are implemented.


my guess is that the driver is actually looking at the sql statement and
not recognizing exec as a valid sql statement - (why it would do this I
don't know.)


I know our tds odbc driver works fine with sp's, but not sure if that is
any help to you if you are using jdbc.



At 12:06 PM 3/28/00 -0500, you wrote:
>Thanks for your info but I got error:
>java.sql.SQLException: not implemented
>
>The query is :
>"exec get_print_no ?"
>
>
>---------------------------------------------------------------------------
>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, 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.
>> 
>> 
>> At 11:42 AM 3/28/00 -0500, you wrote:
>> >Is there any example of calling a stored procedure with SQL-Server JDBC?
>> >
>> >
>>
>---------------------------------------------------------------------------
>> >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
>> >
>> >
>> >---
>> >You are currently subscribed to freetds as: pounder AT inline.net
>> >To unsubscribe, forward this message to
>> $subst('Email.Unsub')
>> >
>> >
>> 
>>      Jon Pounder,   Development Engineer
>>      Inline Internet Systems
>>      pounder AT inline.net Jon AT Pounder.com
>> 
>>      Web Tools Engineered for Success
>>      http://www.inline.net
>>      http://www.ihtml.com
>>      
>>      
>> 
>> ---
>> You are currently subscribed to freetds as: zhlu AT umich.edu
>> To unsubscribe, forward this message to
$subst('Email.Unsub')
>> 
>
>
>---
>You are currently subscribed to freetds as: pounder AT inline.net
>To unsubscribe, forward this message to
$subst('Email.Unsub')
>
>

        Jon Pounder,   Development Engineer
        Inline Internet Systems
        pounder AT inline.net Jon AT Pounder.com

        Web Tools Engineered for Success
        http://www.inline.net
        http://www.ihtml.com