Persistance, clés composées et clés étrangères

**methodman225** · 28/09/2010, 13h57

Bonjour,
Il est question pour moi de faire des ajouts, modifications et suppressions dans une table. Cette table contient de trois clés étrangères et deux de ces clés constituent la clé primaire (j'ai donc une clé composée). J'ai donc mis en oeuvre le code ci dessous, mais à l'exécution rien ne marche. Je souhaite avoir une aide de votre part afin de résoudre mon problème. Merci
Entity

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
 
// ...
@Embeddable
public class BranchAcctPK implements Serializable {
    private String branchCode;
    private String acctType;
 
    public BranchAcctPK() {
    }
 
    public BranchAcctPK(String branchCode, String acctType) {
        this.branchCode = branchCode;
        this.acctType = acctType;
    }
 
    // getter et setter
 
}

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
 
// ...
@Entity
@Table(name = "PRIME_BRANCHACCTINFO")
public class BranchAcct implements Serializable {
 
    EmbeddedId
    protected BranchAcctPK idBranchAcct;
    private String acctNo;
    @JoinColumn(name = "ACCTTYPE")
    @ManyToOne
    private Type type;
    @JoinColumn(name = "BRANCHCODE")
    @ManyToOne
    private Branch branch;
    @JoinColumn(name = "BANKID")
    @ManyToOne
    private Bank bank;
 
    public BranchAcct() {
    }
 
    public BranchAcct(BranchAcctPK branchAcctPK) {
        this.idBranchAcct = branchAcctPK;
    }
 
    public BranchAcct(String branchCode, String acctType) {
        this.idBranchAcct = new BranchAcctPK(branchCode, acctType);
    }
 
    // getter et setter
 
}

Session Facade

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
 
// ...
@Stateless
public class SuiviParametrageFacadeBean implements SuiviParametrageFacade {
 
    @PersistenceContext(unitName = "safe-ejbPU")
    private EntityManager em;
 
    public BranchAcct createBranchAcct(BranchAcct branchAcct) {
        em.persist(branchAcct);
        return branchAcct;
 
    public BranchAcct editBranchAcct(BranchAcct branchAcct) {
        em.merge(branchAcct);
        return branchAcct;
    }
 
    public void removeBranchAcct(BranchAcct branchAcct) {
        branchAcct = em.find(BranchAcct.class, branchAcct.getAcctNo());
        em.remove(em.merge(branchAcct));
    }
 
    public BranchAcct findBranchAcct(Object id) {
        return em.find(BranchAcct.class, id);
    }
 
    public List<BranchAcct> findAllBranchAcct() {
        CriteriaQuery cq = em.getCriteriaBuilder().createQuery();
        cq.select(cq.from(BranchAcct.class));
        return em.createQuery(cq).getResultList();
    }
 
 
}

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
 
// ...
@Stateless
public class SuiviCompteAgenceBean implements SuiviCompteAgence {
 
    @PersistenceContext(unitName = "safe-ejbPU")
    private EntityManager em;
 
    @EJB SuiviBanque suiviB;
    @EJB SuiviAgence suiviA;
    @EJB SuiviTableDesComptes suiviTc;
    @EJB SuiviParametrageFacade suiviPf;
 
    public BranchAcct enregistrerCompteAgence(String bankId, String branchCode, String acctCode, BranchAcct branchAcct) {
        // lier à bank
        Bank b = suiviB.trouverBanque(bankId);
        branchAcct.setBank(b);
        // lier à branch
        Branch br = suiviA.trouverAgence(branchCode);
        branchAcct.setBranch(br);
        // lier à type
        Type t = suiviTc.trouverTableComptes(acctCode);
        branchAcct.setType(t);
        // enregistrer le compte par agence
        branchAcct = suiviPf.createBranchAcct(branchAcct);
        return branchAcct;
    }
 
    public BranchAcct modifierCompteAgence(BranchAcct branchAcct){
        branchAcct = suiviPf.editBranchAcct(branchAcct);
        return branchAcct;
    }
 
    public BranchAcct supprimerCompteAgence(BranchAcct branchAcct){
        suiviPf.removeBranchAcct(branchAcct);
        return branchAcct;
    }
}

**DevServlet** · 28/09/2010, 14h09

Qu'est cer qui ne marche pas?
Envois nous les traces d'erreur, on t'aiderait peut être mieux après.

**methodman225** · 29/09/2010, 14h01

Bonjour DevServlet,
Voici la trace d'erreur que j'ai

javax.faces.el.EvaluationException: javax.ejb.EJBException: Transaction aborted
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:775)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1267)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:312)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97)
at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:332)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:233)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:165)
at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:791)
at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:693)
at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:954)
at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:170)
at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102)
at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88)
at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76)
at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53)
at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57)
at com.sun.grizzly.ContextTask.run(ContextTask.java:69)
at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330)
at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.ejb.EJBException: Transaction aborted
at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:4997)
at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4756)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1955)
at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1906)
at com.sun.ejb.containers.EJBObjectInvocationHandler.invoke(EJBObjectInvocationHandler.java:208)
at com.sun.ejb.containers.EJBObjectInvocationHandlerDelegate.invoke(EJBObjectInvocationHandlerDelegate.java:75)
at $Proxy253.enregistrerCompteAgence(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:228)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:147)
at com.sun.corba.ee.impl.presentation.rmi.codegen.CodegenStubBase.invoke(CodegenStubBase.java:225)
at com.prime.safeconnect.model.ejb.parametrage.session.__SuiviCompteAgence_Remote_DynamicStub.enregistrerCompteAgence(com/prime/safeconnect/model/ejb/parametrage/session/__SuiviCompteAgence_Remote_DynamicStub.java)
at com.prime.safeconnect.model.ejb.parametrage.session._SuiviCompteAgence_Wrapper.enregistrerCompteAgence(com/prime/safeconnect/model/ejb/parametrage/session/_SuiviCompteAgence_Wrapper.java)
at com.prime.safeconnect.managedbean.parametrage.BranchAcctController.createBranchAcct(BranchAcctController.java:233)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.el.parser.AstValue.invoke(AstValue.java:234)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:297)
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:98)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more
Caused by: javax.transaction.RollbackException: Transaction marked for rollback.
at com.sun.enterprise.transaction.JavaEETransactionImpl.commit(JavaEETransactionImpl.java:450)
at com.sun.enterprise.transaction.JavaEETransactionManagerSimplified.commit(JavaEETransactionManagerSimplified.java:837)
at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:4991)
... 56 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20091127-r5931): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-00957: nom de colonne en double

Error Code: 957
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:800)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:866)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:586)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:529)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:914)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:334)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:461)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80)
at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:286)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:675)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:589)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:109)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:86)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2863)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1225)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1207)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1167)
at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:197)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:103)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3260)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1405)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:547)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1510)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3134)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:268)
at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157)
at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68)
at com.sun.enterprise.transaction.JavaEETransactionImpl.commit(JavaEETransactionImpl.java:412)
... 58 more
Caused by: java.sql.SQLException: ORA-00957: nom de colonne en double

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8 Oall.receive(T4C8 Oall.java:639)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
at com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:108)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:791)
... 91 more

**DevServlet** · 29/09/2010, 14h52

Ca vous arrive souvent de lire les traces d'erreur ?

Code :

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

Caused by: java.sql.SQLException: ORA-00957: nom de colonne en double

Tout y est souvent bien expliqué

**methodman225** · 01/10/2010, 18h02

Bonjour DevServlet,
Merci d'avoir attiré mon attention, mais il n'y avait pas que ça. Je me suis un peu pressé de transmettre la trace, à l'origine j'avais un peu modifié mes entities. Tout marche correctement maintenant. Encore une fois grand merci

NB: Ce soir j'éditerais ce message pour partage les modifications effectuées

**DevServlet** · 03/10/2010, 20h18

N'oublies pas le tag "résolu"

**methodman225** · 07/10/2010, 11h46

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
 
//..
public class BranchAcctPK implements Serializable {
    private String acctType;
    private String branchCode;
 
    public BranchAcctPK() {
    }
 
    public BranchAcctPK(String acctType, String branchCode) {
        this.acctType = acctType;
        this.branchCode = branchCode;
    }
 
    //...
}

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
 
@Entity
@Table(name = "PRIME_BRANCHACCTINFO")
@IdClass(BranchAcctPK.class)
public class BranchAcct implements Serializable {
 
    @Id
    @Column(nullable = false, name = "ACCTTYPE", insertable = false, updatable = false)
    private String acctType;
 
    @Column(name = "ACCTNO", insertable = true, updatable = true)
    private String acctNo;
 
    @Id
    @Column(nullable = false, name = "BRANCHCODE", insertable = false, updatable = false)
    private String branchCode;
 
    @ManyToOne
    @JoinColumn(name = "ACCTTYPE")
    private Type type;
 
    @ManyToOne
    @JoinColumn(name = "BRANCHCODE")
    private Branch branch;
 
    @ManyToOne
    @JoinColumn(name = "BANKID")
    private Bank bank;
 
    public BranchAcct() {
    }
 
    public BranchAcct(String acctNo, Type type, Bank bank, Branch branch) {
        this.acctNo = acctNo;
        this.type = type;
        this.bank = bank;
        this.branch = branch;
    }
 
    //...
}

**DevServlet** · 07/10/2010, 14h23

C'est quoi ta question?

**methodman225** · 07/10/2010, 15h13

Bonjour DevServlet,
Il y a pas de question. En fait, mon problème venait du fait que j'avais mal codé mes entities. Donc après l'avoir résolu, j'ai juste voulu partager le resultat en postant le code qu'il me fallait pour régler mon problème.
Merci pour ton assistance

Persistance, clés composées et clés étrangères

JPA Java

Discussions similaires

Partager

Partager