DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Java (http://www.daniweb.com/forums/forum9.html)
-   -   java project database error (http://www.daniweb.com/forums/thread112259.html)

madhusamala Mar 5th, 2008 3:17 am
java project database error
 
i am doing an acadamic java project by using html, servlets.
in html form tag what is the url that i have to give in post attribute.
and i am using access as my database. it is giving that httpserver error
that given table is not found. will u please help me in sorting out this problem

javaAddict Mar 5th, 2008 4:13 am
Re: java project database error
 
In the form tag you must put the url in the 'action' attribute and in the 'method' attribute you put post or get:
<form action="someurl" method="post">
...
</form>
When you submit the form you send the information that are inside it to the given url
And I would suggest to use .jsp to build your pages not servlets

Nilesh Pagar Mar 5th, 2008 9:06 am
Re: java project database error
 
<form action="url"mehtod="post"/>
but this url should identify which servlet to run at server side.

So,
in your web.xml, your

<servlet-mapping>
<servlet-name>somename</servlet-name>
<url-pattern>this pttern should identify your action url properly</url-pattern>
</servlet-mapping>

e.g.
if action="*.do" then
url patter should be

<url-pattern>*.do</url-pattern>

jwenting Mar 5th, 2008 12:01 pm
Re: java project database error
 
well, that form tag you posted won't do as it's seriously malformed...

Nilesh Pagar Mar 5th, 2008 2:07 pm
Re: java project database error
 
Quote:

Originally Posted by jwenting (Post 552911)
well, that form tag you posted won't do as it's seriously malformed...


Well, then you will have a tough time in your project. Anyways it works for me.

Deploy below files in tomcat or any Servlet Container.

Directory structure should be like this.

Sample
---+WEB-INF
------+classes
----------+com
-------------+sample
------------------+Servlet.class
------------------+Servlet.java
------+lib
----------+servlet-api.jar
------+web.xml
---+index.html

1. index.html

<html>
<head></head>
<body>
<form action="sample.do" method="post">
<input type="submit" name="myName" ></input>
</form>
</body>
</html>

2. Servlet.java

package com.sample;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class SampleServlet extends HttpServlet{

private static final long serialVersionUID = -8734960688756643493L;

protected void doGet(HttpServletRequest arg0, HttpServletResponse arg1) throws ServletException, IOException {
service(arg0, arg1);
}
protected void doPost(HttpServletRequest arg0, HttpServletResponse arg1) throws ServletException, IOException {
service(arg0, arg1);
}

protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<HTML>" +
"<HEAD>Sample</HEAD>" +
"<BODY>\n" +
"<H1>Hello World</H1>\n" +
"</BODY>" +
"</HTML>"); }

}


3. web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

<display-name>Sample</display-name>

<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>

<servlet>
<servlet-name>sample</servlet-name>
<servlet-class>com.sample.SampleServlet</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>sample</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
</web-app>


4. servlet-api.jar
download it from
http://www.mtholyoke.edu/courses/sro...ervlet-api.jar

Deploy this application and check if it works. If this also doesn't work then best luck.:D

And by the way "*.do" url is properly functioning in this sample web project.:-O

And about the database error, it might not have been configured properly, provided if you are not doing anything logically or syntactically wrong in your code which connects D:'( B.


All times are GMT -4. The time now is 8:49 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC