Win a copy of Terraform in Action this week in the Cloud forum!
  • 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:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

please help me in my database problems

 
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
i need to use mysql from ide like eclipse to support my applications database requirements .i have downloaded jconnector from mysql & mysql explorer but didnt know how to use it ?
can any one will help me setting this up ..i m a student please help
ide forum guyz are useless they didnt revert the mesage soon they take atleast 3-5 days to revert back a single quary , so i guess this could be the best place to sort this out
i have been trying to set this up from couple of days but fails to do so , so please any one help me out .please !
 
Marshal
Posts: 26914
82
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

naved momin wrote:i need to use mysql from ide like eclipse to support my applications database requirements .i have downloaded jconnector from mysql & mysql explorer but didnt know how to use it ?



So are you looking for some kind of Eclipse plugin to work with the database, or what? Or did you think that Eclipse had some built-in features to work with databases?
 
Ranch Hand
Posts: 326
Android Mac OS X Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Eclipse has a Database Explorer that you can use. Use "Window/Open Persective/Daabase Development". If not installed, use the "Install new software" from the Help menu.

When you use the database connectors, they need to be in the project classpath.
 
naved momin
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Paul Clapham wrote:

naved momin wrote:i need to use mysql from ide like eclipse to support my applications database requirements .i have downloaded jconnector from mysql & mysql explorer but didnt know how to use it ?



So are you looking for some kind of Eclipse plugin to work with the database, or what? Or did you think that Eclipse had some built-in features to work with databases?


anything i just want to use database from eclipse . i have jconnector and i have installed sqlexplorer .
but i need to set this in order that i could able to provide database for my application.
 
Bartender
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do you want to be able to use the database from eclipse? So that you can see table structure/content. Or do you want to use the database in your application? (Which you're probably developing in eclipse).
 
Ove Lindström
Ranch Hand
Posts: 326
Android Mac OS X Firefox Browser
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

naved momin wrote:
anything i just want to use database from eclipse . i have jconnector and i have installed sqlexplorer .
but i need to set this in order that i could able to provide database for my application.



Take a look at http://learnola.com/2009/01/07/java-tutorial-connect-to-mysql-database/

I found this doing java connect to mysql tutorial...
 
naved momin
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Wouter Oet wrote:Do you want to be able to use the database from eclipse? So that you can see table structure/content. Or do you want to use the database in your application? (Which you're probably developing in eclipse).


i want database in my application which is developing in eclipse as my final year project . and i have sql explorer so i think we can view tables and stuff in it ?
 
Rancher
Posts: 1776
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

naved momin wrote:i have sql explorer


is this eclipse sql explorer or a database itself like MySql, Oracle, etc? What database you have chosen to use in your project

naved momin wrote:so i think we can view tables and stuff in it ?


So you opened up the database you have and first created any tables in it? Or you want to even create the code in java to create the tables
Did you saw the below code pointed by Oye in the previous message?


1. Download a database
2. Download its java driver package
3. Set up the database with username & pwd & get the connection string
4. use above code to connect to the db from java... hope this helps.
 
Marshal
Posts: 74389
334
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I presume you have got your database working from the MySQL command line? I presume you have read those tutorials? I like this Tutorial, but you probably only need one.
Only after you have got MySQL working at the command line should you try connecting it to Java™.
I think this discussion would sit better on our databases forum, so I shall move it.
 
naved momin
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

John Jai wrote:

naved momin wrote:i have sql explorer


is this eclipse sql explorer or a database itself like MySql, Oracle, etc? What database you have chosen to use in your project

naved momin wrote:so i think we can view tables and stuff in it ?


So you opened up the database you have and first created any tables in it? Or you want to even create the code in java to create the tables
Did you saw the below code pointed by Oye in the previous message?


1. Download a database
2. Download its java driver package
3. Set up the database with username & pwd & get the connection string
4. use above code to connect to the db from java... hope this helps.


do i need to paste this in my eclipse and run it ? ..
and i have downloaded jconnector but dont know where to place it , i mean install or unrar it ?
and i have mysql server 5.1 installed up and running ...
so please it will be great if you give me some step by step instruction as i m newbie into java
thanks
jai
 
Campbell Ritchie
Marshal
Posts: 74389
334
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Have you found the MySQL documentation? It should be on the MySQL website, and there is a whole chapter about connections, JDBC included. You need to follow those instructions to the letter.
 
reply
    Bookmark Topic Watch Topic
  • New Topic