Connecting from Eclipse Database Explorer
I am having trouble browsing the sample HR database on a local install of XE. I'm using the Eclipse 3.1.1 Database Explorer. I have unlocked the HR user, and I can browse the DB successfully using DBVisualizer.
In the Eclipse new connection wizard, I supply the following info:
Database: Oracle
JDBC driver class: oracle.jdbc.OracleDriver
Class location: <my directory path to>/ojdbc14.jar
Conection URL: jdbc:oracle:thin:@localhost:1521:xe
Username: hr
Password: mypassword
The connection "ping" is successful. When I browse the database explorer hierarchy, I can see the list of schemas (HR, SYS, SYSTEM, etc.). However, I cannot expand any of the schemas to see the tables and other objects below them in the hierarchy. I am able to successfully browse the schemas using other databases.
Any ideas?