Login (web application)

[ the.nick @ 17.10.2007. 18:04 ] @

Pozdrav! Pravim web aplikaciju u JDeveloper-u 10.1.3.3.0, koja treba da uradi autentifikaciju nad korisnickim podacima (username i password), koji se nalaze u Oracle 10g XE (shema je NIKOLA). Medjutim kada pokrenem index-nu stranicu i submit-ujem podatke izbaci mi gresku u browser-u, a kod koji sam sastavio mi se cini ok ali ocigledno nesto nije u redu.
Unaprijed hvala na pomoci!

Greska koju izbaci browser:

Code:

500 Internal Server Error
java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113) at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029) at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274) at view.Login.authenticate(Login.java:40) at _validateuser._jspService(_validateuser.java:60) [/validateuser.jsp] at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)

index.jsp

Code:

<html><head><body>
<form action="validateuser.jsp" method="POST">
Username : <input type="text" name="userName">
Password : <input type="password" name="passWord">
<input type="submit" value="Submit">

<input type="reset" value="Reset">
</form></body></html>

Code:

package view;

import java.sql.*;
import java.io.*;

public class Login {

//default constructor
public Login(){}

//method for the catabase connection
public Connection getConnection()
throws IOException{
Connection conn = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:XE", "nikola", "nick");
}
catch(SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
while((e = e.getNextException()) != null)
System.out.println(e.getMessage());
}
catch(ClassNotFoundException e)
{
System.out.println("ClassNotFoundException: " + e.getMessage());
}
return conn;
}

//method that is called from validateuser.jsp and this checks for the authentic user and pass
public boolean authenticate(String user, String pass)
throws SQLException, IOException{
String Username = null, Password = null;
Login dbconn = new Login();
Statement stmt = dbconn.getConnection().createStatement();
String sql = "SELECT USER_NAME, PASS_WORD FROM LOGIN WHERE USER_NAME='" + user + "'" + "AND PASS_WORD='" + pass + "'";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next()){
Username = rs.getString("USER_NAME");
Password = rs.getString("PASS_WORD");
}
if(Username != null && Password != null && user.equals(Username) && pass.equals(Password)){
return true;
}
else return false;
}
}

validateuser.jsp

Code:

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.util.*" %>
<jsp:useBean id="idHandler" class="view.Login" scope="request">
<jsp:setProperty name="idHandler" property="*"/>
</jsp:useBean>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>
<head><body>
<%
String userName = request.getParameter("userName");
String passWord = request.getParameter("passWord");
if (idHandler.authenticate(userName, passWord)){
response.sendRedirect("cpanel.jsp");
} else {
response.sendRedirect("index.jsp");
}
%>
</body></head>
</html>

web.xml

Code:

<?xml version = '1.0' encoding = 'windows-1252'?>
<web-app 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" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee">
<description>Empty web.xml file for Web Application</description>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>view.Login</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>35</session-timeout>
</session-config>
<mime-mapping>
<extension>html</extension>
<mime-type>text/html</mime-type>
</mime-mapping>
<mime-mapping>
<extension>txt</extension>
<mime-type>text/plain</mime-type>
</mime-mapping>
</web-app>