spark读取oracle

import org.apache.spark.sql.SparkSession

object SparkToOracle {
  def main(args: Array[String]): Unit = {
    val spark = SparkSession
      .builder()
      .master("local[2]")
      .appName("OracleTest")
      .getOrCreate()

    val sqltext="(select * from TABLE_NAME) t"
    val jdbcdf = spark
      .read
      .format("jdbc")
      .option("url", "jdbc:oracle:thin:@IP:1521:SERVICE_NAME ")
      .option("dbtable",sqltext)
      .option("user","username")
      .option("password","password").load()

    print(jdbcdf)
    jdbcdf.createOrReplaceTempView("ls")
    spark.sql("select * from ls").show()

spark.stop()


  }

}