Facing nullpointer exception in Spring JDBC Query.

[Robinson Francis]

Dear all,

I am facing a null pointer exception while trying to build a Spring JDBC application.

The code that calls the Dao Interface is :

//Node location utilization to go here--------------------------------------------->>
			String[] frontPartOfNodeLoc = nodeLocation.split(":");
			System.out.println(frontPartOfNodeLoc[0]);
			int numOfRecords = xrefUtility.retrieveNodeLocationCount(frontPartOfNodeLoc[0]);
			System.out.println("Number of records with this node location is : "+numOfRecords);
//Node location utilization to go above here--------------------------------------->>

The code for retrieveNodeLocationCount is defined in the Dao class file of XRefUtilityDao.java as below:

public int retrieveNodeLocationCount(String nodeLocation);

The implementation is defined in this file : XRefUtilityDaoImpl.java as :

@Override
	public int retrieveNodeLocationCount(String nodeLocation) {
		// TODO Auto-generated method stub
		String retrieveCount = "SELECT COUNT(brm_purchased_product_poid) FROM xref_product_mapping WHERE brm_purchased_product_poid = ? AND inactive_date = null";
		logger.debug("retrieveCount SQL: " + retrieveCount);
		logger.debug("SQL parameters: " +nodeLocation);
		
		Object[] parameters = new Object[]{nodeLocation};
		
		return getJdbcTemplate().queryForInt(retrieveCount, parameters);
	}

For some reason the the execution doesn't reach this portion of code called. Every time I pass the parameters to this method in

 int numOfRecords = xrefUtility.retrieveNodeLocationCount(frontPartOfNodeLoc[0]);

It returns a Null Pointer exception.

Is it true that the service poid contains tmm_streamyx?--->false

Completed process.
MCMB-BILLING#12681/1#20080609-142642.633
java.lang.NullPointerException
	at com.tm.iCarePrime.eai.adapter.mcmb.MCMBSimplyForFun.main(MCMBSimplyForFun.java:180)

I am still new at this Spring Jdbc, I was wondering why this problem cropped up. Maybe I missed something. Thank you.

[Csabba Csurja]

Hi,

from your posted code I was not able to see what is the statment in MCMBSimplyForFun.java:180 line.
Basically, the getJdbcTemplate.queryForInt doesn't throw NullPointerException.
Are you sure that getJdbcTemplate is not null it self, you can check it, if not then give a try to execute a very simple query which is 100% should run (e.g. without any paramter)

Regards,
Csaba