英文:
i failed to connect with database in eclipse
问题
当我刚开始尝试在Eclipse中连接Oracle数据库时，首先遇到了错误。错误出现在这部分 -> 'Data Source Explorer/Database Connection ->新建 Oracle'，但是我解决了它。
- 通过将 'service name - db' 更改为在属性中检查SID并写入 orcl，我解决了这个问题 -> 通用部分
（第一次连接到Oracle数据库时，发生了ORA 12505错误，但我使用了其他我可以使用的SID [cmd - lsnrctl services -> 我找到了 DEDICATED、READY SID]，所以问题得以解决。）
- 通过将 '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
- 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.)
- 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.......
专注分享java语言的经验与见解，让所有开发者获益！
评论