Using PreparedStatements

Can anyone explain what does the following error mean? I'm getting it when I use PreparedStatements to connect in a MS Access 2000 database.

Context log: path="" Error in jsp service() : [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)

at src._0002fsrc_0002fuserDetails_0002ejspuserDetails_jsp_18._jspService(_0002fsrc_0002fuserDetails_0002ejspuserDetails_jsp_18.java:163)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)

at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)

at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)

at com.borland.jbuilder.webserverglue.tomcat.jsp.JspLoaderEcho.service(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)

at org.apache.tomcat.core.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:163)

at ServletHandler.goToPage(ServletHandler.java:30)

at ServletHandler.doPost(ServletHandler.java:21)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:597)

at org.apache.tomcat.servlets.InvokerServlet.service(InvokerServlet.java:257)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)

at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)

at java.lang.Thread.run(Thread.java:484)

[2372 byte] By [deandaniel] at [2007-9-26 2:33:23]
# 1
You are using a method that the jdbc driver and/or database does not support.Solution:-Don't use that feature-Use a different driver and/or database.
jschell at 2007-6-29 9:56:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
oh, I didn't know that MS Access doesn't support PreparedStatements. thanks!
deandaniel at 2007-6-29 9:56:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

There is no method called 'PreparedStatement'.

PreparedStatements have nothing to do with MS Access, and accessing MS Access via ODBC does support PreparedStatements.

Your code, or something that you are calling, is calling a method that the driver you are using does not support. This is most often associated with scrollable result sets and other stuff found in JDBC 2/3.

jschell at 2007-6-29 9:56:27 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...