Error in connecting oracle 10g XE with java

Ranch Hand

Posts: 119

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Iam trying to connect oracle 10g XE with java but iam having some confusion please help me to solve my issue.

I am accessing tomcat with: localhost/8080 and oracle 10g with:localhost:80/apex

My schema name is hr password is hr

My code is :

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
import java.text.*;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.*;
import javax.servlet.http.*;

public class Login1 extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out = response.getWriter();
		try     {
	         // Load the JDBC driver
	            String driverName = "oracle.jdbc.OracleDriver";
	         Class.forName(driverName);
	            // Create a connection to the database
	            String serverName = "127.0.0.1";
	            String portNumber = "1521";
	         String sid = "XE";
	         String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
	         System.out.println(url);
	         String username = "hr";
	            String password = "hr";
	  Connection connection=null;   
	            connection = DriverManager.getConnection(url, username, password);
	            Statement stmt = connection.createStatement();
	            String sql = "select * from ADDUSER" ;
	            ResultSet rs=null;
	            rs=stmt.executeQuery(sql);
	            while(rs.next())
	            {
	            	rs.getString(1);
	            	rs.getString(2);
	            	rs.getString(3);
	            	rs.getString(4);
	            	rs.getString(5);
	            	rs.getString(6);
	            	rs.getString(7);
	            	rs.getString(8);
	            }
	            rs.close();
	            stmt.close();
	            connection.close();
	}
	         catch(Exception e)
	         {
	             System.out.println("Connection Error: " + e);
	         }
	            
	} 
}

Please guide me iam doing correct or not please help to solve my issue, iam using ojdbc14.jar, servlet-api.jar file

Error is
HTTP Status 404 - /trial/servlet/Login1

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

type Status report

message /trial/servlet/Login1

description The requested resource (/trial/servlet/Login1) is not available.

Please solve my issue, I not having any one to solve my issue in my office please guide me iam developing alone please solve y issue.

Thanks in advance.

P Arunkumar

Ranch Hand

Posts: 119

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi

Please guide me and solve my issue, please anyone reply for my post, its my request.

Thanks in advance.

P Arunkumar

Ranch Hand

Posts: 119

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

HI

i have tried it is working fine in java but i tried to connect with jsp, servlet + oracle its showing Null pointer Exception.

My Jsp code is working fine

Main.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Main</title>
</head>
<body>
<script type='text/javascript'>
	function validate(){
		var email=document.form.emailid.value;
		var password=document.form.pass.value;
	if(email==""){
	 alert("Enter Email-id!");
	  return false;
	}
	if(password==""){
	 alert("Enter Password!");
	  return false;
	}
	return true;
	}
	</script>
	<h1><i><center>TAT</center></i></h1>
	<form name="form" method="post" action="Login" onsubmit="javascript:return validate();">
	<center>
	<table align="right">
	<TR><h3>SIGN IN</h3></TR>
	<tr><td>Email-id:</td><td><input type="text" name="emailid"></td><td>Password:</td><td><input type="password" name="pass"></td>
	<tr><td></td><td><input type="submit" value="Login"></td></tr>
	</table>
	</center>
	</form>
</body>
</html>

My servlet code :

Login.java

package Main;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
import java.text.*;
 
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.*;
import javax.servlet.http.*;
import  java.sql.*;

public class Login extends HttpServlet {

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		PrintWriter out = response.getWriter();
		  Connection connection=null;
		  ResultSet rs;
		  HttpSession session = request.getSession(true);
		  String emailid=request.getParameter("emailid");
		  session.setAttribute("emailid",emailid);
		  String password=request.getParameter("pass");
		  response.setContentType("text/html");
		  int count=0;
		  try {
		 // Load the database driver
			  Class.forName("oracle.jdbc.driver.OracleDriver");
			  // connect using Thin driver
			  Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","hr","hr");	  
			  Statement s = connection.createStatement();
		  s.executeQuery ("select EMAIL,PASSWORD from ADDUSER where EMAIL='"+emailid+"' and PASSWORD='"+password+"'");
		  rs = s.getResultSet();
		  while (rs.next ()){
		  count++;
		  }
		  if(count>0){
			  out.println("You are Authenticated person \n");
	                          out.println("<br>");
	          out.println("welcome "+emailid);
	          RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/Profile1.jsp" );
	   	      dispatcher.forward( request, response );
	          }
	         else{
	        	 out.println("You are not an authentic person");
	         }
		  rs.close ();
		  s.close ();
		  }
		  catch(Exception e){
		  System.out.println("Exception is ;"+e);
		  }
	 
	}
	 public void destroy() { 
	}
	}

My oracle DB:

I am accessing tomcat with: localhost/8080 and oracle 10g with:localhost:80/apex

Table name ADDUSER

FIELDS
EMAIL,PASSWORD

Iam getting null pointer exception please solve my issue i can't guess why iam getting error please help me.

thanks in advance.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.