web application in eclipse 9

hello all,
i m working on eclipse9, i hv created a web application with the help of jsp database connectivity,i found some problem while running the error 404 occured....i m giving here the full view of myapp.
new->project->web project->myproject(name of my project)
myproject->webroot->customerfrm.jsp(neme of my jsp page),in this page i write the following code.

<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%
Connection con=null;
ResultSet rs=null;
PreparedStatement stmt=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con=DriverManager.getConnection("jdbc:odbc:mydatabase","system","oracle");
out.write("connected!!!");
if(request.getParameter("action")!=null)
{
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String radd=request.getParameter("radd");
String ofadd=request.getParameter("ofadd");
String company=request.getParameter("company");
String work=request.getParameter("work");
String offphn=request.getParameter("offphn");
String mobile=request.getParameter("mobile");
String email=request.getParameter("email");
String city=request.getParameter("city");
String zip=request.getParameter("zip");
String myquery="insert into customer(first name,last name,residential address,official address,company,work,office phone,mobile,email id,city,zipcode)values(?,?,?,?,?,?,?,?,?,?,?)";
stmt=con.prepareStatement(myquery);
stmt.setString(1,fname);
stmt.setString(2,lname);
stmt.setString(3,radd);
stmt.setString(4,ofadd);
stmt.setString(5,company);
stmt.setString(6,work);
stmt.setString(7,offphn);
stmt.setString(8,mobile);
stmt.setString(9,email);
stmt.setString(10,city);
stmt.setString(11,zip);
rs=stmt.executeQuery("select * from customer");
%>
<html>
<body>
<center>
<h2>customer list</h2>
<table border="1">
<tr>
<td><b>customer id</b></td>
<td><b>first name</b></td>
<td><b>last name</b></td>
<td><b>residential address</b></td>
<td><b>official address</b></td>
<td><b>company</b></td>
<td><b>work</b></td>
<td><b>office phone</b></td>
<td><b>mobile</b></td>
<td><b>email id</b></td>
<td><b>city</b></td>
<td><b>zipcode</b></td>
</tr>
<% int num=1;
while(rs.next()){
%>
<tr>
<td><%=num%></td>
<td><%=rs.getString("first name")%>
<td><%=rs.getString("last name")%>
<td><%=rs.getString("residential address")%>
<td><%=rs.getString("official address")%>
<td><%=rs.getString("company")%>
<td><%=rs.getString("work")%>
<td><%=rs.getString("office phone")%>
<td><%=rs.getString("mobile")%>
<td><%=rs.getString("email id")%>
<td><%=rs.getString("city")%>
<td><%=rs.getString("zipcode")%>
</tr>
<%
num++;
}
rs.close();
stmt.close();
con.close();
%></table></center></body></html>
<%
}
else{%>
<html>
<head>
<script language="javascript">
function validate(form_obj)
{if(form_obj.fname.value.length==0){
alert("please fill the remaining details");
form_obj.fname.focus();
return false;
}
if(form_obj.lname.value.length==0){
alert("please fill the remaining details");
form_obj.lname.focus();
return false;
}
if(form_obj.radd.value.length==0){
alert("please fill the remaining details");
form_obj.resadd.focus();
return false;
}
if(form_obj.ofadd.value.length==0){
alert("please fill the remaining details");
form_obj.ofadd.focus();
return false;
}
if(form_obj.ofphn.value.length==0){
alert("please fill the remaining details");
form_obj.ofphn.focus();
return false;
}if(form_obj.mobile.value.length==0){
alert("please fill the remaining details");
form_obj.mobile.focus();
return false;
}if(form_obj.email.value.length==0){
alert("please fill the remaining details");
form_obj.email.focus();
return false;
}if(form_obj.city.value.length==0){
alert("please fill the remaining details");
form_obj.city.focus();
return false;}
return true;}
</script>
<body><center>
<form action="customerfrm.jsp" method="post" name="entry" onSubmit="return validate(this)">
<input type="hidden" value="list" name="action">
<table><tr><td  ><h2>Customer entry form</h2></td></tr>
<tr><td > </td></tr>
<tr><td > </td></tr>
<tr><td>first name</td><td><input name="fname",type="text"></td></tr>
 <tr><td>last name</td><td><input name="lname",type="text"></td></tr>
 <tr><td>residential address</td><td><input name="radd",type="text"></td></tr>
 <tr><td>official address</td><td><input name="ofadd",type="text"></td></tr>
 <tr><td>company</td><td><input name="company",type="text"></td></tr>
<tr><td>work</td><td><input name="work",type="text"></td></tr>
 <tr><td>office phone</td><td><input name="offphn",type="text"></td></tr>
 <tr><td>mobile</td><td><input name="mobile",type="text"></td></tr>
 <tr><td>email id</td><td><input name="email",type="text"></td></tr>
 <tr><td>city</td><td><input name="city",type="text"></td></tr>
 <tr><td>zipcode</td><td><input name="zip",type="text"></td></tr>
 <tr><td  ><input type="submit" value="submit"></td></tr></table></form></center></body></html>
 <%}%>

can anyone tell me ,whats d prob,in dis code there is no error,the problem can be of tomcat server.
thanks.

Rich, welcome to Java Ranch!

A 404 error is a page not found error. Which URL is causing that error? Also, what is the layout of your WAR file?

Also, please UseRealWords

thanks for reply sir.
when i run my project on myeclipse server(tomcat),the whwn it opens in browse with url http://rich-pc:8080/customer%20info

First, spaces in contexts are not a good ides.

Second, what is in you web.xml? Do you have a welcome-file-list that includes customerfrm.jsp?

Third, what is the name of your war file? I assume it is "customer info.war"...

thank you sir,the problem got resolved now.........

sir,can you give me some idea about the customer support tool database architecture..........thanks

sir,when i click the submit button i got the following error....

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /customerfrm.jsp at line 36

33: stmt.setString(9,email);
34: stmt.setString(10,city);
35: stmt.setString(11,zip);
36: rs=stmt.executeQuery("select * from customer");
37: %>
38: <html>
39: <body>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.sql
eIs i have done any mistake in my code regarding database connectivity?.........please help me

rich baliyani wrote:sir,can you give me some idea about the customer support tool database architecture..........thanks

Which "customer support tool database architecture"? Or are you writing such a tool and need an architecture?

when i click the submit button i got the following error
...
i have done any mistake in my code regarding database connectivity?

Yes, that is what I would guess, but I am not sure because you didn't post the full error text. There should be more after "javax.servlet.ServletException: java.sql". If that is all that showed up in the browser, then look at the web server log file. By the way, which web server are you using?

sir, actually i am trying to make a project on customer support tool in java with eclipse 9 ide,but i want you to please give an overview that how i would take initial,till now i have made a jsp page tried to connect database,but the problem got occured of exception,i am giving here this exception........
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Driver does not support this function
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.sql.SQLException: Driver does not support this function
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:234)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: Driver does not support this function
sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeQuery(JdbcOdbcPreparedStatement.java:117)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.

--------------------------------------------------------------------------------

Apache Tomcat/6.0.13
..................................................................................
i am using type1 driver,is this is the reason for above exception?
thanks.

i tried to use type4 driver & i got the following exception on submit...
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /customerfrm.jsp at line 37

34: stmt.setString(9,email);
35: stmt.setString(10,city);
36: stmt.setString(11,zip);
37: rs=stmt.executeQuery("select*from customer");
38: %>
39: <html>
40: <body>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.sql.SQLException: ORA-03115: unsupported network datatype or representation

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:234)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: ORA-03115: unsupported network datatype or representation

oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.

--------------------------------------------------------------------------------

Apache Tomcat/6.0.13.

First try running your jdbc code from console. It seems you are passing String in place of some other table datatype. Please review it and your db schema too.

sir i have given varchar2 datatype for which i have given string & i also removed variables like officephone,mobile ,zipcode from my program as wall as database too.but still i am getting error .........
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Invalid column index
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.sql.SQLException: Invalid column index
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:205)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: Invalid column index
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5265)
oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5257)
org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:83)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.

--------------------------------------------------------------------------------

Apache Tomcat/6.0.13
please help me so that i can proceed further

java.sql.SQLException: Invalid column index

This error message should be obvious. You will probably have to look at the generated java source file for your JSP to determine the exact line that caused the problem - its line 83 in the generated source:
>>>org.apache.jsp.customerfrm_jsp._jspService(customerfrm_jsp.java:83)

By the way, I recommend that you not embed server-side scripts within a JSP, it makes fixing problems like this a little more difficult. You should be querying the database within servlet code (or within a POJO called by s servlet), and then have the servlet pass a JavaBean to the JSP with the results and then use JSTL to apply the results into the JSP.

sir can you give me some idea about the architecture of a customer tool.................

rich baliyani wrote:sir can you give me some idea about the architecture of a customer tool.................

High level architecture, three-tiered:
+ browser-based UI
+ application server
+ database server
Recommend use of MVC pattern for the application server.

That is as detailed as I am willing to get. Without knowing any of your customer's requirements I cannot get any more detailed.
See also: NotACodeMill