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

JIRA | Etienne Noel | 7 months ago
  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 | 7 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 | 7 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

    Ucanaccess with java servlet program

    Stack Overflow | 2 years ago | user3808015
    java.sql.SQLException: No suitable driver found for jdbc:ucanaccess://C://Users//Satish Aiyappa//Documents//test.accdb
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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
  6. 0

    Class missing, no suitable driver

    GitHub | 2 years ago | TekCastElemental
    java.sql.SQLException: No suitable driver found for jdbc:derby:AccountDatabase

  1. jshakil 1 times, last 1 month ago
  2. linxiaolong 7101 times, last 3 weeks ago
  3. ruifung 1 times, last 3 months ago
  4. linxiaolong 838 times, last 3 months ago
  5. Juraji 1 times, last 9 months ago
49 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