java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true;

JIRA | Etienne Noel | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    I try to connect with the database using the following database profile: {code:java} dbUser = test | dbPassword = test | dbUrl = jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; | dbDriver = net.sourceforge.jtds.jdbc.Driver | dbJar = C:\Atlassian\Bamboo\lib\jtds-1.2.8.jar {code} When doing that, I get the following error from the log: {noformat} 2016-05-19 12:41:42,175 ERROR [14-BAM::Local Agent #2::Agent:pool-30-thread-1] [SqlUtilities] Unable to connect to database using jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; 2016-05-19 12:41:42,175 ERROR [14-BAM::Local Agent #2::Agent:pool-30-thread-1] [SqlUtilities] java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnectionFromDriverManager(SqlUtilities.java:93) at com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnection(SqlUtilities.java:45) at com.appfire.bamboo.sql.SqlTask.processSql(SqlTask.java:84) at com.appfire.bamboo.sql.SqlTask.process(SqlTask.java:49) at com.appfire.bamboo.sql.BaseTask.execute(BaseTask.java:71) at com.atlassian.bamboo.task.TaskExecutorImpl.lambda$executeTasks$124(TaskExecutorImpl.java:273) at com.atlassian.bamboo.task.TaskExecutorImpl.executeTaskWithPrePostActions(TaskExecutorImpl.java:202) at com.atlassian.bamboo.task.TaskExecutorImpl.executeTasks(TaskExecutorImpl.java:273) at com.atlassian.bamboo.task.TaskExecutorImpl.execute(TaskExecutorImpl.java:108) at com.atlassian.bamboo.build.pipeline.tasks.ExecuteBuildTask.call(ExecuteBuildTask.java:74) at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent.build(DefaultBuildAgent.java:215) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:139) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:130) at com.atlassian.bamboo.variable.CustomVariableContextImpl.withVariableSubstitutor(CustomVariableContextImpl.java:215) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl.waitAndPerformBuild(BuildAgentControllerImpl.java:129) at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent$1.run(DefaultBuildAgent.java:137) at com.atlassian.bamboo.utils.BambooRunnables$1.run(BambooRunnables.java:49) at com.atlassian.bamboo.security.ImpersonationHelper.runWith(ImpersonationHelper.java:31) at com.atlassian.bamboo.security.ImpersonationHelper.runWithSystemAuthority(ImpersonationHelper.java:20) at com.atlassian.bamboo.security.ImpersonationHelper$1.run(ImpersonationHelper.java:52) at java.lang.Thread.run(Unknown Source) {noformat}

    JIRA | 11 months ago | Etienne Noel
    java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true;
  2. 0

    I try to connect with the database using the following database profile: {code:java} dbUser = test | dbPassword = test | dbUrl = jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; | dbDriver = net.sourceforge.jtds.jdbc.Driver | dbJar = C:\Atlassian\Bamboo\lib\jtds-1.2.8.jar {code} When doing that, I get the following error from the log: {noformat} 2016-05-19 12:41:42,175 ERROR [14-BAM::Local Agent #2::Agent:pool-30-thread-1] [SqlUtilities] Unable to connect to database using jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; 2016-05-19 12:41:42,175 ERROR [14-BAM::Local Agent #2::Agent:pool-30-thread-1] [SqlUtilities] java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true; at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnectionFromDriverManager(SqlUtilities.java:93) at com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnection(SqlUtilities.java:45) at com.appfire.bamboo.sql.SqlTask.processSql(SqlTask.java:84) at com.appfire.bamboo.sql.SqlTask.process(SqlTask.java:49) at com.appfire.bamboo.sql.BaseTask.execute(BaseTask.java:71) at com.atlassian.bamboo.task.TaskExecutorImpl.lambda$executeTasks$124(TaskExecutorImpl.java:273) at com.atlassian.bamboo.task.TaskExecutorImpl.executeTaskWithPrePostActions(TaskExecutorImpl.java:202) at com.atlassian.bamboo.task.TaskExecutorImpl.executeTasks(TaskExecutorImpl.java:273) at com.atlassian.bamboo.task.TaskExecutorImpl.execute(TaskExecutorImpl.java:108) at com.atlassian.bamboo.build.pipeline.tasks.ExecuteBuildTask.call(ExecuteBuildTask.java:74) at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent.build(DefaultBuildAgent.java:215) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:139) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:130) at com.atlassian.bamboo.variable.CustomVariableContextImpl.withVariableSubstitutor(CustomVariableContextImpl.java:215) at com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl.waitAndPerformBuild(BuildAgentControllerImpl.java:129) at com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent$1.run(DefaultBuildAgent.java:137) at com.atlassian.bamboo.utils.BambooRunnables$1.run(BambooRunnables.java:49) at com.atlassian.bamboo.security.ImpersonationHelper.runWith(ImpersonationHelper.java:31) at com.atlassian.bamboo.security.ImpersonationHelper.runWithSystemAuthority(ImpersonationHelper.java:20) at com.atlassian.bamboo.security.ImpersonationHelper$1.run(ImpersonationHelper.java:52) at java.lang.Thread.run(Unknown Source) {noformat}

    JIRA | 11 months ago | Etienne Noel
    java.sql.SQLException: No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true;
  3. 0

    No suitable driver found for sybaseIQ/Spark to read Data in DataFrames

    Stack Overflow | 4 months ago | NiralKK
    java.sql.SQLException: No suitable driver found for jdbc:sybase:Tds://10.16.15.113:3700/IPRU_NDEV_SYBASE_ID?user=ipru_adw_iq&password=ipru_adw_prod
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Ucanaccess with java servlet program

    Stack Overflow | 3 years ago | user3808015
    java.sql.SQLException: No suitable driver found for jdbc:ucanaccess://C://Users//Satish Aiyappa//Documents//test.accdb
  6. 0

    Connecting my applet to a MS Access Database on my Local Machine

    Oracle Community | 1 decade ago | 843807
    java.sql.SQLException: No suitable driver

  1. DoktorDoener666 1 times, last 3 months ago
  2. jpvee 5 times, last 4 months ago
  3. andyglick 1 times, last 4 months ago
  4. jshakil 1 times, last 6 months ago
  5. linxiaolong 9416 times, last 1 week ago
2 more registered users
51 unregistered visitors
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. java.sql.SQLException

    No suitable driver found for jdbc:sqlserver://10.106.28.16:1433;database=test;integratedSecurity=true;

    at java.sql.DriverManager.getConnection()
  2. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(Unknown Source)
    2. java.sql.DriverManager.getConnection(Unknown Source)
    2 frames
  3. com.appfire.bamboo
    BaseTask.execute
    1. com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnectionFromDriverManager(SqlUtilities.java:93)
    2. com.appfire.bamboo.sql.SqlUtilities.getDatabaseConnection(SqlUtilities.java:45)
    3. com.appfire.bamboo.sql.SqlTask.processSql(SqlTask.java:84)
    4. com.appfire.bamboo.sql.SqlTask.process(SqlTask.java:49)
    5. com.appfire.bamboo.sql.BaseTask.execute(BaseTask.java:71)
    5 frames
  4. com.atlassian.bamboo
    ImpersonationHelper$1.run
    1. com.atlassian.bamboo.task.TaskExecutorImpl.lambda$executeTasks$124(TaskExecutorImpl.java:273)
    2. com.atlassian.bamboo.task.TaskExecutorImpl.executeTaskWithPrePostActions(TaskExecutorImpl.java:202)
    3. com.atlassian.bamboo.task.TaskExecutorImpl.executeTasks(TaskExecutorImpl.java:273)
    4. com.atlassian.bamboo.task.TaskExecutorImpl.execute(TaskExecutorImpl.java:108)
    5. com.atlassian.bamboo.build.pipeline.tasks.ExecuteBuildTask.call(ExecuteBuildTask.java:74)
    6. com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent.build(DefaultBuildAgent.java:215)
    7. com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:139)
    8. com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl$1.call(BuildAgentControllerImpl.java:130)
    9. com.atlassian.bamboo.variable.CustomVariableContextImpl.withVariableSubstitutor(CustomVariableContextImpl.java:215)
    10. com.atlassian.bamboo.v2.build.agent.BuildAgentControllerImpl.waitAndPerformBuild(BuildAgentControllerImpl.java:129)
    11. com.atlassian.bamboo.v2.build.agent.DefaultBuildAgent$1.run(DefaultBuildAgent.java:137)
    12. com.atlassian.bamboo.utils.BambooRunnables$1.run(BambooRunnables.java:49)
    13. com.atlassian.bamboo.security.ImpersonationHelper.runWith(ImpersonationHelper.java:31)
    14. com.atlassian.bamboo.security.ImpersonationHelper.runWithSystemAuthority(ImpersonationHelper.java:20)
    15. com.atlassian.bamboo.security.ImpersonationHelper$1.run(ImpersonationHelper.java:52)
    15 frames
  5. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame