привет всем!
вот кусок кода. питаюсь законектиться к mySQL из Java.

public ResultSet result_query()
{

JDBC_DRIVER = "com.mysql.jdbc.Driver";
DATABASE_URL = "jdbc:odbc:catalog_content";
USERNAME = "root";
PASSWORD = "";
SUB_DIR_QUERY = "SELECT * FROM `subdirectory` where id = 1";

try
{
Class.forName(JDBC_DRIVER).newInstance();
Connection con_directory = DriverManager.getConnection(DATABASE_URL,USERNAME,PASSWORD);
Statement stmt_directory = con_directory.createStatement()
qres = stmt_directory.executeQuery(SUB_DIR_QUERY);
}
catch (Exception E)
{
E.printStackTrace();
}

return qres;
}
//================================================================================================
видает ошибку:

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at catalog.DB_MANAGE.result_query(DB_MANAGE.java:31)
at catalog.DB_MANAGE.main(DB_MANAGE.java:45)
java.lang.NullPointerException
at catalog.DB_MANAGE.main(DB_MANAGE.java:50)

что делать не знаю.
дривер скачен с саита mySQL.com . прописани его папки com , org в project.
заранее спасибо.

исправил:

public ResultSet result_query()
{

JDBC_DRIVER = "com.mysql.jdbc.Driver";
//DATABASE_URL = "jdbc:odbc:catalog_content";
//JDBC_DRIVER = "org.gjt.mm.mysql.Driver";
DB_NAME = "catalog_content";
//DB_NAME = "test";
USERNAME = "root";
PASSWORD = "";
SUB_DIR_QUERY = "SELECT * FROM `subdirectory` where id = 1";


try
{
Class.forName(JDBC_DRIVER).newInstance();
java.sql.Connection con_directory = DriverManager.getConnection("jdbc:mysql://localhost"+DB_NAME,"root","");
Statement stmt_directory = con_directory.createStatement();//stmt=conn.prepareStatement ("SELECT * FROM conf_links");
qres = stmt_directory.executeQuery(SUB_DIR_QUERY);
}
catch (Exception E)
{
E.printStackTrace();
}

return qres;
}

//===================================================

результат , таже ошибка:

java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at catalog.DB_MANAGE.result_query(DB_MANAGE.java:35)
at catalog.DB_MANAGE.main(DB_MANAGE.java:56)
java.lang.NullPointerException
at catalog.DB_MANAGE.main(DB_MANAGE.java:62)

как бить?

всем спасибо.
била досадная синтаксическая ошибка/описка , пропустил /
било:
"jdbc:mysql://localhost"
надо:
"jdbc:mysql://localhost/".
день на ету хрень убил.