Guest User

Untitled

a guest
Feb 18th, 2019
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. <c:set var="time_req1" value="<=${time_req_date}>"/>
  2. <c:set var="time_req2" value="<=${time_req_date2}>"/>
  3. <sql:query var="sqlresult" sql="select * FROM FORM_REDUCVU WHERE
  4. to_date(TIME_REQ,'mm/dd/yyyy') >= ? AND to_date(TIME_REQ,'mm/dd/yyyy')
  5. <= ? ORDER BY ID DESC" maxRows="25" dataSource="jdbc/myoracledev">
  6. <sql:param value="1110484" ></sql:param>
  7. </sql:query>
  8.  
  9. 18-Feb-2019 11:57:32.502 SEVERE [http-nio-20000-exec-6]
  10. org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service()
  11. for servlet [jsp] in context with path [/useragent] threw exception
  12. [javax.servlet.ServletException: javax.servlet.jsp.JspException: select
  13. * FROM FORM_REDUCVU WHERE to_date(TIME_REQ,'mm/dd/yyyy') >= ? AND
  14. to_date(TIME_REQ,'mm/dd/yyyy') <= ? ORDER BY ID DESC: Missing IN or
  15. OUT parameter at index:: 2] with root cause
  16. java.sql.SQLException: Missing IN or OUT parameter at index:: 2
Add Comment
Please, Sign In to add comment