Problem connecting to SQL Server database from Scala

Question

I am trying to connect to a SQL Server database from my Scala code, but I'm getting a 'No suitable driver found' exception. My Scala code is as follows:

import java.sql.{Connection, DriverManager, ResultSet}


val conn = DriverManager.getConnection("jdbc:sqlserver://hostname:port/DBName?user=myusername&password=mypassword")
try {
    val statement = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY)
    val rs = statement.executeQuery("select * from SomeTableName")
    while(rs.next()) {
        println(rs.getInt("CustomerID"))
    }

}
catch {
    case e => e.printStackTrace()
}
finally {
    conn.close()
}

I then ran the following command :

scala -cp /usr/lib/jtds-1.2.5.jar dbprog.scala

I have also tried using JDBC JARs for SQL Server provided by Microsoft sqljdbc.jar and sqljdbc4.jar.

And below is the stacktrace I get :

java.sql.SQLException: No suitable driver found for jdbc:sqlserver://hostname:port/DBName?user=myusername&password=mypassword
        at java.sql.DriverManager.getConnection(DriverManager.java:602)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at Main$$anon$1.<init>((virtual file):8)
        at Main$.main((virtual file):4)
        at Main.main((virtual file))
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at scala.tools.nsc.ObjectRunner$$anonfun$run$1.apply(ObjectRunner.scala:75)
        at scala.tools.nsc.ObjectRunner$.withContextClassLoader(ObjectRunner.scala:49)
        at scala.tools.nsc.ObjectRunner$.run(ObjectRunner.scala:74)
        at scala.tools.nsc.ScriptRunner$.scala$tools$nsc$ScriptRunner$$runCompiled(ScriptRunner.scala:381)
        at scala.tools.nsc.ScriptRunner$$anonfun$runScript$1.apply(ScriptRunner.scala:414)
        at scala.tools.nsc.ScriptRunner$$anonfun$runScript$1.apply(ScriptRunner.scala:413)
        at scala.tools.nsc.ScriptRunner$.withCompiledScript(ScriptRunner.scala:351)
        at scala.tools.nsc.ScriptRunner$.runScript(ScriptRunner.scala:413)
        at scala.tools.nsc.MainGenericRunner$.main(MainGenericRunner.scala:168)
        at scala.tools.nsc.MainGenericRunner.main(MainGenericRunner.scala)

What am I doing wrong and how can I fix that ?

Have you tried manually registering the driver before getting the connection, using DriverManager.registerDriver(jtdsDriverInstance) — Luciano
– Luciano, Commented Jul 4, 2011 at 13:34

Chetan Bhasin · Accepted Answer · 2015-06-26 07:19:39Z

3

Joe You need to do!

import java.sql.{Connection, DriverManager, ResultSet}

Class.forName("org.postgresql.Driver")
val conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/clients","username","password")

then Download -jar db if you need postgresql like me :-D wget postgresql-9.0-801.jdbc3.jar or ~mysql.jar

exec: scala -cp postgresql-9.0-801.jdbc3.jar file.scala

edited Jun 26, 2015 at 7:19

Chetan Bhasin

3,5891 gold badge25 silver badges36 bronze badges

answered Jul 13, 2011 at 7:36

xCheis_

311 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

Marcus Kazmierczak · Accepted Answer · 2011-07-04 13:51:12Z

1

Try including this ahead of your getConnection (modify it to reflect SQLServer driver)

classOf[com.mysql.jdbc.Driver]

I wrote up a full example of using JDBC and Scala here http://solog.co/36/using-scala-with-jdbc-to-connect-to-mysql/

answered Jul 4, 2011 at 13:51

Marcus Kazmierczak

2162 silver badges6 bronze badges

2 Comments

Joe Over a year ago

Its sqlserver not mysql that im trying to connect to. What should be the classOf statement in my case ?

Marcus Kazmierczak Over a year ago

It depends on which driver you use, for Microsoft's driver (sqljdbc) it would be: classOf[com.microsoft.sqlserver.jdbc.SQLServerDriver]

gruggie · Accepted Answer · 2011-07-04 21:16:42Z

0

Replace

val conn = DriverManager.getConnection("jdbc:sqlserver://hostname:port/DBName?user=myusername&password=mypassword")

with

Class.forName("net.sourceforge.jtds.jdbcx.JtdsDataSource")
val conn = DriverManager.getConnection("jdbc:jtds:sqlserver://hostname:port/DBName","myusername","mypassword")

answered Jul 4, 2011 at 21:16

gruggie

4365 silver badges10 bronze badges

2 Comments

Perception Over a year ago

While a great suggestion to the OP to use the superior jTDS driver, you failed to mention that he would have to download the driver and include in his application. If you modify your answer to include this I will upvote.

gruggie Over a year ago

Just below his code snippet, the OP has indicated that he has tested it with jtds, so he has already downloaded the driver

cudiaco · Accepted Answer · 2012-05-27 07:02:19Z

I found this piece of code to work for me:

Try registering your driver with the following:

java.sql.DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver)

rather than using classOf[net.sourceforge.jtds.jdbc.Driver] or Class.forName("net.sourceforge.jtds.jdbc.Driver"),

for example:

  val uri = "jdbc:jtds:sqlserver://localhost:1433/yourdatabae"
  val username = "username"
  val password = "password"

  DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver)

  private val conn: Connection = DriverManager.getConnection(uri, username, password)

  def getConn(): Connection = conn

  def main(args: Array[String]) = {

    val sql = "SELECT SOMETHING FROM YOURTABLE"
    val results = getConn.createStatement.executeQuery(sql)

    processResults(results)

    getConn.close

  }

Collectives™ on Stack Overflow

Problem connecting to SQL Server database from Scala

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related