Right now I have a quick solution which is to build a second JSP page to have all the DB stuff in it. So when the Submit button is clicked, the second page is called, which inturn talks to DB via. SP and determines if the user is valid or not. I was wondering if there is a way to eliminate the use of this second page. ANY IDEAS .... ???
there may be a way for the scenario , BUT what I am really looking for is if there is a way to call a Storedprocedure in a Java Script. [ June 07, 2006: Message edited by: Sudeep Agrawal ]
If you really really want to have the call to the database be executed from the browser, you will have to write an applet. However, that also has problems because standard Java security only lets applets open connections to the server from which they were served. In other words, either your database has to be the same host as your web app server, you have to do something very tricky to proxy a network connection through your web app server to your DB, or you have to somehow get your applet authorized on each host that needs to run it. I know the latter can be done, but I don't write applets and don't now how.