Problème avec hibernate

Version imprimable

Bonjour, je développe une petite appli où j'utilise Hibernate pour le mapping ORM. J'ai une erreur donc j'arrive pas à trouver la source.
voici les erreurs que j'ai dans la console:

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
 
mars 24, 2016 11:04:27 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
mars 24, 2016 11:04:27 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.2.21.Final}
mars 24, 2016 11:04:27 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
mars 24, 2016 11:04:27 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
mars 24, 2016 11:04:27 PM org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: /hibernate.cfg.xml
mars 24, 2016 11:04:27 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: /hibernate.cfg.xml
mars 24, 2016 11:04:27 PM org.hibernate.internal.util.xml.DTDEntityResolver resolveEntity
WARN: HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
mars 24, 2016 11:04:28 PM org.hibernate.cfg.Configuration doConfigure
INFO: HHH000041: Configured SessionFactory: null
mars 24, 2016 11:04:28 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
mars 24, 2016 11:04:28 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
mars 24, 2016 11:04:28 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
mars 24, 2016 11:04:28 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/catalogue]
mars 24, 2016 11:04:28 PM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=root, hbm2ddl.auto=create, password=****}
mars 24, 2016 11:04:28 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
mars 24, 2016 11:04:28 PM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
mars 24, 2016 11:04:28 PM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)
mars 24, 2016 11:04:29 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1146, SQLState: 42S02
mars 24, 2016 11:04:29 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Table 'catalogue.PRODUITS' doesn't exist
org.hibernate.exception.SQLGrammarException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2987)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3499)
	at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)
	at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)
	at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:229)
	at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:209)
	at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:193)
	at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)
	at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)
	at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)
	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:206)
	at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:191)
	at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90)
	at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:683)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:675)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:671)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352)
	at com.sun.proxy.$Proxy7.save(Unknown Source)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:17)
	at org.metier.TestMetier.main(TestMetier.java:8)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'catalogue.PRODUITS' doesn't exist
	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.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5094)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186)
	... 29 more
Exception in thread "main" org.hibernate.SessionException: Session is closed!
	at org.hibernate.internal.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:130)
	at org.hibernate.internal.SessionImpl.getTransaction(SessionImpl.java:1380)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:352)
	at com.sun.proxy.$Proxy7.getTransaction(Unknown Source)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:22)
	at org.metier.TestMetier.main(TestMetier.java:8)

mon fichier hibernate.cfg.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
<?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>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/catalogue</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password"></property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.show_sql">true</property>
        <property name="hibernate.connection.hbm2ddl.auto">create</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.current_session_context_class">thread</property>
        <mapping class="org.metier.Produit"/>
    </session-factory>
</hibernate-configuration>

Ma classe comprenant les méthodes hibernate-jpa

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
 
package org.metier;
 
import java.util.List;
 
import org.hibernate.Query;
import org.hibernate.Session;
 
import util.HibernateUtil;
 
public class CatalogueMetierImpl implements ICatalogueMetier {
 
    @Override
    public void addProduit( Produit p ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        try {
            session.save( p );
        } catch ( Exception e ) {
            session.getTransaction().rollback();
            e.printStackTrace();
        }
        session.getTransaction().commit();
    }
 
    @Override
    public List<Produit> listProduit() {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Query req = session.createSQLQuery( "select p from Produit p" );
        List<Produit> prods = req.list();
        session.getTransaction().commit();
        return prods;
    }
 
    @Override
    public Produit getProduit( Long idProd ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Object p = session.get( Produit.class, idProd );
        if ( p == null )
            throw new RuntimeException( "Produit introuvable" );
        session.getTransaction().commit();
        return (Produit) p;
    }
 
    @Override
    public List<Produit> getProduitParMc( String mc ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Query req = session.createSQLQuery( "select p from Produit p where p.designation like :x" );
        req.setParameter( "x", "%" + mc + "%" );
        List<Produit> prods = req.list();
        session.getTransaction().commit();
        return prods;
    }
 
    @Override
    public void deleteProduit( Long idProd ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Object p = session.get( Produit.class, idProd );
        if ( p == null )
            throw new RuntimeException( "Produit introuvable" );
        session.delete( p );
        session.getTransaction().commit();
    }
 
    @Override
    public void updateProduit( Produit p ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        session.update( p );
        session.getTransaction().commit();
 
    }
 
}

Merci de votre aide

25/03/2016, 14h09
freddou17

Slt,
Pouvons nous voir le mapping de tes tables?

++

oui bien sûr,

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
 
package org.metier;
 
import java.io.Serializable;
 
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
 
@Entity
@Table( name = "PRODUITS" )
public class Produit implements Serializable {
 
    @Id
    @GeneratedValue( strategy = GenerationType.IDENTITY )
    @Column( name = "ID_PRODUIT" )
    private Long   idProduit;
    @Column( name = "DESIGNATION" )
    private String designation;
    private double prix;
    private int    quantite;
 
    public Produit() {
        super();
        // TODO Auto-generated constructor stub
    }
 
    public Produit( String designation, double prix, int quantite ) {
        super();
        this.designation = designation;
        this.prix = prix;
        this.quantite = quantite;
    }

30/03/2016, 09h39
freddou17

Slt,

Il y a cette erreur 'Table 'catalogue.PRODUITS' doesn't exist', es tu sur qu'il n'y a pas d'erreur dans le nom?
Tu es dans un package de test ?

Autre point vu que tu es sur mysql, je pense que ta propriété :

Code:

<property name="hibernate.connection.hbm2ddl.auto">create</property>

devrait être:

Code:

<property name="hibernate.connection.hbm2ddl.auto">update</property>

++

J'avais déjà corrigé le nom de la table.
La valeur "create" pour cette propriété permet degénérer les tables tandis que "update" permet de les mettre à jour lorsqu'elles existent déjà donc je pense pas que ce soit la source du problème.

Code:

1
2
 
 <property name="hibernate.connection.hbm2ddl.auto">create</property>

Je ne suis pas dans le package de test.
L'erreur après connexion du nom de la table est donc la suivante:

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
38
39
40
41
 
mars 30, 2016 10:14:15 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.1.0.Final}
mars 30, 2016 10:14:15 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
mars 30, 2016 10:14:15 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
mars 30, 2016 10:14:15 AM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
mars 30, 2016 10:14:15 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
mars 30, 2016 10:14:16 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
mars 30, 2016 10:14:16 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/catalogue]
mars 30, 2016 10:14:16 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=fnjiokou, hbm2ddl.auto=create, password=****}
mars 30, 2016 10:14:16 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
mars 30, 2016 10:14:16 AM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
mars 30, 2016 10:14:16 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
Initial SessionFactory creation failed.java.lang.NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;
Exception in thread "main" java.lang.ExceptionInInitializerError
	at util.HibernateUtil.<clinit>(HibernateUtil.java:16)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:14)
	at org.metier.TestMetier.main(TestMetier.java:8)
Caused by: java.lang.NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;
	at org.hibernate.cfg.annotations.EntityBinder.processComplementaryTableDefinitions(EntityBinder.java:1087)
	at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:767)
	at org.hibernate.boot.model.source.internal.annotations.AnnotationMetadataSourceProcessorImpl.processEntityHierarchies(AnnotationMetadataSourceProcessorImpl.java:245)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess$1.processEntityHierarchies(MetadataBuildingProcess.java:222)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:265)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:692)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:12)
	... 2 more

30/03/2016, 11h08
jeffray03

salut,
tu sembles avoir 2 versions differentes d´hibernate-jpa-api dans ta classpath.
regardes voir et donnes nous la liste des Jars qui sont dans ta classpath.

Eric
30/03/2016, 12h06
batanga09

1 pièce(s) jointe(s)

J'ai eu à rajouter 1 ou 2 jar pour essayer de résoudre le problème effectivement.
Pièce jointe 205377
30/03/2016, 12h39
jeffray03

salut,
enleves

Code:

