FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Jon Pounder writes:
 > hmmm - not sure what would be "not implemented" there.

Probably the ? which should potentially be replaced by a parameter in
the stored proc call.

I know that Sybase does not support ?-style placeholder parameters to
stored procs at the protocol level, so unless the driver does the
replacement and quoting itself this won't work (and I know that the C
side of FreeTDS does not handle ?-style placeholders at all at the
moment).

Michael


 > 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
 >      
 >      
 > 
 > ---
 > You are currently subscribed to freetds as: mpeppler AT peppler.org
 > To unsubscribe, forward this message to $subst('Email.Unsub')
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler AT peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com