Creating a new Docker Image/container from existing Container And run the new container. Step 1: Create an initial Base Container – for an App ▪️ Let’s get started by creating a running container. ▪️ So that we don’t get bogged down in the details of… Read More
Creating Docker Container using Docker file: Use Case of Docker: ▪️ Consider a team working on a Java application. Various groups are involved in the Software Development lifecycle: designing, development, testing, production, deployment, etc. Step 1: The developer will create an environment that includes a Tomcat… Read More
Basics of Docker Containers: What are containers: ▪️ Containers are lightweight packages of your application code together with dependencies such as specific versions of programming language runtimes and libraries required to run your software services. ▪️ Containers make it easy to share CPU, memory, storage, and… Read More
Handling SQL Error and Vulnerability BUG in JENKINS_job by SQLplus script runner plugin How to make Jenkins job as failure for SQL errors (SQL syntax or any SQL Error): Add the additional code in Jenkins SQL file or SQL user defined code. 👉To check the SQL failure.… Read More
Run SQL as JENKINS_PIPELINE_job by SQL plus script runner plugin. Running the SQL script – As Scripted pipeline job from Jenkins file in GIT repo Note: the SQL script placed in the same location as Jenkins file
|
1 2 3 4 5 6 7 8 9 10 11 12 |
//Pipeline code (scripted pipe) in Jenkins file in GIT repo // node ('master') { stage('Code_checkout') { git url: 'https://github.com/mshan0181/java-sample-code.git' } stage('SQL_script_runner') { echo 'SQLPlusRunner running user define script for shandba@client_access' step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select * from v$version']) step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'userDefined', script: '',scriptContent: 'select name from v$database']) step([$class: 'SQLPlusRunnerBuilder',credentialsId:'shandb-priv-id', instance:'client_access',scriptType:'file', script: 'switchover_status.sql',scriptContent: '']) } } |
👉 Create the (above code) scripted pipeline in Jenkins… Read More
Run SQL as JENKINS_UI_job by SQLplus script runner plugin To perform SQL operations connecting to Remote Oracle DB without SSH connection. This article uses the Jenkins master node to run/execute the SQL. ▪️ SQL plus Script Runner plugin is required to run the SQL code… Read More
Parameterization in Jenkins job Parameters in Jenkins: Parameters can be used in 2 ways in Jenkins job. ▪️ Define parameter value directly inside a build job (or in shell/batch commands) as fixed value. ▪️ Define using Build Parameters – Setting build parameter and passing values… Read More
Please check the PART -1, before going through the Part -2 Declarative and Scripted pipeline job in Jenkins -PART 1 🔗https://www.ktexperts.com/declarative-and-scripted-pipeline-job-in-jenkins-part-1/ Declarative and Scripted pipeline job in Jenkins -PART 2 Creating a Scripted Pipeline job (code in Jenkins web UI): 👉 Configure the Jenkins… Read More
Declarative and Scripted pipeline job in Jenkins -PART 1 What is Pipeline in DevOps? ▪️ A pipeline is a collection of jobs that brings the software from version control into the hands of the end users by using automation tools. ▪️ It is a feature used to… Read More
Configure Agent (Linux-slave) machine with Jenkins Master using SSH key file connection – as Oracle OS user. ▪️ The Linux (slave) agent machine to be configured using SSH key file as Oracle OS user. ▪️ We have earlier successfully configured Agent using SSH key… Read More
