It's not a secret anymore!*
The moose likes IDEs, Version Control and other tools and the fly likes Integrate Eclipse and mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Integrate Eclipse and mysql" Watch "Integrate Eclipse and mysql" New topic
Author

Integrate Eclipse and mysql

anu johncy
Greenhorn

Joined: Dec 05, 2011
Posts: 11
Hai friend ,

In my Java program (using Eclipse IDE),i want to connect mysql .

I download and install Eclipse in (C:\ProgramFiles)
I download and install Mysql .
I download Mysql Connector .

But I can not use data base in my java program


thanks
regards ,
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

anu johncy wrote:But I can not use data base in my java program


Why not?
anu johncy
Greenhorn

Joined: Dec 05, 2011
Posts: 11

Here i am using eclipse IDE , how i can access mysql database using eclipse .

thanks & regards
Anu johncy
anu johncy
Greenhorn

Joined: Dec 05, 2011
Posts: 11
anu johncy wrote:
Here i am using eclipse IDE , how i can access mysql database using eclipse .

thanks & regards
Anu johncy


I got the solution


Integrate Eclipse and MYSQL

1. Install Eclipse in C:/ProgramFiles .
2. Download SQL EXplorer , and unzip in to eclipse folder, then copy sql explorer featers and plugins to eclipse fetures and plugins .
then start eclipse IDE.
3. ineclipse IDE form menu bar click Window->open prespective->others.
open prespective window will come . Select SQL Explorer.
SQl Explorer will come Eclipse IDE.

Click Create New Connection Profile window will get.

give the Name : MySql Connection (any name).
Driver click Add/Edit Drivers button prefernces window will come select JDBC driver from SQLEXplorer . select MYSQL Driver click Add button
Create a new Driver window will get .

give any name as Driver name
ie, Name : MMMYSQL
example URL: jdbc://localhost:3306/db.
select Extra class path tab
click Add jars (to add external jar files ) select mysql connector click Ok .
prefernce window select MMMySql Driver and click Ok
in create new connection profile window select Driver
check auto ligin

give user name : root
passowrd: root (if given in Mysql data base).
check Auto commit.
finaly click Ok button .
 
Don't get me started about those stupid light bulbs.
 
subject: Integrate Eclipse and mysql
 
Similar Threads
Install MySQL for Windows Vista
Swing Designers
regarding books
want to install java 6 , eclipse
Using Mysql dll