aspose file tools*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 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: 18110
    
    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: 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 .
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Integrate Eclipse and mysql
 
Similar Threads
want to install java 6 , eclipse
Swing Designers
regarding books
Using Mysql dll
Install MySQL for Windows Vista