[mapping] problème de configuration

Version imprimable

Bonjour tout le monde,
j'ai suivi le tuto de developpez pour hibernate histoire de me faire la main, et ça fonctionne très bien. Alors, hop, tout fringant, je cherche à adapter ça à mon projet :)
Mais voilà, j'obtiens (et n'arrive pas à dépasser, d'où ce post) toujours cette exception, après test d'insertion d'un objet Procedure dans la BD:

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
Initial SessionFactory creation failed. org.hibernate.MappingException: invalid configuration
Exception in thread "AWT-EventQueue-0" java.lang.ExceptionInInitializerError
	at hibernate.HibernateUtil.<clinit>(HibernateUtil.java:23)
	at parser.SaveToBD.savetoBD(SaveToBD.java:112)
	at fenetre.FileMenu.actionPerformed(FileMenu.java:199)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.AbstractButton.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.hibernate.MappingException: invalid configuration
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1487)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1428)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1414)
	at hibernate.HibernateUtil.<clinit>(HibernateUtil.java:19)
	... 29 more
Caused by: org.xml.sax.SAXParseException: The content of element type "session-factory" is incomplete, it must match "(property*,mapping+,(class-cache|collection-cache|jcs-class-cache|jcs-collection-cache)*)".
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
	at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.endElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
	at org.dom4j.io.SAXReader.read(SAXReader.java:465)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1484)

Du coup je me dis que ça vient de mon fichier de mapping que voici:

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
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
 
<hibernate-mapping >
	<class name="hibernate.Procedure" table="procedure">
 
		<id 
			name="IdProc" type="integer">
			<column name="idProc" not-null="true"/>
 			<generator class="increment"/>
 		</id>
 
 		<property
			column="nameProc"
			length="80"
			name="NameProc"
			not-null="true"
			type="String"
		 />
 
		<property
			name="LastModification"
			column="lastModification"
			not-null="true"
			type="timestamp"
		 />
 
		<property
			name="IdMission"
			column="idMission"
			not-null="true"
			type="integer"
		 />	
 
		<property
			name="File"
			column="file"
			type="binary"
		 />
 
	</class>
</hibernate-mapping>

Est-ce qu'il faut que je précise dans le fichier de configuration d'hibernate où se trouve le fichier de mapping (avec une balise resource)?
J'avoue rester perplexe... Je vous mets le fichier de config.xml au cas où:

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
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration
    PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
 
<hibernate-configuration>
	<session-factory>
		<!-- local connection properties -->
		<property name="hibernate.connection.url">
			jdbc:mysql://127.0.0.1:3306/base
		</property>
		<property name="hibernate.connection.driver_class">
			com.mysql.jdbc.Driver
		</property>
		<property name="hibernate.connection.username">user</property>
		<property name="hibernate.connection.password">user</property>
		<!-- property name="hibernate.connection.pool_size"></property -->
 
		<!-- dialect for MySQL -->
		<property name="dialect">
			org.hibernate.dialect.MySQLDialect
		</property>
 
		<property name="hibernate.show_sql">true</property>
		<property name="hibernate.use_outer_join">true</property>
		<!-- <property name="hibernate.transaction.factory_class">
			net.sf.hibernate.transaction.JTATransactionFactory
			</property>
			<property name="jta.UserTransaction">
			java:comp/UserTransaction
			</property>-->
		<property name="hibernate.transaction.factory_class">
			org.hibernate.transaction.JDBCTransactionFactory
		</property>
	</session-factory>
</hibernate-configuration>

N'hésitez pas à me demander plus de précisions si vous le souhaitez.
Merci de votre aide.

17/09/2007, 11h34
fr1man
Tu dois définir dans ton fichier de conf: hibernate.cfg.xlm, les classes que tu as mappées avec la balise mapping:
Code:

1 2 <mapping resource="tonPackage/TaClasse.hbm.xml"

merci beaucoup! ça marche :).
Enfin presque...
J'obtiens une nouvelle erreur (mais ça avance) :

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
Hibernate: select max(idProc) from procedure
Exception in thread "AWT-EventQueue-0" org.hibernate.exception.SQLGrammarException: could not fetch initial value for increment generator
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.id.IncrementGenerator.getNext(IncrementGenerator.java:107)
	at org.hibernate.id.IncrementGenerator.generate(IncrementGenerator.java:44)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
	at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
	at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
	at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)
	at parser.SaveToBD.savetoBD(SaveToBD.java:114)
	at fenetre.FileMenu.actionPerformed(FileMenu.java:199)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.AbstractButton.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)

