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 | 6 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 | 9 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

    After upgrading to JIRA 6.4.5 to version 7.0.10 we cannot establish a connection via CLI. We have updated the CLI to the latest version. The output of our command is: Client error: Invalid url: jira.fleetboard.net/rest/org.swift.jira.cli/latest/validatelicense? org.swift.common.cli.CliClient$ClientException: Invalid url: jira.fleetboard.net/rest/org.swift.jira.cli/latest/validatelicense? at org.swift.common.cli.AbstractRestClient.restRequestWithUrlConnection(AbstractRestClient.java:723) at org.swift.common.cli.AbstractRestClient.restRequestWithFullUrl(AbstractRestClient.java:571) at org.swift.common.cli.AbstractRestClient.restRequestWithFullUrl(AbstractRestClient.java:542) at org.swift.common.cli.AbstractRestClient.restRequest(AbstractRestClient.java:517) at org.swift.common.cli.AbstractRestClient.restRequest(AbstractRestClient.java:505) at org.swift.common.cli.AbstractRestClient.restRequest(AbstractRestClient.java:489) at org.swift.common.cli.AppfireClient.getServerInfo(AppfireClient.java:171) at org.swift.jira.cli.JiraClient.getRemoteServerInfo(JiraClient.java:1959) at org.swift.jira.cli.JiraClient.validateJiraRelease(JiraClient.java:2119) at org.swift.jira.cli.JiraClient.handleRequest(JiraClient.java:749) at org.swift.common.cli.AbstractRemoteClient.process(AbstractRemoteClient.java:312) at org.swift.common.cli.CliClient.doWork(CliClient.java:433) at org.swift.jira.cli.JiraClient.main(JiraClient.java:157)

    JIRA | 9 months ago | FleetBoard
    org.swift.common.cli.CliClient$ClientException: Invalid url: jira.fleetboard.net/rest/org.swift.jira.cli/latest/validatelicense?

    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