Jdbc null pointer exception

[miko5054]

im tring to wite a jdbc class but greeting a NULL pointer exception on this line

resultSet = preparedStatement.executeQuery(sql);

this is the complete code...

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

public class Select {
//	java.util.Date today = new java.util.Date();
//	java.sql.Date timeStamp = new java.sql.Date(today.getTime());
	
	
	DataBean dataBean = null;
	String localtransactionid ;
	int eventsequenceid = 0;
	Date  eventtimestamp=null;
	String msgflowname = null;
	String eventname = null;
	String brokername = null;
	String severity = null;
	String businesstransactionid = null;
	String url = "***********";
	String username = "*****";
	String password = "*****";
	PreparedStatement preparedStatement = null;
    Statement st = null;
	ResultSet resultSet = null;
	Connection connection = null;

	public Select() {
		connection = getConnection();
	}

	private Connection getConnection() {
		try {
			if (connection == null || connection.isClosed()) {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				connection = (DriverManager.getConnection(url, username,
						password));
			}
		} catch (Exception e) {
		}
		return connection;

	}

	public DataBean selectFilters(String msgflowname, String eventname,
		
			String severity, String businesstransactionid,
			String localtransactionid, Date  eventtimestamp, int eventsequenceid) {
		StringBuilder builder = new StringBuilder();
		builder.append("SELECT eventtimestamp,msgflowname,eventname,severity,localtransactionid,eventsequenceid,businesstransactionid");
		builder.append(" FROM ESB_LOGGER ");
		builder.append(" WHERE ");
		if (localtransactionid != null) {
			builder.append("localtransactionid=" + localtransactionid + ",");
		}
		if (eventsequenceid != 0) {
			builder.append("eventsequenceid=" + eventsequenceid + ",");

		}
		if (eventtimestamp != null) {
			builder.append("eventtimestamp=" + eventtimestamp + ",");
		}
		if (msgflowname != null) {
			builder.append("msgflowname=" + msgflowname + ",");
		}
		if (eventname != null) {
			builder.append("eventname=" + eventname + ",");
		}
		if (brokername != null) {
			builder.append("brokername=" + eventname + ",");
		}
		if (severity != null) {
			builder.append("severity=" + severity + ",");
		}
		if (businesstransactionid != null) {
			builder.append("businesstransactionid==" + businesstransactionid + ",");
		} else {
			System.err.println("all the query is  null");
		}
		builder.append("ORDER BY "+eventtimestamp+ " DESC");
		System.out.println(builder.toString());
		String sql = builder.toString();
		try {
		resultSet = preparedStatement.executeQuery(sql);
			while (resultSet.next()) {
				localtransactionid = resultSet.getString("LOCALTRANSACTIONID");
				String eventseqid = resultSet.getString("EVENTSEQUENCEID");
				eventtimestamp = resultSet.getDate("EVENTTIMESTAMP");
				eventname = resultSet.getString("EVENTNAME");
				businesstransactionid = resultSet
						.getString("BUSINESSTRANSACTIONID");
					severity = resultSet.getString("SEVERITY");
				eventsequenceid = Integer.parseInt(eventseqid);
				dataBean = new DataBean(eventtimestamp, msgflowname, eventname,
						severity, localtransactionid, eventsequenceid,
						businesstransactionid);

			}
			preparedStatement.close();
			resultSet.close();
			connection.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return dataBean;

		}
		
}

thanks miki

[makpandian]

If possible post your error log. Then only find out exactly where the bug is.

[miko5054]

ava.lang.NullPointerException
at Select.selectFilters(Select.java:93)
at MAIN.main(MAIN.java:28)

[JosAH]

im tring to wite a jdbc class but greeting a NULL pointer exception on this line

resultSet = preparedStatement.executeQuery(sql);

Your preparedStatement is null; you initialized it to that value and never assigned another value to it.

kind regards,

Jos