Can't access sqlite db from Spark
<p>I have the following code:</p>

<pre><code>val conf = new SparkConf().setAppName("Spark Test")
val sc = new SparkContext(conf)
val sqlContext = new org.apache.spark.sql.SQLContext(sc)

val data = sqlContext.read.format("jdbc").options(
  Map(
    "url" -&gt; "jdbc:sqlite:/nv/pricing/ix_tri_pi.sqlite3",
    "dbtable" -&gt; "SELECT security_id FROM ix_tri_pi")).load()

data.foreach {
  row =&gt; println(row.getInt(1))
}
</code></pre>

<p>And I try to submit it with:</p>

<pre><code>spark-submit \
  --class "com.novus.analytics.spark.SparkTest" \ 
  --master "local[4]" \
 /Users/smabie/workspace/analytics/analytics-spark/target/scala-2.10/analytics-spark.jar \
  --conf spark.executer.extraClassPath=sqlite-jdbc-3.8.7.jar \
  --conf  spark.driver.extraClassPath=sqlite-jdbc-3.8.7.jar \
  --driver-class-path sqlite-jdbc-3.8.7.jar \
  --jars sqlite-jdbc-3.8.7.jar
</code></pre>

<p>But I get the following exception:</p>

<pre><code>Exception in thread "main" java.sql.SQLException: No suitable driver
</code></pre>

<p>I am using Spark version 1.6.1, if that helps.
Thanks!</p>