cs=objConn.prepareCall("{call [dbo].[get_storeDemographicsData](?,?,?,?,?,?,?,?)}");
			for (int i = 1; i < rowCount; i++) 
			{
				//Get Individual Row
				rowData = s.getRow(i);
				
				String personNo=rowData[0].getContents();
				String addressType=rowData[1].getContents().toUpperCase();
				String countryCode=rowData[2].getContents().toUpperCase();
				String effectStartDate=rowData[6].getContents();
				String effectEndDate=rowData[7].getContents();
				
				//mandatory fields validation
				if((personNo.equals(""))
						||(addressType.equals(""))
						||(countryCode.equals(""))
						||(effectStartDate.equals(""))
						||(effectEndDate.equals("")))
				{
					msg="Mandatory fields are missing";
					errorFlag=1;
					errorRecords = errorRecords+personNo+"|"+msg+"$";
				}
				
				//address type validation
				
				if(!(addressType.equals("WORK")||addressType.equals("HOME")))
				{
					msg="Address type should be either work or home";
					errorFlag=1;
					errorRecords = errorRecords+personNo+"|"+msg+"$";
				}
				
				//country code vallidation
				ArrayList <String> result1 = new ArrayList<String>();
				CallableStatement cs1 = objConn.prepareCall("{call [dbo].[Get_FetchCountryCodeDetails]}");
				cs1.execute();
				ResultSet rs1=(ResultSet)cs1.getResultSet();
				while(rs1.next()){   
					result1.add( rs1.getString("cntry_cd_2"));
					
				} 
				if(!result1.contains(countryCode))
				{
					msg="Invalid Country code";
					errorFlag=1;
					errorRecords = errorRecords+personNo+"|"+msg+"$";
				}
				
				//effect start date and end date validations
				
				SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy");
				try {
					sdf.parse(effectStartDate.trim());
					sdf.parse(effectEndDate.trim());
				} catch (ParseException e) {
					// TODO Auto-generated catch block
					msg="Invalid Date format";
					errorFlag=1;
					errorRecords = errorRecords+personNo+"|"+msg+"$";
				}
				
				//if all the validations are satisfied
				
				
					cs.setString(1,rowData[0].getContents());
					cs.setString(2,addressType);
					cs.setString(3,countryCode);
					cs.setString(4,rowData[3].getContents().toUpperCase());
					cs.setString(5,rowData[4].getContents());
					cs.setString(6,rowData[5].getContents());
					cs.setString(7,rowData[6].getContents());
					cs.setString(8,rowData[7].getContents());
				
					cs.addBatch();
				
			}
			if(errorFlag==0)
			{				
				
					cs.executeBatch();
					cs.clearBatch();
					objConn.commit();
			}