Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_jsp thread: Trying to make Chap 4 Sample Code run


Message #1 by "Mark Laughlin" <projsp@e...> on Wed, 19 Jul 2000 16:28:22
Using chapter 4 code downloaded from Wrox.
JRun 3.0 & JTurbo SQL Server Driver
Access database imported into SQL Server
Tomcat code commented out & non-Tom code uncommented in custDetails.jsp
Verified database connectivity to Customer table via non-bean JSP page 
using JTurbo driver

Appears that app.processRequest(request, out) in line 16 is not getting 
anywhere.

I am able to setProperty of sqlString as well as display a getProperty of 
sqlString on the custDetails.jsp page, but do not get anything displayed in 
the form from the query result set.

Can I assume that since I'm able to get and set that I finally have my 
classpath settings in line? I have the four CLASS files in a 
com\wrox\projsp\ch04 subdirectory beneath the JRun classes directory.

Within the processRequest(), I tried changing the sqlString to "Select * 
from Customer" to see if the displayed getSqlString would be changed and to 
see if a parameter free SQL statement would run. Neither had any affect.

Has anyone else experimented with this? Any suggestions as to where I might 
find the error in my ways?

When I achieve a better understanding, my goal is to write a bean that will 
process calls to any SQL Server Stored Procedure (accepting a parameter 
identifying a particular stored procedure along with a variable number of 
parameters for the Stored Procedure itself). I'd appreciate any advice that 
would help me reach my quest...especially if such a bean already exists!

Mark A. Laughlin
http://www.eoffshore.com/mlaughlin

  Return to Index