Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Database explorer in eclipse

Posted on 2006-04-25
15
Medium Priority
?
1,810 Views
Last Modified: 2008-01-09
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?
0
Comment
Question by:avinthm
  • 8
  • 7
15 Comments
 
LVL 11

Expert Comment

by:fargo
ID: 16537205
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/

0
 
LVL 6

Author Comment

by:avinthm
ID: 16541511
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
0
 
LVL 11

Expert Comment

by:fargo
ID: 16543895
only in webtools project...correct? I am using Eclipse 3.1.1 and i don't have any such view by default.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Author Comment

by:avinthm
ID: 16550703
ya its only in webtools project. i m using the webtools project.
do u have any idea on how to go about this?
0
 
LVL 11

Expert Comment

by:fargo
ID: 16554010
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
0
 
LVL 6

Author Comment

by:avinthm
ID: 16583208
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.
0
 
LVL 6

Author Comment

by:avinthm
ID: 16604094
fargo,

can u please explains the steps that executed to get access to database ?
will definitely increase points.
0
 
LVL 11

Expert Comment

by:fargo
ID: 16604127
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.
0
 
LVL 6

Author Comment

by:avinthm
ID: 16604168
> 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
0
 
LVL 11

Expert Comment

by:fargo
ID: 16604234
update the webtools eclipse installation with the latest version. mine is 3.1.2 with webtools.
0
 
LVL 6

Author Comment

by:avinthm
ID: 16604279
mine is 3.1.0
why doesnt it work with this version ?
0
 
LVL 11

Accepted Solution

by:
fargo earned 1200 total points
ID: 16604306
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)
0
 
LVL 6

Author Comment

by:avinthm
ID: 16604447
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 :)
0
 
LVL 6

Author Comment

by:avinthm
ID: 16627932
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.
0
 
LVL 11

Expert Comment

by:fargo
ID: 16628843
Hi avinthm, if u wish u can very well get refund. Sorry that i couldn't help to fix that problem.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Suggested Courses
Course of the Month20 days, 17 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question