title: How to fix: No suitable driver found for sqlserver://localhost:1433;DatabaseName=XX
body: <p>I have huge Java project that fails to run because of this database error</p>
  
  <blockquote>
    <p>APPLICATION STARTUP FAILURE
    No suitable driver found for sqlserver://localhost:1433;DatabaseName=XX
    java.sql.SQLException: No suitable driver found for sqlserver://localhost:1433;DatabaseName=XX
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at artemispm.serverutil.ConnectionPool.newConnection(ConnectionPool.java:577)
        at artemispm.serverutil.ConnectionPool.manageConnections(ConnectionPool.java:470)
        at artemispm.serverutil.ConnectionPool.getPooledConnection(ConnectionPool.java:421)
        at artemispm.serverutil.ConnectionPool.getConnection(ConnectionPool.java:355)
        at artemispm.serverutil.ConnectionPool.getConnection(ConnectionPool.java:329)
        at artemispm.serverutil.AppMgr.getConnection(AppMgr.java:492)
        at artemispm.trjdbc.TRJConnection.(TRJConnection.java:46)
        at artemispm.trdo.TRBaseSql.getConnection(TRBaseSql.java:2903)
        at artemispm.service.TRDebugWriter.transmit(TRDebugWriter.java:105)
        at artemispm.trapplets.DataBroker.clockedTransmit(DataBroker.java:4969)
        at artemispm.trapplets.DataBroker.callService(DataBroker.java:3125)
        at artemispm.trapplets.DataBroker.callService(DataBroker.java:3103)
        at artemispm.trapplets.DataBroker.initTriton(DataBroker.java:325)
        at artemispm.trapplets.TRApplet.init(TRApplet.java:296)
        at sun.applet.AppletPanel.run(AppletPanel.java:425)
        at java.lang.Thread.run(Thread.java:662)</p>
    
    <p>Build Version:?VERSION?
    productpm.trdo.TRSeriousException: No suitable driver found for sqlserver://localhost:1433;DatabaseName=XX
        at artemispm.trapplets.DataBroker.checkError(DataBroker.java:659)
        at artemispm.trapplets.DataBroker.callService(DataBroker.java:3129)
        at artemispm.trapplets.DataBroker.callService(DataBroker.java:3103)
        at artemispm.trapplets.DataBroker.initTriton(DataBroker.java:325)
        at artemispm.trapplets.TRApplet.init(TRApplet.java:296)
        at sun.applet.AppletPanel.run(AppletPanel.java:425)
        at java.lang.Thread.run(Thread.java:662)</p>
  </blockquote>
  
  <p>I tried to placing
  sqljdbc.jar
  sqljdbc4.jar
  in %catalina_home&amp;\lib folder but that did not help</p>
  
  <p>I am not familiar with Java but would appreciate any help on this.</p>
  
  <p>EDIT:
  My connections string is defined in customer.properties file like this:
  APP.url= sqlserver://localhost:1433;DatabaseName=XX</p>
  
  <p>Now I changed it to:
  APP.url= jdbc:sqlserver://localhost:1433;DatabaseName=XX</p>
  
  <p>and I have new error:</p>
  
  <blockquote>
    <p>APPLICATION STARTUP FAILURE Java Runtime Environment (JRE) version 1.6
    is not supported by this driver. Use the sqljdbc4.jar class library,
    which provides support for JDBC 4.0.</p>
  </blockquote>
  
  <p>How do I switch to new driver ?</p>