Eclipse不能在windows 7上连接oracle 10g XE [英] Eclipse cannot connect oracle 10g XE on windows 7
问题描述
无法连接到新Oracle。
创建与New Oracle的SQL Model Connection连接时出错。 (错误:Io异常:从读取调用中减去一个)
Io异常:从读取调用中减去一个
创建到新Oracle的jdbc.connection.name连接时出错。 (错误:Io异常:从读取调用中减去一个)
Io异常:从读取调用中减去一个
但它正常打开数据库页面。我可以创建表,插入等。
我的url是 http:// localhost:8080 / apex
。
我在Eclipse中使用了以下连接设置:
- SID:XE
- 主机:localhost
- 端口号:8080
- 用户名:系统
- 密码:123
- 连接网址:jdbc:oracle:thin:@localhost:8080:XE
我也从services.msc启动了所有Oracle服务。
我如何解决这些错误?
端口8080不适用于Oracle数据库本身,它是通过Web浏览器查看Oracle Application Express(Apex)。
我猜你希望Eclipse连接到数据库本身,所以你的JDBC URL应该使用端口1521而不是8080:
jdbc:oracle:thin:@localhost:1521:XE
Eclipse is not able to connect to oracle 10g it is giving errors like:
Could not connect to New Oracle.
Error creating SQL Model Connection connection to New Oracle. (Error: Io exception: Got minus one from a read call)
Io exception: Got minus one from a read call
Error creating jdbc.connection.name connection to New Oracle. (Error: Io exception: Got minus one from a read call)
Io exception: Got minus one from a read call
But it is opening the database page normally. I can create tables, insert, etc.
My url is http://localhost:8080/apex
.
I used the following connection settings in Eclipse:
- SID: XE
- Host: localhost
- Port no: 8080
- Username: system
- password: 123
- Connection url: jdbc:oracle:thin:@localhost:8080:XE
I have also started all Oracle services from services.msc.
How can I fix these errors?
Port 8080 is not for the Oracle database itself, it is for viewing Oracle Application Express (Apex) via a web browser.
I'm guessing you want Eclipse to connect to the database itself, so your JDBC URL should use port 1521 instead of 8080:
jdbc:oracle:thin:@localhost:1521:XE
这篇关于Eclipse不能在windows 7上连接oracle 10g XE的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!