You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by "Lemke, Wesley" <We...@LibertyMutual.com> on 2005/05/10 19:42:50 UTC
Order of Inserts/Update in PB
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:
com.lmig.pm.affinity.model.client.ClientContract@1edf1edf
[5/10/05 12:39:33:591 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@365e365e
[5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.model.client.ClientRelationship@16501650
[5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@6f2e6f2e
[5/10/05 12:39:33:732 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.workflow.ApprovalStatus@543a543a
[5/10/05 12:39:33:742 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@7abb7abb
[5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.workflow.ApprovalStatus@5ac75ac7
[5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@3370337
[5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.workflow.ApprovalStatus@5f775f77
[5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@b930b93
[5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.workflow.WorkOrder@11ad11ad
[5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@15281528
[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:
com.lmig.pm.affinity.model.client.ClientBillingInfo@234a234a
[5/10/05 12:39:34:132 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@252c252c
[5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.model.party.Address@10fe10fe
[5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@35bc35bc
[5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.model.party.Contact@551c551c
[5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@405f405f
[5/10/05 12:39:34:443 CDT] 6dbd6dbd SystemOut O
[org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
com.lmig.pm.affinity.model.client.Status@73817381
[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:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@59205920
[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,com.lmig.pm.affinity.model.client.Status@73817381,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:
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@230a230a
[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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Order of Inserts/Update in PB
Posted by Armin Waibel <ar...@apache.org>.
Hi Wes,
Lemke, Wesley wrote:
> 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.
>
The insert/update ordering in OJB is:
first store 1:1 references
store main object
store 1:n, m:n references
So if you store a Group object, OJB will find the 1:1 reference to
Account and store this object first (when storing Account OJB again
check references for ordering).
But in
> <reference-descriptor name="accountTeam"
> class-ref="com.lmig.pm.affinity.model.client.account.AccountTeam">
> <foreignkey field-ref="accountTeamId"/>
> </reference-descriptor>
you don't set auto-update="object" to force OJB to store the referenced
object too.
http://db.apache.org/ojb/docu/guides/basic-technique.html#1%3A1+auto-xxx+setting
If you need a different order you have to insert the objects in two
steps, e.g. first store Account, then set Group reference in Account,
store Account again to link Account and store Group (or store Group,
then store Account, if auto-update is link/false).
regards,
Armin
> 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:
> com.lmig.pm.affinity.model.client.ClientContract@1edf1edf
> [5/10/05 12:39:33:591 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@365e365e
> [5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.model.client.ClientRelationship@16501650
> [5/10/05 12:39:33:642 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@6f2e6f2e
> [5/10/05 12:39:33:732 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.workflow.ApprovalStatus@543a543a
> [5/10/05 12:39:33:742 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@7abb7abb
> [5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.workflow.ApprovalStatus@5ac75ac7
> [5/10/05 12:39:33:832 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@3370337
> [5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.workflow.ApprovalStatus@5f775f77
> [5/10/05 12:39:33:932 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@b930b93
> [5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.workflow.WorkOrder@11ad11ad
> [5/10/05 12:39:33:972 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@15281528
> [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:
> com.lmig.pm.affinity.model.client.ClientBillingInfo@234a234a
> [5/10/05 12:39:34:132 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@252c252c
> [5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.model.party.Address@10fe10fe
> [5/10/05 12:39:34:232 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@35bc35bc
> [5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.model.party.Contact@551c551c
> [5/10/05 12:39:34:343 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@405f405f
> [5/10/05 12:39:34:443 CDT] 6dbd6dbd SystemOut O
> [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] DEBUG: executeUpdate:
> com.lmig.pm.affinity.model.client.Status@73817381
> [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:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@59205920
> [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,com.lmig.pm.affinity.model.client.Status@73817381,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:
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@230a230a
> [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: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org