Problème de connexion Hibernate
Bonjour,
Bon voila j'ai un souci de connexion entre mes fichiers de configuration et ma base de donnée , j'ai ces 2 erreurs ci dessous qui s'affiche pourtant j'ai tout fait pour configurer ma base de donnée ,j'ai crée la base , mis en place tout les éléments d'Hibernate , mais bon , j'ai toujours un problème de connexion , bon déja je vous montre mes codes et après l'erreur qui s'affiche sur la console :
Class SessionFactoryUtil :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| package com.pfe.configuration;
*
import org.hibernate.*;
import org.hibernate.cfg.*;
*
public class SessionFactoryUtil {
****public static final SessionFactory sessionFactory;
*
****static {
********try {
************// Création de la SessionFactory à partir de hibernate.cfg.xml
************sessionFactory = new Configuration().configure("com/pfe/configuration/hibernate.cfg.xml").buildSessionFactory();
********} catch (Throwable ex) {
************// Make sure you log the exception, as it might be swallowed
************System.err.println("Initial SessionFactory creation failed." + ex);
************throw new ExceptionInInitializerError(ex);
********}
****}
*
***// public static final ThreadLocal session = new ThreadLocal();
*
****public static SessionFactory getSessionFactory() {
********return sessionFactory;
****}
} |
ArticleBean.hbm.xml :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
| <?xml version="1.0" encoding="UTF-8"?>
*
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
*
*
*
<hibernate-mapping>
*
****<class name="com.pfe.beans.Bean_article_it" table="bd_article_it" >
*****
********<id name="id_article" column="id_article">
************<generator class="native" />
********</id>
*********
********<property name="titreArticle" column="titre_article" ></property>
*********
********<property name="descriptionArticle" column="description_article" ></property>
*********
********<property name="contenueArticle" column="contenue_article" ></property>
*********
********<property name="image_article" column="image_article" ></property>
*********
********<property name="date_heure_publication_article" column="date_heure_article" ></property>
********
********
****</class>
*****
</hibernate-mapping> |
hibernate.cfg.xml :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
| <?xml version="1.0" encoding="UTF-8"?>
*
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
*
<hibernate-configuration>
*
****<session-factory>
*****
********<!-- On pourra changer le SGBD facilement avec Hibernet , si on souhaite travailler après
*************avec Oracle il suffit juste de changer les paramètres de connexion .**
*********-->
*****
********<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
********<property name="hibernate.connection.class_driver">com.mysql.jdbc.Driver</property>
********<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/lets_start_it_base</property>
********<property name="hibernate.connection.username">admin1</property>
********<property name="hibernate.connection.password">admin1</property>
********<property name="hibernate.connection.pool_size">20</property>
********<property name="hibernate.show_sql">true</property>
**********
********<property name="hibernate.current_session_context_class">thread</property>
*********
********<mapping resource="com/pfe/configuration/ArticleBean.hbm.xml"/>
********<mapping resource="com/pfe/configuration/FichierBean.hbm.xml"/>
********<mapping resource="com/pfe/configuration/PersonneBean.hbm.xml"/>
********<mapping resource="com/pfe/configuration/CategorieBean.hbm.xml"/>
*
****</session-factory>
*****
</hibernate-configuration> |
Ma method Main pour le test , TestMain.java :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| package com.pfe.test;
*
*
*
import com.pfe.beans.Bean_article_it;
import com.pfe.implementdao.ArticleImpDAO;
import com.pfe.interfacesdao.IArticleDAO;
*
public class TestMain {
*
****public static void main(String[] args) {
*********
********IArticleDAO interfaceArticle = new ArticleImpDAO();
*********
********Bean_article_it beanArtcile = new Bean_article_it("Titre 1", "Description 1", "Contenue 1", "Image 1", null);
*********
********interfaceArticle.addArticle(beanArtcile);
*********
********System.out.println("ADDED !");
*********
****}
*
} |
Et voila les 2 erreurs qui s'affiche :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
| org.hibernate.exception.GenericJDBCException: Cannot open connection
****at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
****at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
****at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
****at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
****at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
****at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
****at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
****at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
****at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
****at com.pfe.implementdao.ArticleImpDAO.addArticle(ArticleImpDAO.java:25)
****at com.pfe.test.TestMain.main(TestMain.java:17)
Caused by: java.sql.SQLException: Access denied for user 'admin1'@'localhost' (using password: YES)
****at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
****at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
****at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
****at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
****at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4323)
****at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1267)
****at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2255)
****at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
****at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
****at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
****at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
****at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
****at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
****at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
****at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
****at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
****at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
****at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
****at java.sql.DriverManager.getConnection(DriverManager.java:664)
****at java.sql.DriverManager.getConnection(DriverManager.java:208)
****at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
****at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
****... 6 more
ADDED ! |
Merci .
