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