[SPARK-10036] DataFrameReader.json and DataFrameWriter.json don't load the JDBC driver class before creating JDBC connection

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.5.0
• Component/s: SQL
• Assignee: Shixiong Zhu
• Reporter: Shixiong Zhu
• Created: 16/Aug/15 15:35
• Updated: 18/Aug/15 12:55
• Resolved: 17/Aug/15 18:54

Description

Here is the reproduce code and the stack trace

val url = "jdbc:postgresql://.../mytest"
import java.util.Properties

val prop = new Properties()
prop.put("driver", "org.postgresql.Driver")
prop.put("user", "...")
prop.put("password", "...")

val df = sqlContext.read.jdbc(url, "mytest", prop)

java.sql.SQLException: No suitable driver found for jdbc:postgresql://.../mytest
	at java.sql.DriverManager.getConnection(DriverManager.java:689)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCRDD$.resolveTable(JDBCRDD.scala:121)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCRelation.<init>(JDBCRelation.scala:91)
	at org.apache.spark.sql.DataFrameReader.jdbc(DataFrameReader.scala:200)
	at org.apache.spark.sql.DataFrameReader.jdbc(DataFrameReader.scala:130)

Issue Links

• links to: [Github] Pull Request #8232 (zsxwing)