jstl problem-accessing database

[Ankur Jain]

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

 javax.servlet.ServletException: javax.servlet.jsp.JspException: 
INSERT INTO Marks (rollno,physics,chemistry,mathematics,total) values (?,?,?,?,?)
 
: SQL Exception : [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
org.apache.jasper.runtime.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??

[Tim Baker]

My guess would be that your JDBC driver doesn't support the operation you are trying to carry out.

[Ankur Jain]

no. its not the driver problem b'coz the <sql:query> tag is working
means i can query data but cant modify it

[Adeel Ansari]

Originally posted by Ankur Jain:
no. its not the driver problem b'coz the <sql:query> tag is working
means i can query data but cant modify it

I think Tim addressed the same issue. He was saying the same thing, that the driver might not support the inserts and updates.