scala 读取oracle,使用Spark / Scala连接oracle数据库获取错误

我是Sacala的新手,我有一个文本文件,其中我试图读取并加载到数据帧之后我试图加载到数据库中,同时加载到数据库I' m当我在Toad中使用的相同凭证成功连接时,获得下面给出的错误。任何帮助将不胜感激

的text.txt

TYPE,CODE,SQ_CODE,RE_TYPE,VERY_ID,IN_DATE,DATE

"F","000544","2017002","OP","95032015062763298","20150610","20150529"

"F","000544","2017002","LD","95032015062763261","20150611","20150519"

"F","000544","2017002","AK","95037854336743246","20150611","20150429"

val sparkSession = SparkSession.builder().master("local").appName("IT_DATA").getOrCreate()

Driver=oracle.jdbc.driver.OracleDriver

Url=jdbc:oracle:thin:@xxx.com:1521/DATA00.WORLD

username=xxx

password=xxx

val dbProp = new java.util.Properties

dbProp.setProperty("driver", Driver)

dbProp.setProperty("user", username)

dbProp.setProperty("password", password)

//Create dataframe boject

val df = sparkSession.read

.format("com.databricks.spark.csv")

.option("header", "true")

.option("inferSchema", "true")

.option("location", "/xx/xx/xx/xx/test.csv")

.option("delimiter", ",")

.option("dateFormat", "yyyyMMdd")

.load().cache()

df.write.mode("append").jdbc(Url, TableTemp, dbProp)

df.show

+-----+-------+---------+---------+-------------------+---------+-------------+

| TYPE| CODE| SQ_CODE| RE_TYPE | VERY_ID| IN_DATE| DATE |

+-----+-------+---------+---------+-------------------+---------+-------------+

| F | 000544| 2017002| OP | 95032015062763298| 20150610| 2015-05-29|

| F | 000544| 2017002| LD | 95032015062763261| 20150611| 2015-05-19|

| F | 000544| 2017002| AK | 95037854336743246| 20150611| 2015-04-29|

+-----+-------+---------+--+------+-------------------+---------+-------------+

错误

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值