Hi,
In my environment all is OK. I use Tomcat 3.1. Please check server
configuration.
Marin Velikov
----- Original Message -----
From: "Narendra Kumar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 14, 2000 1:25 PM
Subject: No such method found error....?
> Hi, Here is a very small Problem. I am trying to access the database thru
JSP. Here i am using class to access. The file names are "SampCon.jsp" which
i placed in "public_html" directory of "JavaWebServer2.0". And created a
directory "Asraid" under that and placed "Connect.java" and made it as
package. And even i set the class path. Here i am providing the codes...
>
> SampCon.jsp:---
>
> <%@ page import="Asraid.*, java.sql.*,java.util.*" errorPage="error.jsp"
%>
>
> <html>
> <title>Test</title>
> <body>
>
> <form name="frm">
> <jsp:useBean id="db" scope="page" class="Asraid.Connect" />
> <jsp:setProperty name="db" property="*" />
> <input type="text" name="Status" value="<%= db.sss() %>" size="25" >
>
> New Status : <%= db.sss() %>
> <select name="mod">
> <%! String col;
> ResultSet res=null;
> %>
> <%
> try{
> res = db.getResult();
> while( res.next() ){
> col = res.getString(1);
> %>
> <option name="<%= col %>" > <%= col %>
>
> <% }
> }catch(SQLException se){
> }
> %>
> </select>
> </form>
> </body>
> </html>
> ----------------------------------
> Connect.java:-------
> package Asraid;
>
> import java.sql.*;
> import java.io.*;
> import javax.servlet.*;
> import javax.servlet.http.*;
> import java.util.*;
>
> public class Connect {
> java.sql.Connection aidcon;
> String user_id = "aidtest";
> String password = "aidtest";
> String ipaddress = "172.22.1.171"; file://ipaddress of database
server
> String port = "1521"; file://port of database server
> String sid = "PAID"; file://SID of database server
> String dbUrl = "jdbc:oracle:thin:" + user_id + "/" + password +
"@" + ipaddress + ":" + port + ":" + sid;
> String name="failure";
> Statement stat;
> public ResultSet res=null;
> public Connect(){
> try{
> Class.forName("oracle.jdbc.driver.OracleDriver");
> aidcon = DriverManager.getConnection(dbUrl);
> }catch(Exception e){
> System.out.println("Hello the error is here");
> System.out.println(e);
> }
> System.out.println("Success");
> name = "success";
> }
> public ResultSet getResult() throws SQLException{
> System.out.println("in side get result");
> stat = aidcon.createStatement();
> res = stat.executeQuery("SELECT UNIQUE(module_typ)
FROM aid_control");
> return (res == null ) ? null : res;
> }
> public String sss(){
> return name;
> }
> public static void main(String args[])throws Exception{
> Connect c = new Connect();
> System.out.println("Before res");
> ResultSet rs = c.getResult();
> System.out.println("after res");
> while( rs.next()){
> System.out.println(rs.getString(1));
> }
> }
> }
> --------------------------
> Every thing is working fine. I can able to access the "sss" method but if
i use "getResult()" method then it is giving an
error ---"java.lang.NoSuchMethodError: Asraid.Connect:method
getResult()Ljava/sql/ResultSet; not found"---
>
> Please help me.
> Thanks in advance,
> Naren.
>
> Naren,
> Programmer Analyst,
> SilverLine Technologies,
> Chennai.
> ______________________________________________________
> 123India.com - India's Premier Portal
> Get your Free Email Account at http://www.123india.com
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
