Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jstl access "sql:update" problem

 
Ankur Jain
Ranch Hand
Posts: 44
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using jstl to access thedatabase

It is working if I am using <sql:query > tag ,but when executing
<sql:update>
it throws exception

code:
--------------------------------------------------------------------------------

javax.servlet.ServletException: javax.servlet.jsp.JspException: INSERT INTO Marks (rollno,physics,chemistry,mathematics,total) values (?,?,?,?,?) : org.apache.jasper.runtiSQL Exception : [Microsoft][ODBC Microsoft Access Driver]Optional feature not implementedme.PageContextImpl.doHandlePageException(PageContextImpl.java:821)org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)org.apache.jsp.MarksInput_jsp._jspService(MarksInput_jsp.java:107)org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362) …

--------------------------------------------------------------------------------


Plz tell me what is wrong??
[ June 26, 2005: Message edited by: Ankur Jain ]
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This issue might be because of MS Access. Have you tried with some other DB?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!