DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17203>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17203 Tomcat 4.1 and oracle custom tags for Jdeveloper Summary: Tomcat 4.1 and oracle custom tags for Jdeveloper Product: Tomcat 4 Version: 4.1.0 Platform: PC URL: http://www.intelligence.tuc.gr/aler/login.html OS/Version: All Status: NEW Severity: Critical Priority: Other Component: Servlet & JSP API AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] When i am trying to open a database connection using this command <%--Retrieving profiles for current user --%> <database:dbOpen connId="ProfilesConnection" user="<%=UserSession.getdbUser()%>" password="<%=UserSession.getdbPass()%>" URL="<%=UserSession.getdbURL()%>" scope="page" commitOnClose="true"> </database:dbOpen> using the oracle custom tag library for Jdeveloper I get the error bellow although the same program works fine on Tomcat 3. javax.servlet.ServletException: oracle.jsp.dbutil.ConnBean.getDataSource()Ljava/lang/String; at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:497) at org.apache.jsp.profiles_jsp._jspService(profiles_jsp.java:309) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDi ....... Steps to reproduce: Try [EMAIL PROTECTED]/mike at http://www.intelligence.tuc.gr/aler/login.html as email/password. Expected results: The program profiles.jsp should read data from the database and show them on the screen. Additional Builds and Platforms: - Occurs on Tomcat 4.1 on Linux or Windows. - Doesn't occur on Tomcat 3 on Linux or Windows. Additional Information: The custom tag library for oracle and Jdeveloper can be downloaded from http://otn.oracle.com the whole file that this happens is profiles.jsp bellow. <%@ taglib uri="sqltaglib.tld" prefix="database" %> <html> <jsp:useBean id="UserSession" class="alert.LoginBean" scope="session" > </jsp:useBean> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" /> <meta name="description" content="Library Alert System Technical University of Crete"> <meta name="keywords" content="library , alert , technical , university , crete"> <meta name="author" content="Giannis Alexakis"> <title>Library Alert Service</title> <link rel="stylesheet" type="text/css" href="style.css" /> </head> <body > <!-- First div, this is the left bar --> <div align="center" class="menu"> <table border="1"> <tbody> <tr> <td> <table cellpadding="4"> <tbody> <tr> <th>Menu</th> </tr> <tr> <th><hr /></th> </tr> <tr> <td class="button" onMouseover="this.style.backgroundColor='#ADD1E9'" onMouseout="this.style.backgroundColor='#EEEEEE'"> <a href="logout.jsp">Logout</a></td> </tr> <tr> <td class="button" onMouseover="this.style.backgroundColor='#ADD1E9'" onMouseout="this.style.backgroundColor='#EEEEEE'"> <a href="userinfo.jsp">Personal</a></td> </tr> <tr> <td class="button" onMouseover="this.style.backgroundColor='#ADD1E9'" onMouseout="this.style.backgroundColor='#EEEEEE'"> <a href="profiles.jsp">Profiles</a></td> </tr> <tr> <td class="button" onMouseover="this.style.backgroundColor='#ADD1E9'" onMouseout="this.style.backgroundColor='#EEEEEE'"> <a href="helpuser.html">Help</a></td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </div> <!-- Second div, bar at top --> <div class="top" align="right"> <h3 class="header">Library Alert Service</h3> </div> <div class="image"> <img src="tuc_logo.gif" width="40" height="40" alt="logo" /> </div> <!-- Third div, bar at bottom --> <div class="footer" align="left"> Send comments to the <a class="author" href="mailto:[EMAIL PROTECTED]?subject=Alert comments"> author</a> <br /> <script language="JavaScript" type="text/javascript"> // append a modification date only if server provides a valid date if (Date.parse(document.lastModified) > 0) { document.write('last modified:' + document.lastModified + '<BR>'); } </script> </div> <!--Main div--> <div class="main"> <center> <%--This is the command that produces the bug--%> <database:dbOpen connId="ProfilesConnection" user="<%=UserSession.getdbUser()%>" password="<%=UserSession.getdbPass()%>" URL="<%=UserSession.getdbURL()%>" scope="page" commitOnClose="true"> </database:dbOpen> <database:dbQuery queryId="FindProfiles" connId="ProfilesConnection" scope="page" output="JDBC"> select * from profiles where email='<%=UserSession.getUsername()%>' </database:dbQuery> <% String email,profile_desc,title_rule,author_rule,abstract_rule,body_rule; %> <br> <table border="1" cellpadding="10" bordercolor="#111111" cellspacing="0" style="border-collapse: collapse" bordercolorlight="#754D41" bordercolordark="#111111"> <tr > <td align="center" ><u><b>Profile description</b></u></td> <td align="center" colspan="2"><u><b>Options</b></u></td> </tr> <database:dbNextRow queryId="FindProfiles"> <%profile_desc=FindProfiles.getString(1);%> <tr valign="middle"> <td align="center"><%=profile_desc%></td> <form action="profileinfo.jsp" method="post"> <td valign="middle" align="center"> <input type="submit" value="edit"> </td> <input type="hidden" name="Action" value="update"> <input type="hidden" name="ProfileDesc" value="<%=profile_desc%>"> </form> <form action="submitprofile.jsp" method="post"> <td valign="middle" align="center" ><input type="submit" value="delete"></td> <input type="hidden" name="Action" value="delete"> <input type="hidden" name="OldProfileDesc" value="<%=profile_desc%>"> </form> </tr> </database:dbNextRow> </table> <database:dbCloseQuery queryId="FindProfiles" /> <database:dbClose connId="ProfilesConnection" /> <br><br> <form action="newprofile.jsp" method="post"> <input type="submit" value="new profile"> <input type="hidden" name="Action" value="insert"> </form> </center> </div> <br><br> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
