Advertisement
Guest User

Untitled

a guest
Sep 12th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. val dataframe_oracle = sqlContext.read.format("jdbc").option("url", dbUrl).option("driver", "oracle.jdbc.driver.OracleDriver").option("dbtable", sqlQuery).option("user", dbUserName).option("password", dbPassword).load
  2.  
  3. Stu _id Percent
  4. 1 80.145
  5. 2 60.34
  6.  
  7. Stu _id Percent
  8. 1 0E+127
  9. 2 0E+127
  10.  
  11. var connection: Connection = null
  12. val driver = "oracle.jdbc.driver.OracleDriver"
  13. Class.forName(driver)
  14.  
  15. var dbURL: String = "jdbc:oracle:thin:@//" + dbServer + ":" + dbPort + "/" + dbName //+localhost:1521/xe"
  16.  
  17. connection = DriverManager.getConnection(dbURL, dbUsername, dbpassword)
  18. val DBMetaData = connection.getMetaData();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement