Connect Java to a MySQL database

Question

Can anyone help me how I can able to connect Java to MySQL Database. When I tried to connect it, it is giving me something like this:

java.sql.SQLException: No suitable driver found for jdbc:mysql://database/table

    at java.sql.DriverManager.getConnection(DriverManager.java:689)

    at java.sql.DriverManager.getConnection(DriverManager.java:247)

Any help would be appreciated.

Answer 1

Basically, you can use DataSource as DriverManger is become old for these things:

Context context = new InitialContext();

DataSource dataSource = (DataSource) context.lookup("java:comp/env/jdbc/myDB");

I hope this will help.

Want to become a Java Expert? Join Java Training now!!

Want to know more about Java? Watch this video on Java Tutorial | Java Course: