This jsp works if I explicitly set the url and driver, but I can not figure how to get values for url/driver from a context initParm into the driver setup.
I have searched the archives. I have spent hours on this. I have looked at the source for the examples. I am out of paths to pursue. ERROR is that the Servlet exception in <driver> driver="" is invalid. (and I am looking for syntax to get a good value into driver ) This must be an FAQ but found no FAQs. Thanks <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd";> <%@ taglib uri="http://java.sun.com/jstl/ea/sql"; prefix="sql" %> <%@ taglib uri="http://java.sun.com/jstl/ea/core"; prefix="c" %> <%@ page import="com.anabasisnw.assignment.*"%> <%@ page import="com.anabasisnw.assignment.Utility.*"%> <% // I can see that I get the correct context initparms String ctx_user = application.getInitParameter("user"); String ctx_password = application.getInitParameter("password"); String ctx_driver= application.getInitParameter("driver"); String ctx_url = application.getInitParameter("url"); ctx_url += Utility.QUEST + ctx_user + Utility.AMP + ctx_password; // I found this techique in apache..examples-standard...session.jsp --%> session.setAttribute("myDbUrl", ctx_url ); session.setAttribute("myDbDriver", ctx_driver ); %> <html><head><title></title> <link rel="stylesheet" type="text/css "href="styles.css" /> </head><body><h2>Formated List using JSP Standard Tag Library </h2> <%-- If I stuff driver and url by hand it works, but what must I do to pass those values in ? --%> <sql:driver var="dataSource" driver="${myDbDriver}" url= "${myDbUrl}" /> <sql:query var="bike_trips" dataSource="${dataSource}" > SELECT * from bike_trips </sql:query> <p>Table follows: <table border="1"> <c:forEach var="row" items="${bike_trips.rows}" > <tr> <td><c:out value="${row.trip_id}" /></td> <td><c:out value="${row.destination}" /></td> <td><c:out value="${row.last_name}" /></td> </tr> </c:forEach> </table> </body> </html> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
