how do I pass a resultSet back to a scriptlet? I can not use Javabeans either since we are running (at work) iplanet 4.1 (no web-inf) and I do not have permissions to the class path. All my logic must be performed in jsp files.... === Here is my attempt: <% ResultSet rs = getResultSet("SELECT * FROM COFFEES"); //Loop through results of query. while(rs.next()) { out.println( rs.getString("Coffee_Name")); } %>
got it! The code I submitted worked. I had an error else where in my jsp page. Duh! But...Now the question is is this an acceptable design approach. Again, I can not utilize beans, but I am trying to separate my java from the presentation. Rather than have duplicate code in every jsp that connects to the oracle DB, I can do a page include to attach my returnrecordset method. Does anyone see a problem/conflict with this approach. Thanks again! Jeff
Ron Newman
Ranch Hand
Joined: Jun 06, 2002
Posts: 1056
posted
0
Maybe you should use JSTL's SQL-access tags?
Ron Newman - SCJP 1.2 (100%, 7 August 2002)
Jeff Rozycki
Greenhorn
Joined: Jul 15, 2003
Posts: 4
posted
0
I wish I could but our company is using iplanet 4.1. No Web-Inf. I've tried for months to get javabeans to work. I do not have access a folder in the class path. Creating a web-inf folder in my personal webspace given to me by the IT department does not work for beans, so I'm assuming I will not be able to add my own tags. Any thoughts?
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
subject: scriptlet method to return resultSet help