stored procedure call in jdbc

Henry Lu zhlu at umich.edu
Tue Mar 28 13:29:52 EST 2000


As matter of fact, this is an OUTPUT parameter. Could you give
me an example of calling string?


---------------------------------------------------------------------------
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:

> ahh - I didn't realize that was part of the query string, I thought it was
> just because it was a question.
> 
> 
> yes I agree then if that is the case, that is the trouble for sure.
> 
> just put the value in place of the "?".
> 
> 
> At 09:21 AM 3/28/00 -0800, you wrote:
> >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
> >
> >---
> >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')
> 




More information about the FreeTDS mailing list