From: Eman Hossny (e.hossnygmail.com)
Date: Thu Nov 29 2007 - 05:41:28 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi all,
i need to use Eclipse(java SDK) to connect to MYSQL DB,
& i write the following code for connection, but when i run it no thing
happen, no output appear, & when i debug it, i found that the debuger was
stopped the line

conn=DriverManager.getConnection(connectionURL,"Eman","Eman");

----------------------------------------my code for connection

String driver ="com.mysql.jdbc.Driver";
String dbName="travel";
String connectionURL = "jdbc:mysql://localhost/" + dbName;
try{
     //load the driver
      Class.forName(driver).newInstance();
      conn=DriverManager.getConnection(connectionURL,"Eman","Eman");
       System.out.println("Successfully connected to " +
                       "MySQL server using TCP/IP...");
       }
       catch(Exception e)
       {
               e.printStackTrace();
         System.out.println("Error "+e.getMessage());
       }
-----------------------------------------

-note: i added the connector/j.jar to the classpath environment variable
-Is the connector/J version must be consistent with the jdk version?
-i consume more time to solve this problem but till now didn't reach to any
thing.any help please,
waitting for reply

--
Eman Hossny,
Teacher Assistant,
Computer Science Department,
Faculty of Computers and Information
Cairo University, Egypt

íÇÑÈ ÇáÚÊÞ ãä ÇáäÇÑ áì æáæÇáÏíÇ

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]