You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by bu...@apache.org on 2003/02/19 15:36:41 UTC
DO NOT REPLY [Bug 17202] New: -
Tomcat 4.1 and oracle custom tags for Jdeveloper
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=17202>.
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=17202
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: tomcat-dev@jakarta.apache.org
ReportedBy: galexakis@intelligence.tuc.gr
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 mike@in.gr/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:galexakis@intelligence.tuc.gr?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: tomcat-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org