Problème connexion Hibernate

**ilamine55** · 06/05/2010, 15h39

bonjour,
j ai essayer d exécuter un simple programme qui utilise hibernate ,mais j ai cette erreur.

15:17:06,876 INFO Version:15 - Hibernate Annotations 3.2.0.GA
15:17:06,911 INFO Environment:543 - Hibernate 3.3.1.GA
15:17:06,918 INFO Environment:576 - hibernate.properties not found
15:17:06,928 INFO Environment:709 - Bytecode provider name : javassist
15:17:06,944 INFO Environment:627 - using JDK 1.4 java.sql.Timestamp handling
15:17:07,091 INFO Configuration:1460 - configuring from resource: /hibernate.cfg.xml
15:17:07,092 INFO Configuration:1437 - Configuration resource: /hibernate.cfg.xml
15:17:07,373 INFO Configuration:1575 - Configured SessionFactory: null
15:17:07,483 INFO AnnotationBinder:387 - Binding entity from annotated class: net.roseindia.Employee
15:17:07,547 INFO EntityBinder:340 - Bind entity net.roseindia.Employee on table Employee
Initial SessionFactory failed.java.lang.NoSuchMethodError: org.slf4j.Logger.isTraceEnabled()Z
Exception in thread "main" java.lang.ExceptionInInitializerError
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:14)
at net.roseindia.Exemple1.main(Exemple1.java:14)
Caused by: java.lang.NoSuchMethodError: org.slf4j.Logger.isTraceEnabled()Z
at org.hibernate.type.NullableType.<clinit>(NullableType.java:59)
at org.hibernate.Hibernate.<clinit>(Hibernate.java:103)
at org.hibernate.type.TypeFactory.<clinit>(TypeFactory.java:69)
at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:283)
at org.hibernate.mapping.SimpleValue.isValid(SimpleValue.java:276)
at org.hibernate.mapping.Property.isValid(Property.java:207)
at org.hibernate.mapping.PersistentClass.validate(PersistentClass.java:458)
at org.hibernate.mapping.RootClass.validate(RootClass.java:215)
at org.hibernate.cfg.Configuration.validate(Configuration.java:1135)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1320)
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:10)
... 1 more

**ilamine55** · 06/05/2010, 15h41

voici le code source :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
public class HibernateUtil {
 
	 private static final SessionFactory sessionFactory;
	  static {
	    try {
	      // Create the SessionFactory from hibernate.cfg.xml
	      sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory();
	    } catch (Throwable ex) {
	      // Make sure you log the exception, as it might be swallowed
	      System.err.println("Initial SessionFactory failed." + ex);
	      throw new ExceptionInInitializerError(ex);
	    }
	  }
 
	  public static SessionFactory getSessionFactory() {
	    return sessionFactory;
	  }
}

**ilamine55** · 06/05/2010, 15h42

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
38
39
40
41
42
 
import java.io.Serializable;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
 
 
 
@Entity
@Table(name="Employee")
public class Employee {
 
	public Employee(){
 
	}
 
@Id
@Column(name="id")
int id;
 
@Column(name="name")
String name;
 
public int getId() {
	return id;
}
 
public void setId(int id) {
	this.id = id;
}
 
public String getName() {
	return name;
}
 
public void setName(String name) {
	this.name = name;
}
 
}

**ilamine55** · 06/05/2010, 15h43

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
 
public class Exemple1 {
 
 
	public static void main (String args[])throws Exception{
 
		/** avoir la session factory   */
 
		SessionFactory session = HibernateUtil.getSessionFactory();
	    Session sess = session.getCurrentSession();
 
	    /** commancer les transations */
	    Transaction tx = sess.beginTransaction();
 
	    /** creer le POJO */
	    Employee pojo = new Employee();
	    pojo.setId(2);
	    pojo.setName("lllll");
 
	    /** save session */
	    sess.save(pojo);
	    /** commit le changement  */
	    tx.commit();
 
	    System.out.println("enregistrer dans la base");
	    session.close();
 
 
	}
}

**ilamine55** · 06/05/2010, 15h50

vous trouverez ci-joint les jar utiliser .
merci d'avance pour votre réponse.

**fr1man** · 06/05/2010, 15h59

Sans doute une mauvaise version de ta lib slf4j.

