how to add mysql driver jar file in eclipse

Question

I have the jar file: mysql-connector-java-5.1.14-bin.jar and I want to add it to my project. I add the jar at this way: project-> properties -> (Java Build Path) Libraries and add it from external jars. But when I try to use it and write:

import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;

I get error under "com.mysql".

What is my mistake?

`import java.sql.*;` after adding external connector JAR, anyone? — instinct, Jul 18 '14 at 06:09
Might be your connector jar is corrupt. You may try downloading it again or try to open it using an archive manager tool. — James Jithin, Sep 26 '15 at 05:38

score 1 · Answer 1 · answered Mar 18 '14 at 20:40

1

If the JAR file for the JDBC driver appears in the "Referenced Libraries" branch of the project, like this:

then you don't need an import statement for it. Just use DriverManager.getConnection() and Java should be able to find the JDBC driver itself.

String myConnectionString =
        "jdbc:mysql://localhost:3307?" +
        "useUnicode=yes&characterEncoding=UTF-8";
// the following statement assumes
//     import java.sql.*;
Connection dbConnection = DriverManager.getConnection(myConnectionString, "root", "myPassword");

answered Mar 18 '14 at 20:40

Gord Thompson

116,920
32
215
418

Thanks, that work. But the command: MysqlDataSource ds = new MysqlConnectionPoolDataSource(); stil get error. how can I fix that? – user1994587 Mar 19 '14 at 09:58
@user1994587 In that case `import com.mysql.jdbc.jdbc2.optional.*;` works fine for me. – Gord Thompson Mar 19 '14 at 10:52

how to add mysql driver jar file in eclipse

1 Answers1

Linked