Oficial plugin page (basic documentation + stats)

https://plugins.jenkins.io/sqlplus-script-runner

Oficial wiki (basic documentation + user comments)

https://wiki.jenkins.io/display/JENKINS/SQLPlus+Script+Runner+Plugin

Jenkins plugin - SQL*Plus Script Runner

This plugin enables you run Oracle SQL*Plus scripts on your Jenkins jobs ( SQL*Plus installation required! ).

All you have to do is provide a valid ORACLE_HOME and you are in business:

You can run a script inside your workspace or a user defined for every job:

You can check later all SQL*Plus output inside your build output:

Download the last release and give it a try!

https://github.com/boaglio/jenkins-plugin-sqlplus-script-runner/releases

Developer guide

Fork repository
Code code code
Run it with:

mvn clean
mvn generate-sources (convert Message*.properties into Messages.java)
mvn compiler:compile
mvn clean -DskipTests package hpi:run

Try it at http://localhost:8080
Commit and submit pull request

Translator guide

Fork repository
Copy config.properties to config_.properties (example: config_pt_BR.properties)
Copy global.properties to global_.properties
Copy Messages.properties to Messages_.properties
Copy all HTML files too
Translate it
Run it with:

mvn clean -DskipTests package hpi:run

Try it at http://localhost:8080
Commit and submit pull request

Pipeline

user defined script

node { echo 'SQLPlusRunner running user define script for system@xe' step([$class: 'SQLPlusRunnerBuilder',credentialsId:'system', instance:'xe',scriptType:'userDefined', script: '',scriptContent: 'select * from v$version']) }

file script

node { echo 'SQLPlusRunner running file script for system@xe' step([$class: 'SQLPlusRunnerBuilder',credentialsId:'system', instance:'xe',scriptType:'file', script: 'start.sql',scriptContent: '']) }

Optional parameters

customOracleHome
customSQLPlusHome
customTNSAdmin
customNLSLang
customSQLPath

Having problems?

Please open a new issue and inform:

Jenkins server Operation System;
Jenkins version;
Where SQLPlus Script Runner is running (local machine or slave machine);
Slave machine Operation System (if applicable);
Oracle Database version;
Oracle SQL*Plus version;
Build log with debug info enabled.

License

cube-dragon/sqlplus-script-runner-plugin

ErrorLooks like something went wrong!

About

Resources

License

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Languages

Error
Looks like something went wrong!

Packages