Skip to main content

Posts

fatal: refusing to merge unrelated histories

This problem generally occur when you try to checkout repo for the first time and try to commit some files in repo. and during that following error message is shown from git: Problem: fatal: refusing to merge unrelated histories Error redoing merge 1234deadbeef1234deadbeef Solution: 1. open cmd.exe 2. open your repo path in cmd 3. Run command  git pull origin master --allow-unrelated-histories this should solve your problem.

Error: Registry key 'Software\JavaSoft\Java Runtime Environment'\CurrentVersion'

Problem : Error : Registry key ' Software\JavaSoft\Java 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 Files\Java\jdk1. 6.0 _45\ bin ;%PATH% change path according to your jdk location

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. ...

Points to consider for creating new tables

Below are the points which can be consider while creating new table in the database. Comments ( Always add comments to columns and tables) a.        I always find comments incredibly helpful, they could answer some of the business / content questions. b.       You can add table and column comments. c.        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). d.       Column comments are useful, as long as they do not simply restate the column name e.       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. f.         However if the contents may not be i...

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) . In Eclipse:  Help  ->  Install New Software Type the following URL in field Work with:  http://download.eclipse.org/technology/m2e/releases Click  Next  etc. to move forward and choose to restart Eclipse when prompted Steps to create program Step 1 :   First create a new Maven project.  In Eclipse: File -> New -> Other  -> Maven -> Maven project Click: Next, Next, Nex...

Converting excel data into SQL insert query.

Lets suppose you have thousands of data which you need to insert in database and that data is in Excel. you can easily convert your data into query. 1. insert a new column in your sheet. 2. write this query in the first empty column which is newly created  here B2,C2 represent columns of your data. Query builder: = "insert into employees values('" &B2& "','" &C2& "','" &D2& "','" &E2& "','" &F2& "', '" &G2& "','" &H2& "','" &I2& "','" &J2& "','" &K2& "','" &L2& "','" &M2& "');" 3. Add coloumns which you need in your query. 4. drag down to all rows so that changes reflect for all the rows. 5. save your excel. you have sql query of insertion.

SQL Error: ORA-14402: updating partition key column would cause a partition change

Error: SQL Error: ORA- 14402 : updating partition key column would cause a partition change 14402 . 00000 - "updating partition key column would cause a partition change" *Cause: An UPDATE statement attempted to change the value of a partition key column causing migration of the row to another partition *Action: Do not attempt to update a partition key column or make sure that the new partition key is within the range containing the old Solution :  ALTER TABLE <table name> ENABLE ROW MOVEMENT; Example: select * from part_table; CREATE TABLE part_table (ID NUMBER ) PARTITION BY RANGE (ID) (partition p0 values less than ( 1 ), PARTITION p1 VALUES LESS THAN ( MAXVALUE )); insert into part_table values ( 0 ); UPDATE part_table SET ID = 2 ; when you try to update this partition column it gives you  ORA- 14402 . By default ROW MOVEMENT is DISABLE. you should al...