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