Error: Registry key ‘SoftwareJavaSoftJava Runtime Environment’CurrentVersion’

Problem :

Error: Registry key 'SoftwareJavaSoftJava Runtime Environment'CurrentVersion'

has value '1.8'
, but '1.7' is required.

Error: could not find java.dll

Error: Could not find Java SE Runtime Environment.




Solution :

open command prompt window

run this below command

Preview:

set PATH=c:Program FilesJavajdk1.6.0_45bin;%PATH%


change path according to your jdk location

129 total views, no views today

Jenkins step by step

JENKINS
Jenkins is a powerful application that allows continuous integration and continuous delivery of projects, regardless of the platform you are working on. It is a free source that can handle any kind of build or continuous integration. You can integrate Jenkins with a number of testing and deployment technologies. In this tutorial, we would explain how you can use Jenkins to build and test your software projects continuously.

Once you install Jenkins your home page will look like this.
1.  Home page jenkins

2.Click on Manage Jenkins to configure the Jenkins configuration.

3.Lets configure global configuration and path

.

5. configure Global tool configuration.

6. We need to install various plugins so that our Jenkins is self capable. Go to manage plugin link for that and below window will open.


this window contains all plugin installed and available you can search out the plugin you need in the search bar.

Now all the configuration part is done.
We are going to add our repository in Jenkins.

7 .  as per diagram in STEP 1 click on the new item link on the left side bar.A window will open name your project whatever you want.

8.  fill all details and save.
9. choose already present job or create a new job
10.  set your repository location.












150 total views, no views today

Points to consider for creating new tables

  1. Comments ( Always add comments to columns and tables)
  • I always find comments incredibly helpful, they could answer some of the business / content questions. You can add table and column comments.
  • Add comments at the table level at the very least to indicate the contents of the table and the relationship between the two (other than simply knowing parent-> child by way of the Foreign Key).
  • Column comments are useful, as long as they do not simply restate the column name
  • There are undoubtedly some terms for which there is a Glossary of Terms etc. in which case repeating the definition given there is also of little value
  • However if the contents may not be immediately obvious / there is no pre-defined term it is definitely useful.

  2. Column naming convention

  • While I like the underscores (they are natural for DB developers)
  • As a general translation from camel case java attribute names, we have generally ended up without any underscores.
  • Maintain consistency with your database tables.

3. NOT NULL Columns

  • You have only defined the primary key columns as not null (because you have to)
  • There are more columns that cannot be null(i.e The foreign key column for example)
  • If a column cannot be null, we should have a not null constraint on the column. This will prevent an application error from going undetected if a null value is inadvertently inserted.

4. TIMESTAMP/DATE columns

  • Timestamps are ‘interesting’ beasts in oracle, when you consider timezone and some arithmetic functions and implicit type conversions that take place
  • When to use Date and when to use Timestamp?
    • If you have milliseconds, then clearly you have to use timestamps
    • If they are simply to the second precision (or worse a given day), then using a DATE column makes more sense

5. Surrogate Primary Keys and Compound Keys / Unique Constraints

  • We seem to have a general pattern of using surrogate Primary Keys everywhere
  • Sometimes there is a perfectly natural primary key, for example if you have a table defining enumerations, you might as well use the enumeration value as the primary key, there is no need to define a separate PKEY column as well
  • The tables as they stand with the surrogate PKEY give no indication as to which columns should be unique.
    • i.e. could we have multiple records for the same PKEY+SOME_COLOUMN

6 . Performance Considerations

  •  Indexes on Foreign Key Columns
    • You are undoubtedly going to wish to query the child records for a given parent record. You are not allowing for this, so querying child table for a given parent table record will require a full table scan.

7. Caching on Sequences

  • Create sequences  to generate values for the PKEYs
  • Is there is no order dependency on the PKEY column values then should allow caching of the sequence values.
  • This improves the efficiency significantly, but at the cost of potentially having gaps in the sequence (which you could always have if a transaction rolls back) and ‘out of order’ inserts in the case of databases with multiple (RAC) instances.

8 . Partitioning Considerations 

  • Expected Data Volumes
  • Is the data write time critical?
  • Do we expect to read the data far more than we write the data?
  • Do we have to retain the data indefinitely?
  • Do we expect to read ‘ALL current’ records on a frequent basis?
  • can we sacrifice some performance when writing the data in order to optimise the data read

127 total views, no views today

First Selenium program using Maven+Java


This is basic example to use Webdriver, Maven with Java.


We need Tools:


1.Eclipse – IDE to Build our applications

Download and install Eclipse. I choose Eclipse IDE 
you can choose IDE of you choice.



2.Maven – We need maven to get all our dependencies automatically, which also allows users to reuse same jars across multiple projects

Download and install maven.
Eclipse does not have integrated Maven support out of the box. To add the support, I am going to use Maven Integration (m2e).


Steps to create program


Step 1:  First create a new Maven project. 

In Eclipse: File -> New -> Other  -> Maven -> Maven project

  • Click: Next, Next, Next
  • Type in field Group Id: com.demo.yourCompanyName
  • Type in field Artifact Id: yourProjectName
  • Click: Finish


Step 2 Edit pom.xml

Eclipse should detect the pom.xml changes automatically, build the project and download required dependencies.

After the build is finished, there should be selenium*.jar files under Maven Dependencies under the Project Explorer panel.

POM.XML

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.demo.yourCompanyName</groupId>
<artifactId>Demo</artifactId>
<version>0.0.1-SNAPSHOT</version>

<dependencies>
<dependency>
<groupId>org.seleniumhq.selenium</groupId>
<artifactId>selenium-server</artifactId>
<version>3.4.0</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
</dependencies>

<build>
<sourceDirectory>src</sourceDirectory>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>


Step 3:

Create a new test class
Right-click over package com.yourcompany.yourclientprojectname 

under src/test/java and select New -> Class

Type in ClassName: OpenFirefox

Java Code:

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
public class OpenFirefox {

public static void main(String[] args)

{

System.out.println("Start");

System.setProperty("webdriver.gecko.driver", "Path to gekco driver\geckodriver.exe");

WebDriver driver = new FirefoxDriver();

driver.get("https://www.google.co.in/");

System.out.println("End");
}
}


Step 4 :


Right click on class RunAs –>java application.

Your firefox browser will open with given URL “https://www.google.co.in/

137 total views, no views today