hibernate-entitymanager-5.1.0XXX

Eric
30/03/2016, 13h03
batanga09

Je l'ai enlevé mais l'erreur persiste. j'ai exactement le même message.
30/03/2016, 13h55
jeffray03

salut,
il faut faire un nettoyage de ton projet, mettre a la place de gerimo-jta, simplement

Code:

jta-1.1.jar

et reessayer.

Eric
30/03/2016, 14h19
batanga09

qu'entends tu par nettoyer mon projet? c'est un projet web dynamique!
30/03/2016, 14h23
jeffray03

project --> clean
30/03/2016, 14h36
batanga09

Malheureusement, toujours pas de changement.
30/03/2016, 14h42
jeffray03

essaies de les enlever une par une et voir si cela change quelque chose.
eric
30/03/2016, 15h14
batanga09
Il ne se passe pas grand chose, des erreurs changent selon je jar que je retire.
Personnellement j'ai comme l'impression que c'es cette ligne le problème
Code:

1 2 INFO: HHH000206: hibernate.properties not found
En cherchant sur internet, il paraît que ça pourrait venir de ma classe: "HibernateUtil.java".
30/03/2016, 15h39
freddou17

tu as besoin de hibernate tools?

dans les required d'hibernate 5.1.0 on a :
- antlr-2.7.7.jar
- jboss-logging-3.3.0.Final.jar
-hibernate-jpa-2.1-api-1.0.0.Final.jar
-javassist-3.20.0-GA.jar
-geronimo-jta_1.1_spec-1.1.1.jar
-jandex-2.0.0.Final.jar
-classmate-1.3.0.jar
-dom4j-1.6.1.jar
-hibernate-commons-annotations-5.0.1.Final.jar
-hibernate-core-5.1.0.Final.jar

Peux tu nous montrer ton HibernateUtils stp?
++

Je n'ai plus d'hibernate tools. j'ai exactement les jar required et mysql-connector!
Mon HibernateUtil:

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
 
package util;
 
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
 
public class HibernateUtil {
    public static final SessionFactory sessionFactory;
 
    static {
        try {
            // Création de la SessionFactory à partir de hibernate.cfg.xml
            sessionFactory = new Configuration().configure().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 SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

En plus dans mes logs j'ai ces deux lignes aussi

Code:

1
2
3
 
Initial SessionFactory creation failed.java.lang.NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;
Exception in thread "main" java.lang.ExceptionInInitializerError

30/03/2016, 16h27
tchize_
Code:

1 2 <property name="hibernate.connection.hbm2ddl.auto">create</property>
La propriété correcte c'est hibernate.hbm2ddl.auto pas hibernate.~~connection~~.hbm2ddl.auto. Comme on le vois dans tes logs, hibernate ne crée pas les tables.
30/03/2016, 16h35
batanga09

Même problème. :(

salut,
peux tu essayer de construire ta sessionFactory comme l'exemple ci-dessous:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
private static SessionFactory sessionFactory;
 
    public static SessionFactory getSessionFactory() {
        if (sessionFactory == null) {
            // loads configuration and mappings
            Configuration configuration = new Configuration().configure();
            ServiceRegistry serviceRegistry
                = new StandardServiceRegistryBuilder()
                    .applySettings(configuration.getProperties()).build();
 
            // builds a session factory from the service registry
            sessionFactory = configuration.buildSessionFactory(serviceRegistry);           
        }
 
        return sessionFactory;

Avec cette sessionFactory j'ai

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
mars 31, 2016 2:07:05 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.1.0.Final}
mars 31, 2016 2:07:05 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
mars 31, 2016 2:07:05 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
mars 31, 2016 2:07:05 PM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
mars 31, 2016 2:07:05 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
mars 31, 2016 2:07:05 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
mars 31, 2016 2:07:05 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/ma_bdd]
mars 31, 2016 2:07:05 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=fnjiokou, password=****}
mars 31, 2016 2:07:05 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
mars 31, 2016 2:07:05 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
mars 31, 2016 2:07:06 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
mars 31, 2016 2:07:06 PM org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@7fecbee0'
org.hibernate.MappingException: Unknown entity: org.metier.Produit
	at org.hibernate.internal.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:776)
	at org.hibernate.internal.SessionImpl.getEntityPersister(SessionImpl.java:1533)
	at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:104)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
	at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
	at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
	at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
	at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)
	at org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:338)
	at com.sun.proxy.$Proxy17.save(Unknown Source)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:17)
	at org.metier.TestMetier.main(TestMetier.java:8)
