Git commands for development workflow

1. checkout remote dev branch to local git checkout -b local_dev_branch origin/dev 2. after modified, submit to local, the example shows submit modified java files. git commit -m *.java “modified java files” 3. after submit code in local, you can submit own branch to remote, the branch name can be same with local branch name […]

Read More

Connect Hana with Java

Please see below code for getting hana kernel info and license info Please also search ‘ngdbc jar’ or use directly attached jar zipped ngdbc-2-3-58.jar import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; static void query_info(String ip, String port, String tename, String user, String password) { String perline = “”; Connection connection = null; String hostname […]

Read More

Remote to call selenium server

Server end: We need to prepare to install firefox and selenium jar and gecko packages. 1) start selenium server, e.g. java -jar selenium-server-standalone-3.141.5.jar -role hub 2) start geckodriver with firefox browser, e.g. java -Dwebdriver.gecko.driver=/path/to/geckodriver -Dwebdriver.firefox.bin=/path/to/firefox-bin -jar /path/to/selenium-server-standalone-3.141.5.jar -role node -port 6666 -hub http://serverIP:4444/grid/register -browser browserName=firefox Until now, the selenium server will be listening on remote […]

Read More

Some useful sql commands and knowledge in sqlplus

1. When you access sqlplus with sysdba withought password to check system tables sqlplus / as sysdba 2. When you access sqlplus with anonymous, only use sqlplus command without any privileges sqlplus /nolog 3. To check sid information we need to check tnsnames.ora file in network folder 4. Display cache commands: l or run 1) […]

Read More

Difference start commands between selenium1 and selenium3

For start selenium1: java -jar selenium-server.jar -port portnumber e.g. java -jar selenium-server.jar -port 4444 For start selenium3 # Run selenium server and default node register port is 4444 # for exmple java -jar selenium-server-standalone-3.141.5.jar -role hub # If you run higher FF version, please run gecko driver node # Note sometimes need selenium jar and […]

Read More

Run hashicorp nomad in localhost steps

Nomad is a tool of deploy cluster scheduler. Sometimes we need to install localhost to try how to use it,here are some steps for linux ubuntu18.04 installation: 1) Download nomad with binary version Download nomad,then need to add bin path to execute. 2) Then we need to a server config file to start nomad server, below […]

Read More

Migration issue fix from Selenium1 to Selenium3

For migration, because the old system needs to run to new browser and keep test automation running normally, so facing new browser, csv command parse code also needs to be adjusted. Below are some issues happened during testing, and solutions: 1. Because run too faster on v63 When WebDriverWait function can’t work for waiting time, […]

Read More