JDBC + Localhost

[Behrouz Hosseini]

Hi guys,
I am new at java and JDBC and I am trying to use JDBC to connect localhost /mysql.
I have this code

   import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBTest {
	public static void main(String[] args) {
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost/jdbctest";
		String username = "root";
		String password = "pass";
		// Statement;
		try {
			Class.forName(driver);
			Connection connection = DriverManager.getConnection(url, username,
					password);
			Statement statement = connection.createStatement();
			ResultSet resultset = statement.executeQuery("SELECT * FROM java");
			while (resultset.next()) {
				System.out.println(resultset.getString(1) + ", ");
				System.out.println(resultset.getString(2) + ", ");
				System.out.println(resultset.getString(3) + "\n ");
			}
			connection.close();

		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		} catch (SQLException sqle) {

			sqle.printStackTrace();
		}
	}
} 

but I get this error:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/jdbctest
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:22)

could you please let me know what I am doing wrong? can you let me know where can I find a useful tutorial regarding this?
Best regards
Behrouz

[Tim McGuire]

did you download the JDBC driver from the MySQL web site? I think it is called jConnector.

[wang lei]

you need to download the JDBC driver from the MySQL web site,
and you can get some userful messages from the sun web site,i think.

In addition to this,i also hava a suggest for you codes,

(my english is very poor and beg your pardon)

'connection.close();' should be put insize finally{} block,such as following codes:

try {  
            Class.forName(driver);  
            Connection connection = DriverManager.getConnection(url, username,  
                    password);  
            Statement statement = connection.createStatement();  
            ResultSet resultset = statement.executeQuery("SELECT * FROM java");  
            while (resultset.next()) {  
                System.out.println(resultset.getString(1) + ", ");  
                System.out.println(resultset.getString(2) + ", ");  
                System.out.println(resultset.getString(3) + "\n ");  
            }  
        } catch (ClassNotFoundException cnfe) {  
            cnfe.printStackTrace();  
        } catch (SQLException sqle) {  
            sqle.printStackTrace();  
        } finally {  
           /*finally can help you to close the Connection resource.
             *if you do not use this,it will have a mistake when execute the                             
 connection.close(); and it will throw a Exception so close() method is not executing correctly
            */
             
           try{
              if(connection !=null){
                   connection.close();
              }
          }catch(Exception e){e.printStackTrace();}
        }

[Bnaresh Yad]

download mysql-connector-java-5.1.12-bin.jar and place it in your lib folder. your problem will be solved

[Jan Cumps]

Bnaresh Yad wrote:download mysql-connector-java-5.1.12-bin.jar and place it in your lib folder. your problem will be solved

Hi Bnaresh. What lib folder are you talking about?

And Welcome to JavaRanch!

[Bnaresh Yad]

i mean to say is add that jar file into your classpath

[abhi vazhakalil]

Hey, this is a common issue which most of the beginners come across. What you need to do is just download the jar myql jar file and add this file under your libraries. This issue will be solved.

[Jan Cumps]

Welcome to JavaRanch, Abhi.

[abhi vazhakalil]

Jan Cumps wrote:Welcome to JavaRanch, Abhi.

Thanks Jan