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
Jenkins pipeline job to trigger commands/scripts based on time in Oracle DB server. ▪️ This job triggers the commands/scripts based on time (as Oracle user) in Oracle DB server (Jenkins Slave server) ▪️ This job will trigger the job similar to CRONJOB in Unix machine. What… Read More
Jenkins job to run SQL code in remote DB server. SQL code is executed (as shell file) in Oracle DB server (Jenkins Slave server) What is Jenkins: ▪️ Jenkins is a powerful tool that allows continuous integration (CI) and continuous delivery (CD) of projects, regardless of… Read More
Dear Readers, In this article,we will see Download and Install Maven Plugin In Jenkins. Steps to Follow Logging to Jenkins. Download and Install Maven Plugin. Restart Jenkins. Logging to Jenkins. Verify plugin “maven integration” and “green balls”. First,we need to go Jenkins Logging page… Read More
