• 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
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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 ,
 
Sheriff
Posts: 28372
99
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 .
 
Space pants. Tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic