| Author |
Integrate Eclipse and mysql
|
anu johncy
Greenhorn
Joined: Dec 05, 2011
Posts: 7
|
|
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: 13842
|
|
anu johncy wrote:But I can not use data base in my java program
Why not?
|
 |
anu johncy
Greenhorn
Joined: Dec 05, 2011
Posts: 7
|
|
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: 7
|
|
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 .
|
 |
 |
|
|
subject: Integrate Eclipse and mysql
|
|
|