Hi.
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.
The proc works like a charm within SQL Server. Runs in less than 3
minutes.
BUT when the JSP calls it, the proc begins the backup process and then
just hangs inside SQL Server. You have to reboot SQL Server to get the
stupid proc process ID to let go of the backup file (it's still trying
to initialize it even though the JSP has long finished).
As a debugging strategy, we removed the invocation of the backup and
restore procs from inside the master proc, so that the master proc is
calling single seperate procs that only do simple stuff, like truncates
and inserts, etc,
With this debug master proc, the JSP returns right away, but only the
first proc from inside the master proc is run. The other procs are not
called by the master proc when called by the JSP. (They are when the
master proc is run from isql).
If anyone can come up with some snippets of Java with JDBC that could I
could
give to my developers to try to plug inside the JSP, I would **REALLY**
appreciate it.
Take care,
Chuck Boyce
===========================================================================
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