Exception in thread "main" org.hibernate.SessionException: Session is closed!
	at org.hibernate.internal.AbstractSessionImpl.errorIfClosed(AbstractSessionImpl.java:132)
	at org.hibernate.internal.AbstractSessionImpl.getTransaction(AbstractSessionImpl.java:311)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:338)
	at com.sun.proxy.$Proxy17.getTransaction(Unknown Source)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:22)
	at org.metier.TestMetier.main(TestMetier.java:8)

salut,
remplacesceci :

Code:

1
2
// loads configuration and mappings
            Configuration configuration = new Configuration().configure();

avec

Code:

1
2
 
  Configuration configuration = new Configuration().addAnnotatedClass(Produit.class).configure();

Eric

A ce moment la retrouve la, je même erreur que j'avais avant le remplacement de la sessionFactory :(

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
 
mars 31, 2016 4:48:17 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.1.0.Final}
mars 31, 2016 4:48:18 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
mars 31, 2016 4:48:18 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
mars 31, 2016 4:48:18 PM org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-configuration. Use namespace http://www.hibernate.org/dtd/hibernate-configuration instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
mars 31, 2016 4:48:18 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
mars 31, 2016 4:48:18 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
mars 31, 2016 4:48:18 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/ma_bdd]
mars 31, 2016 4:48:18 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {user=fnjiokou, password=****}
mars 31, 2016 4:48:18 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
mars 31, 2016 4:48:18 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
mars 31, 2016 4:48:18 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
Exception in thread "main" java.lang.NoSuchMethodError: javax.persistence.Table.indexes()[Ljavax/persistence/Index;
	at org.hibernate.cfg.annotations.EntityBinder.processComplementaryTableDefinitions(EntityBinder.java:1087)
	at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:767)
	at org.hibernate.boot.model.source.internal.annotations.AnnotationMetadataSourceProcessorImpl.processEntityHierarchies(AnnotationMetadataSourceProcessorImpl.java:245)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess$1.processEntityHierarchies(MetadataBuildingProcess.java:222)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:265)
	at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
	at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:692)
	at util.HibernateUtil.getSessionFactory(HibernateUtil.java:20)
	at org.metier.CatalogueMetierImpl.addProduit(CatalogueMetierImpl.java:14)
	at org.metier.TestMetier.main(TestMetier.java:8)

01/04/2016, 08h09
jeffray03

1 pièce(s) jointe(s)

Pièce jointe 205556
ce sont les fichiers donc tu en a besoin pour le faire. cela marche bien chez moi.

Eric
01/04/2016, 14h26
batanga09

Bonjour,

Je ne comprends pas mais j'ai toujours la même erreur pourtant j'utilise exactement les mêmes jar!!
02/04/2016, 00h17
jeffray03

crees un nouveau projet.

