java.lang.NullPointerException

[Farakh khan]

Hello,

public boolean isCvExist(String email,String phone,String mobile){

	email = email.toLowerCase();

	boolean exists = false;

		try{
			if ((cnn==null)||cnn.isClosed()){
			cnn=DB.getOracleConnection();
			}
		
		String query =	" select "+
				" 	count(*) from users a, cvProperties b, cvDetails c "+
				" where  "+
				" 	a.user_id=b.user_id and b.cv_id=c.cv_id "+
				" and "+
				" 	lower(login)=? "+
				" OR  "+
				" 	lower(email)=?  "+
				" OR  "+
				" 	phone=? "+
				" OR  "+
				" 	mobile=?";

		PreparedStatement ps=cnn.prepareStatement(query);
		ps.setString(1, email);
		ps.setString(2, email);
		ps.setString(3, phone);
		ps.setString(4, mobile);

		rs=ps.executeQuery();

		if(rs.next()){
			int totalRecords = rs.getInt(1);
			
			if(totalRecords>0){
			exists = true;
			}
		}
		ps.close();					

		}catch(Exception e){
		System.out.println("UserDAO.isCvExist()"+e.toString()); 
		}

	return exists;
	}

I am calling this method like:

boolean isCvExists = cd.isCvExist(email,phone,mobile);

		if(isCvExists){			
			System.out.println("cvName===>"+cvName);
			out.println("<br>"+cvName+" ... <font color=red>already exists. Not parsed</font><br>");
			um.deleteFile(destPath, cvName);
		}
		else{
		//website=1,agent=2,staff=3,employer=4
		String cvIds = ud.insertToCvProperties(req,3,staffId,userId,category,cvName,"0",0);
		String cvId = (String) session.getAttribute("cvId");			

			String insertIntoCvDetails = 
				ud.insertIntoCvDetails(cvId,
				  nullCheck(objectives),nullCheck(name),nullCheck(fatherName),nullCheck(motherName),
				  nullCheck(dob),nullCheck(gender),nullCheck(mStatus),nullCheck(nationality),
				  nullCheck(passportNo),nullCheck(email),nullCheck(phone),nullCheck(mobile),
				  nullCheck(address),nullCheck(state),nullCheck(zipCode),nullCheck(city),
				  nullCheck(education),nullCheck(work),nullCheck(skills),nullCheck(languages),
				  nullCheck(hobbies),nullCheck(achievements),nullCheck(references));

			out.println("CV insert into DB successfully.....");
		}//cvExists

but sometime its throw the following NPE:

BulkUpload.java java.lang.NullPointerException
java.lang.NullPointerException
        at CvDAO.isCvExist(CvDAO.java:710)
        at BulkUpload.doPost(BulkUpload.java:209)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:304)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:175)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:164)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:100)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
929)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:405)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:261)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:515)
        at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoin
t.java:1773)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:603)
        at java.lang.Thread.run(Thread.java:722)

Thanks & best regards

[Matthew Brown]

So which line does it throw it on? I can see it's line 710 in the source file - how does that correspond to the code you've posted?

[Muhammad Saifuddin]

Its time for debugging..

as Exception already point you the method.

at CvDAO.isCvExist(CvDAO.java:710)

use System.out.println before and after inside isCvExist method under if statement or use IDE debugger, you can use Netbeans for it.

[Farakh khan]

Matthew Brown wrote:So which line does it throw it on? I can see it's line 710 in the source file - how does that correspond to the code you've posted?

I am thankful to you Metthew.
email = email.toLowerCase(); was on line 710 that was coming NULL I fixed and now its running fine

Thanks again from the bottom of my heart

Best regards

[Matthew Brown]

You're welcome! I didn't really do anything, though - just suggested you look more closely at the error the computer was giving you. You solved the problem.