Or, d'après le tutoriel, il suffit de déclarer dans le fichier de mapping que idProc est un identifiant (avec la balise <id>) pour qu'hibernate s'en occupe... Il me manque quelque chose :? Je précise qu'il n'y a encore rien dans la table procédure (j'essaie simplement d'insérer via hibernate pour l'instant), donc je veux bien comprendre qu'il ne ressort rien de la commande:

Code:

select max(idProc) from procedure

Mais je ne comprends pas pourquoi il la lance. Merci par avance de votre aide.

17/09/2007, 13h54
Ginseng

Apparemment, le problème vient de la requête en elle-même, qui devrait être:

Code:

select max(idProc) from 'procedure'

et non:

Code:

select max(idProc) from procedure

Une idée en ce qui concerne ces quotes non présents dans la reqête formée par hibernate?
Je continue de chercher.
17/09/2007, 15h27
Ginseng

Hop, après avoir rajouté des backsticks (et non des quotes!) autour du nom de la table dans le fichier de mapping, la reqûete d'insertion s'effectue sans problème.
Par contre je ne m'explique pas pourquoi ces backsticks ne sont pas nécessaires dans le tuto de developpez (je suis sous phpMyAdmin) alors qu'avec mes tables ils le sont 8O

Enfin, ça marche, c'est l'essentiel (mais j'aime pas trop ne pas avoir compris).
Bye.
17/09/2007, 16h10
fr1man

Peut-être que procedure est un mot clef de mysql.
Essaie en changeant le nom de la table.
17/09/2007, 17h12
Ginseng

En effet c'est un mot réservé. En changeant de nom de table, il n'y plus aucun problème!:yaisse2:
Merci fr1man.

[Demande d'aide][hibernate]

Salut tout le monde, je suis une débutante de l'utilisation d'hibernate j'ai essayée de faire un petit exemple mais j'ai cette exception:

Initial SessionFactory creation failed.org.hibernate.MappingException: invalid configuration
Exception in thread "main" java.lang.ExceptionInInitializerError
at com.mql.util.HibernateUtil.<clinit>(HibernateUtil.java:18)
at com.mql.test.TesTHibernate.main(TesTHibernate.java:11)
Caused by: org.hibernate.MappingException: invalid configuration
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1347)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1322)
at com.mql.util.HibernateUtil.<clinit>(HibernateUtil.java:13)
... 1 more
Caused by: org.xml.sax.SAXParseException: Document is invalid: no grammar found.
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl$NSContentDriver.scanRootElementHook(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.dom4j.io.SAXReader.read(SAXReader.java:465)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1344)

voilà mes fihciers:

j'ai une classe java bean User
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 package com.mql.vo; /** * @author KhadijaRSS * */ public class User { private int idUser; private String login; private String pass; public User() { } public String getLogin() { return login; } public void setLogin(String login) { this.login = login; } public String getPass() { return pass; } public void setPass(String pass) { this.pass = pass; } public void setIdUser(int idUser) { this.idUser = idUser; } public int getIdUser() { return idUser; } }
et le fciher de mapping associé:
Code:

1 2 3 4 5 6 7 8 9 10 <hibernate-mapping package="com.mql.vo"> <class name="User" table="Compte"> <id name="idUser" column="idCompte"> <generator class="native"/> </id> <property name="login" column="login"/> <property name="pass" column="password"/> </class> </hibernate-mapping>
une classe de creation d'une session hibernate:
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 package com.mql.util; import java.io.File; 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 File f=new File("D:/JAVA/workspace/Test1Hibernate/WebContent/WEB-INF/classes/com/mql/util/hibernate.cfg.xml"); sessionFactory = new Configuration().configure(f).buildSessionFactory(); sessionFactory.openSession(); } 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; } }
le fcihier de configuration
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 <hibernate-configuration> <session-factory>  <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url"> jdbc:mysql://localhost:3307/mql</property> <property name="connection.username">root</property> <property name="connection.password">arhid28</property>  <property name="connection.pool_size">1</property>  <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <mapping resource="com/mql/vo/User.hbm.xml"/>  <property name="current_session_context_class">thread</property>  <property name="cache.provider_class"> org.hibernate.cache.NoCacheProvider</property>  <property name="show_sql">true</property>  <property name="hbm2ddl.auto">create</property> </session-factory> </hibernate-configuration>
et finalement ma classe de test:
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.mql.test; import org.hibernate.Session; import com.mql.util.HibernateUtil; import com.mql.vo.User; public class TesTHibernate { public static void main(String[] args) { Session session = HibernateUtil.getSessionFactory().getCurrentSession(); session.beginTransaction(); User user = new User(); user.setIdUser(1); user.setLogin("khadija"); user.setPass("khadija"); session.save(user); session.getTransaction().commit(); HibernateUtil.getSessionFactory().close(); } }
Merci d'avance :)