Java

java project database error

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Mar 2008

Posts: 8

Reputation: madhusamala is an unknown quantity at this point

Solved Threads: 1

madhusamala madhusamala is offline

Offline

Newbie Poster

java project database error

Mar 5th, 2008

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

•

Join Date: Dec 2007

Posts: 1,706

Reputation: javaAddict is a name known to all

Solved Threads: 228

javaAddict javaAddict is offline

Offline

Posting Virtuoso

Re: java project database error

Mar 5th, 2008

In the form tag you must put the url in the 'action' attribute and in the 'method' attribute you put post or get:

Help with Code Tags

Java Syntax (Toggle Plain Text)

<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

Last edited by javaAddict; Mar 5th, 2008 at 4:14 am.

Check out my New Bike at my Public Profile at the "About Me" tab

•

Join Date: Mar 2006

Posts: 9

Reputation: Nilesh Pagar is an unknown quantity at this point

Solved Threads: 1

Nilesh Pagar Nilesh Pagar is offline

Offline

Newbie Poster

Re: java project database error

Mar 5th, 2008

<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>

Nilesh Pagar

•

Join Date: Nov 2004

Posts: 6,143

Reputation: jwenting is just really nice

Solved Threads: 212

jwenting

Offline

duckman

Re: java project database error

Mar 5th, 2008

well, that form tag you posted won't do as it's seriously malformed...

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.

•

Join Date: Mar 2006

Posts: 9

Reputation: Nilesh Pagar is an unknown quantity at this point

Solved Threads: 1

Nilesh Pagar Nilesh Pagar is offline

Offline

Newbie Poster

Re: java project database error

Mar 5th, 2008

•

Originally Posted by jwenting

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.

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

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