my dog learned polymorphism*
The moose likes IDEs, Version Control and other tools and the fly likes Eclipse/SQL Explorer - can't list procedures in structure view Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Eclipse/SQL Explorer - can Watch "Eclipse/SQL Explorer - can New topic
Author

Eclipse/SQL Explorer - can't list procedures in structure view

Carl Zeigler
Greenhorn

Joined: Mar 09, 2010
Posts: 5
Hello,
I have installed the SQL Explorer plugin for Eclipse. I have the connection working OK but if I connect with a read only ID, I can only view a list of the database tables. The functions and procedure elements of the database structure view will not populate with the functions/procedures in the schema.

If I connect with an ID that has update permissions to the database, the function and procedure elements of the database structure view populate correctly.

I am connecting to an Oracle database (10.2.0.4.0) using the Oracle thin driver from oracle.jdbc.OracleDriver in ojdb6.jar. I am using version 3.5.2 of the Eclipse platform on a WinXP machine.

Incedentally, I tried to install the Toad plugin for Eclipse and have the exact same issue.

Can anyone please suggest a solution? I need to be able to use the read only ID in order to access or view database tables, procedures and functions in a production environment.

Thank you,
Carl
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Eclipse/SQL Explorer - can't list procedures in structure view
 
Similar Threads
Mr.Kyte, could you introduce a little about your book?
Is ORM suitable for *big* apps ?
Crystal Reports with Eclipse
java stored procedure problems
Problem while executing Procedures Using Callable Statement