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
