Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

please help me in my database problems

 
naved momin
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • 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 !
 
Paul Clapham
Sheriff
Pie
Posts: 20719
30
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • 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?
 
Ove Lindström
Ranch Hand
Posts: 326
Android Firefox Browser Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Wouter Oet
Saloon Keeper
Posts: 2700
IntelliJ IDE Opera
  • Mark post as helpful
  • send pies
  • 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 Firefox Browser Mac OS X
  • Mark post as helpful
  • send pies
  • 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
  • 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 ?
 
John Jai
Rancher
Posts: 1776
  • Mark post as helpful
  • send pies
  • 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.
 
Campbell Ritchie
Sheriff
Posts: 48363
56
  • Mark post as helpful
  • send pies
  • 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
  • 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
Sheriff
Posts: 48363
56
  • Mark post as helpful
  • send pies
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic