please help me in my database problems

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 !

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?

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.

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.

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

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

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 ?

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.

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.

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?
public static void main(String[] args) { //try block for sql exceptions try { //create driver - ALTER TO SUIT YOUR DRIVER/ DBMS Class.forName("com.mysql.jdbc.Driver").newInstance(); //database connection code - ENTER YOUR DETAILS String username = "yourname"; String password = "yourpwd"; //URL - ALTER TO CONNECT TO YOUR DATABASE String dbURL = "jdbc:mysql://somedomain.com/database?user=" + username + "&password=" + password; //create the connection - ALTER FOR YOUR DBMS java.sql.Connection myConnection = DriverManager.getConnection(dbURL); //create statement handle for executing queries Statement stat = myConnection.createStatement(); } catch( Exception E ) { System.out.println( E.getMessage() ); }

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

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.