Reputation: 155
I can connect Java and Maria DB with JDBC and DriverManager. It works. I can write line in my database's tables ect.... But with "BASIC DATA SOURCE" i can't connect to MariaDB. I use openJDK 15 on FEDORA. I don't understand why i can't connect to database.
This is my code :
public static void main(String... args){
Connection conn = null;
try {
long identifiant = 24L;
String nom = "Errani";
String prenom = "Sara";
//data for connection with DB
String userName = "kent1";
String password= "*****";
BasicDataSource dataSource = new BasicDataSource();
conn = dataSource.getConnection();
dataSource.setUrl("jdbc:mariadb://localhost:3306/TENNIS");
dataSource.setUsername(userName);
dataSource.setPassword(password);
//conn = DriverManager.getConnection("jdbc:mariadb://localhost:3306/TENNIS?useSSL=false&useLegacyDatetimeCode=false&serverTimezone=Europe/Paris","kent1","*****");
//conn.setAutoCommit(false);
PreparedStatement preparedStatement = conn.prepareStatement("UPDATE JOUEUR SET NOM=?, PRENOM=? WHERE ID=?");
preparedStatement.setString(1, nom);
preparedStatement.setString(2, prenom);
preparedStatement.setLong(3, identifiant);
int nombreEnregistrementModifies = preparedStatement.executeUpdate();
System.out.println("Le nombre d'enregistrement modifié est : "+nombreEnregistrementModifies);
System.out.println("success");
//conn.commit();
} catch (SQLException e) {
e.printStackTrace();
}
finally {
try {
if (conn!=null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
And this is my error when i RUN my code :
java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:75)
at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:462)
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:528)
at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734)
at com.mycompany.tennis.core.TestDeConnection.main(TestDeConnection.java:28)
Caused by: java.sql.SQLException: No suitable driver
at java.sql/java.sql.DriverManager.getDriver(DriverManager.java:298)
at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:60)
... 4 more
and this is my pom.xml with Maven and my dependencies for MariaDB connector and DBCP
<dependencies>
<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
<dependency>
<groupId>org.mariadb.jdbc</groupId>
<artifactId>mariadb-java-client</artifactId>
<version>2.7.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-dbcp2</artifactId>
<version>2.8.0</version>
</dependency>
</dependencies>
</project>
Upvotes: 1
Views: 650
Reputation: 155
I have solution....
In fact, i should put the conn = dataSource.getConnection();
after the userName and userPassword.....
So my code seems like that now :
dataSource.setUrl("jdbc:mariadb://localhost:3306/TENNIS");
dataSource.setUsername(userName);
dataSource.setPassword(password);
//conn = DriverManager.getConnection("jdbc:mariadb://localhost:3306/TENNIS?useSSL=false&useLegacyDatetimeCode=false&serverTimezone=Europe/Paris","kent1","*****");
//conn.setAutoCommit(false);
conn = dataSource.getConnection();
PreparedStatement preparedStatement = conn.prepareStatement("UPDATE JOUEUR SET NOM=?, PRENOM=? WHERE ID=?");
It works !
Upvotes: 0