• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Integrate Eclipse and mysql

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ,
 
Marshal
Posts: 28177
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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



Why not?
 
anu johncy
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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

thanks & regards
Anu johncy
 
anu johncy
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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 .
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic