Block or stop connecting Peers or IP Addresses to utorrent

uTorrent is one of the more popular free torrent clients. The installer size is tiny and only a fraction of system resources are used when the program is running.

µTorrent is Very Easy Way to Download Files. Its Very Convenient to Download through this Software. The Main & very Excellent Feature of this Software is that you don't have to worry about your Link Breakdown or wait to Shutdown your Computer till your Download is Completed. It works when it gets the Internet Connection and Starts its Work. It Resumes the Downloads from where it was Interrupted.

Steps to block connecting Peers or IP Addresses:

Step 1: Options > Preferences > Advanced or press (CTRL+ P) and set the value of ipfilter.enable to true.

Step 2: Click the Peers tab. Right-click anywhere inside the Peers tab and uncheck “Resolve IPs” Tab.

Step 3: Open a Notepad window and manually type in any IP address per line that you wish to block, you can also block range of IPs eg. 192.168.2.xxx-192.168.2.xxx. Save the Notepad window (with the IP addresses) as “ipfilter.dat” (including the quotes).

Save/Paste this file on following location :
C:\Documents and Settings\<username>\Application Data\uTorrent (For Windows XP, 2003 and 2000).

C:\Users\<username>\AppData\Roaming\uTorrent (For Windows Vista, 7 and 8, 8.1).

Shortcut : Click Windows+R to open RUN an type %AppData%\uTorrent to open location.

Step 4: Right click anywhere on the Peers Tab and select Reload IP Filter:

This will block all IP Addresses that are present in your ipfilter.dat file.

Read More

Oracle and MySql : Find Top 3rd highest salary row from employee table

In Oracle using ROWNUM :
For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on.

You can use ROWNUM to limit the number of rows returned by a query, as in this example:

SELECT Cols |* FROM table_name WHERE ROWNUM < Number;

Example to find the 3rd highest salary using Oracle Database:

Employee Table :

Sql Command in action in Oracle Database

In SQL using SELECT TOP clause :

The SELECT TOP clause is used to specify the number of records to return, as in this example:

SELECT TOP number|percent column_name(s) FROM table_name;

Example to find the 3rd highest salary using MySql Database:
Query 1: SELECT MIN(SALARY) AS Salary FROM Employee WHERE SALARY IN (SELECT DISTINCT TOP 3 SALARY FROM Employee ORDER BY SALARY DESC);

Query 2 : SELECT Top 1 Salary AS Salary FROM Employee WHERE SALARY IN (SELECT DISTINCT TOP 3 SALARY FROM Employee ORDER BY SALARY DESC) ORDER BY SALARY;

Also Read : SQL : Find 2nd or 3rd highest salary from employee table without ROWNUM or TOP

Read More

Maven Installation under Windows: “JAVA_HOME is set to an invalid directory”

Problem : JAVA_HOME is set to an invalid directory. please set the java_home variable in your environment variable to match the location of your java installation.

Solution :  
Computer > Properties > Advanced System Settings > System Properties > Advanced > Environment Variables

In System Variables :
Variable Name : JAVA_HOME
Variable Value :  C:\Program Files\Java\jdk1.8.0_45 (Set your JDK)

In System Variable:
Variable Name : path or PATH
Variable Value : [already there+];%JAVA_HOME%\bin

If You are getting still this error then:
To Set JAVA_HOME : go to Command Prompt and Execute following command
set JAVA_HOME=C:\Program Files (x86)\Java\jdk1.8.0_45

Restart your IDE and Command Prompt then install mvn again. 

Please Comment Thanks to us if this topic is helpful :)

Read More

Error-JavaEE-Oracle[Solved]-Apache Maven install “'mvn' not recognized as an internal or external command”

Problem : Apache Maven install “'mvn' not recognized as an internal or external command”

Solution : Here I am using Windows 8.1 and Java 8.
1. Check out Maven in your Apache Tomcat Directory. If Maven folder is not there then download it first from this site : https://maven.apache.org/download.cgi
Download apache-maven-3.3.3-bin.zip
Unzip it and paste "apache-maven-3.3.3" inside "apache-tomcat-7.0.54" as I'm using Apache 7.
 
2. Create a user variables like this [ M2 = %M2_HOME% ]

3. Create a user variables like this [M2_HOME = F:\apache-tomcat-7.0.54\apache-maven-3.3.3\bin]
 (as my apache tomcat is in F:\ dive your may be in C:\ drive)

4. Edit the Path or PATH to [What ever is already in here +];%M2%

5. Dependency in pom.xml

6. Now open Command Prompt go-to  "F:\apache-tomcat-7.0.54\apache-maven-3.3.3\bin"
Execute following command

 mvn install:install-file -Dfile=C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14_g.jar -DgroupId=com.oracle -DartifactId=ojdbc14_g -Dversion=10.2.0 -Dpackaging=jar   

Please Comment Thanks to us if this topic is helpful :)

Read More

Error-JavaEE[Solved] : m2e Maven Dependency Plugin Install in Eclipse

Problem : Cannot complete the install because one or more required items could not be found.

Software being installed: m2e connector for the Maven Dependency Plugin 0.0.4.201410161303 (com.ianbrandt.tools.m2e.mdp.feature.feature.group 0.0.4.201410161303)

Missing requirement: m2e connector for Maven Dependency Plugin 0.0.4.201410161303 (com.ianbrandt.tools.m2e.mdp.core 0.0.4.201410161303) requires 'bundle org.eclipse.m2e.jdt 1.4.0' but it could not be found

 Cannot satisfy dependency:

 From: m2e connector for the Maven Dependency Plugin 0.0.4.201410161303 (com.ianbrandt.tools.m2e.mdp.feature.feature.group 0.0.4.201410161303)

 To: com.ianbrandt.tools.m2e.mdp.core [0.0.4.201410161303]

Solution : 
1. Start Eclipse IDE > Help > Install New Software
2. Paste site: http://download.eclipse.org/releases/indigo/  in Work with Textbox
3. Once the list loads, under "General Purpose Tools", check "m2e - Maven Integration for Eclipse ".

Continue Installation with Next

Click Finish

Wait For Completion of Installation.

NOTE : Sometimes it still shows error while installation with Eclipse Indigo
so if you are not still able to install it then download "eclipse-jee-luna-SR2-win32-x86_64" 
It already comes with m2e Maven dependency plugin.

Please Comment Thanks to us if this topic is helpful :)

Read More

Styling Hyperlinks by CSS

• a:link - a normal, unvisited link
• a:visited - a link the user has visited
• a:hover - a link when the user mouses over it
• a:active - a link the moment it is clicked

 /* unvisited link */  
 a:link {  
   color: #FF0000;  
 }  
 /* visited link */  
 a:visited {  
   color: #00FF00;  
 }  
 /* mouse over link */  
 a:hover {  
   color: #FF00FF;  
 }  
 /* selected link */  
 a:active {  
   color: #0000FF;  
 }  

Text Decoration
The text-decoration property is mostly used to remove underlines from links:

 a:link {  
   text-decoration: none;  
 }  
 a:visited {  
   text-decoration: none;  
 }  
 a:hover {  
   text-decoration: underline;  
 }  
 a:active {  
   text-decoration: underline;  
 }   

Background Color
The background-color property specifies the background color for links:

 a:link {  
   background-color: #B2FF99;  
 }  
 a:visited {  
   background-color: #FFFF85;  
 }  
 a:hover {  
   background-color: #FF704D;  
 }  
 a:active {  
   background-color: #FF704D;  
 }   

Read More