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
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

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

    atlassian.net | 9 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

    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