Erro ao conectar ao oracle com Beans

Pessoal fiz um aplicação em jsp e utilizando javaBeans para conectar ao Oracle e me retornar um resultSet. Estou utilizando o Tomcat. Quando entro na pagina me dar o seguindo erro.

//-------------------------------------------------------------------------------
// Erro no tomcat
//-------------------------------------------------------------------------------

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

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:346)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

root cause

java.lang.NullPointerException

pAccess.Conectar.getStatement(Conectar.java:48)

pAccess.Conectar.getResult(Conectar.java:53)

org.apache.jsp.logar_jsp._jspService(logar_jsp.java:71)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)

javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

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

//-------------------------------------------------------------------------------

// Fonte do Beans

//-------------------------------------------------------------------------------

package pAccess;

import java.sql.DriverManager;

import java.sql.SQLException;

public class Conectar {

private String hostName = null;
private String userName = null;
private String password = null;
private String url = null;
private String jdbcDriver = null;
private String dataBaseName = null;
private String dataBasePrefix = null;
private String dataBasePort = null;

public Conectar(){
	super();
	// ajustar os valores para cada bando
	hostName = "10.85.200.15";			
	userName = "login";
	password = "senha";
	jdbcDriver = "oracle.jdbc.driver.OracleDriver";
	dataBaseName = "Oracle";
	dataBasePort = "1521";	
	dataBasePrefix ="jdbc:oracle:thin:@";
	
	url = dataBasePrefix + hostName + ":" + dataBasePort + ":" + dataBaseName; 
}


private java.sql.Connection getConexao() throws SQLException{
	try{
		Class.forName(jdbcDriver);
		try{
			return DriverManager.getConnection(url,userName,password);							
		} catch (Exception e){
			e.printStackTrace();
			return null;
		}
	} catch (Exception e){
		e.printStackTrace();
		return null;
	}
}

private java.sql.Statement getStatement() throws SQLException{
	return	getConexao().createStatement();	
}
 

public java.sql.ResultSet getResult(String sql) throws SQLException{
	return getStatement().executeQuery(sql);
}

}

//-------------------------------------------------------------------------------

// Fonte do JSP

//-------------------------------------------------------------------------------

<%@ page import = “pAccess.Conectar”%>

<jsp:useBean id=“pCon” class = “pAccess.Conectar” />

<%@ page import=“java.sql.*” %>

<%@ page import=“java.sql.DriverManager” %>

<%@ page import=“java.sql.SQLException” %>

<%

String sql = “”;

String usu = “”;

String pass = “”;

usu = request.getParameter("txtusuario");

sql = "Select apecli from e085cli where codcli = 100";
java.sql.ResultSet rs;
rs = pCon.getResult(sql);

try{
	if (rs.next()){
		out.println(rs.getString("apecli"));
	}else{
		out.println("Não encontrado");
	}	 
}catch(SQLException e){
	out.println("Não conectou");
}finally{
	out.println("fechado");
}
 
out.println(usu);

//-------------------------------------------------------------------------------
// Fim
//-------------------------------------------------------------------------------

1 Resposta

Topicos relacionados