J'ai pu corriger ce fameux problème.:)
par contre j'ai un dernier petit problème, j'essaye de rentrer deux champs dans la table, mais il rentre la première, puis l'écrase avant de rentrer la seconde comme le montre ces logs.

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
avr. 06, 2016 12:14:15 AM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
avr. 06, 2016 12:14:15 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.2.21.Final}
avr. 06, 2016 12:14:15 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
avr. 06, 2016 12:14:15 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
avr. 06, 2016 12:14:15 AM org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: /hibernate.cfg.xml
avr. 06, 2016 12:14:15 AM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: /hibernate.cfg.xml
avr. 06, 2016 12:14:15 AM org.hibernate.internal.util.xml.DTDEntityResolver resolveEntity
WARN: HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
avr. 06, 2016 12:14:15 AM org.hibernate.cfg.Configuration doConfigure
INFO: HHH000041: Configured SessionFactory: null
avr. 06, 2016 12:14:16 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
avr. 06, 2016 12:14:16 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
avr. 06, 2016 12:14:16 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
avr. 06, 2016 12:14:16 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/catalogue]
avr. 06, 2016 12:14:16 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=root, password=****}
avr. 06, 2016 12:14:17 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
avr. 06, 2016 12:14:18 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
avr. 06, 2016 12:14:18 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
avr. 06, 2016 12:14:18 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000227: Running hbm2ddl schema export
Hibernate: drop table if exists PRODUITS
Hibernate: create table PRODUITS (ID_PRODUIT bigint not null auto_increment, DESIGNATION varchar(255), prix double precision not null, quantite integer not null, primary key (ID_PRODUIT))
avr. 06, 2016 12:14:18 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)
avr. 06, 2016 12:14:19 AM org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: /hibernate.cfg.xml
avr. 06, 2016 12:14:19 AM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: /hibernate.cfg.xml
avr. 06, 2016 12:14:19 AM org.hibernate.internal.util.xml.DTDEntityResolver resolveEntity
WARN: HHH000223: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/. Use namespace http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration Guide!
avr. 06, 2016 12:14:19 AM org.hibernate.cfg.Configuration doConfigure
INFO: HHH000041: Configured SessionFactory: null
avr. 06, 2016 12:14:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH000402: Using Hibernate built-in connection pool (not for production use!)
avr. 06, 2016 12:14:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
avr. 06, 2016 12:14:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
avr. 06, 2016 12:14:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost:3306/catalogue]
avr. 06, 2016 12:14:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=root, password=****}
avr. 06, 2016 12:14:19 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
avr. 06, 2016 12:14:19 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
avr. 06, 2016 12:14:19 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
avr. 06, 2016 12:14:19 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000227: Running hbm2ddl schema export
Hibernate: drop table if exists PRODUITS
Hibernate: create table PRODUITS (ID_PRODUIT bigint not null auto_increment, DESIGNATION varchar(255), prix double precision not null, quantite integer not null, primary key (ID_PRODUIT))
avr. 06, 2016 12:14:19 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)

06/04/2016, 08h25
tchize_

Tu devrais éviter de créer les tables à chaque session factory, à moins que tu ne compte pas conserver tes données plus de quelques heures
Tu devrais surtout éviter de créer une nouvelle sessionFactory à chaque fois. On vois bien dans tes logs que tu as créé deux session factory.

salut,
quelle est la valeur de ta propriété:

Code:

hbm2ddl.auto

car il fait ceci chaque fois:

Code:

1
2
3
4
5
6
 
INFO: HHH000227: Running hbm2ddl schema export
Hibernate: drop table if exists PRODUITS
Hibernate: create table PRODUITS (ID_PRODUIT bigint not null auto_increment, DESIGNATION varchar(255), prix double precision not null, quantite integer not null, primary key (ID_PRODUIT))
avr. 06, 2016 12:14:18 AM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete

il devrais etre a update et non create.
Eric

Rebonjour,
J'ai de nouveau un petit problème (ou gros même d'ailleurs), lorsque je fais des requêtes vers ma base de donné. toutes les requêtes utilisant la méthode "createSQLQuery" ne marche pas, tandis que les autres méthodes marchent bien.
Par exemple ces deux appels

Code:

1
2
3
4
5
6
7
8
9
10
 
List<Produit> prods = metier.getProduitParMc( "PS" );
        for ( Produit p1 : prods ) {
            System.out.println( p1.getDesignation() );
        }
 
        List<Produit> pr = metier.listProduit();
        for ( Produit p2 : pr ) {
            System.out.println( p2.getDesignation() );
        }

dont voici le code

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
 @Override
    public List<Produit> listProduit() {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Query req = session.createSQLQuery( "select p from Produit p " );
        List<Produit> prods = req.list();
        session.getTransaction().commit();
 
        return prods;
    }
 
