i want to create a simple form which stores date in to a ms access db

so i created a form register.html and action user_register.jsp

i also created a ms aceess db

when i fill the form the data is passed to the Auction.mdb but the server shows 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: Exception in JSP: /user_register.jsp:11

8: <% Statement myStatement = myConn.createStatement (); %>
9: <% String StrUser = request.getParameter("username"); %>
10: <% String StrPass = request.getParameter("password"); %>
11: <% ResultSet myResult = myStatement.executeQuery("INSERT INTO Auction([UserName], [Password]) VALUES ('"+StrUser+"', '"+StrPass+"')"); %>
12: <% myConn.close(); %>
13: </BODY>
14: </HTML>


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

javax.servlet.ServletException: No ResultSet was produced
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.user_005fregister_jsp._jspService(user_005fregister_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

java.sql.SQLException: No ResultSet was produced
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
org.apache.jsp.user_005fregister_jsp._jspService(user_005fregister_jsp.java:66)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

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

the regiser.html is

<html>
<head>
<title>Welcome to the Action...</title></head>
<body>
<form action="user_register.jsp" method="post">
Username:<input type="text" name="username">
Password:<input type="password" name="password">
<input type="submit" name="okfunc" value="OK">
</form></body></html>

user_register.jsp is

<HTML>
<BODY>
<%@ page language="java" import="java.sql.*" %>
<%  String url = "jdbc:odbc:Auction", user="", passwd=""; %>
<%   Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<%--<%   Connection myConn = DriverManager.getConnection (url, user, passwd); %> --%>
<% Connection myConn = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:/Auction/Auction.mdb"); %>
<%   Statement myStatement = myConn.createStatement (); %>
<% String StrUser = request.getParameter("username"); %>
<% String StrPass = request.getParameter("password"); %>
<%   ResultSet myResult = myStatement.executeQuery("INSERT INTO Auction([UserName], [Password]) VALUES ('"+StrUser+"', '"+StrPass+"')"); %>  
<% myConn.close(); %>   
</BODY>
</HTML>

i m very new to jsp so any help wud be gr8
thanx in advance

this is the server error log


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: Exception in JSP: /user_register.jsp:11

8: <% Statement myStatement = myConn.createStatement (); %>
9: <% String StrUser = request.getParameter("username"); %>
10: <% String StrPass = request.getParameter("password"); %>
11: <% ResultSet myResult = myStatement.executeQuery("INSERT INTO Auction([UserName], [Password]) VALUES ('"+StrUser+"', '"+StrPass+"')"); %>
12: <% myConn.close(); %>
13: </BODY>
14: </HTML>


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

javax.servlet.ServletException: No ResultSet was produced
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.user_005fregister_jsp._jspService(user_005fregister_jsp.java:77)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

java.sql.SQLException: No ResultSet was produced
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:259)
org.apache.jsp.user_005fregister_jsp._jspService(user_005fregister_jsp.java:66)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

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


the register.html file

<html>
<head>
<title>Welcome to the Action...</title></head>
<body>
<form action="user_register.jsp" method="post">
Username:<input type="text" name="username">
Password:<input type="password" name="password">
<input type="submit" name="okfunc" value="OK">
</form></body></html>

the user_register.jsp

<HTML>
<BODY>
<%@ page language="java" import="java.sql.*" %>
<% String url = "jdbc:odbc:Auction", user="", passwd=""; %>
<% Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); %>
<%--<% Connection myConn = DriverManager.getConnection (url, user, passwd); %> --%>
<% Connection myConn = DriverManager.getConnection("jdbc:odbcriver={MicroSoft Access Driver (*.mdb)};DBQ=C:/Auction/Auction.mdb"); %>
<% Statement myStatement = myConn.createStatement (); %>
<% String StrUser = request.getParameter("username"); %>
<% String StrPass = request.getParameter("password"); %>
<% ResultSet myResult = myStatement.executeQuery("INSERT INTO Auction([UserName], [Password]) VALUES ('"+StrUser+"', '"+StrPass+"')"); %>
<% myConn.close(); %>
</BODY>
</HTML>

Use single scriptlet if possible. To execute Non-query(Insert/delete/update/create/alter) use executeUpdate() method.

If the given connection url fails then use System DSN.

<HTML>
<BODY>
  <%@ page language="java" import="java.sql.*" %>
 <% 
    String url = "jdbc:odbc:Auction", user="", passwd=""; 
   Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
   Connection myConn = DriverManager.getConnection("jdbc:odbcriver={MicroSoft Access Driver (*.mdb)};DBQ=C:/Auction/Auction.mdb");
  Statement myStatement = myConn.createStatement ();
  String StrUser = request.getParameter("username");
  String StrPass = request.getParameter("password");

  myStatement.executeUpdate("INSERT INTO Auction([UserName], [Password]) VALUES ('"+StrUser+"', '"+StrPass+"')");
  myStatement.close();
  myConn.close(); 

%>
</BODY>
</HTML>

the value filled in the form are getting stored in the auction .mdb database but i still get a server error 500....

thanx in advance

thanku adatapost for ur reply

Error 500 shows that your page script has some problems. Let us know - How did you create your web application? - manually or netbean.

Error 500 shows that your page script has some problems. Let us know - How did you create your web application? - manually or netbean.

i did it manually...............i am using tomcat apache 5.5.27

actually i googled the code

Do you know how to create a web context? Actually, first you have to create web-context. Do you know the structure of Web application?

This question has already been answered. Start a new discussion instead.