org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL.

JIRA | Ben Dailey | 5 years ago
  1. 0

    JIRA Command Line Interface - JIRA Command Line Interface (CLI) - Confluence

    atlassian.net | 8 months ago
    org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL.
  2. 0

    Bob, thanks for a great product and your work. Quick question: I'm having trouble using the runfromsql action with MS SQL Server. I tried connecting using both the driver: {code} >jira --action runfromsql --sql "select 'getserverinfo' as action" --host "localhost" --driver "mssql" --database "DB" --dbUser "sa" --dbPassword "pwd" --verbose --debug {code} and URL methods: {code} >jira --action runfromsql --sql "select 'getserverinfo' as action" --url "jdbc:jtds:sqlserver://localhost;user=sa;password=pwd" --database "DB" --verbose --debug {code} I have put the JTDS jar (jtds-1.2.5.jar) into the lib/jdbc directory. I also tried specifying the port number. But I always get the following error: {code} Client error: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL. org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL. at org.swift.common.cli.CliUtils.getDatabaseUrl(CliUtils.java:437) at org.swift.common.cli.CliUtils.getDatabaseConnection(CliUtils.java:367) at org.swift.common.cli.CliClient.runFromSql(CliClient.java:838) at org.swift.jira.cli.JiraClient.handleRequest(JiraClient.java:401) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:118) at org.swift.common.cli.CliClient.doWork(CliClient.java:225) at org.swift.jira.cli.JiraClient.main(JiraClient.java:140) {code} Can you please help? I'm running on Win 32 with Java 1.6 and JCLI 2.2.0

    JIRA | 5 years ago | Ben Dailey
    org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL.
  3. 0

    Bob, thanks for a great product and your work. Quick question: I'm having trouble using the runfromsql action with MS SQL Server. I tried connecting using both the driver: {code} >jira --action runfromsql --sql "select 'getserverinfo' as action" --host "localhost" --driver "mssql" --database "DB" --dbUser "sa" --dbPassword "pwd" --verbose --debug {code} and URL methods: {code} >jira --action runfromsql --sql "select 'getserverinfo' as action" --url "jdbc:jtds:sqlserver://localhost;user=sa;password=pwd" --database "DB" --verbose --debug {code} I have put the JTDS jar (jtds-1.2.5.jar) into the lib/jdbc directory. I also tried specifying the port number. But I always get the following error: {code} Client error: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL. org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL. at org.swift.common.cli.CliUtils.getDatabaseUrl(CliUtils.java:437) at org.swift.common.cli.CliUtils.getDatabaseConnection(CliUtils.java:367) at org.swift.common.cli.CliClient.runFromSql(CliClient.java:838) at org.swift.jira.cli.JiraClient.handleRequest(JiraClient.java:401) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:118) at org.swift.common.cli.CliClient.doWork(CliClient.java:225) at org.swift.jira.cli.JiraClient.main(JiraClient.java:140) {code} Can you please help? I'm running on Win 32 with Java 1.6 and JCLI 2.2.0

    JIRA | 5 years ago | Ben Dailey
    org.swift.common.cli.CliClient$ClientException: Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When I try to export a whole space I sometimes get a 403 error but sometimes it works. Here the log output: u837608@LHT-N51548 /cygdrive/c/Users/u837608/Downloads/atlassian-cli-5.1.0 % ./confluence.bat --action exportSpace --space "mreliabilityfleet" --file "exportSpaceHtml.zip" --exportType "HTML" -v Server address: https://lht.app.lufthansa.com/confluence/rpc/soap-axis/confluenceservice-v2 Successful login to: https://lht.app.lufthansa.com/confluence/rpc/soap-axis/confluenceservice-v2 by user: u837608. Response code: 200, message: OK, url: https://lht.app.lufthansa.com/confluence/rest/org.swift.confluence.cli/latest/validatelicense? Space exported with url: https://lht.app.lufthansa.com/confluence/download/temp/htmlexport-20160308-133651-113/Confluence-space-export-133843-114.html.zip to file: exportSpaceHtml.zip 62461df693 logged out. u837608@LHT-N51548 /cygdrive/c/Users/u837608/Downloads/atlassian-cli-5.1.0 % ./confluence.bat --action exportSpace --space "SDG" --file "exportSpaceHtml.zip" --exportType "HTML" -v !180 Server address: https://lht.app.lufthansa.com/confluence/rpc/soap-axis/confluenceservice-v2 Successful login to: https://lht.app.lufthansa.com/confluence/rpc/soap-axis/confluenceservice-v2 by user: u837608. Response code: 200, message: OK, url: https://lht.app.lufthansa.com/confluence/rest/org.swift.confluence.cli/latest/validatelicense? e0292d11bb logged out. Client error: Bad response code (403) received trying to retrieve data from URL: https://lht.app.lufthansa.com/confluence/download/temp/htmlexport-20160308-134006-275/Confluence-space-export-134048-276.html.zip org.swift.common.cli.CliClient$ClientException: Bad response code (403) received trying to retrieve data from URL: https://lht.app.lufthansa.com/confluence/download/temp/htmlexport-20160308-134006-275/Confluence-space-export-134048-276.html.zip at org.swift.common.cli.CliUtils.copyUrlToFile(CliUtils.java:223) at org.swift.confluence.cli.ConfluenceClient.exportSpace(ConfluenceClient.java:6234) at org.swift.confluence.cli.ConfluenceClient.handleRequest(ConfluenceClient.java:923) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:312) at org.swift.common.cli.CliClient.doWork(CliClient.java:433) at org.swift.confluence.cli.ConfluenceClient.main(ConfluenceClient.java:171)

    JIRA | 10 months ago | Kevin Rancka
    org.swift.common.cli.CliClient$ClientException: Bad response code (403) received trying to retrieve data from URL: https://lht.app.lufthansa.com/confluence/download/temp/htmlexport-20160308-134006-275/Confluence-space-export-134048-276.html.zip
  6. 0

    When running run action to perform templated actions, getting an error difficult to decipher during action "addRepository". Creating a repository from scratch each time since each build plan needs a unique branch and there are many distinct repos. *Command being enacted in the Windows terminal:* {code:java} bamboo -v --action run --file bamboo_project_template.txt --findReplace "#PROJECT#:ENGLISHIVV13CID4160,#NAME#:"English-IV-v13-GS-4160",#WEBDAV#:educator_englishIV_v13_2_gs,#BRANCH#:gs_master_v13,#CLONEURL#:English%%20IV {code} *Template txt file being used:* {code:java} # Create a new project based on a template project --action cloneProject --project GE --toProject #PROJECT# # --name "#NAME#" # Add VSO/Git Repository --action addRepository --plan #PROJECT#-PRE --repositoryKey "GIT" --repository "VSO #WEBDAV#" --field1 repository.git.repositoryUrl --value1 https://flvs.visualstudio.com/DefaultCollection/cs/_git/#CLONEURL# --field2 repository.git.branch --value2 "#BRANCH#" --field3 repository.git.username --value3 "iceteam" --field4 repository.git.password --value4 "4bw5rngxkdklwww5xxxxxxxxxxxxxgar==xxxxxxxxxxxxxsg7mhn2ykmq" # Add a script task to PRE --action addTask --build #PROJECT#-PRE --job "default" --taskKey "CHECKOUT" --fields "argument:pubplan" --field1 "Repository" --value1 "VSO #WEBDAV#" --action addTask --build #PROJECT#-PRE --job "default" --taskKey "SCRIPT" --fields "argument:pubplan" --field1 "scriptLocation" --value1 "FILE" --field2 "scriptFile" --value2 "C:\Users\admin\Desktop\cwRsync_5.5.0_x86_Free\rsync_pub2.bat" --field3 "Argument" --value3 "${bamboo.buildKey} #WEBDAV#" {code} *CLI output pasted below:* {code:java} C:\Users\admin\Desktop\bamboo-cli-5.2.0>bamboo_action.bat C:\Users\admin\Desktop\bamboo-cli-5.2.0>bamboo -v --action run --file bamboo_project_template.txt --findReplace "#PROJECT#:ENGLISHIVV13CID4160,#NAME#:"English-IV-v13-GS-4160",#WEBD AV#:educator_englishIV_v13_2_gs,#BRANCH#:gs_master_v13,#CLONEURL#:English%20IV Server address: http://127.0.0.1:8085 Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/org.swift.bamboo.cli/latest/validatelicense? # Create a new project based on a template project Run: --action cloneProject --project GE --toProject ENGLISHIVV13CID4160 Server address: http://127.0.0.1:8085 URL requested: http://127.0.0.1:8085/rest/api/latest/project/GE? Request type: GET Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/project/GE? URL requested: http://127.0.0.1:8085/rest/api/latest/project/GE?&expand=plans.plan&max-results=100&start-index=0 Request type: GET Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/project/GE?&expand=plans.plan&max-results=100&start-index=0 URL requested: http://127.0.0.1:8085/rest/api/latest/project?&max-results=2147483647 Request type: GET Content type: application/xml Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/project?&max-results=2147483647 Looking for project ENGLISHIVV13CID4160: AGV3 Looking for project ENGLISHIVV13CID4160: C1VG Looking for project ENGLISHIVV13CID4160: EIVG Looking for project ENGLISHIVV13CID4160: MLAVG Looking for project ENGLISHIVV13CID4160: MUHV3G Looking for project ENGLISHIVV13CID4160: MWHVG4 Looking for project ENGLISHIVV13CID4160: P1VG Looking for project ENGLISHIVV13CID4160: GE URL requested: http://127.0.0.1:8085/build/admin/create/performClonePlan.action?&planKeyToClone=GE-PRE&chainName=pubplan&projectKey=ENGLISHIVV13CID4160&chainKey=PRE&clonePlan=true& bamboo.successReturnMode=json&save=Create&projectName=ENGLISHIVV13CID4160&chainDescription=&tmp.createAsEnabled=true&existingProjectKey=newProject Request type: POST Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/build/admin/create/performClonePlan.action?&planKeyToClone=GE-PRE&chainName=pubplan&projectKey=ENGLISHIVV13CID4160&chain Key=PRE&clonePlan=true&bamboo.successReturnMode=json&save=Create&projectName=ENGLISHIVV13CID4160&chainDescription=&tmp.createAsEnabled=true&existingProjectKey=newProject URL requested: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE? Request type: GET Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE? Plan ENGLISHIVV13CID4160-PRE created based on GE-PRE. 1 plans cloned from GE to ENGLISHIVV13CID4160. # --name "English-IV-v13-GS-4160" # Add VSO/Git Repository Run: --action addRepository --plan ENGLISHIVV13CID4160-PRE --repositoryKey "GIT" --repository "VSO educator_englishIV_v13_2_gs" --field1 repository.git.repositoryUrl --value1 https ://flvs.visualstudio.com/DefaultCollection/cs/_git/English%20IV --field2 repository.git.branch --value2 "gs_master_v13" --field3 repository.git.username --value3 "iceteam" --field4 repository.git.password --value4 "4bw5rngxkdklxxxxxxxxxxxxxxxxxxxxxxxx7mhn2ykmq" Server address: http://127.0.0.1:8085 URL requested: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE?&expand=plans.plan Request type: GET Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE?&expand=plans.plan URL requested: http://127.0.0.1:8085/chain/admin/config/editChainRepository.action?&buildKey=ENGLISHIVV13CID4160-PRE Request type: GET Content type: text/html Response code: 200, message: OK, url: http://127.0.0.1:8085/chain/admin/config/editChainRepository.action?&buildKey=ENGLISHIVV13CID4160-PRE URL requested: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE? Request type: GET Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/rest/api/latest/plan/ENGLISHIVV13CID4160-PRE? URL requested: http://127.0.0.1:8085/chain/admin/config/createRepository.action?&confirm=true&selectedRepository=com.atlassian.bamboo.plugins.atlassian-bamboo-plugin-git%3Agit&repo sitory.git.username=iceteam&bamboo.successReturnMode=json&repositoryId=0&planKey=ENGLISHIVV13CID4160-PRE&repository.git.branch=gs_master_v13&repository.git.password=***&repository. git.repositoryUrl=https%3A%2F%2Fflvs.visualstudio.com%2FDefaultCollection%2Fcs%2F_git%2FEnglish%2520IV&repositoryName=VSO+educator_englishIV_v13_2_gs Request type: POST Content type: application/json Response code: 200, message: OK, url: http://127.0.0.1:8085/chain/admin/config/createRepository.action?&confirm=true&selectedRepository=com.atlassian.bamboo.plugins.atlassian-bambo o-plugin-git%3Agit&repository.git.username=iceteam&bamboo.successReturnMode=json&repositoryId=0&planKey=ENGLISHIVV13CID4160-PRE&repository.git.branch=gs_master_v13&repository.git.p assword=***&repository.git.repositoryUrl=https%3A%2F%2Fflvs.visualstudio.com%2FDefaultCollection%2Fcs%2F_git%2FEnglish%2520IV&repositoryName=VSO+educator_englishIV_v13_2_gs Remote error: unknown org.swift.common.cli.AbstractRemoteClient$RemoteRestException: unknown at org.swift.bamboo.cli.helpers.RepositoryHelper.addOrUpdateRepository(RepositoryHelper.java:197) at org.swift.bamboo.cli.BambooClient.handleRequest(BambooClient.java:713) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:443) at org.swift.common.cli.CliClient.doWork(CliClient.java:454) at org.swift.common.cli.CliClient.doWork(CliClient.java:521) at org.swift.common.cli.CliClient.doWork(CliClient.java:517) at org.swift.common.cli.CliClient.processRunLine(CliClient.java:1253) at org.swift.common.cli.AbstractRemoteClient.processRunLine(AbstractRemoteClient.java:772) at org.swift.common.cli.CliClient.doSingleRunLine(CliClient.java:1225) at org.swift.common.cli.CliClient.run(CliClient.java:1086) at org.swift.bamboo.cli.BambooClient.handleRequest(BambooClient.java:525) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:443) at org.swift.common.cli.CliClient.doWork(CliClient.java:454) at org.swift.bamboo.cli.BambooClient.main(BambooClient.java:253) Client error: 1 actions failed, 1 actions were successful from file: C:\Users\admin\Desktop\bamboo-cli-5.2.0\bamboo_project_template.txt org.swift.common.cli.CliClient$ClientException: 1 actions failed, 1 actions were successful from file: C:\Users\admin\Desktop\bamboo-cli-5.2.0\bamboo_project_template.txt at org.swift.common.cli.CliClient.run(CliClient.java:1159) at org.swift.bamboo.cli.BambooClient.handleRequest(BambooClient.java:525) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:443) at org.swift.common.cli.CliClient.doWork(CliClient.java:454) at org.swift.bamboo.cli.BambooClient.main(BambooClient.java:253) C:\Users\admin\Desktop\bamboo-cli-5.2.0> {code}

    JIRA | 9 months ago | George Meyer
    org.swift.common.cli.CliClient$ClientException: 1 actions failed, 1 actions were successful from file: C:\Users\admin\Desktop\bamboo-cli-5.2.0\bamboo_project_template.txt

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.swift.common.cli.CliClient$ClientException

      Could not default the database connection URL from: net.sourceforge.jtds.Driver. Provide a connection URL.

      at org.swift.common.cli.CliUtils.getDatabaseUrl()
    2. org.swift.common
      CliClient.runFromSql
      1. org.swift.common.cli.CliUtils.getDatabaseUrl(CliUtils.java:437)
      2. org.swift.common.cli.CliUtils.getDatabaseConnection(CliUtils.java:367)
      3. org.swift.common.cli.CliClient.runFromSql(CliClient.java:838)
      3 frames
    3. org.swift.jira
      JiraClient.handleRequest
      1. org.swift.jira.cli.JiraClient.handleRequest(JiraClient.java:401)
      1 frame
    4. org.swift.common
      CliClient.doWork
      1. org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:118)
      2. org.swift.common.cli.CliClient.doWork(CliClient.java:225)
      2 frames
    5. org.swift.jira
      JiraClient.main
      1. org.swift.jira.cli.JiraClient.main(JiraClient.java:140)
      1 frame