Eclipse-plsql连接oracle正常但javajdbc连不上(java.sql.SQLException: ORA-01017: invalid username/password; logon denied)

数据库   发布日期:2025年06月18日   浏览次数:149

1、错误现象

  1. java.sql.SQLException: ORA-01017: invalid username/password; logon denied
  2. at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  3. at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
  4. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
  5. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
  6. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
  7. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  8. at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
  9. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
  10. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
  11. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
  12. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
  13. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
  14. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  15. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  16. at Test.getConnection(Test.java:76)
  17. at Test.download(Test.java:22)
  18. at Test.main(Test.java:14)
  19. Exception in thread "main" java.lang.NullPointerException
  20. null at Test.download(Test.java:58)
  21. at Test.main(Test.java:14)

二、原因

PL/SQL使用的是SERVICE_NAME连接,程序里用了SID连接

三、本次解决方法

两种程序中的连接方法:

SID连接方式:

  1. jdbc:oracle:thin:@<host>:<port>:<SID>

SERVICE_NAME连接方式:

  1. jdbc:oracle:thin:@<host>:<port>/ServiceName

 

以上就是Eclipse-plsql连接oracle正常但javajdbc连不上(java.sql.SQLException: ORA-01017: invalid username/password; logon denied)的详细内容,更多关于Eclipse-plsql连接oracle正常但javajdbc连不上(java.sql.SQLException: ORA-01017: invalid username/password; logon denied)的资料请关注九品源码其它相关文章!