June 24, 2020

Ctrl + Space not working for content assist in eclipse

Problem: I am writing Java code in Eclipse IDE but the suggestion pop up window for java methods is not showing. Which generally pops up on the click of ctrl+space.

Solution: 
Follow the below steps:
Step 1: Go to Windows -> Preferences -> Java -> Editor -> Content Assist -> Advanced -> select Java Proposals Checbox. 
Step 2: Click Apply -> OK 
Step 3: If still not working then restart Eclipse IDE.
(check screenshot for reference)

June 22, 2020

[Solved] WebDriverException: Cannot find firefox binary in PATH. Make sure firefox is installed.

Problem: During Selenium Automation testing, I tried to run my code script on the Mozilla Firefox browser and my code was not able to find the path of installed software/browser.

Solution: 
I used the below code snippet to set the path.

System.setProperty("webdriver.firefox.bin", "C:\\Program Files\\Mozilla Firefox\\firefox.exe");

Kill process using shortcut in command prompt in windows OS

Problem: When we get a message that port 8080 already in use then it becomes very difficult to use the same port for different processes.

Solution: Just run the below commands in command prompt and whoop! magic happens. 
Follow the screenshot for the reference.

Sample commands:
netstat -ano | findstr :8080 (replace 8080 with your port)
taskkill /F /PID 11237 (replace 11237 with your pid)

A sample screenshot is for port 8088

Run .sql file in Oracle SQL developer

Problem: Some times we have to execute insert queries of a table that we exported in .sql file. For multiple .sql files having huge data, it's not easy to execute those queries using copy and paste in SQL Developer tools.

Solution: To execute .sql file you just need to write the path of your .sql file after @ and then file name with extension with delimiter ';' in the end. Select the complete command and press yellow highlighted green triangular button to execute sql script command. Just follow the below image for the reference.
Sample command:
@F:\myData.sql

Disclaimer

We shall not be liable for the improper or incomplete transmission of the information contained in this communication nor for any delay in its response or damage to your system. We do not guarantee that the integrity or security of this communication has been maintained or that this communication is free of viruses, interceptions or interferences. Anyone communicating with us by email accepts the risks involved and their consequences. We accept no liability for any damage caused by any virus transmitted by this site.