problem to insert data - mysql

[mark smith]

hi

i try to insert some value in a mysql database

public final String url="jdbc:mysql://localhost/test";
public final String user="test";
public final String password="test";
public Connection conn;
public String query = "insert into membre(firstname, lastname) values ("paul", "smith")";
        
 
try{
  Class.forName("com.mysql.jdbc.Driver");
  conn=DriverManager.getConnection("url","user","password");
  st= conn.createStatement();
  st.execute(query);
}catch(Exception e){
  System.out.println(e.getMessage()); //here

i downloaded the mysql driver (jar file)

in netbeans, i added the jar into the compile, compile test and run test section for the project

when i run project, an error is catched is: import java.sql.Connection;

java.sql.SQLException: No suitable driver

any idea?
[ September 10, 2006: Message edited by: mark smith ]

[Alice Corman]

When you say the mySQL driver, do you mean the MySQL Connector/J jar? Did you first verify that you connect to your database (named: "test") using the mySQL client and the username/password: test/test?


Try supplying the default port number (3306) in the url:

public final String url="jdbc:mysql://localhost:3306/test";

Don't quotes around the variable names here:

conn=DriverManager.getConnection("url","user","password");

Using quotes will pass in the word "url" instead of the url variable ("jdbc:mysql://localhost:3306/test"). Use:

conn=DriverManager.getConnection(url,user,password);

[ September 10, 2006: Message edited by: Alice Corman ]

[Alice Corman]

Correction: Default port should be 3306
[ September 10, 2006: Message edited by: Alice Corman ]

[Rushikesh Wagh]

public String query = "insert into membre(firstname, lastname) values ("paul", "smith")";


I dont think this will worl.....
Please Try Out Single Quotes Insted Of Double Quotes .....

public String query = "insert into membre(firstname, lastname) values ('paul', 'smith')";

Cheers