• 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic