我在Eclipse中未能成功连接数据库。

huangapple 未分类评论52阅读模式
英文:

i failed to connect with database in eclipse

问题

当我刚开始尝试在Eclipse中连接Oracle数据库时,首先遇到了错误。错误出现在这部分 -> 'Data Source Explorer/Database Connection ->新建 Oracle',但是我解决了它。

  1. 通过将 'service name - db' 更改为在属性中检查SID并写入 orcl,我解决了这个问题 -> 通用部分

(第一次连接到Oracle数据库时,发生了ORA 12505错误,但我使用了其他我可以使用的SID [cmd - lsnrctl services -> 我找到了 DEDICATED、READY SID],所以问题得以解决。)

  1. 通过将 'Host - server' 更改为 'Host - localhost',我认为它肯定会起作用。然后运行了Tomcat服务器。但它仍然不起作用。

当我检查控制台时,我可以找到这个错误消息。

============================================================================

java.sql.SQLException: 无法创建 PoolableConnectionFactory(监听器拒绝连接,出现以下错误:

ORA-12505,TNS:listener does not currently know of SID given in connect descriptor

)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:668)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:543)

at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:752)

at sec02.ex02.MemberDAO.listMembers(MemberDAO.java:33)

at sec02.ex02.MemberServlet.doHandle(MemberServlet.java:49)

at sec02.ex02.MemberServlet.doGet(MemberServlet.java:20)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

(...)

我该如何解决这个问题……

英文:

when i tried to connect Oracle Database with Eclipse at first
i got Error in this part -> 'Data Source Explorer/Database Connection ->new Oracle'
but , i resolved it

  1. by changing 'service name - db' into 'checking SID and writing orcl' in properties ->general part

(at the first time when i connected to Oracle Database, ORA 12505 happend, but i used other SID that i
can use [cmd -lsnrctl services-> i found DEDICATED, READY SID] so that probloem was resolved.)

  1. by changing 'Host - server' into 'Host - localhost'

i thought it would work certainly. and runned tomcat server.
but it still doesn't work

when i checked console, i could find this error message.

============================================================================

	java.sql.SQLException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:

	ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

	 )

		at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:668)

		at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:543)

		at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:752)

		at sec02.ex02.MemberDAO.listMembers(MemberDAO.java:33)

		at sec02.ex02.MemberServlet.doHandle(MemberServlet.java:49)

		at sec02.ex02.MemberServlet.doGet(MemberServlet.java:20)

		at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

		at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

		at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

(...)

how can i resolve it.......

huangapple
  • 本文由 发表于 2020年7月26日 16:26:28
  • 转载请务必保留本文链接:https://java.coder-hub.com/63097825.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定