We have a 1-1 relationship between GenericGroup and AccountTeam.
However, in the user interface, the GenericGroup is created on one page,
and the AccountTeam is added later on, on a different page. Once we
create the AccountTeam Object, associate it with the correct
GenericGroup and then save, we are getting a FK error.
OJB seems to be trying to update the GenericGroup before it inserts the
AccountTeam. Is there a way to control the order of the statements?
Even w/o the FK constraint, OJB should be inserting the AccountTeam
object first, because we are using database generated Ids.
Here is the relevant portion of the mapping document and stack trace:
<class-descriptor
class="com.lmig.pm.affinity.model.client.NewClientGroup"
table="DEXA400T"
>
...
<field-descriptor
name="accountTeamId"
column="ACCT_TEAM_ID"
jdbc-type="INTEGER"
access="anonymous"
/>
<reference-descriptor name="accountTeam"
class-ref="com.lmig.pm.affinity.model.client.account.AccountTeam">
<foreignkey field-ref="accountTeamId"/>
</reference-descriptor>
...
</class-descriptor>
<class-descriptor
class="com.lmig.pm.affinity.model.client.account.AccountTeam"
table="DEXA540T"
>
<field-descriptor
name="objectId"
column="ACCT_TEAM_ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
access="readonly"
/>
<field-descriptor
name="accountManagerId"
column="ACCT_MGR_ID"
jdbc-type="INTEGER"
access="anonymous"
/>
<reference-descriptor name="accountManager"
class-ref="com.lmig.pm.affinity.model.client.account.AccountManager">
<foreignkey field-ref="accountManagerId"/>
</reference-descriptor>
<field-descriptor
name="araId"
column="ARA_ID"
jdbc-type="INTEGER"
access="anonymous"
/>
<reference-descriptor name="ara"
class-ref="com.lmig.pm.affinity.model.client.account.AccountRelationsAss
ociate">
<foreignkey field-ref="araId"/>
</reference-descriptor>
<field-descriptor
name="managementLevelId"
column="ANT_MGT_LEV_ID"
jdbc-type="INTEGER"
access="anonymous"
/>
<reference-descriptor name="managementLevel"
class-ref="com.lmig.pm.affinity.model.client.account.AccountManagementLe
vel">
<foreignkey field-ref="managementLevelId"/>
</reference-descriptor>
<collection-descriptor
name="salesReps"
element-class-ref="com.lmig.pm.affinity.model.client.account.SalesRepres
entative"
auto-delete="true"
auto-update="false"
>
<inverse-foreignkey field-ref="accountTeamId" />
</collection-descriptor>
<field-descriptor
name="idOfLastUserToUpdate"
column="LAST_MODIFIED_USER"
/>
<field-descriptor
name="lastModifiedDate"
column="LAST_MODIFIED_DTM"
jdbc-type="TIMESTAMP"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTi
mestampFieldConversion"
/>
<field-descriptor
name="objectStatus"
column="ROW_STTS_FLAG"
/>
<!-- Field used for OJB's Optimistic Locking -->
<field-descriptor
name="optLockField"
column="OP_LOCK_ID"
jdbc-type="INTEGER"
locking="true"
/>
</class-descriptor>
[5/10/05 12:39:33:441 CDT] 6dbd6dbd SystemOut O The broker was not
in transaction - nothing will happen
[5/10/05 12:39:33:591 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:591 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:732 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:742 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:032 CDT] 6dbd6dbd SystemOut O Store successful
[5/10/05 12:39:34:122 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:132 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:443 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:34:443 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:UPDATE AD2STDDE.DEXA580T SET
STATUS_ID=?,TMN_REASON_ID=?,EFF_DT=?,PREVIOUS_EFF_DT=?,PREVIOUS_STATUS_I
D=?,LAST_MODIFIED_USER=?,LAST_MODIFIED_DT=?,ROW_STTS_FLAG=?,OP_LOCK_ID=?
WHERE AGR_STATUS_ID = ? AND OP_LOCK_ID = ?
[5/10/05 12:39:34:443 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:57:746 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
3932,ACCOUNT TEAM TEST 3,100 Liberty Way,,Dean Thurs,Tue May 10 00:00:00
CDT 2005,null,code: 1 value: Client
Group,,LOBs:0,MLs:1,null,null,com.lmig.pm.affinity.model.client.NewClien
tGroup,null,null,Group Savings
Plus,[EMAIL PROTECTED],null,VIPs:0,code:
2 value: Employer Group,,null,true,true,SGs:0
[5/10/05 12:39:57:746 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG:
SQL:UPDATE AD2STDDE.DEXA400T SET
CLIENT_ID=?,CATEGORY_TYPE_ID=?,INN_CLIENT_NB=?,ETL_CLIENT_ID=?,SDD_COMP_
I=?,PRIMARY_GRP_I=?,ELIGIBLES_ID=?,CLIENT_BILLING_ID=?,ACCT_TEAM_ID=?,PR
OGRAM_NM=?,NAME=?,LAST_NAME=?,LAST_NAME_DT=?,KEY_WORDS=?,EFF_DT=?,COMMEN
TS=?,MAIL_MEMBERS=?,REPORTS_ID=?,type_id=?,REPORTS_DESC=?,ADDRESS_ID=?,C
ONTACT_ID=?,AGR_STATUS_ID=?,CLASS_NAME=?,LAST_MODIFIED_USER=?,LAST_MODIF
IED_DTM=?,ROW_STTS_FLAG=?,OP_LOCK_ID=? WHERE GENERIC_GRP_ID = ? AND
OP_LOCK_ID = ?
[5/10/05 12:39:57:746 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
[EMAIL PROTECTED]
[5/10/05 12:39:58:417 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException
during the execution of the update (for a
com.lmig.pm.affinity.model.client.NewClientGroup): [IBM][CLI
Driver][DB2] SQL0530N The insert or update value of the FOREIGN KEY
"ACCT$TEA" is not equal to any value of the parent key of the parent
table. SQLSTATE=23503
[5/10/05 12:39:58:417 CDT] 6dbd6dbd SystemOut O [IBM][CLI
Driver][DB2] SQL0530N The insert or update value of the FOREIGN KEY
"ACCT$TEA" is not equal to any value of the parent key of the parent
table. SQLSTATE=23503
[5/10/05 12:39:58:417 CDT] 6dbd6dbd SystemErr R
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0530N The
insert or update value of the FOREIGN KEY "ACCT$TEA" is not equal to any
value of the parent key of the parent table. SQLSTATE=23503
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
java.lang.Throwable.<init>(Throwable.java)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
java.lang.Throwable.<init>(Throwable.java)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
java.sql.SQLException.<init>(SQLException.java:51)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.DB2Exception.<init>(DB2Exception.java:72)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcepti
onGenerator.java:270)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExcepti
onGenerator.java:207)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptio
nGenerator.java:458)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.
java)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeUpdate(DB2PreparedState
ment.java:1642)
[5/10/05 12:39:58:437 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPr
eparedStatement.java:555)
[5/10/05 12:39:58:447 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(Unknown
Source)
[5/10/05 12:39:58:447 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown
Source)
[5/10/05 12:39:58:447 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
[5/10/05 12:39:58:447 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source)
[5/10/05 12:39:58:447 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
[5/10/05 12:39:58:457 CDT] 6dbd6dbd SystemErr R at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown
Source)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.persistence.PersistenceManager.save(PersistenceMana
ger.java:338)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.persistence.PersistenceManager.saveList(Persistence
Manager.java:1244)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.persistence.PersistenceManager.saveList(Persistence
Manager.java:1262)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.action.AffinityAction.persistAdmObject(AffinityActi
on.java:575)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.action.SaveClientPageThreeAction.doPerform(SaveClie
ntPageThreeAction.java:84)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.action.AffinityAction.execute(AffinityAction.java:1
32)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr
ocessor.java:484)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:
274)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.lmig.pm.affinity.servlet.ActionServlet.doPost(ActionServlet.java:79)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictSe
rvletInstance.java:110)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLi
fecycleServlet.java:174)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycle
Servlet.java:313)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLif
ecycleServlet.java:116)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.
java:283)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(Vali
dServletReferenceState.java:42)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(Servle
tInstanceReference.java:40)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispa
tch(WebAppRequestDispatcher.java:948)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRe
questDispatcher.java:530)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppReq
uestDispatcher.java:176)
[5/10/05 12:39:58:467 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:7
9)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInv
oker.java:201)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocati
on(CachedInvocation.java:71)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(Servle
tRequestProcessor.java:182)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSELis
tener.java:334)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection
.java:56)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
610)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.http.HttpConnection.run(HttpConnection.java)
[5/10/05 12:39:58:477 CDT] 6dbd6dbd SystemErr R at
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
