mssql jdbc - How can I use sql in a jenkins pipeline job? - Stack Overflow

admin管理员组

文章数量:1317898

In my jenkins pipeline job I need to connect to a ms sql db and fetch some data, something like the below:

pipeline {
    stages {
        stage('Fetch Data from Database') {
            steps {
                script {
                    // connect to db
                    // fetch data

I have tried a few different methods, one example like:

                    sql = groovy.sql.Sql.newInstance(DB_URL, DB_CREDENTIALS_USR, DB_CREDENTIALS_PSW, DB_DRIVER)

but I get the error: "No suitable driver found".

Firstly, is this a common/best practice way to use sql in the pipeline?

Secondly, what is the best practice for getting the driver e.g. manually download the .jar and put it in some jenkins folder, or use some plugin to handle it?

本文标签： mssql jdbcHow can I use sql in a jenkins pipeline jobStack Overflow