7 Replies Latest reply: Feb 19, 2013 8:07 AM by 987522 RSS

    mySQL and JDeveloper

    987522
      Hello all. I have problem usgin mySQL connector with JDeveloeper. I have downloaded "JDBC Driver for MySQL (Connector/J)" from here [mysql.com|http://www.mysql.com/products/connector/]

      Local mySQL database is working as it is shown bellow:
      ========================================
      [marek@dev Middleware]$ mysql -u root -p
      Enter password:
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 45
      Server version: 5.5.29 MySQL Community Server (GPL)

      Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      mysql> show databases;
      --------------------
      | Database |
      --------------------
      | information_schema |
      | 10mindemo |
      | mysql |
      | performance_schema |
      | test |
      --------------------
      5 rows in set (0.00 sec)

      mysql> Bye
      [marek@dev Middleware]$


      [marek@dev mysql-connector-java-5.1.23]$ pwd
      /home/marek/Oracle/mysql-connector-java-5.1.23
      [marek@dev mysql-connector-java-5.1.23]$ ls -la
      total 1252
      drwxrwxr-x. 4 marek marek 4096 Feb 18 13:52 .
      drwxrwxr-x. 4 marek marek 4096 Feb 18 13:52 ..
      -rw-r--r--. 1 marek marek 45947 Jan 25 22:26 build.xml
      -rw-r--r--. 1 marek marek 214680 Jan 25 22:26 CHANGES
      -rw-r--r--. 1 marek marek 18122 Jan 25 22:26 COPYING
      drwxr-xr-x. 2 marek marek 4096 Jan 25 22:26 docs
      -rw-r--r--. 1 marek marek 843090 Jan 25 22:26 mysql-connector-java-5.1.23-bin.jar
      -rw-r--r--. 1 marek marek 63924 Jan 25 22:26 README
      -rw-r--r--. 1 marek marek 66228 Jan 25 22:26 README.txt
      drwxr-xr-x. 7 marek marek 4096 Jan 25 22:26 src
      [marek@dev Middleware]$ netstat -pa | grep sql
      (Not all processes could be identified, non-owned process info
      will not be shown, you would have to be root to see it all.)
      tcp 0 0 *:mysql *:* LISTEN -
      unix 2 [ ACC ] STREAM LISTENING 208399 - /var/lib/mysql/mysql.sock
      ===================================================================
      I think I have succesfully done importing the mysql-lib, please see following pictures:
      [01mysql|http://i47.tinypic.com/2luols.png]
      [02mysql|http://i50.tinypic.com/21ew8wy.png]
      [03mysql|http://i45.tinypic.com/m4kuq.png]

      But when I try to test the connection I get the following error:
      Test failed: Driver class not found.
      Verify the Driver location

      Pictures bellow are steps which I followed:
      [01project|http://i49.tinypic.com/wj8mjo.png]
      [02project|http://i50.tinypic.com/2qkm6is.png]
      [03project|http://i50.tinypic.com/33yrpm9.png]
      [04project|http://i45.tinypic.com/3469hlt.png]