**ilamine55** · 06/05/2010, 16h04

tu ne sais pas quel version que je doit utiliser ?

**aitnasser** · 07/05/2010, 00h50

veillez utiliser "slf4j-api-1.5.8.jar" et "slf4j-jdk14-1.5.8.jar" et ça va marché incha allah

**ilamine55** · 07/05/2010, 17h09

merci pour ta réponse ça effectivement marcher.
maintenant j ai une exception dans le dialecte

Initial SessionFactory failed.org.hibernate.HibernateException: Could not instantiate dialect class
Exception in thread "main" java.lang.ExceptionInInitializerError
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:14)
at net.roseindia.Exemple1.main(Exemple1.java:14)
Caused by: org.hibernate.HibernateException: Could not instantiate dialect class
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:107)
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:65)
at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:460)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:155)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:10)
... 1 more
Caused by: java.lang.ClassCastException: net.sf.hibernate.dialect.MySQLDialect cannot be cast to org.hibernate.dialect.Dialect
at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:101)
... 7 more

**fr1man** · 07/05/2010, 17h18

Tu utilises Hibernate 2 ou 3 ?
Si tu es en 3, les packages commencent par org.hibernate et non pas net.sf.hibernate.

De plus, si ta version de MySql est >=5, tu dois utiliser un autre dialect, MySQLInnoDBDialect ou MySQLMyISAMDialect, selon ton moteur.

**ilamine55** · 07/05/2010, 17h56

t avais raison a propos des packages , mais il ne comprend pas MySQLMyISAMDialect . voici mon fichier hibernate.cfg.xml

Code xml :

Sélectionner tout - Visualiser dans une fenêtre à part

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
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Database connection settings -->
<property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernateannotation</property>
<property name="connection.username">root</property>
<property name="connection.password"></property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>
<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">none</property>
 
<mapping class="net.roseindia.Employee"/>
 
</session-factory>
</hibernate-configuration>

**fr1man** · 07/05/2010, 18h00

Utilises-tu bien le moteur MyISAM ?

Quel est le message d'erreur ?

**ilamine55** · 07/05/2010, 18h00

voici l'exécution

17:59:02,601 INFO Version:15 - Hibernate Annotations 3.2.0.GA
7 mai 2010 17:59:02 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.3.1.GA
7 mai 2010 17:59:02 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
7 mai 2010 17:59:02 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
7 mai 2010 17:59:02 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
7 mai 2010 17:59:03 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
7 mai 2010 17:59:03 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
7 mai 2010 17:59:03 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
17:59:04,013 INFO AnnotationBinder:387 - Binding entity from annotated class: net.roseindia.Employee
17:59:04,120 INFO EntityBinder:340 - Bind entity net.roseindia.Employee on table Employee
7 mai 2010 17:59:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
7 mai 2010 17:59:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 1
7 mai 2010 17:59:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
7 mai 2010 17:59:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql://localhost:3306/hibernateannotation
7 mai 2010 17:59:04 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.1.33-community-log
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
7 mai 2010 17:59:05 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
7 mai 2010 17:59:05 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Using default transaction strategy (direct JDBC transactions)
7 mai 2010 17:59:05 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
7 mai 2010 17:59:05 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
7 mai 2010 17:59:05 org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge <init>
INFO: Cache provider: org.hibernate.cache.NoCacheProvider
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
7 mai 2010 17:59:05 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
Initial SessionFactory failed.java.lang.NoClassDefFoundError: org/apache/commons/collections/map/LRUMap
Exception in thread "main" java.lang.ExceptionInInitializerError
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:14)
at net.roseindia.Exemple1.main(Exemple1.java:14)
Caused by: java.lang.NoClassDefFoundError: org/apache/commons/collections/map/LRUMap
at org.hibernate.util.SimpleMRUCache.init(SimpleMRUCache.java:71)
at org.hibernate.util.SimpleMRUCache.<init>(SimpleMRUCache.java:55)
at org.hibernate.util.SimpleMRUCache.<init>(SimpleMRUCache.java:50)
at org.hibernate.engine.query.QueryPlanCache.<init>(QueryPlanCache.java:65)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:176)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
at net.roseindia.HibernateUtil.<clinit>(HibernateUtil.java:10)
... 1 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections.map.LRUMap
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
... 8 more