spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Sharma <deepakmc...@gmail.com>
Subject Re: What are the configurations needs to connect spark and ms-sql server?
Date Mon, 08 Aug 2016 08:03:54 GMT
Hi Devi
Please make sure the jdbc jar is in the spark classpath.
With spark-submit , you can use --jars option to specify the sql server
jdbc jar.

Thanks
Deepak

On Mon, Aug 8, 2016 at 1:14 PM, Devi P.V <devip2136@gmail.com> wrote:

> Hi all,
>
> I am trying to write a spark dataframe into MS-Sql Server.I have tried
> using the following code,
>
>  val sqlprop = new java.util.Properties
>     sqlprop.setProperty("user","uname")
>     sqlprop.setProperty("password","pwd")
>     sqlprop.setProperty("driver","com.microsoft.sqlserver.jdbc.
> SQLServerDriver")
>     val url = "jdbc:sqlserver://samplesql.amazonaws.com:1433/dbName"
>     val dfWriter = df.write
>     dfWriter.jdbc(url, "tableName", sqlprop)
>
> But I got following error
>
> Exception in thread "main" java.lang.ClassNotFoundException:
> com.microsoft.sqlserver.jdbc.SQLServerDriver
>
> what are the configurations needs to connect to MS-Sql Server.Not found
> any library dependencies for connecting spark and MS-Sql.
>
> Thanks
>



-- 
Thanks
Deepak
www.bigdatabig.com
www.keosha.net

Mime
View raw message