aspose file tools*
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 Soft Skills this week in the Jobs Discussion 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Eclipse/SQL Explorer - can't list procedures in structure view