Database explorer in eclipse

Hi experts,

I m trying to connect to MySQL using Database Explorer in Eclipse.
I have Eclipse Version: 3.1.0.

I have made all the connections and the connection was successful.
But i m not able to browse the database.

When i finish giving all the connection parameter and click on Finish, i get a "Navigator.title!" window instead of "Database Explorer" window.
I do have a table in my database.
Even "Data Output" window is also not showing anything.

Can anybody tell me whats happening?
LVL 6
avinthmAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fargoCommented:
Hi,

what kind of plugin u r using? I don't think there is anything like "Database Explorer" plugin in eclipse (is it in webtools?). I know of SQL Explorer, quantam DB etc.

BTW in my opinion, better off for squirrel sql client
http://squirrel-sql.sourceforge.net/

avinthmAuthor Commented:
its not a plugin. its one of the view
Show View -> Data -> Data Explorer.

Its one of the feature of eclipse where u can connect directly to database and view your schema and tables
fargoCommented:
only in webtools project...correct? I am using Eclipse 3.1.1 and i don't have any such view by default.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

avinthmAuthor Commented:
ya its only in webtools project. i m using the webtools project.
do u have any idea on how to go about this?
fargoCommented:
hi avinthm,

i just now downloaded webtools and tried the database explorer for mysql connection. It works like a charm. Probably, you have installed some other plugins which interfere with database explorer etc. Check the logs of eclipse, you will get better ideas. Generally u will find eclipse logs file in the root directory of eclipse
avinthmAuthor Commented:
I hav installed Exadel Studio plugin (for struts framework) and Oxygen plugin (for xml).
I will remove the plugins and try it out once again.

if possible can you tell me the steps that u followed to connect to mysql ?
I dont think i have missed out any...even though for verification.
avinthmAuthor Commented:
fargo,

can u please explains the steps that executed to get access to database ?
will definitely increase points.
fargoCommented:
Window --> Show View --> Data --> Database Explorer

then in the opened database explorer, select Connections
Connections --> right click --> New Connection

In the opened mask,

I have selected MySql->4.1 in the database manager tree
Then defined all the connection details, with the correct jdbc jar file for the mysql.

Define use the username password to connect and that's all.
avinthmAuthor Commented:
> in the opened database explorer
When i select Database Explorer, i get a window "Navigator.title!" (dont know why?)

But i do have a New Connection button.
When i click it, i get a window where i specify the following details

Connection URL Detials :
Database : test
JDBC Driver class : com.mysql.jdbc.Driver
Class Location : <location of mysql-connector-java-3.1.12-bin.jar>
Connnection URL : jdbc:mysql://localhost:3306/test

when i click on "Test Connection" i get "Connection to MySQL is successful"
Then when i click "Finish", i dont get the Database Explorer.

And i have MySql -> 4.0 only
fargoCommented:
update the webtools eclipse installation with the latest version. mine is 3.1.2 with webtools.
avinthmAuthor Commented:
mine is 3.1.0
why doesnt it work with this version ?
fargoCommented:
I have used it from here
http://www.eclipse.org/webtools/

goto downloads and select build 1.0.2 OR 1.0.1 (i have 1.0.1 with Eclipse 3.1.2)
i can't say why it doesn't work.
Check the logs man..eclipse logs.
Morever, u should be having the GEF and EMF library(dependencies)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
avinthmAuthor Commented:
now i m updating eclipse. let me check if it works fine.
i didnt find any log which specifies abt this problem.

thanks for the guidance :)
avinthmAuthor Commented:
I updated Eclipse with WTP updates.
When i right click on Database Explorer , the New Connection is still disabled.
Its better to download latest version and try.

Anyways, Thanks fargo.
fargoCommented:
Hi avinthm, if u wish u can very well get refund. Sorry that i couldn't help to fix that problem.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.