Chapter 9: java.lang.ClassNotFoundException: org.sqllite.JDBC
arunprasadbh opened this issue · 2 comments
arunprasadbh commented
Hi I am trying to use sqllite to create Data frame. Below is the code.
_
driver = "org.sqllite.JDBC"
path = "/dbfs/databricks-datasets/definitive-guide/data/flight-data/jdbc/my-sqlite.db"
url = "jdbc:sqllite:" + path
table_name = "flight_info"
dfDF = spark.read.format("jdbc").option("url", url)
.option("dbtable", table_name)
.option("driver", driver)
.load()
_
I am getting error class not found:
java.lang.ClassNotFoundException: org.sqllite.JDBC on line that has driver option.
Is it possible to run JDBC code on community edition? please let me know what I need to do sort this error.
arunprasadbh commented
typo in sqllite causing this issue. please ignore.
arunprasadbh commented
typo in sqllite causing this issue. please ignore.