spark jdbc salesforce connection: invalid username, password, security token; or user locked out

Question

i am getting jdbc error when connecting from spark to salesforce from windows... using the cdata jdbc driver

i am sure i can login to salesforce with username/password. in addition, reset my password which generate a new security token. have no idea how i can get above error...

details below:

spark-shell --jars "c:\cdata\cdata.jdbc.salesforce.jar"

val = spark.sqlContext
    .read
    .format("jdbc")
    .option("url","jdbc:salesforce:User=myusername;Password=mypassword;SecurityToken=*****;")
    .option("driver","cdata.jdbc.salesforce.SalesforceDriver")
    .load()

i have retried resetting password and regenerating security token(in that order) few times. still getting that error. i am sure my username password is correct because i can login.