Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tomcat 4.1 and Oracle custom tag library
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">
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(PageContextImp
l.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
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.
Additional Builds and Platforms:
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"
Logout</td> </tr> <tr> <td class="button"
Personal</td> </tr> <tr> <td class="button"
Profiles</td> </tr> <tr> <td class="button"
Help</td> </tr> </tbody> </table> </td>
<!-- 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_at_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:dbQuery queryId="FindProfiles" connId="ProfilesConnection"
scope="page" output="JDBC">select * from profiles where email='<%=UserSession.getUsername()%>'
<% 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></database:dbNextRow>
</tr>
<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">
</center>
</div>
<br><br>
</body>
</html>
Received on Wed Feb 19 2003 - 14:47:01 CST