bonjour,

j'ai créer 2 fichiers jpa avec une relation one to many .

je n'arrive pas à sauvegarder sans qu'il y ait une violation de contrainte

code erreur :

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
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
 
alter table JPAMODULE1 drop constraint FKC6BE7B2A9B6E2BCA
alter table JPAMODULE1 drop constraint FKC6BE7B2A6F18654C
alter table JPAMODULE2 drop constraint FKC6BE7B2B6F18654E
alter table JPAMODULE2 drop constraint FKC6BE7B2B9B6E2BCB
drop table JPAMAIN1
drop table JPAMAIN2
drop table JPAMODULE1
drop table JPAMODULE2
create table JPAMAIN1 (ID bigint not null, NAME varchar(255), primary key (ID))
create table JPAMAIN2 (ID bigint not null, NAME varchar(255), primary key (ID))
create table JPAMODULE1 (ID bigint not null, OPTION_STRING varchar(255), ALTITUDE_DU_SITE_STRING varchar(255), PRESSION_TOTAL_STRING varchar(255), PRESSION_VAPEUR_SATUREE_STRING varchar(255), PRESSION_PARTIELLE_AIR_STRING varchar(255), PRESSION_PARTIELLE_VAPEUR_EAU_STRING varchar(255), TEMPERATURE_SECHE_STRING varchar(255), TEMPERATURE_HUMIDE_STRING varchar(255), TEMPERATURE_ROSEE_STRING varchar(255), HUMIDITE_RELATIVE_STRING varchar(255), HUMIDITE_ABSOLUE_STRING varchar(255), HUMIDITE_ABSOLUE_SATURATION_STRING varchar(255), DEGRES_DE_SATURATION_STRING varchar(255), MASSE_VOLLEUMIQUE_STRING varchar(255), VOLUME_SPECIFIQUE_STRING varchar(255), ENTALPIE_SPECIFIQUE_STRING varchar(255), JPAMAIN1 bigint, POINT varchar(255), idx integer, primary key (ID))
create table JPAMODULE2 (ID bigint not null, JPAMAIN2 bigint, TEMPERATURE_SECHE varchar(255), HUMIDITE_RELATIVE varchar(255), HUMIDITE_ABSOLUE varchar(255), ENTHALPIE varchar(255), MASSE_VOLUMIQUE varchar(255), VOLUME_SPECIFIQUE varchar(255), DEBIT_MASSE varchar(255), DEBIT_VOLUME varchar(255), TEMPERATURE_SECHE_SORTIE varchar(255), HUMIDITE_RELATIVE_SORTIE varchar(255), HUMIDITE_ABSOLUE_SORTIE varchar(255), ENTHALPIE_SORTIE varchar(255), MASSE_VOLUMIQUE_SORTIE varchar(255), VOLUME_SPECIFIQUE_SORTIE varchar(255), DEBIT_MASSE_SORTIE varchar(255), DEBIT_VOLUME_SORTIE varchar(255), PUISSANCE_TOTALE varchar(255), PUISSACE_SENSIBLE varchar(255), PUISSANCE_LATENTE varchar(255), DEBIT_CONDENSAT varchar(255), EFFICACITE_BATTERIE varchar(255), SAISIEDEBIT varchar(255), SAISIEOPTION1 varchar(255), SAISIEOPTION2 varchar(255), TEMPERATUREMOYENNESURFACIQUE varchar(255), DEDEAU varchar(255), TEMPERATURE_AIR_NEUF varchar(255), TEMPERATURE_AIR_REPRIS varchar(255), HUMIDITE_RELATIVE_AIR_NEUF varchar(255), HUMIDITE_RELATIVE_AIR_REPRIS varchar(255), DEBIT_MASSE_AIR_NEUF varchar(255), DEBIT_MASSE_AIR_REPRIS varchar(255), DEBIT_VOLUME_AIR_NEUF varchar(255), DEBIT_VOLUME_AIR_REPRIS varchar(255), RESULTAT_TEMPERATURE_AIR_NEUF varchar(255), RESULTAT_HUMIDITE_RELATIVE_AIR_NEUF varchar(255), RESULTAT_DEBIT_MASSE_AIR_NEUF varchar(255), RESULTAT_DEBIT_VOLUME_AIR_NEUF varchar(255), RESULTAT_TEMPERATURE_AIR_REPRIS varchar(255), RESULTAT_HUMIDITE_RELATIVE_AIR_REPRIS varchar(255), RESULTAT_DEBIT_MASSE_AIR_REPRIS varchar(255), RESULTAT_DEBIT_VOLUME_AIR_REPRIS varchar(255), OPTION_MASSE_DEBIT integer, OPTION_BATTERIE_FROIDE_TEMPERATURE integer, OPTION_DESHUMIDIFICATION integer, DEBIT_OPTION_SORTIE varchar(255), ALTITUDE integer, NOM_TRAITEMENT varchar(255), MELANGE_TEMPERATURE_SECHE varchar(255), MELANGE_HUMIDITE_RELATIVE varchar(255), MELANGE_HUMIDITE_ABSOLUE varchar(255), MELANGE_ENTHALPIE varchar(255), MELANGE_DEBIT_MASSE varchar(255), MELANGE_DEBIT_VOLUME varchar(255), MELANGE_MASSE_VOLUMIQUE varchar(255), MELANGE_VOLUME_SPECIFIQUE varchar(255), idx integer, primary key (ID))
alter table JPAMODULE1 add constraint FKC6BE7B2A9B6E2BCA foreign key (ID) references JPAMAIN1
alter table JPAMODULE1 add constraint FKC6BE7B2A6F18654C foreign key (JPAMAIN1) references JPAMAIN1
alter table JPAMODULE2 add constraint FKC6BE7B2B6F18654E foreign key (JPAMAIN2) references JPAMAIN2
alter table JPAMODULE2 add constraint FKC6BE7B2B9B6E2BCB foreign key (ID) references JPAMAIN2
Hibernate: select max(ID) from JPAMAIN1
Hibernate: select max(ID) from JPAMODULE1
Hibernate: insert into JPAMAIN1 (NAME, ID) values (?, ?)
Hibernate: insert into JPAMODULE1 (OPTION_STRING, ALTITUDE_DU_SITE_STRING, PRESSION_TOTAL_STRING, PRESSION_VAPEUR_SATUREE_STRING, PRESSION_PARTIELLE_AIR_STRING, PRESSION_PARTIELLE_VAPEUR_EAU_STRING, TEMPERATURE_SECHE_STRING, TEMPERATURE_HUMIDE_STRING, TEMPERATURE_ROSEE_STRING, HUMIDITE_RELATIVE_STRING, HUMIDITE_ABSOLUE_STRING, HUMIDITE_ABSOLUE_SATURATION_STRING, DEGRES_DE_SATURATION_STRING, MASSE_VOLLEUMIQUE_STRING, VOLUME_SPECIFIQUE_STRING, ENTALPIE_SPECIFIQUE_STRING, JPAMAIN1, POINT, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into JPAMODULE1 (OPTION_STRING, ALTITUDE_DU_SITE_STRING, PRESSION_TOTAL_STRING, PRESSION_VAPEUR_SATUREE_STRING, PRESSION_PARTIELLE_AIR_STRING, PRESSION_PARTIELLE_VAPEUR_EAU_STRING, TEMPERATURE_SECHE_STRING, TEMPERATURE_HUMIDE_STRING, TEMPERATURE_ROSEE_STRING, HUMIDITE_RELATIVE_STRING, HUMIDITE_ABSOLUE_STRING, HUMIDITE_ABSOLUE_SATURATION_STRING, DEGRES_DE_SATURATION_STRING, MASSE_VOLLEUMIQUE_STRING, VOLUME_SPECIFIQUE_STRING, ENTALPIE_SPECIFIQUE_STRING, JPAMAIN1, POINT, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Exception in thread "AWT-EventQueue-0" org.hibernate.exception.ConstraintViolationException: could not insert: [com.progiciel.jpa.JpaModule1]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at com.progiciel.visual.Module1.actionPerformed(Module1.java:970)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
	at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
	at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
	at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
	at java.awt.Component.processMouseEvent(Component.java:6289)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
	at java.awt.Component.processEvent(Component.java:6054)
	at java.awt.Container.processEvent(Container.java:2041)
	at java.awt.Component.dispatchEventImpl(Component.java:4652)
	at java.awt.Container.dispatchEventImpl(Container.java:2099)
	at java.awt.Component.dispatchEvent(Component.java:4482)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
	at java.awt.Container.dispatchEventImpl(Container.java:2085)
	at java.awt.Window.dispatchEventImpl(Window.java:2478)
	at java.awt.Component.dispatchEvent(Component.java:4482)
	at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
	at java.awt.EventQueue.access$000(EventQueue.java:85)
	at java.awt.EventQueue$1.run(EventQueue.java:603)
	at java.awt.EventQueue$1.run(EventQueue.java:601)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
	at java.awt.EventQueue$2.run(EventQueue.java:617)
	at java.awt.EventQueue$2.run(EventQueue.java:615)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.sql.SQLIntegrityConstraintViolationException: INSERT sur la table 'JPAMODULE1' a entraîné la violation de la contrainte de clé externe 'FKC6BE7B2A9B6E2BCA' pour la clé (2).  L'instruction a été annulée.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
	at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2434)
	... 47 more
Caused by: java.sql.SQLException: INSERT sur la table 'JPAMODULE1' a entraîné la violation de la contrainte de clé externe 'FKC6BE7B2A9B6E2BCA' pour la clé (2).  L'instruction a été annulée.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	... 58 more
Caused by: ERROR 23503: INSERT sur la table 'JPAMODULE1' a entraîné la violation de la contrainte de clé externe 'FKC6BE7B2A9B6E2BCA' pour la clé (2).  L'instruction a été annulée.
	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.GenericRIChecker.doCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.RISetChecker.doFKCheck(Unknown Source)
	at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
	... 52 more

voici mon test :
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
 
	Session session= HibernateUtil.getSessionFactory().openSession();
 
			Transaction tx =session.beginTransaction();
 
			JpaMain1 main1 =new JpaMain1();
			 JpaModule1 module1 =null;
 
 
 
			 ChaineDeVariable cdve =new ChaineDeVariable();
 
			 main1.setName("testing3");
			 session.save(main1);
 
			 for(int i=0;vModule1.size()>i;i++){
 
 
			module1 =new JpaModule1();
				  cdve =vModule1.elementAt(i);
				  module1.setJpamodule1(cdve);
				  module1.setJpamain1(main1);
 
				  session.save(module1);
 
 
			 }
 
 
 
			  tx.commit();
 
 
 
			 session.close();

fichier hibernate.cfg.xml :

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
 
<?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 name="GTA">
  <property name="hibernate.connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>
  <property name="hibernate.connection.password">gta</property>
  <property name="hibernate.connection.url">jdbc:derby:MyDB</property>
  <property name="hibernate.connection.username">rockstar</property>
  <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>
  <property name="show_sql">true</property>
 
  <property name="current_session_context_class">thread</property>
  <mapping resource="com/progiciel/jpa/JpaMain1.hbm.xml"/>
  <mapping resource="com/progiciel/jpa/JpaMain2.hbm.xml"/>
  <mapping resource="com/progiciel/jpa/JpaModule1.hbm.xml"/>
  <mapping resource="com/progiciel/jpa/JpaModule2.hbm.xml"/>
 
 </session-factory>
</hibernate-configuration>

on peut pas retirer les clés étrangère qui font ch..

merci