try using Statement stmt = myConn.createStatement(); instead. // Error might be here Statement stmt = myConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); :~) Ricky Y. Artigas Analyst/Programmer / Database Administrator Information Technology Division Easycall Communications Phils., Inc. > ------------------------------- > IMPORTANT NOTICE: > This message (and any attachment hereto) may contain privileged and/or > confidential information specific to EasyCall. If you are not the intended > addressee indicated in this message, you may not copy or disseminate this > message (or any attachment hereto) to anyone. Instead, please destroy this > message (and any attachment hereto), and kindly notify the sender by reply > email. Any information in this message (and any attachment thereto) that > do not relate to the official business of EasyCall shall be understood as > neither given nor endorsed by the company. > > > -----Original Message----- > From: S.Jyotinarayan [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 12:01 PM > To: [EMAIL PROTECTED] > Subject: Error: [Microsoft][ODBC SQL Server Driver] Optional feature > not implemented > > I am running on Win2k OS, Tomcat 4 Application server and MS SQL Server 2k > as DB. I have made an ODBC connection and dns is manu. I am running the > following code as per your instructions and i am getting some errors > displayed below the code ). Please tell me where's the mistake. > Thanx in advance > Jyoti. > > > <html> > <head> > <title>Manu Collection</title> > > <script language="JavaScript"> > function butFn(buttonAction,submitPage) > { > if(buttonAction=="Back" || buttonAction=="First" || > buttonAction=="Prev" > || buttonAction=="Next" || buttonAction=="Last") > { > document.reader.action=submitPage; > document.reader.submit(); > } > } > </script> > </head> > > <%@ page language="java" import="java.sql.*" %> > <body> > <h1>Manu Collection</h1> > > <% > int inc = 0; > > String from=request.getParameter("from"); > > if (from=="F") { inc=1; } > else if(from=="P") { inc=Integer.parseInt(request.getParameter("inc")); > } > else if(from=="N") { inc=Integer.parseInt(request.getParameter("inc")); > } > else if(from=="L") { inc=-1; } > > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); > > Connection myConn = DriverManager.getConnection("jdbc:odbc:manu"); > > // Error might be here > Statement stmt = > myConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, > ResultSet.CONCUR_UPDATABLE); > > String qry=""; > ResultSet myResultSet=null; > > if(inc==0) { > qry="select * from tblMS"; > myResultSet = stmt.executeQuery(qry); > myResultSet.absolute(inc); > session.setAttribute("rsSession",myResultSet); > } else if(inc>0) { > myResultSet=(ResultSet)session.getAttribute("rsSession"); > myResultSet.absolute(inc); > } > > String MSID = myResultSet.getString("MSID"); > String msOldNo = myResultSet.getString("msOldNo"); > String msTitle = myResultSet.getString("msTitle"); > String msAuthor = myResultSet.getString("msAuthor"); > %> > > <FORM NAME="reader"> > <table width="75%" border="1"> > <tr> > <td>MSID</td> > <td> > <input type="text" name="txtMSID" value="<%= MSID %>"> > </td> > <td>msOldNo</td> > <td> > <input type="text" name="txtmsOldNo" value="<%= msOldNo %>"> > </td> > </tr> > <tr> > <td>msTitle</td> > <td> > <input type="text" name="txtmsTitle" value="<%= msTitle %>"> > </td> > <td>msAuthor</td> > <td> > <input type="text" name="txtmsAuthor" value="<%= msAuthor %>"> > </td> > </tr> > <tr> > <td colspan="4"> > <div align="center"> > <input type="button" name="butFirst" value="First" > onClick="butFn('First','manutst.jsp?from=F')"> > <input type="button" name="butPrev" value="Prev"> > <input type="button" name="butNext" value="Next"> > <input type="button" name="butLast" value="Last"> > </div> > </td> > </tr> > </table> > </form> > > </body> > </html> > > > > > A Servlet Exception Has Occurred > Exception Report: > javax.servlet.ServletException: [Microsoft][ODBC SQL Server > Driver]Optional > feature not implemented > at > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextI > mp > l.java:457) > at org.apache.jsp.manutst$jsp._jspService(manutst$jsp.java:133) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet. > ja > va:201) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati > on > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter > Ch > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve. > ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve. > ja > va:215) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1 > 64 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja > va > :163) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav > a: > 1005) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:10 > 98 > ) > at java.lang.Thread.run(Unknown Source) > > Root Cause: > java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Optional feature > not implemented > at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) > at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) > at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) > at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) > at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) > at org.apache.jsp.manutst$jsp._jspService(manutst$jsp.java:84) > at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet. > ja > va:201) > at > org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) > at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati > on > FilterChain.java:247) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter > Ch > ain.java:193) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve. > ja > va:243) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve. > ja > va:215) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1 > 64 > ) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 64) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja > va > :163) > at > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java > :5 > 66) > at > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472 > ) > at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > at > org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.jav > a: > 1005) > at > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:10 > 98 > ) > at java.lang.Thread.run(Unknown Source)
==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com