invalid arguments in data source
I try to do search function using JSP. no compile error message but when I click sumit on the page. I have the following error message.
can you help me? it probably caused by datasource connection or custome library path?
HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfillingthis request.
exception
org.apache.jasper.JasperException: Can't create DataSource: invalid arguments in call
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
root cause
javax.servlet.ServletException: Can't create DataSource: invalid arguments in call
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.srfind_jsp._jspService(srfind_jsp.java:134)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
root cause
javax.servlet.jsp.JspException: Can't create DataSource: invalid arguments in call
com.ora.jsp.tags.sql.UseDataSourceTag.doEndTag(UseDataSourceTag.java:77)
org.apache.jsp.srfind_jsp._jspService(srfind_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
my sample code: search.jsp and srfind.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head>
<title>Search for the Service Request </title>
</head>
<body bgcolor="white">
Please enter information about the employee you're looking for.
<form action="srfind.jsp" method="get">
<table>
<td>First Name:</td>
<td><input type="text" name="firstName">
</td>
</tr>
<tr>
<td>Last Name:</td>
<td><input type="text" name="lastName">
</td>
</tr>
<tr>
<td colspan=2><input type="submit" value="Search"></td>
</tr>
</table>
</form>
</body>
</html>
--srfind.jsp
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page language="java" contentType="text/html" %>
<%@ taglib uri="/orataglib" prefix="ora" %>
<ora:useDataSource id="csdev" className="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@10.40.129.39:1521:csdev" />
<ora:sqlQuery id="sr_id" dataSource="csdev" scope="request">
SELECT * FROM sr_create WHERE firstName LIKE ? AND lastName LIKE ? ORDER BY lastName
<ora:sqlStringValue param="firstName" prefix="%" suffix="%" />
<ora:sqlStringValue param="lastName" prefix="%" suffix="%" />
</ora:sqlQuery>
<jsp:forward page="srlist.jsp" />
Message was edited by:
jin412
