Advertisement
Guest User

Untitled

a guest
Jan 28th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.92 KB | None | 0 0
  1. val sqlContext = new org.apache.spark.sql.SQLContext(sc)
  2. val driver = "com.ibm.db2.jcc.DB2Driver"
  3. Class.forName(driver)
  4. val data = sqlContext.load("jdbc", Map( "url" -> " jdbc:db2://75.126.155.153:50001/SQLDB:securityMechanism=9", "dbtable" -> "HAWAII"))
  5.  
  6. Name: java.sql.SQLException
  7. Message: No suitable driver found for jdbc:db2://75.126.155.153:50001/SQLDB:securityMechanism=9
  8. StackTrace: java.sql.DriverManager.getConnection(DriverManager.java:608)
  9. java.sql.DriverManager.getConnection(DriverManager.java:199)
  10. org.apache.spark.sql.jdbc.JDBCRDD$.resolveTable(JDBCRDD.scala:118)
  11. org.apache.spark.sql.jdbc.JDBCRelation.<init>(JDBCRelation.scala:128)
  12. org.apache.spark.sql.jdbc.DefaultSource.createRelation(JDBCRelation.scala:113)
  13. org.apache.spark.sql.sources.ResolvedDataSource$.apply(ddl.scala:269)
  14. org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:114)
  15. org.apache.spark.sql.SQLContext.load(SQLContext.scala:1253)
  16. $line18.$read$$iwC$$iwC$$iwC$$iwC.<init>(<console>:16)
  17. $line18.$read$$iwC$$iwC$$iwC.<init>(<console>:21)
  18. $line18.$read$$iwC$$iwC.<init>(<console>:23)
  19. $line18.$read$$iwC.<init>(<console>:25)
  20. $line18.$read.<init>(<console>:27)
  21. $line18.$read$.<init>(<console>:31)
  22. $line18.$read$.<clinit>(<console>)
  23. java.lang.J9VMInternals.initializeImpl(Native Method)
  24. java.lang.J9VMInternals.initialize(J9VMInternals.java:235)
  25. $line18.$eval$.<init>(<console>:7)
  26. $line18.$eval$.<clinit>(<console>)
  27. java.lang.J9VMInternals.initializeImpl(Native Method)
  28. java.lang.J9VMInternals.initialize(J9VMInternals.java:235)
  29. $line18.$eval.$print(<console>)
  30. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  31. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
  32. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
  33. java.lang.reflect.Method.invoke(Method.java:620)
  34. org.apache.spark.repl.SparkIMain$ReadEvalPrint.call(SparkIMain.scala:1065)
  35. org.apache.spark.repl.SparkIMain$Request.loadAndRun(SparkIMain.scala:1338)
  36. org.apache.spark.repl.SparkIMain.loadAndRunReq$1(SparkIMain.scala:840)
  37. org.apache.spark.repl.SparkIMain.interpret(SparkIMain.scala:871)
  38. org.apache.spark.repl.SparkIMain.interpret(SparkIMain.scala:819)
  39. com.ibm.spark.interpreter.ScalaInterpreter$$anonfun$interpretAddTask$1$$anonfun$apply$3.apply(ScalaInterpreter.scala:296)
  40. com.ibm.spark.interpreter.ScalaInterpreter$$anonfun$interpretAddTask$1$$anonfun$apply$3.apply(ScalaInterpreter.scala:291)
  41. com.ibm.spark.global.StreamState$.withStreams(StreamState.scala:80)
  42. com.ibm.spark.interpreter.ScalaInterpreter$$anonfun$interpretAddTask$1.apply(ScalaInterpreter.scala:290)
  43. com.ibm.spark.interpreter.ScalaInterpreter$$anonfun$interpretAddTask$1.apply(ScalaInterpreter.scala:290)
  44. com.ibm.spark.utils.TaskManager$$anonfun$add$2$$anon$1.run(TaskManager.scala:123)
  45. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
  46. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
  47. java.lang.Thread.run(Thread.java:801)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement