c3p0, problème de rollback

**spif17** · 14/09/2011, 11h48

Salut à tous,

J'utilise c3p0 comme pool de connexion pour mon projet EJB 3 avec Jboss 6 Final
et une base PostgreSQL 8.4
J'ai une entité A qui contient une liste d'entités B.
En base, j'ai une table A et une table B, B à une clef etrangere vers A.

Mon scénario : je persite mon d'entité A, dans sa liste d'entités B
j'ai un entité qui ne respecte pas une contrainte en base (table B).
Dans ce scénario le comportement souhaité est aucune sauvergarde en base
des entités A et B.

Pour ce scénario, quand j'utilise c3p0 j'ai une entité A sauvegardé en base,
quand je n'utilise pas c3p0 l'entité A n'est pas sauvegardé.

Je ne comprend pas pourquoi l'utilisation de c3p0 empeche de faire un rollback
sur la transaction ?
Dans les log de Jboss, il est indiqué pour c3p0 un mode autocommit à true,
si dans mon persistence.xml, j'ajoute <property name="hibernate.connection.autocommit" value="false"/>
c3p0 à mode autocommit à false mais je n'ai plus la possibilité de sauvegarder une entité
en base avec mon code actuel.

- Code :

postgresql-ds.xml (JBoss) :

Code :

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

1
2
3
4
5
6
7
8
9
10
11
12
13
<?xml version="1.0" encoding="utf-8"?>
<datasources>
  <local-tx-datasource>
    <jndi-name>formationDS</jndi-name>
    <connection-url>jdbc:postgresql://localhost:5432/test</connection-url>
    <driver-class>org.postgresql.Driver</driver-class>
    <user-name>postgres</user-name>
    <password>postgres</password>
	<metadata>
	   <type-mapping>PostgreSQL 8.0</type-mapping>
	</metadata>
  </local-tx-datasource>
</datasources>

persistence.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
22
23
24
25
26
27
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
    version="2.0">	
	<persistence-unit name="resourceManager">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
	    <jta-data-source>java:/formationDS</jta-data-source>
 
		<properties>
            <property name="hibernate.connection.driver_class" value="org.postgresql.Driver" />
		    <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" /> -->
 
			<property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/test" />
			<property name="hibernate.connection.username" value="postgres" />
			<property name="hibernate.connection.password" value="postgres" />
			<property name="hibernate.show_sql" value="true" />
 
			<property name="hibernate.connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" />
			<property name="hibernate.c3p0.acquire_increment" value="1" />
			<property name="hibernate.c3p0.min_size" value="10" />
			<property name="hibernate.c3p0.max_size" value="100" />
			<property name="hibernate.c3p0.max_statements" value="500" />
			<property name="hibernate.c3p0.timeout" value="30" />
		</properties>
	</persistence-unit>
</persistence>

entité A :

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
import javax.*;
 
@Entity
@Table(name = "intervenant", schema = "referentiel")
public class IntervenantRefEntity implements Serializable {
 
	private static final long serialVersionUID = 1L;
 
 
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "intervenant_sequence")
	@SequenceGenerator(name = "intervenant_sequence", sequenceName = "referentiel.intervenant_int_id_seq",allocationSize=1)
	@Column(name = "int_id", unique = true, nullable = false, insertable = true, updatable = false)
	private Long id;
 
	@NotNull
	@Column(name = "int_maj")
	private Date maj;
...
	@OneToMany(cascade = CascadeType.ALL, mappedBy = "intervenant",targetEntity=AliasIntervenantRefEntity.class)
	private List<AliasIntervenantRefEntity> aliasIntervenants;
 
	@Transient
	public void addAliasIntervenant(AliasIntervenantRefEntity aliasIntervenant) {
		if (aliasIntervenants == null) {
			aliasIntervenants = new ArrayList<AliasIntervenantRefEntity>();
		}
		aliasIntervenant.setIntervenant(this);
		aliasIntervenants.add(aliasIntervenant);
	}
 
	@Transient
	public void setIntervenantRefData(IntervenantRefTO intervenant) {
		this.auteurMaj = intervenant.getAuteurMaj();
		this.bp = StringUtils.stripToNull(intervenant.getBp());
...
 
		if (intervenant.getAliasIntervenants() != null) {
			for (AliasIntervenantRefTO aliasIntervenantTO : intervenant.getAliasIntervenants()) {
				AliasIntervenantRefEntity aliasIntervenantEntity = new AliasIntervenantRefEntity();
				aliasIntervenantEntity.setAliasIntervenantRefData(aliasIntervenantTO);
				addAliasIntervenant(aliasIntervenantEntity);
			}
		}
	}
}

entité B :

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
import javax.*;
 
@Entity
@Table(name = "alias_intervenant", schema = "referentiel")
public class AliasIntervenantRefEntity implements Serializable {
	private static final long serialVersionUID = 1L;
 
	@Id
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "alias_intervenant_sequence")
	@SequenceGenerator(name = "alias_intervenant_sequence", sequenceName = "referentiel.alias_intervenant_alias_int_id_seq",allocationSize=1)
	@Column(name = "alias_int_id", unique = true, nullable = false, insertable = true, updatable = false)
	private Long id;
 
	@NotNull
	@Column(name = "alias_int_maj")
	private Date maj;
...
	@ManyToOne
	@JoinColumn(name = "alias_int_int_id", referencedColumnName = "int_id")
	private IntervenantRefEntity intervenant;
 
	@Transient
	public void setAliasIntervenantRefData(AliasIntervenantRefTO aliasIntervenantRef){
		this.auteurMaj = aliasIntervenantRef.getAuteurMaj();
		this.codeAliasOrigine = aliasIntervenantRef.getCodeAliasOrigine();
		this.libelle = aliasIntervenantRef.getLibelle();
		this.maj = aliasIntervenantRef.getMaj();
	}
}

session bean :

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
import javax.*;
 
@Stateless
@Remote(IntervenantRefRemote.class)
public class IntervenantRefBean implements IntervenantRefRemote {
	private final static Logger log = Logger.getLogger(IntervenantRefBean.class);
 
	@PersistenceContext(unitName = "resourceManager")
	protected EntityManager entityManager;
 
	@Override
	@TransactionAttribute(TransactionAttributeType.REQUIRED)
	public IntervenantRefTO saveIntervenant(IntervenantRefCreationRequest request) {
 
		// Create the bean
		IntervenantRefEntity intervenantRefEntity = new IntervenantRefEntity();
		intervenantRefEntity.setIntervenantRefData(request.getIntervenant());
 
		// Set the MAJ date and author
		intervenantRefEntity.setMaj(new Date());
		intervenantRefEntity.setAuteurMaj(request.getEmail());
		if(intervenantRefEntity.getAliasIntervenants() != null){
			for(AliasIntervenantRefEntity aliasIntervenantRefEntity : intervenantRefEntity.getAliasIntervenants()) {
				aliasIntervenantRefEntity.setMaj(new Date());
				aliasIntervenantRefEntity.setAuteurMaj(request.getEmail());
			}
		}
 
		if(intervenantRefEntity.getCode() == null) {
			intervenantRefEntity.setCode(Utils.generateUniqueCode(17));
			entityManager.persist(intervenantRefEntity);
			String code = Utils.generateCode(intervenantRefEntity.getId(), "INT", Constants.formatterIntervenant);
			intervenantRefEntity.setCode(code);
		}
 
		return intervenantRefEntity.getIntervenantRefData();
	}	
}

Code :

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

1
2
3
4
@Remote
public interface IntervenantRefRemote {
       public IntervenantRefTO saveIntervenant(IntervenantRefCreationRequest request);
}

- Stack trace du scénario :
Avec c3p0 :

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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
 
17:21:39,636 INFO  [STDOUT] Hibernate: insert into referentiel.intervenant (int_auteur_maj, int_bp, int_code, int_code_postal, int_code_remplacement,  int_code_siret, int_code_statut, int_commentaire, int_departement, int_domaine_activite, int_immo, int_lieu_dit, int_maj, int_mnemonique, int_nom, int_rue, int_ville, int_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
 
17:21:39,636 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [1] as [VARCHAR] - auteurMaj
17:21:39,636 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [2] as [VARCHAR] - <null>
17:21:39,636 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [3] as [VARCHAR] - 379532d5-1bb5-491
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [4] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [5] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [7] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [8] as [VARCHAR] - Provisoire
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [9] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [10] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [11] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [12] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [13] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [14] as [TIMESTAMP] - Tue Sep 06 17:21:39 CEST 2011
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [15] as [VARCHAR] - toto
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [16] as [VARCHAR] - Nom_0.9702020948974598
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [17] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [18] as [VARCHAR] - <null>
17:21:39,646 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [19] as [BIGINT] - 151
17:21:40,186 INFO  [STDOUT] Hibernate: insert into referentiel.alias_intervenant (alias_int_auteur_maj, alias_int_code_origine, alias_int_int_id, alias_int_libelle, alias_int_maj, alias_int_id) values (?, ?, ?, ?, ?, ?)
 
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [1] as [VARCHAR] - auteurMaj
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [2] as [INTEGER] - 100
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [3] as [BIGINT] - 151
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [4] as [VARCHAR] - libelle
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [5] as [TIMESTAMP] - Tue Sep 06 17:21:39 CEST 2011
17:21:40,186 TRACE [org.hibernate.type.descriptor.sql.BasicBinder] binding parameter [6] as [BIGINT] - 151
17:21:40,767 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 23503
17:21:40,767 ERROR [org.hibernate.util.JDBCExceptionReporter] L'élément du batch 0 insert into referentiel.alias_intervenant (alias_int_auteur_maj, alias_int_code_origine, alias_int_int_id, alias_int_libelle, alias_int_maj, alias_int_id) values ('auteurMaj', '100', '151', 'libelle', '2011-09-06 17:21:39.636000 +02:00:00', '151') a été annulé. Appeler getNextException pour en connaître la cause.
17:21:40,767 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 23503
17:21:40,767 ERROR [org.hibernate.util.JDBCExceptionReporter] ERREUR: une instruction insert ou update sur la table « alias_intervenant » viole la contrainte de clé
étrangère « fk_alias_intervenant_alias_origine »
  Détail*: La clé (alias_int_code_origine)=(100) n'est pas présente dans la table « alias_origine ».
17:21:40,767 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) [:3.6.0.Final]
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [:3.6.0.Final]
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [:3.6.0.Final]
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) [:3.6.0.Final]
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) [:3.6.0.Final]
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [:3.6.0.Final]
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [:3.6.0.Final]
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) [:3.6.0.Final]
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) [:3.6.0.Final]
	at org.hibernate.transaction.synchronization.CallbackCoordinator.beforeCompletion(CallbackCoordinator.java:117) [:3.6.0.Final]
	at org.hibernate.transaction.synchronization.HibernateSynchronizationImpl.beforeCompletion(HibernateSynchronizationImpl.java:51) [:3.6.0.Final]
	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:97) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:274) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:94) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:159) [:6.0.0.Final]
	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1158) [:6.0.0.Final]
	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:119) [:6.0.0.Final]
	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75) [:6.0.0.Final]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:82) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:255) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterceptor.java:349) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:209) [:0.0.1]
	at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxInterceptorWrapper.java:52) [:0.0.1]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) [:1.0.0.GA]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) [:1.0.3]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:182) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(CurrentInvocationContextInterceptor.java:47) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) [:1.0.1]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCCLInterceptor.java:86) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:392) [:1.7.17]
	at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53) [:1.7.17]
	at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) [:1.0.1.GA]
	at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:898) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:791) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:744) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:548) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:234) [:6.0.0.Final]
Caused by: java.sql.BatchUpdateException: L'élément du batch 0 insert into referentiel.alias_intervenant (alias_int_auteur_maj, alias_int_code_origine, alias_int_int_id, alias_int_libelle, alias_int_maj, alias_int_id) values ('auteurMaj', '100', '151', 'libelle', '2011-09-06 17:21:39.636000 +02:00:00', '151') a été annulé. Appeler getNextException pour en connaître la cause.
	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586) [:]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811) [:]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) [:]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725) [:]
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) [:0.9.1.2]
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [:3.6.0.Final]
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [:3.6.0.Final]
	... 46 more
 
17:21:40,837 WARN  [com.arjuna.ats.arjuna] ARJUNA-12125 TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffc0a80138:126a:4e66392e:1b, org.hibernate.transaction.synchronization.HibernateSynchronizationImpl@118a206 >: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1214) [:3.6.0.Final]
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1147) [:3.6.0.Final]
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1153) [:3.6.0.Final]
	at org.hibernate.ejb.AbstractEntityManagerImpl$3.mapManagedFlushFailure(AbstractEntityManagerImpl.java:1067) [:3.6.0.Final]
	at org.hibernate.transaction.synchronization.CallbackCoordinator.beforeCompletion(CallbackCoordinator.java:122) [:3.6.0.Final]
	at org.hibernate.transaction.synchronization.HibernateSynchronizationImpl.beforeCompletion(HibernateSynchronizationImpl.java:51) [:3.6.0.Final]
	at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:97) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:274) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:94) [:6.0.0.Final]
	at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:159) [:6.0.0.Final]
	at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1158) [:6.0.0.Final]
	at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:119) [:6.0.0.Final]
	at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75) [:6.0.0.Final]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:82) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:255) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.required(CMTTxInterceptor.java:349) [:0.0.1]
	at org.jboss.ejb3.tx2.impl.CMTTxInterceptor.invoke(CMTTxInterceptor.java:209) [:0.0.1]
	at org.jboss.ejb3.tx2.aop.CMTTxInterceptorWrapper.invoke(CMTTxInterceptorWrapper.java:52) [:0.0.1]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76) [:1.0.0.GA]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) [:1.0.3]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:182) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.core.context.CurrentInvocationContextInterceptor.invoke(CurrentInvocationContextInterceptor.java:47) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) [:1.0.1]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.interceptor.EJB3TCCLInterceptor.invoke(EJB3TCCLInterceptor.java:86) [:1.7.17]
	at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:392) [:1.7.17]
	at org.jboss.ejb3.session.InvokableContextClassProxyHack._dynamicInvoke(InvokableContextClassProxyHack.java:53) [:1.7.17]
	at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:91) [jboss-aop.jar:2.2.1.GA]
	at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82) [:1.0.1.GA]
	at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:898) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:791) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:744) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:548) [:6.0.0.Final]
	at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:234) [:6.0.0.Final]
Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96) [:3.6.0.Final]
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [:3.6.0.Final]
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) [:3.6.0.Final]
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) [:3.6.0.Final]
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) [:3.6.0.Final]
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) [:3.6.0.Final]
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [:3.6.0.Final]
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) [:3.6.0.Final]
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) [:3.6.0.Final]
	at org.hibernate.transaction.synchronization.CallbackCoordinator.beforeCompletion(CallbackCoordinator.java:117) [:3.6.0.Final]
	... 39 more
Caused by: java.sql.BatchUpdateException: L'élément du batch 0 insert into referentiel.alias_intervenant (alias_int_auteur_maj, alias_int_code_origine, alias_int_int_id, alias_int_libelle, alias_int_maj, alias_int_id) values ('auteurMaj', '100', '151', 'libelle', '2011-09-06 17:21:39.636000 +02:00:00', '151') a été annulé. Appeler getNextException pour en connaître la cause.
	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586) [:]
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811) [:]
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) [:]
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725) [:]
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) [:0.9.1.2]
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) [:3.6.0.Final]
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) [:3.6.0.Final]
	... 46 more

Sans c3p0 :

Code :

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

1
2
3
4
5
6
7
8
9
'élément du batch 0 insert into referentiel.alias_intervenant (alias_int_auteur_maj, alias_int_code_origine, alias_int_int_id, alias_int_libelle, alias_int_maj, alias_int_id) values ('auteurMaj', '100', '200', 'libelle', '2011-09-06 17:52:15.586000 +02:00:00', '200') a été annulé. Appeler getNextException pour en connaître la cause.
	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2586)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1811)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2725)
	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:774)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 46 more

Merci pour votre aide.

**nathieb** · 16/09/2011, 22h26

Bonjour,

Tu dois, je pense ne pas me tromper gérer toute la transaction
pour qu'il n'y ai pas de pb.

Code :

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

1
2
3
4
5
6
7
8
9
10
 
em = factory.createEntityManager();
EntityTransaction t = em.getTransaction();
t.begin();
int oldVersion = foo.getVersion();
Foo dbFoo = em.find( foo.getClass(), foo.getKey() ); // load the current state
if ( dbFoo.getVersion()!=foo.getVersion ) throw new StaleObjectStateException();
dbFoo.setProperty("bar");
t.comit();
em.close();

s'il y a une exception, dans ce cas il faut effectuer un rollback.
le .getTransation lock tes ressources

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
Session session = factory.openSession();
Transaction tx = null;
try {
    tx = session.beginTransaction();
 
    // Do some work
    session.load(...);
    session.persist(...);
 
    tx.commit(); // Flush happens automatically
}
catch (RuntimeException e) {
    tx.rollback();
    throw e; // or display error message
}
finally {
    session.close();
}

http://community.jboss.org/wiki/SessionsAndTransactions
lien hibernate docs

Olivier

**spif17** · 02/10/2011, 18h24

Merci pour votre réponse.

En gérant toute la transaction j'ai le même problème.
(j'ai suivi ce tuto http://geertschuring.wordpress.com/2...3-jpa-and-jta/)

c3p0, problème de rollback

Java EE

Vue hybride

Discussions similaires

Partager

Partager