Julio
This problem occurs because by default (with weblogic anyway) database
inserts are delayed until ejbPostCreate. I had this same problem and
solved it by setting the delay-database-insert-until parameter in the
weblogic-cmp-rdbms-jar.xml file to ejbCreate for the parent bean. Thus,
the parent bean will exist when you create the child bean in
ejbPostCreate. Hope this helps.
Cliff
Julio Cesar Macavilca wrote:
>
> I have table Quote (parent) and table QuotePartner (child), relationship
> 1-to-1, managed as CMP using ejb 2.0 on a WebLogic Server.
> The problem is that a need to maintain relation 1-to-1, it means when a
> Quote is created, inmediately I create QuotePartner on method
> ejbPostCreate(), but it seems that first create child on database before
> insert parent, because a database integrity constrint is fired.
>
> I disabled that contraint and it works, but I wondering a way to implement
> this withou disable database constraint.
> Any idea or coments will be gratefully received
> Thanks in advance
>
> QuoteBean.java code:
>
> public java.math.BigDecimal ejbCreate() throws CreateException {
> BigDecimal vQuotePK = ....// autogenerated ID managed by my own
> code
> this.setQuoteid( vQuotePK ); // set parent id
> }
> public void ejbPostCreate() throws CreateException {
> System.out.println("QuoteBean.ejbPostCreate");
> // create QuotePartner
> QuotepartnerHome vPartnerHome = null;
> try{
> System.out.println("QuoteBean.ejbPostCreate creating Context");
> javax.naming.Context context = new
> javax.naming.InitialContext();
> System.out.println("QuoteBean.ejbPostCreate look home");
> vPartnerHome =(QuotepartnerHome)context.lookup("Quotepartner");;
> }catch(javax.naming.NamingException e){
> System.out.println("QuoteBean.ejbPostCreate Error :"+
> e.getExplanation());
> e.printStackTrace(System.out);
> throw new javax.ejb.EJBException( e.getMessage() );
> }
> BigDecimal vQuotePK = this.getQuoteid(); // get parent Id
> System.out.println("QuoteBean.ejbPostCreate creating QuotePartner");
> Quotepartner vPartner = vPartnerHome.create(vQuotePK );
> //create child
> }
>
> Error:
>
> java.rmi.RemoteException: EJB Exception:; nested exception is:
> javax.ejb.TransactionRolledbackLocalException: EJB Exception:
> - with nested exception:
> [java.sql.SQLException: ORA-02291: integrity constraint
> (JMACAVILCA.SYS_C00306834) violated - parent key not found
> ]
>
> Start server side stack trace:
> java.rmi.RemoteException: EJB Exception:; nested exception is:
> javax.ejb.TransactionRolledbackLocalException: EJB Exception:
> - with nested exception:
> [java.sql.SQLException: ORA-02291: integrity constraint
> (JMACAVILCA.SYS_C00306834) violated - parent key not found
> ] java.sql.SQLException: ORA-02291: integrity constraint
> (JMACAVILCA.SYS_C00306834) violated - parent key not found
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
> at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
>
> at
> oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446
> )
> at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
>
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
> :1900)
> at
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState
> ment.java:363)
> at weblogic.jdbc.pool.Statement.executeUpdate(Statement.java:293)
> at
> weblogic.jdbc.rmi.internal.PreparedStatementImpl.executeUpdate(PreparedState
> mentImpl.java:64)
> at
> weblogic.jdbc.rmi.SerialPreparedStatement.executeUpdate(SerialPreparedStatem
> ent.java:58)
> at
> com.transi.ejb.Quotepartner_rihass__WebLogic_CMP_RDBMS.__WL_create(Quotepart
> ner_rihass__WebLogic_CMP_RDBMS.java:2981)
> at
> com.transi.ejb.Quotepartner_rihass__WebLogic_CMP_RDBMS.ejbPostCreate(Quotepa
> rtner_rihass__WebLogic_CMP_RDBMS.java:2825)
> at java.lang.reflect.Method.invoke(Native Method)
> at weblogic.ejb20.manager.DBManager.create(DBManager.java:583)
> at weblogic.ejb20.manager.DBManager.localCreate(DBManager.java:471)
> at
> weblogic.ejb20.internal.EntityEJBLocalHome.create(EntityEJBLocalHome.java:16
> 7)
> at
> com.transi.ejb.QuotepartnerBean_rihass_LocalHomeImpl.create(QuotepartnerBean
> _rihass_LocalHomeImpl.java:118)
> at com.transi.ejb.QuoteBean.ejbPostCreate(QuoteBean.java:64)
> at
> com.transi.ejb.Quote_1aoeos__WebLogic_CMP_RDBMS.ejbPostCreate(Quote_1aoeos__
> WebLogic_CMP_RDBMS.java:3189)
> at java.lang.reflect.Method.invoke(Native Method)
> at weblogic.ejb20.manager.DBManager.create(DBManager.java:583)
> at weblogic.ejb20.manager.DBManager.remoteCreate(DBManager.java:462)
> at weblogic.ejb20.internal.EntityEJBHome.create(EntityEJBHome.java:190)
>
> at
> com.transi.ejb.QuoteBean_1aoeos_HomeImpl.create(QuoteBean_1aoeos_HomeImpl.ja
> va:107)
> at com.transi.ejb.QuoteBean_1aoeos_HomeImpl_WLSkel.invoke(Unknown Source)
>
> at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:296)
>
> at
> weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef.java
> :93)
> at
> weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:265)
>
> at
> weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:2
> 2)
> at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
> at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
--
Cliff Vasicek
Net Quotient Consulting Group
[EMAIL PROTECTED]
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
