Various error during maven configuration with java spring

Q1- During project Creation or Maven Update or if Pom.xml showing any error or dependecy jar not loading then-

Solution:  Go to User Profile Foler =>.m2=>delete .lastupate.

if you unable to find User Profile folder then follow below steps-

1-Open folder by running this text (without Quotes) in Search Explorer of Window “%USERPROFILE%.m2”.
2-After running above command, “m2” folder of maven will open. Now search for file (without Quotes) “*.lastUpdated”.
3-In this step, delete all the files found by running Step 2.
4-Now go to Eclipse project and select “Maven | Update Dependency” or “Maven | Update Project”
5-If you still facing error then close eclipse and delete .m2 folder and try again.

-----------------------------------------------------------------------------------------

Q2- Could not transfer artifact org.apache.maven.plugins:maven-surefire-plugin:pom:2.7.1 from/to central
or
ArtifactTransferException: Could not transfer artifact
or
How to create settings.xml

Solution: Create settings.xml file in User Profile Foler =>.m2 folder.  ( if you are unable to fine user profile folder then see Q1 (above).

To create settings.xml file-> open notepad-> paste below code-> save as-> File Name- settings.xml. Save As Type- All and Save.

<settings xmlns="http://maven.apache.org/SETTINGS/1.0.0"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0
https://maven.apache.org/xsd/settings-1.0.0.xsd">
<localRepository>${user.home}/.m2/repository</localRepository>
<interactiveMode>true</interactiveMode>
<offline>false</offline>
</settings>

---------------------------------------------------------------------------------

Q3- tomcat:deploy: “Cannot invoke Tomcat manager: Connection refused”
Solution: Before deploying of project make sure following-
For tomcat7 or tomcat 8 do the following-

1- Project- pom.xml

<plugin>
    <groupId>org.apache.tomcat.maven</groupId>
    <artifactId>tomcat7-maven-plugin</artifactId>
    <version>2.2</version>
    <configuration>
        <url>http://localhost:8080/manager/text</url>       
        <path>/projectName</path>
        <username>tomcat</username>
        <password>tomcat</password>
    </configuration>
</plugin>

2- TomcatDirectory\conf\ tomcat-users.xml: Add below line in  section

<role rolename="manager-gui"/>
  <role rolename="manager-status"/>
  <role rolename="manager-script"/>
  <role rolename="manager-jmx"/>
  <user username="tomcat" password="tomcat" roles="manger-gui,manager-status,manager-script,manager-jmx"/>

it will show like this-

Now run project and deploy it (Right Click on project=>Run as=>Run Configuration)

Gole:- clean install tomcat7:deploy   (For first time deployment) and for next time use clean install tomcat7:redeploy. 

Profile:-Leave Blank

Gole:-Default or path (if you have created settings.xml)

Create a maven project and Deloy maven project with tomcat

In this tutorial we learn-
1- How to create Maven based Java web project.
2- How to deploy/run project with tomcat server.


First make sure your eclipse have installed maven plugin. if not then your need to install m2e-eclipse plugin in order to have this simple utility in Eclipse.

• You can follow below link to install Maven plugin in eclipse-https://stackoverflow.com/questions/8620127/maven-in-eclipse-step-by-step-installation

1  Create Maven Project in STS ( Spring Tool Suite ).

1-Click File —> New —> Others menu, select Maven Project in the popup wizard dialog.
eclipse file new others maven project wizard dialog

2-Click Next button, check Create a simple project checkbox in the next dialog.

3-Input the spring project group id, artifact id and select packaging type with war in the next dialog.


4-Click Finish button to complete the wizard. In the left package explorer panel, you can see the project just created, the project name is just the artifact id.

5-There is an error in the pom.xml, the error message is “web.xml is missing and is set to true“, so copy below xml code into pom.xml between project xml tag.
<build>
    <finalName>Deploy maven project to tomcat example</finalName>

       <plugins>
          <plugin>
             <artifactId>maven-war-plugin</artifactId>
             <version>2.3</version>
             <configuration>
               <failOnMissingWebXml>false</failOnMissingWebXml>
             </configuration>
          </plugin>
       </plugins>
</build>

6-Now right click the project name in left package explorer panel, click Maven —> Update Project menu item, then all the project error will disappear.

2. Deploy Maven Project To Tomcat.

First make sure following-
1- Tomcat is installed or have downloadd Tomcat Folder.
2-CATALINA_HOME (tomcat), JRE_HOME (jre) or JAVA_HOME (java) set in system environment veriable. (how to set environment veriable- http://hemantmenaria.blogspot.com/search/label/set%20catalina_home)
3- Need to start tomcat.

1-Before we can deploy eclipse maven project to tomcat, we need to add below user role in TOMCAT_HOME/conf/tomcat-users.xml file (Under <tomcat-users > section) as below, otherwise there will throw an unauthorized error during the maven project deploy process. Then we should restart tomcat server. When deploy war to tomcat in maven plugin, the role should be manager-scrip.

<!-- tomcat role is used to deploy maven project to tomcat in eclipse scripts.-->

<user username="tomcat" password="tomcat" roles="manager-script"/>
<!-- admin role is used to login tomcat manager GUI. -->

<user username="admin" password="admin" roles="manager-gui"/>

2-Then add below xml in the pom.xml plugins section.

<plugin>
   <groupId>org.apache.tomcat.maven</groupId>
   <artifactId>tomcat7-maven-plugin</artifactId>
   <version>2.2</version>
   <configuration>
      <url>http://localhost:8080/manager/text</url>
      <path>/DeployMavenToTomcat</path>
      <!-- Set update to true to avoid exist war package can not be override error -->
      <update>true</update>
      <!-- Because deploy this maven project using plugin in pom so use the manager-script role user. -->
      <username>tomcat</username>
      <password>tomcat</password>
   </configuration>
</plugin>

3-Right click the maven project, click Run As —> Run Configurations menu item.

4-Input clean install tomcat7:deploy in the Goals input text box.

5-Click Run button, when you see BUILD SUCCESS in the output console, that means the maven project has been deployed to tomcat server successfully.

6-Open a web browser, and input http://localhost:8080/manager/html, input admin / admin in the popup prompt. After you login, you can see DeployMavenToTomcat application in the application list

Convert existing Java project to Maven

Convert existing Java or Spring project into Maven based Project-

Steps you need to follow-

1- Make sure your eclipse have installed maven plugin. if not then your need to install m2e-eclipse plugin in order to have this simple utility in Eclipse.

• You can follow below link to install Maven plugin in eclipse-https://stackoverflow.com/questions/8620127/maven-in-eclipse-step-by-step-installation 

2- Now In your eclipse just right click on Java Project and click Configure and you should see “Convert to Maven Project” option

3- You will see dialogue like this below. Just enter“Name” and you should be all set.

4- Now you can see a new file pom.xml in your project- A Project Object Model or POM is the fundamental unit of work in Maven. It is an XML file that contains information about the project and configuration details used by Maven to build the project. It also manages all the jar dependency required by your project.

5- Next, make the list of all dependency jar which you have configured in Java Build Path and add  all jar dependency into pom.xml file.

6-To get maven jar dependency, go to https://mvnrepository.com/  (Maven website). Here search all jar one by one and select version.

7- Now copy the code mentioned in Maven tab (maven dependency code) and paste it into pom.xml under dependencies section as shown below.

8- One by one paste all the jar dependency in pom.xml.

9- All done, project has been converted into maven based project.

note : if you are getting any error in pom.xml then you need to update your maven. (Right click on project=> click on Maven=> Update Project; Make sure "Force Updateof Snapshots/Releases" is checked.)
--------------------------------------------------------------------------------------

Now How to compile and run the maven based project?

Step-1. Right click on project=> click on Maven=> Update Maven. Make sure "Force Update of Snapshots/Releases" is checked during project Update. (if done then skip it.)

Step-2 After updating Right click on project=> click on Run As=> Maven Install (Shown Below)

and done :)
Check on the console. if you get any compilation error like Build Failer ("no compiler is provided in this environment perhaps you are running on a jre"). then=> 
Right Click on project=> Build Patah => Configure Build Path=>Select Library Tab=> Double Click on JRE System Library=>Now select Workspace default JRE option =>Finish & Apply.

Step-3 If you have faced any error in step-2 then again try to build by Right click on project=>Click on Run As=> Maven Clean and check console for a successful build.

Note:- During above steps if you still getting error or any issue or want to try all step again then first you need to delete .m2/repository from your eclipse working directory. (c:/user/username/.m2). Just close eclipse and delete .m2 folder and try again.


In case of any issue, you can watch below video-

Excel split data into multiple worksheets based on column

 Here VBA Code to split data into multiple worksheets based on selected column

If you have an excel sheet and want to split the data into individual multiple sheet based on column valued then the below code is best for you.


Open Visual basic editor by pressing Alt+F11
On project window at left side => right click on project => insert=>Module.
now paste below code. read comments and set your parameter.

Sub parse_data()
Dim lr As Long
Dim ws As Worksheet
Dim vcol, i As Integer
Dim icol As Long
Dim myarr As Variant
Dim title As String
Dim titlerow As Integer
vcol = 7  ''name of column on which basis you want to create saprate sheet
Set ws = Sheets("finalsheet")  ''name of your master sheet which need to compile
lr = ws.Cells(ws.Rows.Count, vcol).End(xlUp).Row
title = "A1:V1"  ''range of column which need to transfer into each individual sheet
titlerow = ws.Range(title).Cells(1).Row
icol = ws.Columns.Count
ws.Cells(1, icol) = "Unique"
For i = 2 To lr
On Error Resume Next
If ws.Cells(i, vcol) <> "" And Application.WorksheetFunction.Match(ws.Cells(i, vcol), ws.Columns(icol), 0) = 0 Then
ws.Cells(ws.Rows.Count, icol).End(xlUp).Offset(1) = ws.Cells(i, vcol)
End If
Next
myarr = Application.WorksheetFunction.Transpose(ws.Columns(icol).SpecialCells(xlCellTypeConstants))
ws.Columns(icol).Clear
For i = 2 To UBound(myarr)
ws.Range(title).AutoFilter field:=vcol, Criteria1:=myarr(i) & ""
If Not Evaluate("=ISREF('" & myarr(i) & "'!A1)") Then
Sheets.Add(after:=Worksheets(Worksheets.Count)).Name = myarr(i) & ""
Else
Sheets(myarr(i) & "").Move after:=Worksheets(Worksheets.Count)
End If
ws.Range("A" & titlerow & ":A" & lr).EntireRow.Copy Sheets(myarr(i) & "").Range("A1")
Sheets(myarr(i) & "").Columns.AutoFit
Next
ws.AutoFilterMode = False
ws.Activate
End Sub



=========================
now its time to run your code by pressing F5.
Done!

X-Frame-Options Header Not Set 'ClickJacking' attacks

X-Frame-Options header is included in the HTTP response to protect against 'ClickJacking' attacks.

The X-Frame-Options header is used to indicate whether or not a website/browser should be allowed to open a page in frame or iframe.This will prevent website content embedded into other websites.
It protect against 'ClickJacking' attacks.
 
There are three options for X-Frame-Options: 

• SAMEORIGIN: This option will allow page to be displayed in frame on the same origin, means you can render the same website page into iframe/frame. 
  
•  DENY: This option will prevent a page displaying in a frame or iframe, means no one website can render website page in frame/iframe.  
• ALLOW-FROM uri: This Option will allow page to be displayed only on the specified origin.if you want to allow render the page of website for a particular website then you can use this option.

Syntax: 

IN HTML Page:- Type below code in head section:

       http-equiv="X-FRAME-OPTIONS" content="DENY">

IN PHP Page:- 



 ========================================================
You can use any web developer tool to view Response headers and ensure you see

======================================================

Configuring Apache HOw to Check X-Frame-Option of a web page:
To configure Apache to send the X-Frame-Options for all pages, add below setting to your site as required:

• Header always append X-Frame-Options SAMEORIGIN 
• Header set X-Frame-Options DENY 
• Header set X-Frame-Options "ALLOW-FROM https://example.com/"  

======================================================

Cpanel Cron job for mysql datbase backup

Cron Job: Cron Job is a time base task which will execute on a fixed time or interval (repeat after a time).

How to create a cron job in cpanel to take database backup. 

Now Follow the Steps:

Step 1- First of all Create a file on your computer system and paste below code into file 

[client]

user = yourCpanelUserName

password = "yourCpanelPassword"

host = localhost

save above file with .my.cnf and upload it to your server directory (like /home/Your_Domain_Directory/)

 Step 2- Create a folder for backup with name of  db_backup on server at same place ( /home/Your_Domain_Directory/)

Step 3- 

1 -Go to Cpanel main page

2- Click on Cron Job

3- Enter email for notification regarding cron job.

4- Select Job Setting  means frequency of your task /job execution.

5- Paste below line in command text box:

mysqldump --all-databases  > /home/Your_Domain_Directory/db_backup/All_DB_Backup_$(date +'\%d-\%m-\%Y').sql

The above code will generate backup for your all databases in /home/Your_Domain_Directory/db_backup directory with the name of "All_DB_Backup_TodayDate".  so if you set daily backup policy then it will create a backup file with current date without overriding the same file.

if you want to take backup of a particular database then at the place of --all-database you can write the name of the particular database.

Step 4 - Finally click on Add Crone Job button to save it.

Step 5 - Go to the folder /home/Your_Domain_Directory/db_backup  to check your datbase backup.

httpd-xampp.conf: How to allow access to an external IP or another computer IP to mysql

Access Xampp mysql from another computer:-

Open your xampp folder go to =>apache=>conf=>extra=>httpd-xampp.conf

 copy below cod and past it into httpd-xampp.conf file 

// How to allow a particular IP to access

    Require local
    Require ip 10.0.0.1
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var

=====================

Note: Write the remote IP at the place of 10.0.0.1

======================================= 

// How to allow anyone to access which is not safe.

    # Require local
    Require all granted
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var