This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes please help me in my database problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "please help me in my database problems " Watch "please help me in my database problems " New topic
Author

please help me in my database problems

naved momin
Ranch Hand

Joined: Jul 03, 2011
Posts: 688

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 !


The Only way to learn is ...........do!
Visit my blog http://inaved-momin.blogspot.com/
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

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

Joined: Mar 10, 2008
Posts: 326

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

Joined: Jul 03, 2011
Posts: 688

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

Joined: Oct 25, 2008
Posts: 2700

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).


"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
Ove Lindström
Ranch Hand

Joined: Mar 10, 2008
Posts: 326

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

Joined: Jul 03, 2011
Posts: 688

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
Bartender

Joined: May 31, 2011
Posts: 1776
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

Joined: Oct 13, 2005
Posts: 38045
    
  22
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

Joined: Jul 03, 2011
Posts: 688

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

Joined: Oct 13, 2005
Posts: 38045
    
  22
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.
 
Don't get me started about those stupid light bulbs.
 
subject: please help me in my database problems
 
Similar Threads
Create A Report
how to check whether the browser is internet explorer or mozilla
org.hibernate.HibernateException: Missing column: (on an MySQL database)
Getter Setter functions not working
Remote Access