Hi Mark, Thank you *VERY* much for your reply! It's very encouraging to know that people are reading what you post on a mailing list. As an update, this morning we tested the process by using ColdFusion through an ODBC dsn to call the master proc -- both the more complex proc, which runs a backup first; and the debug proc, which does not -- ran correctly. I'm thinking this problem with invoking the proc from the JSP has got to be somehow JDBC-related? ~Chuck At 03:41 AM 5/7/01 +0000, you wrote: >On Sun, 6 May 2001 22:59:00 -0400, you wrote: > > >My team are building a web app with JSP's and SQL Server. We are on a > >tight time frame. One of our developers has about 6 mos. of JSP > >experience and is quite good for that amount of time. The other > >developer has been using JSP's for less than 5 weeks, but is a good CF > >programmer. I'm working the MS SQL Server 7 back end. > > > >So far, the JSP guys have gotten by quite nicely with the Jakarta JDBC > >tag library to call stored procs and use the procs returns. > > > >BUT, I have built this fairly large set of stored procs that are called > >by a single stored proc. The first proc called bt the master proc does a > > > >backup of a user > >provided database name, then the master proc proceeds to invoke other > >procs that each do certain stuff (truncate tables, insert records into > >tables, update tables -- until finally, if there is an error with the > >backup proc, the master proc will call a proc to do a restore. > >It's hard to tell - are you trying to get a remote user to run procs >on the server? > >Is it possible that once the first sub-proc finishes, it returns a >code to the JSP, which then completes processing, thus terminating any >forked processes such as the main? > >Mark > >___________________________________________________________________________ >To unsubscribe, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