@Override
    public List<Produit> getProduitParMc( String mc ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Query req = session.createSQLQuery( "select p from Produit p where p.designation like :x" );
        req.setParameter( "x", "%" + mc + "%" );
        List<Produit> prods = req.list();
        session.getTransaction().commit();
        return prods;
    }

me donnent les erreurs suivantes

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
38
39
40
41
42
43
44
 
Hibernate: select p from Produit p where p.designation like ?
avr. 10, 2016 2:44:18 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1146, SQLState: 42S02
avr. 10, 2016 2:44:18 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Table 'catalogue.Produit' doesn't exist
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not extract ResultSet
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
	at org.hibernate.loader.Loader.doQuery(Loader.java:906)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
	at org.hibernate.loader.Loader.doList(Loader.java:2550)
	at org.hibernate.loader.Loader.doList(Loader.java:2536)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
	at org.hibernate.loader.Loader.list(Loader.java:2361)
	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:340)
	at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:1788)
	at org.hibernate.internal.AbstractSessionImpl.list(AbstractSessionImpl.java:232)
	at org.hibernate.internal.SQLQueryImpl.list(SQLQueryImpl.java:157)
	at org.metier.CatalogueMetierImpl.getProduitParMc(CatalogueMetierImpl.java:54)
	at org.metier.TestMetier.main(TestMetier.java:20)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'catalogue.Produit' doesn't exist
	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.Util.getInstance(Util.java:387)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
	... 15 more

Pourtant cette requête marche bien

Code:

1
2
3
4
5
6
7
8
9
10
 
metier.addProduit( new Produit( "HP1234", 456.89, 4 ) );
        metier.addProduit( new Produit( "SAM78HV", 7896.00, 2 ) );
        metier.addProduit( new Produit( "PS4H12", 1200.00, 6 ) );
 
        Produit p = metier.getProduit( 1L );
        System.out.println( p.getDesignation() );
        System.out.println( p.getPrix() );
        p.setPrix( 111.11 );
        metier.updateProduit( p );

code:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
@Override
public List<Produit> listProduit() {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Query req = session.createSQLQuery( "select p from Produit p " );
        List<Produit> prods = req.list();
        session.getTransaction().commit();
 
        return prods;
 
    }
 
    @Override
    public void deleteProduit( Long idProd ) {
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        Object p = session.get( Produit.class, idProd );
        if ( p == null )
            throw new RuntimeException( "Produit introuvable" );
        session.delete( p );
        session.getTransaction().commit();
    }

log

Code:

1
2
3
4
5
6
7
8
9
10
11
12
 
Hibernate: drop table if exists PRODUITS
Hibernate: create table PRODUITS (ID_PRODUIT bigint not null auto_increment, DESIGNATION varchar(255), prix double precision not null, quantite integer not null, primary key (ID_PRODUIT))
avr. 10, 2016 2:44:17 PM org.hibernate.tool.hbm2ddl.SchemaExport execute
INFO: HHH000230: Schema export complete
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)
Hibernate: insert into PRODUITS (DESIGNATION, prix, quantite) values (?, ?, ?)
Hibernate: select produit0_.ID_PRODUIT as ID_PRODU1_0_0_, produit0_.DESIGNATION as DESIGNAT2_0_0_, produit0_.prix as prix3_0_0_, produit0_.quantite as quantite4_0_0_ from PRODUITS produit0_ where produit0_.ID_PRODUIT=?
HP1234
456.89
Hibernate: update PRODUITS set DESIGNATION=?, prix=?, quantite=? where ID_PRODUIT=?

10/04/2016, 14h58
tchize_

createSQLQuery, comme son nom l'indique, attends une requête SQL, pas une requête HQL. Donc des tables, pas des classes. Par défaut ça te retournera juste une List<Object[]> pas une List<Produit>.

Pour une requête HQL comme tu le fais c'est createQuery.
10/04/2016, 15h02
batanga09

Quelle erreur!8-) merci