I don't have it here at the moment, but I think the WROK book "Java DATA" does a good job on this. I will check tonight. It's on my boat.
At 09:59 AM 8/19/2002 -0700, you wrote: >I don't think there is one, it'd be really nice if there was however. There >is some good documentation available from Sun, but it doesn't get into real >examples (like what you're doing). > >--mikej >-=----- >mike jackson >[EMAIL PROTECTED] > > > -----Original Message----- > > From: Turner, John [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 19, 2002 9:18 AM > > To: '[EMAIL PROTECTED]' > > Subject: OFF-TOPIC: Pointers to CallableStatement docs? > > > > > > > > Hello - > > > > I think there is a java-user list, or even a jdbc-interest list, but I'd > > rather not subscribe when all I need is one quick pointer, so I am hoping > > someone on this list can get me started. > > > > I'm having quite a bit of difficulty working with stored procedures in my > > classes and servlets. The database is MS SQL Server 2000. I've > > read every > > single doc I can find, both at Sun, through Google, and even through the > > driver vendor's documentation. I even scammed some code from a JDBC 3.0 > > book (the only one I could find) at Border's, with still no luck. > > > > Can anyone point me to a resource that explains how to setup stored > > procedures in a CallableStatement correctly? I understand about > > registering > > the output parameters and setting the input types, and I > > understand that the > > parameters in a CallableStatement are numbered from left to right starting > > at 1. I've seen the examples at Sun, etc. but they're not much help. > > > > The problem is that all of the examples I can find deal with very simple, > > very rudimentary stored procedures, like finding the average of > > two numbers, > > or whatever. Our stored procedures are more involved than that. > > > > Example: a stored procedure used to validate logins. It has 5 input > > parameters, and 5 output parameters. It returns a status. > > According to the > > docs I have read so far, that means I should have a CallableStatement with > > 11 question marks ("?") in it (5 + 5 + 1 = 11). but that doesn't > > work, and > > I have tried every combination of inputs, outputs, input/outputs, > > etc. that > > I can think of, to no avail. > > > > Any help or pointers to resources that explain stored procedures and > > CallableStatements in more in-depth fashion would be greatly appreciated. > > > > - John > > > > ============================================ > > John Turner > > [EMAIL PROTECTED] | 248-488-3466 > > Advertising Audit Service > > http://www.aas.com > > > > > > -- > > To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>