Hi, Which version of Spark are you using?
Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 15 May 2016 at 20:05, KhajaAsmath Mohammed <mdkhajaasm...@gmail.com> wrote: > Hi , > > I am trying to test sql server connection with JDBC RDD but unable to > connect. > > val myRDD = new JdbcRDD( sparkContext, () => > DriverManager.getConnection(sqlServerConnectionString) , > "select CTRY_NA,CTRY_SHRT_NA from dbo.CTRY limit ?, ?", > 0, 5, 1, r => r.getString("CTRY_NA") + ", " + > r.getString("CTRY_SHRT_NA")) > > > sqlServerConnectionString here is jdbc:sqlserver:// > usaecducc1ew1.ccgaco45mak.us-east-1.rds.amazonaws.com > ;database=ProdAWS;user=sa;password=?s3iY2mv6.H > > > can you please let me know what I am doing worng. I tried solutions from > all forums but didnt find any luck > > Thanks, > Asmath. >