openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Sutter <kwsut...@gmail.com>
Subject Re: Critical issue (Blocker): missing fields in update statement
Date Fri, 09 Mar 2012 20:47:01 GMT
Good to hear!  And, thanks for the feedback.

Kevin

On Fri, Mar 9, 2012 at 2:38 PM, Prabhat Sharma2 <prabhatsharma@in.ibm.com>wrote:

> Thanks for the information.
>
> Yes, I am a very new user on OpenJPA.
>
> I have upgraded openJPA jars from 1.2.2 to 2.1.1.
>
> The problem got resolved after changing enhancement technique. The runtime
> enhancement by providing a javaagent when launching the JVM that OpenJPA.
>
> Thanks & Regards,
> Prabhat Sharma
>
>
>
>
>
> From:   Kevin Sutter <kwsutter@gmail.com>
> To:     dev@openjpa.apache.org
> Date:   03/08/2012 11:19 AM
> Subject:        Re: Critical issue (Blocker): missing fields in update
>            statement
>
>
>
> Right, the removal of the RuntimeUnenhancedClasses property will require
> you to either perform build-time enhancement or some form of dynamic
> enhancement.  There's an old blog posting from Rick that describes these
> options quite well:
>
> http://webspherepersistence.blogspot.com/2009/02/openjpa-enhancement.html
>
> As far as @Transient annotation not being honored...  I would try to
> reproduce that situation with a simple test case.  We have many, many
> junits that test this capability, so there must be something unique with
> your setup or usage that would prevent this from being usable.  It's a very
> common scenario.
>
> Just curious...  Why are you using such an old version of OpenJPA?  It
> sounds like you are just starting out with OpenJPA, so why not pick a newer
> release that would have more features (and fixes)?
>
> Thanks,
> Kevin
>
> On Thu, Mar 8, 2012 at 6:13 AM, Prabhat Sharma2
> <prabhatsharma@in.ibm.com>wrote:
>
> >
> > Many Thanks for helping me.
> >
> > But when I remove or make  "unsupported", i get the below error:
> >
> > ====================================================
> > 62  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting
> OpenJPA
> > 1.2.2
> > 187  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
> > dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
> > Mar 8, 2012 6:58:49 AM com.ibm.ws.util.ImplFactory
> > WARNING: WSVR0073W
> > 9484  RDCBusinessComponent  WARN   [P=928671:O=0:CT] openjpa.Enhance -
> This
> > configuration disallows runtime optimization, but the following listed
> > types were not enhanced at build time or at class load time with a
> > javaagent: "[........class com.ibm.rdc.business.sapr3.TpakdPK,class
> > com.ibm.rdc.business.sapr3.Knvv,class
> > com.ibm.rdc.business.sapr3.KnvvPK,........... ]".
> > <openjpa-1.2.2-r422266:898935 fatal user error>
> > org.apache.openjpa.persistence.ArgumentException: The type "class
> > com.ibm.rdc.business.sapr3.KnvvPK" has not been enhanced.
> > ====================================================
> >
> > And when I Enhance at compile using "Add/Remove Bytecode Enhancer" (on
> > RSA8.0.3 (using OpenJPA plugin)  then all "@Transient" variables comes in
> > entity SQLs. Below is the error:
> > ====================================================
> >
> > 62  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting
> OpenJPA
> > 1.2.2
> > 156  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
> > dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
> > Mar 8, 2012 7:10:23 AM com.ibm.ws.util.ImplFactory
> > WARNING: WSVR0073W
> > 8828  RDCBusinessComponent  TRACE  [P=622625:O=0:CT] openjpa.jdbc.SQL -
> <t
> > 1181369962, conn 1349406830> executing prepstmnt 1665033022 SELECT
> > t0.allowDelete, t0.allowInsert, t0.allowUpdate, t0.antlf, t0.aufsd,
> > t0.autlf, t0.awahr, t0.begru, t0.boidt, t0.bokre, t0.bzirk, t0.chspl,
> > t0.eikto, t0.erdat, t0.ernam, t0.faksd, t0.fpart, t0.kunnr, t0.mandt,
> > t0.spart, t0.vkorg, t0.vtweg, t0.inco1, t0.inco2, t0.kalks, t0.kdgrp,
> > t0.klabc, t0.konda, t0.kotkd, t0.ktgrd, t0.ktokd, t0.kurst, t0.kvakz,
> > t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3, t0.kvgr4, t0.kvgr5, t0.kzazu,
> > t0.kztlf, t0.lifsd, t0.loevm, t0.lprio, t0.mrnkz, t0.OLDKNVV_KUNNR,
> > t0.OLDKNVV_MANDT, t0.OLDKNVV_SPART, t0.OLDKNVV_VKORG, t0.OLDKNVV_VTWEG,
> > t0.perfk, t0.perrl, t0.pltyp, t0.prat1, t0.prat2, t0.prat3, t0.prat4,
> > t0.prat5, t0.prat6, t0.prat7, t0.prat8, t0.prat9, t0.prata, t0.prfre,
> > t0.SAP_TS, t0.SHAD_UPDATE_IND, t0.SHAD_UPDATE_TS, t0.waers, t0.vkbur,
> > t0.vwerk, t0.versg, t0.vkgrp, t0.vsbed, t0.vsort, t0.zterm FROM
> SAPR3.KNVV
> > t0 WHERE t0.kunnr = ? AND t0.mandt = ? AND t0.spart = ? AND t0.vkorg = ?
> > AND t0.vtweg = ?  optimize for 1 row [params=(String) 0060718462,
> (String)
> > 030, (String) 00, (String) 0147, (String) C]
> > 10687  RDCBusinessComponent  TRACE  [P=622625:O=0:CT] openjpa.jdbc.SQL -
> <t
> > 1181369962, conn 1349406830> [1859 ms] spent
> > <openjpa-1.2.2-r422266:898935 nonfatal general error>
> > org.apache.openjpa.persistence.PersistenceException: T0.ALLOWDELETE IS
> NOT
> > VALID IN THE CONTEXT WHERE IT IS USED. SQLCODE=-206, SQLSTATE=42703,
> > DRIVER=3.58.81 {prepstmnt 1665033022 SELECT t0.allowDelete,
> t0.allowInsert,
> > t0.allowUpdate, t0.antlf, t0.aufsd, t0.autlf, t0.awahr, t0.begru,
> t0.boidt,
> > t0.bokre, t0.bzirk, t0.chspl, t0.eikto, t0.erdat, t0.ernam, t0.faksd,
> > t0.fpart, t0.kunnr, t0.mandt, t0.spart, t0.vkorg, t0.vtweg, t0.inco1,
> > t0.inco2, t0.kalks, t0.kdgrp, t0.klabc, t0.konda, t0.kotkd, t0.ktgrd,
> > t0.ktokd, t0.kurst, t0.kvakz, t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3,
> > t0.kvgr4, t0.kvgr5, t0.kzazu, t0.kztlf, t0.lifsd, t0.loevm, t0.lprio,
> > t0.mrnkz, t0.OLDKNVV_KUNNR, t0.OLDKNVV_MANDT, t0.OLDKNVV_SPART,
> > t0.OLDKNVV_VKORG, t0.OLDKNVV_VTWEG, t0.perfk, t0.perrl, t0.pltyp,
> t0.prat1,
> > t0.prat2, t0.prat3, t0.prat4, t0.prat5, t0.prat6, t0.prat7, t0.prat8,
> > t0.prat9, t0.prata, t0.prfre, t0.SAP_TS, t0.SHAD_UPDATE_IND,
> > t0.SHAD_UPDATE_TS, t0.waers, t0.vkbur, t0.vwerk, t0.versg, t0.vkgrp,
> > t0.vsbed, t0.vsort, t0.zterm FROM SAPR3.KNVV t0 WHERE t0.kunnr = ? AND
> > t0.mandt = ? AND t0.spart = ? AND t0.vkorg = ? AND t0.vtweg = ?  optimize
> > for 1 row [params=(String) 0060718462, (String) 030, (String) 00,
> (String)
> > 0147, (String) C]} [code=-206, state=42703]SQLCA OUTPUT[Errp=DSNXORSO,
> > Errd=-600, 0, 0, -1, 0, 0]
> >
> > =====================================================
> >
> >
> >
> > Thanks & Regards,
> > Prabhat Sharma
> >
> >
> >
> >
> > From:   Kevin Sutter <kwsutter@gmail.com>
> > To:     dev@openjpa.apache.org
> > Date:   03/07/2012 06:21 PM
> > Subject:        Re: Critical issue (Blocker): missing fields in update
> >            statement
> >
> >
> >
> > Who told you to use this property?
> >
> > <property name="openjpa.RuntimeUnenhancedClasses" value="supported"/>
> >
> > This is bad, very bad...  Subclassing support is not ready for primetime.
> > There is a reason why this is deliberately turned off both...
> >
> > Kevin
> >
> > On Wed, Mar 7, 2012 at 4:50 PM, Prabhat Sharma2
> > <prabhatsharma@in.ibm.com>wrote:
> >
> > > Hi Kevin,
> > >
> > > Yes, we have so many fields in the table and relationships. This is on
> an
> > > old legacy SAP model. Our system was build on Versata and now migrating
> > on
> > > OpenJPA and Struts. We can not modify the schema/table.
> > >
> > >
> > > I am getting the same error even after removing  EM.merge() from
> > > entiryManager method updateKnvv:
> > > ===============================================================
> > > @Action(Action.ACTION_TYPE.UPDATE)
> > >        public String updateKnvv(Knvv knvv) throws
> Exception,RDCException
> > {
> > >                 EntityManager em = getEntityManager();
> > >                try {
> > >                        em.getTransaction().begin();
> > >                         Knvv o = em.find(Knvv.class, knvv.getId());
> > >
> > >                        o.setLoevm(knvv.getLoevm());
> > >                        em.getTransaction().commit();
> > >                        //em.flush();
> > >                        //em.getTransaction().commit();
> > >                } catch(RDCException rde){
> > >                        throw new RDCException(rde.getMessage());
> > >                 }
> > >                catch (Exception ex) {
> > >                        try {
> > >                                if (em.getTransaction().isActive()) {
> > >                                        em.getTransaction().rollback();
> > >                                }
> > >                        } catch (Exception e) {
> > >                                ex.printStackTrace();
> > >                                throw e;
> > >                        }
> > >                        throw ex;
> > >                } finally {
> > >                         //em.close();
> > >                }
> > >                return "";
> > >        }
> > > ===============================================================
> > >
> > > My persistence.xml has all the entites. here is the sample:
> > > ===============================================================
> > >
> > > <?xml version="1.0" encoding="UTF-8"?>
> > > <persistence version="1.0" 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_1_0.xsd">
> > >
> > >
> > >        <persistence-unit name="RDCBusinessComponent">
> > >
> > >                <jta-data-source>jdbc/EUSHDB2C</jta-data-source>
> > >                <class>com.ibm.rdc.business.sapr3.Knvv</class>
> > >                <class>com.ibm.rdc.business.sapr3.KnvpPK</class>
> > >                <class>com.ibm.rdc.business.sapr3.Kna1PK</class>
> > >                <class>com.ibm.rdc.business.sapr3.Kna1</class>
> > > ..
> > > ..
> > > ..
> > > ..
> > >                <jta-data-source>jdbc/RDCDB2</jta-data-source>
> > >                <properties>
> > >
> > >                        <!-- property name="openjpa.jdbc.EagerFetchMode"
> > >
> > value="none"/-->
> > >                        <property name="openjpa.jdbc.Schema"
> > value="SAPR3"/>
> > >                        <property
> name="openjpa.jdbc.TransactionIsolation"
> > > value=
> > > "read-uncommitted"/>
> > >                        <property name="openjpa.ManagedRuntime"
> > value="jndi
> > > (TransactionManagerName=java:appserver/TransactionManager)"/>
> > >                        <property name="openjpa.ConnectionFactoryMode"
> > > value=
> > > "managed"/>
> > >                        <property name="openjpa.ConnectionRetainMode"
> > value=
> > > "always"/>
> > >                        <property
> name="openjpa.RuntimeUnenhancedClasses"
> > > value=
> > > "supported"/>
> > >                        <property name="openjpa.jdbc.EagerFetchMode"
> > > value="join"
> > > />
> > >
> > >                        <!--  When needs to run on local -->
> > >                        <property name="openjpa.Log" value="SQL=TRACE"/>
> > >                        <property name="openjpa.ConnectionDriverName"
> > value=
> > > "com.ibm.db2.jcc.DB2Driver"/>
> > >                        <property name="openjpa.ConnectionURL"
> value=XXXXX
> > >                        <property name="openjpa.ConnectionUserName"
> > > value="XXXX"
> > > />
> > >                        <property name="openjpa.ConnectionPassword"
> > > value="XXXX"
> > > />
> > >                        <!--   END  -->
> > >
> > >                </properties>
> > >        </persistence-unit>
> > >
> > > </persistence>
> > >
> > >
> > > ===============================================================
> > >
> > > I enabled the trace, here is the output of the trace:
> > >
> > > ====================================================================
> > > 47  RDCBusinessComponent  INFO   [main] openjpa.Runtime - Starting
> > OpenJPA
> > > 1.2.2
> > > 141  RDCBusinessComponent  INFO   [main] openjpa.jdbc.JDBC - Using
> > > dictionary class "com.ibm.ws.persistence.jdbc.sql.DB2Dictionary".
> > > Mar 7, 2012 2:13:41 PM com.ibm.ws.util.ImplFactory
> > > WARNING: WSVR0073W
> > >
> > > 3454  RDCBusinessComponent  INFO   [P=621171:O=0:CT] openjpa.Enhance -
> > > Creating subclass for "[class com.ibm.rdc.business.sapr3.TpakdPK, class
> > > com.ibm.rdc.business.sapr3.IknviPK, class
> > > com.ibm.rdc.business.sapr3.Tvv4PK, class
> > > com.ibm.rdc.business.sapr3.CountyRegion, class
> > > com.ibm.rdc.business.sapr3.Rkna1PK, class
> > > com.ibm.rdc.business.sapr3.TvsbPK, class
> > > com.ibm.rdc.business.sapr3.TvkbtPK, class
> > > com.ibm.rdc.business.sapr3.Tvk0tPK, class
> > > com.ibm.rdc.business.sapr3.GcsFinoblInput, class
> > > com.ibm.rdc.business.sapr3.LegxrefPK, class
> > > com.ibm.rdc.business.sapr3.TerritoryPK, class
> > > com.ibm.rdc.business.sapr3.TzontPK, class
> > com.ibm.rdc.business.sapr3.Rknbk,
> > > class com.ibm.rdc.business.sapr3.ShipMethPK, class
> > > com.ibm.rdc.business.sapr3.DstXrefPK, class
> > > com.ibm.rdc.business.sapr3.TtxitPK, class
> > > com.ibm.rdc.business.sapr3.ZkvindtPK, class
> > > com.ibm.rdc.business.sapr3.JobMsgPK, class
> > > com.ibm.rdc.business.sapr3.Tvk8tPK, class
> > > com.ibm.rdc.business.sapr3.SdOrgtempPK, class
> > > com.ibm.rdc.business.sapr3.Tprit, class
> > > com.ibm.rdc.business.sapr3.InacxrefPK, class
> > > com.ibm.rdc.business.sapr3.SdValidTaxcd, class
> > > com.ibm.rdc.business.sapr3.AvoidtagPK, class
> > > com.ibm.rdc.business.sapr3.ImetatablePK, class
> > > com.ibm.rdc.business.sapr3.RknvlPK, class
> > com.ibm.rdc.business.sapr3.Tprio,
> > > class com.ibm.rdc.business.sapr3.DpartnerPK, class
> > > com.ibm.rdc.business.sapr3.ConditionPK, class
> > > com.ibm.rdc.business.sapr3.TerritoryLog, class
> > > com.ibm.rdc.business.sapr3.Guictinpctl, class
> > > com.ibm.rdc.business.sapr3.Tvkwz, class
> com.ibm.rdc.business.sapr3.Tvk9t,
> > > class com.ibm.rdc.business.sapr3.CtReqStatus, class
> > > com.ibm.rdc.business.sapr3.CountyRegionPK, class
> > > com.ibm.rdc.business.sapr3.Istxhl, class
> com.ibm.rdc.business.sapr3.Tspa,
> > > class com.ibm.rdc.business.sapr3.RknvvPK, class
> > > com.ibm.rdc.business.sapr3.Bisadr, class
> > > com.ibm.rdc.business.sapr3.TkuktAwfFilterPK, class
> > > com.ibm.rdc.business.sapr3.T009tPK, class
> > > com.ibm.rdc.business.sapr3.T042zPK, class
> > > com.ibm.rdc.business.sapr3.ExtractmsgPK, class
> > > com.ibm.rdc.business.sapr3.CtEmeaIsuconv, class
> > > com.ibm.rdc.business.sapr3.T188PK, class
> > > com.ibm.rdc.business.sapr3.Zkvindt, class
> > > com.ibm.rdc.business.sapr3.Tvk8PK, class
> > com.ibm.rdc.business.sapr3.TparPK,
> > > class com.ibm.rdc.business.sapr3.T151PK, class
> > > com.ibm.rdc.business.sapr3.T014PK, class
> > > com.ibm.rdc.business.sapr3.JobControl, class
> > > com.ibm.rdc.business.sapr3.ClusterLog, class
> > > com.ibm.rdc.business.sapr3.Tskdt, class
> > com.ibm.rdc.business.sapr3.KnvkPK,
> > > class com.ibm.rdc.business.sapr3.Tvf, class
> > > com.ibm.rdc.business.sapr3.RknvpPK, class
> > > com.ibm.rdc.business.sapr3.Tvk3tPK, class
> > > com.ibm.rdc.business.sapr3.NutmegCollt, class
> > > com.ibm.rdc.business.sapr3.Tvast, class
> > > com.ibm.rdc.business.sapr3.ClientDun, class
> > > com.ibm.rdc.business.sapr3.TtxidPK, class
> > > com.ibm.rdc.business.sapr3.Condition, class
> > > com.ibm.rdc.business.sapr3.KnviPK, class
> > > com.ibm.rdc.business.sapr3.Tvk4tPK, class
> > com.ibm.rdc.business.sapr3.Rsadr,
> > > class com.ibm.rdc.business.sapr3.TkuktAwfFilter, class
> > > com.ibm.rdc.business.sapr3.T685, class
> com.ibm.rdc.business.sapr3.Tpart,
> > > class com.ibm.rdc.business.sapr3.T683, class
> > > com.ibm.rdc.business.sapr3.Tvl, class
> com.ibm.rdc.business.sapr3.Tvv5PK,
> > > class com.ibm.rdc.business.sapr3.PoolLogPK, class
> > > com.ibm.rdc.business.sapr3.Tvv3PK, class
> > > com.ibm.rdc.business.sapr3.IknexPK, class
> > com.ibm.rdc.business.sapr3.T009t,
> > > class com.ibm.rdc.business.sapr3.DpredPK, class
> > > com.ibm.rdc.business.sapr3.Tvmst, class
> > com.ibm.rdc.business.sapr3.BnkaPK,
> > > class com.ibm.rdc.business.sapr3.T005PK, class
> > > com.ibm.rdc.business.sapr3.CoverageId, class
> > > com.ibm.rdc.business.sapr3.TvkwzPK, class
> > > com.ibm.rdc.business.sapr3.RknviPK, class
> > > com.ibm.rdc.business.sapr3.Kna1PK, class
> > > com.ibm.rdc.business.rdaccess.UserHasRolePK, class
> > > com.ibm.rdc.business.sapr3.RegionPK, class
> > > com.ibm.rdc.business.sapr3.Sizeinfo, class
> > > com.ibm.rdc.business.sapr3.LogChgCode, class
> > > com.ibm.rdc.business.sapr3.Tvk7t, class
> > > com.ibm.rdc.business.sapr3.ZkvinactPK, class
> > > com.ibm.rdc.business.sapr3.Tpfkt, class
> com.ibm.rdc.business.sapr3.Tsad3,
> > > class com.ibm.rdc.business.sapr3.Iknvi, class
> > > com.ibm.rdc.business.sapr3.Tsabt, class
> > com.ibm.rdc.business.sapr3.Tvk6tPK,
> > > class com.ibm.rdc.business.sapr3.PendAaRuleset, class
> > > com.ibm.rdc.business.sapr3.Iknvl, class
> > com.ibm.rdc.business.sapr3.TincPK,
> > > class com.ibm.rdc.business.sapr3.T005tPK, class
> > > com.ibm.rdc.business.sapr3.Iknvk, class
> com.ibm.rdc.business.sapr3.Iknva,
> > > class com.ibm.rdc.business.sapr3.KnexPK, class
> > > com.ibm.rdc.business.sapr3.KnvaPK, class
> com.ibm.rdc.business.sapr3.Pool,
> > > class com.ibm.rdc.business.sapr3.Loadfilestatus, class
> > > com.ibm.rdc.business.sapr3.Cmrstatus, class
> > > com.ibm.rdc.business.sapr3.Iknvd, class
> > com.ibm.rdc.business.sapr3.BknvpPK,
> > > class com.ibm.rdc.business.sapr3.RsegPK, class
> > > com.ibm.rdc.business.sapr3.Tvbur, class
> > > com.ibm.rdc.business.sapr3.CdGcsFinoblHier, class
> > > com.ibm.rdc.business.sapr3.Avoidtag, class
> > > com.ibm.rdc.business.sapr3.Tvv5tPK, class
> > com.ibm.rdc.business.sapr3.Tvk8t,
> > > class com.ibm.rdc.business.sapr3.SadrPK, class
> > > com.ibm.rdc.business.sapr3.Iknvp, class
> com.ibm.rdc.business.sapr3.Iknvv,
> > > class com.ibm.rdc.business.sapr3.Kna1, class
> > > com.ibm.rdc.business.sapr3.Tbrc, class
> > com.ibm.rdc.business.sapr3.Pkna1PK,
> > > class com.ibm.rdc.business.sapr3.Bknva, class
> > > com.ibm.rdc.business.sapr3.Upload, class
> > com.ibm.rdc.business.sapr3.Bknvd,
> > > class com.ibm.rdc.business.sapr3.Tstl, class
> > > com.ibm.rdc.business.sapr3.T685aPK, class
> > > com.ibm.rdc.business.sapr3.FsExtractReqPK, class
> > > com.ibm.rdc.business.sapr3.Rknb1, class
> > > com.ibm.rdc.business.sapr3.Icommidoc, class
> > > com.ibm.rdc.business.sapr3.T685a, class
> > com.ibm.rdc.business.sapr3.T001PK,
> > > class com.ibm.rdc.business.sapr3.Iseg, class
> > > com.ibm.rdc.business.sapr3.Tvk5t, class
> > com.ibm.rdc.business.sapr3.TcurfPK,
> > > class com.ibm.rdc.business.sapr3.SectorIsuPK, class
> > > com.ibm.rdc.business.sapr3.EmeaLo, class
> > com.ibm.rdc.business.sapr3.Isadr,
> > > class com.ibm.rdc.business.sapr3.Chghistory, class
> > > com.ibm.rdc.business.sapr3.KnbkPK, class
> > > com.ibm.rdc.business.sapr3.Tvk2tPK, class
> > > com.ibm.rdc.business.sapr3.TviptPK, class
> > > com.ibm.rdc.business.rdaccess.User, class
> > > com.ibm.rdc.business.sapr3.Tvk1PK, class
> > com.ibm.rdc.business.sapr3.Tvk0PK,
> > > class com.ibm.rdc.business.sapr3.Loadstatus, class
> > > com.ibm.rdc.business.sapr3.Kna1extLog, class
> > > com.ibm.rdc.business.sapr3.Dfilter, class
> > com.ibm.rdc.business.sapr3.Rkna1,
> > > class com.ibm.rdc.business.sapr3.BknvkPK, class
> > > com.ibm.rdc.business.sapr3.Kna1ext, class
> > > com.ibm.rdc.business.sapr3.AutodelExPK, class
> > > com.ibm.rdc.business.sapr3.BknvlPK, class
> > com.ibm.rdc.business.sapr3.Tvk6t,
> > > class com.ibm.rdc.business.rdaccess.UserHasRole, class
> > > com.ibm.rdc.business.sapr3.FsCriteria, class
> > > com.ibm.rdc.business.sapr3.Region, class
> > > com.ibm.rdc.business.sapr3.Coverage, class
> > > com.ibm.rdc.business.sapr3.Tvp6PK, class
> > com.ibm.rdc.business.sapr3.Tvv2PK,
> > > class com.ibm.rdc.business.sapr3.BisadrPK, class
> > > com.ibm.rdc.business.sapr3.Tvkbz, class
> > > com.ibm.rdc.business.sapr3.CviCovAssign, class
> > > com.ibm.rdc.business.sapr3.BknexPK, class
> > com.ibm.rdc.business.sapr3.T005p,
> > > class com.ibm.rdc.business.sapr3.CtBatchStatus, class
> > > com.ibm.rdc.business.sapr3.TprioPK, class
> > > com.ibm.rdc.business.sapr3.TpaumPK, class
> > com.ibm.rdc.business.sapr3.Tpakd,
> > > class com.ibm.rdc.business.sapr3.Kna1extPK, class
> > > com.ibm.rdc.business.sapr3.TtxerPK, class
> > com.ibm.rdc.business.sapr3.T005t,
> > > class com.ibm.rdc.business.sapr3.CopycfgPK, class
> > > com.ibm.rdc.business.sapr3.T005u, class
> com.ibm.rdc.business.sapr3.T005f,
> > > class com.ibm.rdc.business.sapr3.EmeaLoPK, class
> > > com.ibm.rdc.business.sapr3.Tvkbt, class
> > com.ibm.rdc.business.sapr3.TvkotPK,
> > > class com.ibm.rdc.business.sapr3.Distnr, class
> > > com.ibm.rdc.business.sapr3.Knvv, class
> > com.ibm.rdc.business.sapr3.BknvaPK,
> > > class com.ibm.rdc.business.sapr3.Zkvinacn, class
> > > com.ibm.rdc.business.sapr3.Bknex, class
> com.ibm.rdc.business.sapr3.Knvp,
> > > class com.ibm.rdc.business.sapr3.Zkvinact, class
> > > com.ibm.rdc.business.sapr3.CtPriority, class
> > > com.ibm.rdc.business.sapr3.Pkna1, class
> com.ibm.rdc.business.sapr3.Knvh,
> > > class com.ibm.rdc.business.sapr3.Tvsdt, class
> > > com.ibm.rdc.business.sapr3.Knvi, class
> > > com.ibm.rdc.business.sapr3.Changelog, class
> > > com.ibm.rdc.business.sapr3.Knvk, class com.ibm.rdc.business.sapr3.Knvl,
> > > class com.ibm.rdc.business.sapr3.DispatchTime, class
> > > com.ibm.rdc.business.sapr3.IntAccountPK, class
> > > com.ibm.rdc.business.sapr3.VSiteKnvv, class
> > > com.ibm.rdc.business.sapr3.Knva, class
> > > com.ibm.rdc.business.sapr3.FsExtractReq, class
> > > com.ibm.rdc.business.sapr3.Knvd, class
> > com.ibm.rdc.business.sapr3.BknbkPK,
> > > class com.ibm.rdc.business.sapr3.GmeDunPK, class
> > > com.ibm.rdc.business.sapr3.Skb1PK, class
> > > com.ibm.rdc.business.sapr3.Checkbox, class
> > > com.ibm.rdc.business.sapr3.CustreqPK, class
> > > com.ibm.rdc.business.sapr3.CtBatchStatusPK, class
> > > com.ibm.rdc.business.sapr3.Bkna1PK, class
> > > com.ibm.rdc.business.sapr3.TryForFitRslt, class
> > > com.ibm.rdc.business.sapr3.CoveragePK, class
> > > com.ibm.rdc.business.sapr3.Tsad3tSadr, class
> > > com.ibm.rdc.business.sapr3.IsadrPK, class
> > > com.ibm.rdc.business.sapr3.Territory, class
> > > com.ibm.rdc.business.sapr3.KsskPK, class
> > > com.ibm.rdc.business.rdaccess.UserPropertyVal, class
> > > com.ibm.rdc.business.sapr3.Tvkdt, class
> > > com.ibm.rdc.business.sapr3.Tsad3tPK, class
> > > com.ibm.rdc.business.sapr3.ZzkvSic, class
> > > com.ibm.rdc.business.sapr3.TvsdtPK, class
> > > com.ibm.rdc.business.sapr3.Tvk6PK, class
> > com.ibm.rdc.business.sapr3.T683PK,
> > > class com.ibm.rdc.business.sapr3.T052uAwfFilter, class
> > > com.ibm.rdc.business.sapr3.Tvsbt, class com.ibm.rdc.business.sapr3.Geo,
> > > class com.ibm.rdc.business.sapr3.SubBranchPK, class
> > > com.ibm.rdc.business.sapr3.TzonePK, class
> > > com.ibm.rdc.business.sapr3.Land1MappingPK, class
> > > com.ibm.rdc.business.sapr3.Tvfst, class
> > com.ibm.rdc.business.sapr3.T685PK,
> > > class com.ibm.rdc.business.sapr3.Ilrruleset, class
> > > com.ibm.rdc.business.sapr3.BknviPK, class
> > > com.ibm.rdc.business.sapr3.CtT005extPK, class
> > > com.ibm.rdc.business.sapr3.CoverageLstRunTimestampTmpPK, class
> > > com.ibm.rdc.business.sapr3.TvfPK, class
> > > com.ibm.rdc.business.sapr3.FsCriteriaPK, class
> > > com.ibm.rdc.business.sapr3.RknvkPK, class
> > com.ibm.rdc.business.sapr3.Rseg,
> > > class com.ibm.rdc.business.sapr3.StxhPK, class
> > > com.ibm.rdc.business.sapr3.JobMsg, class
> > com.ibm.rdc.business.sapr3.RulePK,
> > > class com.ibm.rdc.business.sapr3.IntAccount, class
> > > com.ibm.rdc.business.sapr3.Sadr, class
> > com.ibm.rdc.business.sapr3.TvkbzPK,
> > > class com.ibm.rdc.business.sapr3.Tbrct, class
> > > com.ibm.rdc.business.sapr3.Ttxid, class
> > > com.ibm.rdc.business.sapr3.TaguserPK, class
> > > com.ibm.rdc.business.sapr3.Tinct, class
> > com.ibm.rdc.business.sapr3.TvgfPK,
> > > class com.ibm.rdc.business.sapr3.Tvk7tPK, class
> > > com.ibm.rdc.business.sapr3.T052uAwfFilterPK, class
> > > com.ibm.rdc.business.sapr3.Host, class
> > > com.ibm.rdc.business.sapr3.BknvkSadr, class
> > > com.ibm.rdc.business.sapr3.Cluster, class
> > > com.ibm.rdc.business.sapr3.CtLaRegion, class
> > > com.ibm.rdc.business.sapr3.T001wPK, class
> > > com.ibm.rdc.business.sapr3.HierarchyLinksExPK, class
> > > com.ibm.rdc.business.sapr3.Ixftest, class
> > > com.ibm.rdc.business.sapr3.Knb1PK, class
> com.ibm.rdc.business.sapr3.Tinc,
> > > class com.ibm.rdc.business.sapr3.Ttxit, class
> > > com.ibm.rdc.business.sapr3.T001w, class
> > com.ibm.rdc.business.sapr3.GmeDun,
> > > class com.ibm.rdc.business.sapr3.NutmegColltPK, class
> > > com.ibm.rdc.business.sapr3.T016t, class
> > > com.ibm.rdc.business.sapr3.CountryRegion, class
> > > com.ibm.rdc.business.sapr3.TransMedium, class
> > > com.ibm.rdc.business.sapr3.Ttxer, class
> com.ibm.rdc.business.sapr3.JobPK,
> > > class com.ibm.rdc.business.sapr3.IcommaudPK, class
> > > com.ibm.rdc.business.sapr3.Rknvv, class
> > com.ibm.rdc.business.sapr3.TvsbtPK,
> > > class com.ibm.rdc.business.sapr3.T002t, class
> > > com.ibm.rdc.business.sapr3.ChangelogPK, class
> > > com.ibm.rdc.business.sapr3.ZkvinacnPK, class
> > > com.ibm.rdc.business.sapr3.Account, class
> > > com.ibm.rdc.business.sapr3.ThitPK, class
> > > com.ibm.rdc.business.sapr3.CrmRestart, class
> > > com.ibm.rdc.business.sapr3.Tpaer, class
> > com.ibm.rdc.business.sapr3.TspaPK,
> > > class com.ibm.rdc.business.sapr3.Ikna1PK, class
> > > com.ibm.rdc.business.sapr3.LoadjobPK, class
> > > com.ibm.rdc.business.sapr3.Tsad3PK, class
> > com.ibm.rdc.business.sapr3.Tzone,
> > > class com.ibm.rdc.business.sapr3.Tsad3tSadrPK, class
> > > com.ibm.rdc.business.sapr3.TsadvtPK, class
> > com.ibm.rdc.business.sapr3.Bnka,
> > > class com.ibm.rdc.business.sapr3.CtLaRegionPK, class
> > > com.ibm.rdc.business.sapr3.CtActInactStat, class
> > > com.ibm.rdc.business.sapr3.CtEmeaIsuconvPK, class
> > > com.ibm.rdc.business.sapr3.Rknva, class
> com.ibm.rdc.business.sapr3.Tcurc,
> > > class com.ibm.rdc.business.sapr3.Tcurf, class
> > > com.ibm.rdc.business.sapr3.Tcure, class
> > com.ibm.rdc.business.sapr3.Bstxhl,
> > > class com.ibm.rdc.business.sapr3.AutodelEx, class
> > > com.ibm.rdc.business.sapr3.Dpartner, class
> > > com.ibm.rdc.business.sapr3.Rknvd, class
> com.ibm.rdc.business.sapr3.Tcury,
> > > class com.ibm.rdc.business.sapr3.Tzont, class
> > > com.ibm.rdc.business.sapr3.Extractmsg, class
> > > com.ibm.rdc.business.sapr3.Rknvi, class
> > > com.ibm.rdc.business.sapr3.SalesVertical, class
> > > com.ibm.rdc.business.sapr3.CtYesno, class
> > com.ibm.rdc.business.sapr3.Rknvk,
> > > class com.ibm.rdc.business.sapr3.Rknvl, class
> > > com.ibm.rdc.business.sapr3.T016tPK, class
> > com.ibm.rdc.business.sapr3.Tcurr,
> > > class com.ibm.rdc.business.sapr3.Rknvp, class
> > > com.ibm.rdc.business.sapr3.Tcurt, class
> com.ibm.rdc.business.sapr3.Tcurv,
> > > class com.ibm.rdc.business.sapr3.TbrctPK, class
> > > com.ibm.rdc.business.sapr3.Bknb1, class
> > > com.ibm.rdc.business.sapr3.DstNonclonedPK, class
> > > com.ibm.rdc.business.sapr3.OrgMemoryTable, class
> > > com.ibm.rdc.business.sapr3.Skb1, class
> com.ibm.rdc.business.sapr3.TclaPK,
> > > class com.ibm.rdc.business.sapr3.T005fPK, class
> > > com.ibm.rdc.business.sapr3.Tsadvt, class
> > > com.ibm.rdc.business.sapr3.T056xPK, class
> > > com.ibm.rdc.business.sapr3.T077dPK, class
> > > com.ibm.rdc.business.sapr3.InobPK, class
> > > com.ibm.rdc.business.sapr3.TkupaPK, class
> > > com.ibm.rdc.business.sapr3.SubBranch, class
> > > com.ibm.rdc.business.sapr3.Thit, class
> com.ibm.rdc.business.sapr3.Bkna1,
> > > class com.ibm.rdc.business.sapr3.TvgftPK, class
> > > com.ibm.rdc.business.sapr3.Iknbk, class
> > > com.ibm.rdc.business.sapr3.TryForFitRsltPK, class
> > > com.ibm.rdc.business.sapr3.SdOrgtemp, class
> > > com.ibm.rdc.business.sapr3.TpfktPK, class
> > > com.ibm.rdc.business.sapr3.IaleaudPK, class
> > > com.ibm.rdc.business.sapr3.OrgMemoryTablePK, class
> > > com.ibm.rdc.business.sapr3.Tvkt, class
> > com.ibm.rdc.business.sapr3.TsabtPK,
> > > class com.ibm.rdc.business.sapr3.Branch, class
> > > com.ibm.rdc.business.sapr3.TpartPK, class
> > > com.ibm.rdc.business.sapr3.ZzkvSicPK, class
> > > com.ibm.rdc.business.sapr3.Land1Mapping, class
> > > com.ibm.rdc.business.sapr3.Ikna1, class
> > > com.ibm.rdc.business.sapr3.Acctxref, class
> > > com.ibm.rdc.business.sapr3.CceKnvvPK, class
> > > com.ibm.rdc.business.sapr3.Copycfg, class
> > > com.ibm.rdc.business.sapr3.TvlstPK, class
> > > com.ibm.rdc.business.sapr3.IknvvPK, class
> > > com.ibm.rdc.business.sapr3.PartDelivery, class
> > > com.ibm.rdc.business.sapr3.UploadPK, class
> > > com.ibm.rdc.business.sapr3.LegDiscLog, class
> > > com.ibm.rdc.business.sapr3.Tvko, class
> > > com.ibm.rdc.business.sapr3.LedgerKatr6MapPK, class
> > > com.ibm.rdc.business.sapr3.Kna1extLogPK, class
> > > com.ibm.rdc.business.sapr3.Kna1Dun, class
> > > com.ibm.rdc.business.sapr3.Kna1DunPK, class
> > > com.ibm.rdc.business.sapr3.Tpar, class
> > > com.ibm.rdc.business.sapr3.CoverageLstRunTimestampTmp, class
> > > com.ibm.rdc.business.sapr3.Tvv4tPK, class
> > > com.ibm.rdc.business.sapr3.CoverageLstRunTimestamp, class
> > > com.ibm.rdc.business.sapr3.Iknb1, class
> > > com.ibm.rdc.business.sapr3.CoverageLstRunTimestampPK, class
> > > com.ibm.rdc.business.sapr3.TcurtPK, class
> > > com.ibm.rdc.business.sapr3.BknvvPK, class
> > com.ibm.rdc.business.sapr3.Inob,
> > > class com.ibm.rdc.business.sapr3.Sector, class
> > > com.ibm.rdc.business.sapr3.TsavtPK, class
> > > com.ibm.rdc.business.sapr3.Tvk5tPK, class
> > > com.ibm.rdc.business.sapr3.IknvkSadrPK, class
> > > com.ibm.rdc.business.sapr3.IknvpPK, class
> > com.ibm.rdc.business.sapr3.Tvk8,
> > > class com.ibm.rdc.business.sapr3.TvkttPK, class
> > > com.ibm.rdc.business.sapr3.CceKnvpPK, class
> > > com.ibm.rdc.business.sapr3.ClusterLogPK, class
> > > com.ibm.rdc.business.sapr3.Tvk6, class
> com.ibm.rdc.business.sapr3.TvlPK,
> > > class com.ibm.rdc.business.sapr3.Iknex, class
> > > com.ibm.rdc.business.sapr3.Tvk2, class
> > > com.ibm.rdc.business.sapr3.IntAccountLogPK, class
> > > com.ibm.rdc.business.sapr3.Tvk1, class com.ibm.rdc.business.sapr3.Tvk0,
> > > class com.ibm.rdc.business.sapr3.T002, class
> > > com.ibm.rdc.business.sapr3.T001, class
> com.ibm.rdc.business.sapr3.Tvk2PK,
> > > class com.ibm.rdc.business.sapr3.T005, class
> > > com.ibm.rdc.business.sapr3.T052uPK, class
> > > com.ibm.rdc.business.sapr3.TcurePK, class
> > > com.ibm.rdc.business.sapr3.TbrcPK, class
> > > com.ibm.rdc.business.sapr3.ImasteridocPK, class
> > > com.ibm.rdc.business.sapr3.CradDecisionTbl, class
> > > com.ibm.rdc.business.sapr3.Tier, class
> > > com.ibm.rdc.business.sapr3.AccountPK, class
> > > com.ibm.rdc.business.sapr3.ClusterPK, class
> > > com.ibm.rdc.business.sapr3.DdestPK, class
> > > com.ibm.rdc.business.sapr3.LedgerKatr6Map, class
> > > com.ibm.rdc.business.sapr3.Imasteridoc, class
> > > com.ibm.rdc.business.sapr3.T014, class
> > com.ibm.rdc.business.sapr3.IknbkPK,
> > > class com.ibm.rdc.business.sapr3.T151, class
> > > com.ibm.rdc.business.sapr3.Tsad3t, class
> > > com.ibm.rdc.business.sapr3.T005pPK, class
> > > com.ibm.rdc.business.sapr3.PrefMethContact, class
> > > com.ibm.rdc.business.sapr3.T002tPK, class
> > > com.ibm.rdc.business.sapr3.Loadjob, class
> com.ibm.rdc.business.sapr3.Job,
> > > class com.ibm.rdc.business.sapr3.Icommaud, class
> > > com.ibm.rdc.business.sapr3.IstxhlPK, class
> > > com.ibm.rdc.business.sapr3.TvmstPK, class
> > com.ibm.rdc.business.sapr3.Tvgf,
> > > class com.ibm.rdc.business.sapr3.Legxref, class
> > > com.ibm.rdc.business.sapr3.Bknbk, class
> > > com.ibm.rdc.business.sapr3.Custlist, class
> > > com.ibm.rdc.business.sapr3.Remoteaction, class
> > > com.ibm.rdc.business.sapr3.TvtwPK, class
> > > com.ibm.rdc.business.sapr3.TvfstPK, class
> > > com.ibm.rdc.business.sapr3.T151tPK, class
> > > com.ibm.rdc.business.sapr3.KlahPK, class
> > > com.ibm.rdc.business.sapr3.SdValidTaxcdPK, class
> > > com.ibm.rdc.business.sapr3.Tvv1tPK, class
> > > com.ibm.rdc.business.sapr3.CmrstatusPK, class
> > > com.ibm.rdc.business.sapr3.Langid, class
> > com.ibm.rdc.business.sapr3.TskdPK,
> > > class com.ibm.rdc.business.sapr3.IsuSubind, class
> > > com.ibm.rdc.business.sapr3.T151t, class
> > com.ibm.rdc.business.sapr3.Tvv1PK,
> > > class com.ibm.rdc.business.sapr3.Imetatable, class
> > > com.ibm.rdc.business.sapr3.LoadmsgPK, class
> > > com.ibm.rdc.business.sapr3.Tvv1t, class
> > com.ibm.rdc.business.sapr3.TinctPK,
> > > class com.ibm.rdc.business.sapr3.TfactPK, class
> > > com.ibm.rdc.business.sapr3.LoadstatusPK, class
> > > com.ibm.rdc.business.sapr3.GcsFinoblHierPK, class
> > > com.ibm.rdc.business.sapr3.GcsFinoblHier, class
> > > com.ibm.rdc.business.sapr3.Tvv2tPK, class
> > > com.ibm.rdc.business.sapr3.RknbkPK, class
> > com.ibm.rdc.business.sapr3.Tvk4t,
> > > class com.ibm.rdc.business.sapr3.Bknvi, class
> > > com.ibm.rdc.business.sapr3.Custreq, class
> > com.ibm.rdc.business.sapr3.Bknvk,
> > > class com.ibm.rdc.business.sapr3.TvkdtPK, class
> > > com.ibm.rdc.business.sapr3.Bknvl, class
> > com.ibm.rdc.business.sapr3.TskdtPK,
> > > class com.ibm.rdc.business.sapr3.Rknkk, class
> > > com.ibm.rdc.business.sapr3.Tsavt, class
> > com.ibm.rdc.business.sapr3.TvktPK,
> > > class com.ibm.rdc.business.sapr3.Bknvp, class
> > > com.ibm.rdc.business.sapr3.IsuSubindPK, class
> > > com.ibm.rdc.business.sapr3.Ialeaud, class
> > com.ibm.rdc.business.sapr3.Tvv2t,
> > > class com.ibm.rdc.business.sapr3.TkuklPK, class
> > > com.ibm.rdc.business.sapr3.Atab, class
> com.ibm.rdc.business.sapr3.Bknvv,
> > > class com.ibm.rdc.business.sapr3.RknkkPK, class
> > > com.ibm.rdc.business.sapr3.PendRulesetKatr6PK, class
> > > com.ibm.rdc.business.sapr3.Knex, class
> > > com.ibm.rdc.business.sapr3.IcommidocPK, class
> > > com.ibm.rdc.business.sapr3.T188, class
> > com.ibm.rdc.business.sapr3.Loadmsg,
> > > class com.ibm.rdc.business.sapr3.Tvk3t, class
> > > com.ibm.rdc.business.sapr3.Tvk9tPK, class
> > > com.ibm.rdc.business.sapr3.ShipMeth, class
> > > com.ibm.rdc.business.sapr3.Tvv3t, class
> > com.ibm.rdc.business.sapr3.TpaerPK,
> > > class com.ibm.rdc.business.sapr3.FloorLevelChk, class
> > > com.ibm.rdc.business.sapr3.IntAccountLog, class
> > > com.ibm.rdc.business.sapr3.IknvkPK, class
> > com.ibm.rdc.business.sapr3.Tvv1,
> > > class com.ibm.rdc.business.sapr3.Tvv2, class
> > > com.ibm.rdc.business.sapr3.Tvv4t, class
> com.ibm.rdc.business.sapr3.Tvv5,
> > > class com.ibm.rdc.business.sapr3.T188t, class
> > > com.ibm.rdc.business.sapr3.ClientTable, class
> > > com.ibm.rdc.business.sapr3.Tvv3, class
> > com.ibm.rdc.business.sapr3.RknexPK,
> > > class com.ibm.rdc.business.sapr3.Tvv4, class
> > > com.ibm.rdc.business.sapr3.CustdestPK, class
> > > com.ibm.rdc.business.sapr3.AtabPK, class
> com.ibm.rdc.business.sapr3.Tvtw,
> > > class com.ibm.rdc.business.sapr3.TvstPK, class
> > > com.ibm.rdc.business.sapr3.Tvsb, class
> > com.ibm.rdc.business.sapr3.Taguser,
> > > class com.ibm.rdc.business.sapr3.Tvk2t, class
> > > com.ibm.rdc.business.sapr3.Tvipt, class
> > com.ibm.rdc.business.sapr3.Rknb1PK,
> > > class com.ibm.rdc.business.sapr3.Tkupa, class
> > > com.ibm.rdc.business.sapr3.T005uPK, class
> > com.ibm.rdc.business.sapr3.Tvsd,
> > > class com.ibm.rdc.business.sapr3.TvburPK, class
> > > com.ibm.rdc.business.sapr3.T056x, class
> com.ibm.rdc.business.sapr3.Tvv5t,
> > > class com.ibm.rdc.business.sapr3.TcurrPK, class
> > > com.ibm.rdc.business.sapr3.Tvst, class
> > com.ibm.rdc.business.sapr3.Tvk1tPK,
> > > class com.ibm.rdc.business.sapr3.Tskd, class
> > > com.ibm.rdc.business.sapr3.T077d, class
> com.ibm.rdc.business.sapr3.Tvk1t,
> > > class com.ibm.rdc.business.sapr3.BstxhlPK, class
> > > com.ibm.rdc.business.sapr3.Bknb1PK, class
> > com.ibm.rdc.business.sapr3.T077x,
> > > class com.ibm.rdc.business.sapr3.PoolLog, class
> > > com.ibm.rdc.business.sapr3.Extractstatus, class
> > > com.ibm.rdc.business.sapr3.BknvkSadrPK, class
> > > com.ibm.rdc.business.sapr3.TstlPK, class
> > com.ibm.rdc.business.sapr3.Tvkot,
> > > class com.ibm.rdc.business.sapr3.DstNoncloned, class
> > > com.ibm.rdc.business.sapr3.TcuryPK, class
> > > com.ibm.rdc.business.sapr3.JobControlPK, class
> > > com.ibm.rdc.business.sapr3.Tvro, class
> > com.ibm.rdc.business.sapr3.TvastPK,
> > > class com.ibm.rdc.business.sapr3.Tvlst, class
> > > com.ibm.rdc.business.sapr3.TcurvPK, class
> > > com.ibm.rdc.business.sapr3.LogChgCodePK, class
> > > com.ibm.rdc.business.sapr3.RsadrPK, class
> > > com.ibm.rdc.business.sapr3.VKnvpUnion1, class
> > > com.ibm.rdc.business.sapr3.Tclu, class
> com.ibm.rdc.business.sapr3.PoolPK,
> > > class com.ibm.rdc.business.sapr3.Inacxref, class
> > > com.ibm.rdc.business.sapr3.Tcla, class
> com.ibm.rdc.business.sapr3.Tvk0t,
> > > class com.ibm.rdc.business.sapr3.BranchPK, class
> > > com.ibm.rdc.business.sapr3.ExtractstatusPK, class
> > > com.ibm.rdc.business.sapr3.TcluPK, class
> > > com.ibm.rdc.business.sapr3.CustlistPK, class
> > > com.ibm.rdc.business.sapr3.RknvaPK, class
> > > com.ibm.rdc.business.sapr3.Pmasteridoc, class
> > > com.ibm.rdc.business.sapr3.TcurcPK, class
> > > com.ibm.rdc.business.sapr3.KnvlPK, class
> > > com.ibm.rdc.business.sapr3.PmasteridocPK, class
> > > com.ibm.rdc.business.sapr3.GeoPK, class
> > > com.ibm.rdc.business.sapr3.PendRulesetKatr6, class
> > > com.ibm.rdc.business.sapr3.DfilterPK, class
> > > com.ibm.rdc.business.sapr3.HierarchyLinksEx, class
> > > com.ibm.rdc.business.sapr3.IknvkSadr, class
> > > com.ibm.rdc.business.sapr3.IknvaPK, class
> > > com.ibm.rdc.business.sapr3.IknvlPK, class
> > > com.ibm.rdc.business.sapr3.TvkoPK, class
> > com.ibm.rdc.business.sapr3.Tvgft,
> > > class com.ibm.rdc.business.sapr3.KnvpPK, class
> > > com.ibm.rdc.business.sapr3.Ddest, class
> > > com.ibm.rdc.business.sapr3.SectorPK, class
> > com.ibm.rdc.business.sapr3.Rule,
> > > class com.ibm.rdc.business.sapr3.Knb1, class
> > > com.ibm.rdc.business.sapr3.Iknb1PK, class
> > > com.ibm.rdc.business.sapr3.ChghistoryPK, class
> > > com.ibm.rdc.business.sapr3.SectorIsu, class
> > > com.ibm.rdc.business.sapr3.TkuktPK, class
> > > com.ibm.rdc.business.sapr3.SalesVerticalPK, class
> > > com.ibm.rdc.business.sapr3.Klah, class
> > com.ibm.rdc.business.sapr3.RknvdPK,
> > > class com.ibm.rdc.business.sapr3.KnvvPK, class
> > > com.ibm.rdc.business.sapr3.AcctxrefPK, class
> > > com.ibm.rdc.business.sapr3.Knb5, class
> > > com.ibm.rdc.business.sapr3.SizeinfoPK, class
> > > com.ibm.rdc.business.sapr3.KnvhPK, class
> com.ibm.rdc.business.sapr3.Stxl,
> > > class com.ibm.rdc.business.sapr3.Tkukt, class
> > > com.ibm.rdc.business.sapr3.T189tPK, class
> > > com.ibm.rdc.business.sapr3.IknvdPK, class
> > > com.ibm.rdc.business.sapr3.CceKnvp, class
> > > com.ibm.rdc.business.sapr3.TpritPK, class
> > com.ibm.rdc.business.sapr3.Tfact,
> > > class com.ibm.rdc.business.sapr3.CdGcsFinoblHierPK, class
> > > com.ibm.rdc.business.sapr3.Stxh, class
> > > com.ibm.rdc.business.sapr3.CoverageIdPK, class
> > > com.ibm.rdc.business.sapr3.TvroPK, class
> > com.ibm.rdc.business.sapr3.Tkukl,
> > > class com.ibm.rdc.business.sapr3.CceKnvv, class
> > > com.ibm.rdc.business.sapr3.BknvdPK, class
> > > com.ibm.rdc.business.sapr3.Tvv3tPK, class
> > com.ibm.rdc.business.sapr3.Tvktt,
> > > class com.ibm.rdc.business.sapr3.StxlPK, class
> > > com.ibm.rdc.business.sapr3.Rknex, class
> > > com.ibm.rdc.business.sapr3.Custdest, class
> > > com.ibm.rdc.business.sapr3.T189t, class
> com.ibm.rdc.business.sapr3.T052u,
> > > class com.ibm.rdc.business.sapr3.T042z, class
> > > com.ibm.rdc.business.sapr3.Kssk, class
> > com.ibm.rdc.business.sapr3.VCceOrg,
> > > class com.ibm.rdc.business.sapr3.CviCovAssignPK, class
> > > com.ibm.rdc.business.sapr3.CtT005ext, class
> > > com.ibm.rdc.business.sapr3.CountryRegionPK, class
> > > com.ibm.rdc.business.sapr3.T188tPK, class
> > > com.ibm.rdc.business.sapr3.TvsdPK, class
> > > com.ibm.rdc.business.sapr3.TerritoryLogPK, class
> > > com.ibm.rdc.business.sapr3.Dpred, class
> com.ibm.rdc.business.sapr3.Tvp6,
> > > class com.ibm.rdc.business.sapr3.Knbk, class
> >
> > > t10.prst2, t10.pruin, t10.spras, t10.uinln, t10.umrwrt, t10.waers,
> > > t10.wechf, t10.xaddr, t10.xanzum, t10.xdezp, t10.xegld, t10.xland,
> > > t10.xmwsn, t10.xplpf, t10.xplst, t10.xprbk, t10.xprso, t10.xregs,
> > > t10.xskfn, t11.counc, t11.LAND1, t11.mandt, t11.regio, t11.spras,
> > > t11.bezei, t12.LAND1, t12.mandt, t12.spras, t12.landx, t12.natio,
> > > t13.bland, t13.LAND1, t13.mandt, t13.spras, t13.bezei, t14.mandt,
> > > t14.periv, t14.spras, t14.ltext, t15.BRSCH, t15.mandt, t15.spras,
> > > t15.brtxt, t16.KTOKD, t16.mandt, t16.spras, t16.txt30, t17.braco,
> > > t17.mandt, t17.vtext, t17.spras, t18.braco, t18.mandt, t18.vtext,
> > > t18.spras, t19.braco, t19.mandt, t19.vtext, t19.spras, t20.braco,
> > > t20.mandt, t20.vtext, t20.spras, t21.braco, t21.mandt, t21.vtext,
> > > t21.spras, t22.mandt, t22.waers, t22.altwr, t22.gdatu, t22.isocd,
> > t6.TELBX,
> > > t6.TELF1, t6.TELF2, t6.TELFX, t6.TELTX, t6.TELX1, t23.ident, t23.abbr,
> > > t23.aktbjahr, t23.aktvjahr, t23.basis, t23.bjahr, t23.crdat,
> t23.crtime,
> > > t23.crusr, t23.ditag, t23.dotag, t23.fetag, t23.frtag, t23.hocid,
> > > t23.interv, t23.miwch, t23.motag, t23.satag, t23.sotag, t23.vjahr,
> > > t24.ident, t24.spras, t24.ltext, t25.kukla, t25.mandt, t25.spras,
> > > t25.vtext, t26.client, t26.langu, t26.title, t26.TITLE_MEDI, t27.aufsp,
> > > t27.mandt, t27.spras, t27.vtext, t28.faksp, t28.mandt, t28.spras,
> > > t28.vtext, t29.gform, t29.mandt, t30.katr10, t30.mandt, t31.katr10,
> > > t31.mandt, t31.spras, t31.vtext, t32.katr1, t32.mandt, t32.spras,
> > > t32.vtext, t33.katr2, t33.mandt, t33.spras, t33.vtext, t34.katr3,
> > > t34.mandt, t34.spras, t34.vtext, t35.katr4, t35.mandt, t35.spras,
> > > t35.vtext, t36.katr5, t36.mandt, t36.spras, t36.vtext, t37.katr6,
> > > t37.mandt, t37.spras, t37.vtext, t38.katr7, t38.mandt, t38.spras,
> > > t38.vtext, t39.katr8, t39.mandt, t39.spras, t39.vtext, t40.katr9,
> > > t40.mandt, t40.spras, t40.vtext, t41.lifsp, t41.mandt, t41.spras,
> > > t41.vtext, t6.TXJCD, t42.LAND1, t42.mandt, t42.spras, t42.zone1,
> > t42.vtext,
> > > t6.UMJAH, t6.UMSA1, t6.UMSAT, t6.UWAER, t6.VBUND, t6.WERKS, t6.XCPDK,
> > > t6.XZEMP, t43.mandt, t43.ZZKV_INAC, t43.ZZKV_INACT, t43.ZZKV_ACD,
> > > t43.ZZKV_ACT, t43.ZZKV_ASSIST_IND, t43.ZZKV_CTRYNX, t43.ZZKV_DESC,
> > > t43.ZZKV_GCM, t43.ZZKV_HQ_LOCATION, t43.ZZKV_HQCC,
> t43.ZZKV_INAC_NAMEAB,
> > > t43.ZZKV_INAC_SUPER, t43.ZZKV_TOP_CUST, t44.mandt, t44.spras,
> > > t44.ZZKV_INACT, t44.ZZKV_DESC, t6.ZZKV_CUSNO, t6.ZZKV_DEPT,
> t6.ZZKV_DUNS,
> > > t6.ZZKV_ESTAB, t6.ZZKV_INAC, t6.ZZKV_INACT, t6.ZZKV_INTFUNC,
> > > t6.ZZKV_INTLOC, t6.ZZKV_INTUSER, t6.ZZKV_LIC, t6.ZZKV_LOTID,
> > t6.ZZKV_NODE1,
> > > t6.ZZKV_NODE2, t6.ZZKV_ORG_FLG, t6.ZZKV_PARTYID, t6.ZZKV_SEQNO,
> > > t6.ZZKV_SIC, t45.bran1, t45.brsch, t45.mandt, t45.ZZKV_GEO,
> t45.ZZKV_SIC,
> > > t45.BRAN1_DESC, t45.BRSCH_DESC, t45.CREATE_TMSTMP, t45.CREATE_USERID,
> > > t45.UPD_TMSTMP, t45.UPD_USERID, t45.ZZKV_SIC_DESC, t6.ZZKV_SNDX_NAME1,
> > > t6.ZZKV_SNDX_NAME2, t6.ZZKV_TIER, t6.ZZKV_UC_STRT_ADDR, t0.konda,
> > t0.ktgrd,
> > > t0.kurst, t0.kvakz, t0.kvawt, t0.kvgr1, t0.kvgr2, t0.kvgr3, t0.kvgr4,
> > > t0.kvgr5, t0.kzazu, t0.kztlf, t0.lifsd, t0.loevm, t0.lprio, t0.mrnkz,
> > > t46.kztlf, t46.text, t0.perfk, t0.perrl, t0.pltyp, t0.prat1, t0.prat2,
> > > t0.prat3, t0.prat4, t0.prat5, t0.prat6, t0.prat7, t0.prat8, t0.prat9,
> > > t0.prata, t0.prfre, t0.SAP_TS, t0.SHAD_UPDATE_IND, t0.SHAD_UPDATE_TS,
> > > t47.mandt, t47.spras, t47.ztagg, t47.zterm, t47.text1, t48.kdgrp,
> > > t48.mandt, t48.spras, t48.ktext, t49.konda, t49.mandt, t49.spras,
> > > t49.vtext, t50.mandt, t50.pltyp, t50.spras, t50.ptext, t51.CURC_OLD,
> > > t51.mandt, t51.cause, t51.CURC_NEW, t52.mandt, t52.spras, t52.waers,
> > > t52.ktext, t52.ltext, t53.ident, t53.spras, t53.ltext, t54.ident,
> > > t54.spras, t54.ltext, t55.inco1, t55.mandt, t55.ortob, t56.inco1,
> > > t56.mandt, t56.spras, t56.bezei, t57.lprio, t57.mandt, t57.spras,
> > > t57.bezei, t58.aufsp, t58.mandt, t58.spras, t58.vtext, t59.faksp,
> > > t59.mandt, t59.spras, t59.vtext, t60.mandt, t60.spras, t60.vkbur,
> > > t60.bezei, t61.mandt, t61.spart, t61.vkbur, t61.vkorg, t61.vtweg,
> > > t62.kalks, t62.mandt, t62.spras, t62.vtext, t63.mandt, t63.spras,
> > > t63.vkorg, t63.vtext, t64.ktgrd, t64.mandt, t64.spras, t64.vtext,
> > > t65.mandt, t65.vkorg, t65.vtweg, t65.werks, t66.lifsp, t66.mandt,
> > > t66.spras, t66.vtext, t67.mandt, t67.spras, t67.vsbed, t67.vtext,
> > > t68.mandt, t68.spras, t68.stgku, t68.bezei20, t69.kvgr1, t69.mandt,
> > > t69.spras, t69.bezei, t70.kvgr2, t70.mandt, t70.spras, t70.bezei,
> > > t71.kvgr3, t71.mandt, t71.spras, t71.bezei, t72.kvgr4, t72.mandt,
> > > t72.spras, t72.bezei, t73.kvgr5, t73.mandt, t73.spras, t73.bezei,
> > t0.versg,
> > > t0.vkbur, t0.vkgrp, t0.vsbed, t0.vsort, t0.vwerk, t0.waers, t0.zterm
> FROM
> > > SAPR3.KNVV t0 LEFT OUTER JOIN SAPR3.Checkbox t1 ON t0.loevm = t1.flag
> > LEFT
> > > OUTER JOIN SAPR3.Checkbox t2 ON t0.kzazu = t2.flag LEFT OUTER JOIN
> > > SAPR3.Checkbox t3 ON t0.loevm = t3.flag LEFT OUTER JOIN SAPR3.Checkbox
> t4
> > > ON t0.mrnkz = t4.flag LEFT OUTER JOIN SAPR3.CLIENT_TABLE t5 ON t0.mandt
> =
> > > t5.client LEFT OUTER JOIN SAPR3.KNA1 t6 ON t0.kunnr = t6.KUNNR AND
> > t0.mandt
> > > = t6.MANDT LEFT OUTER JOIN SAPR3.PART_DELIVERY t46 ON t0.kztlf =
> > t46.kztlf
> > > LEFT OUTER JOIN SAPR3.T052u t47 ON t0.mandt = t47.mandt AND t0.zterm =
> > > t47.zterm LEFT OUTER JOIN SAPR3.T151t t48 ON t0.mandt = t48.mandt AND
> > > t0.kdgrp = t48.kdgrp LEFT OUTER JOIN SAPR3.T188t t49 ON t0.mandt =
> > > t49.mandt AND t0.konda = t49.konda LEFT OUTER JOIN SAPR3.T189t t50 ON
> > > t0.mandt = t50.mandt AND t0.pltyp = t50.pltyp LEFT OUTER JOIN
> SAPR3.Tcure
> > > t51 ON t0.mandt = t51.mandt AND t0.waers = t51.CURC_OLD LEFT OUTER JOIN
> > > SAPR3.Tcurt t52 ON t0.mandt = t52.mandt AND t0.waers = t52.waers LEFT
> > OUTER
> > > JOIN SAPR3.Tfact t53 ON t0.perfk = t53.ident LEFT OUTER JOIN
> SAPR3.Tfact
> > > t54 ON t0.perrl = t54.ident LEFT OUTER JOIN SAPR3.Tinc t55 ON t0.mandt
> =
> > > t55.mandt AND t0.inco1 = t55.inco1 LEFT OUTER JOIN SAPR3.Tinct t56 ON
> > > t0.mandt = t56.mandt AND t0.inco1 = t56.inco1 LEFT OUTER JOIN
> SAPR3.Tprit
> > > t57 ON t0.mandt = t57.mandt AND t0.lprio = t57.lprio LEFT OUTER JOIN
> > > SAPR3.Tvast t58 ON t0.mandt = t58.mandt AND t0.aufsd = t58.aufsp LEFT
> > OUTER
> > > JOIN SAPR3.TVFST t59 ON t0.mandt = t59.mandt AND t0.faksd = t59.faksp
> > LEFT
> > > OUTER JOIN SAPR3.Tvkbt t60 ON t0.mandt = t60.mandt AND t0.vkbur =
> > t60.vkbur
> > > LEFT OUTER JOIN SAPR3.Tvkbz t61 ON t0.mandt = t61.mandt AND t0.vkorg =
> > > t61.vkorg AND t0.vtweg = t61.vtweg AND t0.spart = t61.spart AND
> t0.vkbur
> > =
> > > t61.vkbur LEFT OUTER JOIN SAPR3.Tvkdt t62 ON t0.mandt = t62.mandt AND
> > > t0.kalks = t62.kalks LEFT OUTER JOIN SAPR3.Tvkot t63 ON t0.mandt =
> > > t63.mandt AND t0.vkorg = t63.vkorg LEFT OUTER JOIN SAPR3.Tvktt t64 ON
> > > t0.mandt = t64.mandt AND t0.ktgrd = t64.ktgrd LEFT OUTER JOIN
> SAPR3.Tvkwz
> > > t65 ON t0.mandt = t65.mandt AND t0.vkorg = t65.vkorg AND t0.vtweg =
> > > t65.vtweg AND t0.vwerk = t65.werks LEFT OUTER JOIN SAPR3.TVLST t66 ON
> > > t0.mandt = t66.mandt AND t0.lifsd = t66.lifsp LEFT OUTER JOIN
> SAPR3.Tvsbt
> > > t67 ON t0.mandt = t67.mandt AND t0.vsbed = t67.vsbed LEFT OUTER JOIN
> > > SAPR3.Tvsdt t68 ON t0.mandt = t68.mandt AND t0.versg = t68.stgku LEFT
> > OUTER
> > > JOIN SAPR3.Tvv1t t69 ON t0.mandt = t69.mandt AND t0.kvgr1 = t69.kvgr1
> > LEFT
> > > OUTER JOIN SAPR3.Tvv2t t70 ON t0.mandt = t70.mandt AND t0.kvgr2 =
> > t70.kvgr2
> > > LEFT OUTER JOIN SAPR3.Tvv3t t71 ON t0.mandt = t71.mandt AND t0.kvgr3 =
> > > t71.kvgr3 LEFT OUTER JOIN SAPR3.Tvv4t t72 ON t0.mandt = t72.mandt AND
> > > t0.kvgr4 = t72.kvgr4 LEFT OUTER JOIN SAPR3.Tvv5t t73 ON t0.mandt =
> > > t73.mandt AND t0.kvgr5 = t73.kvgr5 LEFT OUTER JOIN SAPR3.CLIENT_TABLE
> t7
> > ON
> > > t6.MANDT = t7.client LEFT OUTER JOIN SAPR3.T001w t8 ON t6.MANDT =
> > t8.MANDT
> > > AND t6.WERKS = t8.werks LEFT OUTER JOIN SAPR3.T002T t9 ON t6.SPRAS =
> > > t9.SPRSL LEFT OUTER JOIN SAPR3.T005 t10 ON t6.MANDT = t10.MANDT AND
> > > t6.LAND1 = t10.LAND1 LEFT OUTER JOIN SAPR3.T005f t11 ON t6.MANDT =
> > > t11.mandt AND t6.LAND1 = t11.LAND1 AND t6.REGIO = t11.regio AND
> t6.COUNC
> > =
> > > t11.counc LEFT OUTER JOIN SAPR3.T005T t12 ON t6.MANDT = t12.mandt AND
> > > t6.LAND1 = t12.LAND1 LEFT OUTER JOIN SAPR3.T005U t13 ON t6.MANDT =
> > > t13.mandt AND t6.LAND1 = t13.LAND1 AND t6.REGIO = t13.bland LEFT OUTER
> > JOIN
> > > SAPR3.T009t t14 ON t6.MANDT = t14.mandt AND t6.PERIV = t14.periv LEFT
> > OUTER
> > > JOIN SAPR3.T016T t15 ON t6.MANDT = t15.mandt AND t6.BRSCH = t15.BRSCH
> > LEFT
> > > OUTER JOIN SAPR3.T077X t16 ON t6.MANDT = t16.mandt AND t6.KTOKD =
> > t16.KTOKD
> > > LEFT OUTER JOIN SAPR3.TBRCT t17 ON t6.MANDT = t17.mandt AND t6.BRAN1 =
> > > t17.braco LEFT OUTER JOIN SAPR3.TBRCT t18 ON t6.MANDT = t18.mandt AND
> > > t6.BRAN2 = t18.braco LEFT OUTER JOIN SAPR3.TBRCT t19 ON t6.MANDT =
> > > t19.mandt AND t6.BRAN3 = t19.braco LEFT OUTER JOIN SAPR3.TBRCT t20 ON
> > > t6.MANDT = t20.mandt AND t6.BRAN4 = t20.braco LEFT OUTER JOIN
> SAPR3.TBRCT
> > > t21 ON t6.MANDT = t21.mandt AND t6.BRAN5 = t21.braco LEFT OUTER JOIN
> > > SAPR3.Tcurc t22 ON t6.MANDT = t22.mandt AND t6.UWAER = t22.waers LEFT
> > OUTER
> > > JOIN SAPR3.Tfacd t23 ON t6.KNAZK = t23.ident LEFT OUTER JOIN
> SAPR3.Tfact
> > > t24 ON t6.KNAZK = t24.ident AND t6.SPRAS = t24.spras LEFT OUTER JOIN
> > > SAPR3.TKUKT t25 ON t6.MANDT = t25.mandt AND t6.KUKLA = t25.kukla LEFT
> > OUTER
> > > JOIN SAPR3.Tsad3t t26 ON t6.MANDT = t26.client AND t6.ANRED =
> > > t26.TITLE_MEDI LEFT OUTER JOIN SAPR3.Tvast t27 ON t6.MANDT = t27.mandt
> > AND
> > > t6.AUFSD = t27.aufsp LEFT OUTER JOIN SAPR3.TVFST t28 ON t6.MANDT =
> > > t28.mandt AND t6.FAKSD = t28.faksp LEFT OUTER JOIN SAPR3.Tvgf t29 ON
> > > t6.MANDT = t29.mandt AND t6.GFORM = t29.gform LEFT OUTER JOIN
> SAPR3.Tvk0
> > > t30 ON t6.MANDT = t30.mandt AND t6.KATR10 = t30.katr10 LEFT OUTER JOIN
> > > SAPR3.TVK0T t31 ON t6.MANDT = t31.mandt AND t6.KATR10 = t31.katr10 LEFT
> > > OUTER JOIN SAPR3.TVK1T t32 ON t6.MANDT = t32.mandt AND t6.KATR1 =
> > t32.katr1
> > > LEFT OUTER JOIN SAPR3.Tvk2t t33 ON t6.MANDT = t33.mandt AND t6.KATR2 =
> > > t33.katr2 LEFT OUTER JOIN SAPR3.TVK3T t34 ON t6.MANDT = t34.mandt AND
> > > t6.KATR3 = t34.katr3 LEFT OUTER JOIN SAPR3.TVK4T t35 ON t6.MANDT =
> > > t35.mandt AND t6.KATR4 = t35.katr4 LEFT OUTER JOIN SAPR3.Tvk5t t36 ON
> > > t6.MANDT = t36.mandt AND t6.KATR5 = t36.katr5 LEFT OUTER JOIN
> SAPR3.TVK6T
> > > t37 ON t6.MANDT = t37.mandt AND t6.KATR6 = t37.katr6 LEFT OUTER JOIN
> > > SAPR3.TVK7T t38 ON t6.MANDT = t38.mandt AND t6.KATR7 = t38.katr7 LEFT
> > OUTER
> > > JOIN SAPR3.Tvk8t t39 ON t6.MANDT = t39.mandt AND t6.KATR8 = t39.katr8
> > LEFT
> > > OUTER JOIN SAPR3.TVK9T t40 ON t6.MANDT = t40.mandt AND t6.KATR9 =
> > t40.katr9
> > > LEFT OUTER JOIN SAPR3.TVLST t41 ON t6.MANDT = t41.mandt AND t6.LIFSD =
> > > t41.lifsp LEFT OUTER JOIN SAPR3.TZONT t42 ON t6.MANDT = t42.mandt AND
> > > t6.LAND1 = t42.LAND1 AND t6.LZONE = t42.zone1 LEFT OUTER JOIN
> > > SAPR3.ZKVINACN t43 ON t6.MANDT = t43.mandt AND t6.ZZKV_INACT =
> > > t43.ZZKV_INACT AND t6.ZZKV_INAC = t43.ZZKV_INAC LEFT OUTER JOIN
> > > SAPR3.Zkvinact t44 ON t6.MANDT = t44.mandt AND t6.ZZKV_INACT =
> > > t44.ZZKV_INACT LEFT OUTER JOIN SAPR3.ZZKV_SIC t45 ON t6.MANDT =
> t45.mandt
> > > AND t6.ZZKV_SIC = t45.ZZKV_SIC WHERE t0.kunnr = ? AND t0.mandt = ? AND
> > > t0.spart = ? AND t0.vkorg = ? AND t0.vtweg = ?  optimize for 1 row
> > [params=
> > > (String) 0060718462, (String) 030, (String) 00, (String) 0147, (String)
> > C]
> > > 43344  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL
> -
> > <t
> > > 1181369962, conn 1860595430> [640 ms] spent
> > > log4j:WARN No appenders could be found for logger
> > > (com.ibm.rdc.business.sapr3.entitylisteners.KNA1_Listener).
> > > KNA1_Listener.preUpdate()
> > > log4j:WARN Please initialize the log4j system properly.
> > > KNVV_Listener.preUpdate
> > > 44594  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL
> -
> > <t
> > > 1181369962, conn 1860595430> executing prepstmnt 1319259810 UPDATE
> > > SAPR3.PART_DELIVERY SET text = ? WHERE kztlf = ? [params=(String)
> Partial
> > > delivery allowed, (String)  ]
> > > 44704  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL
> -
> > <t
> > > 1181369962, conn 1860595430> [110 ms] spent
> > > 44704  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL
> -
> > <t
> > > 1181369962, conn 1860595430> executing prepstmnt 1761372412 UPDATE
> > > SAPR3.KNA1 SET MANDT = ?, ABRVW = ?, ADRNR = ?, ANRED = ?, AUFSD = ?,
> > BAHNE
> > > = ?, BAHNS = ?, BBBNR = ?, BBSNR = ?, BEGRU = ?, BRAN1 = ?, BRAN2 = ?,
> > > BRAN3 = ?, BRAN4 = ?, BRAN5 = ?, BRSCH = ?, BUBKZ = ?, CITYC = ?, CIVVE
> > > = ?, COUNC = ?, CREATE_OPT_NUM = ?, DATLT = ?, DEAR1 = ?, DEAR2 = ?,
> > DEAR3
> > > = ?, DEAR4 = ?, DEAR5 = ?, DTAMS = ?, DTAWS = ?, DUEFL = ?, EKONT = ?,
> > > ERDAT = ?, ERNAM = ?, ETIKG = ?, EXABL = ?, FAKSD = ?, FISKN = ?, GFORM
> > > = ?, HZUOR = ?, INSPATDEBI = ?, INSPBYDEBI = ?, JMJAH = ?, JMZAH = ?,
> > KATR1
> > > = ?, KATR10 = ?, KATR2 = ?, KATR3 = ?, KATR4 = ?, KATR5 = ?, KATR6 = ?,
> > > KATR7 = ?, KATR8 = ?, KATR9 = ?, KDKG1 = ?, KDKG2 = ?, KDKG3 = ?, KDKG4
> > > = ?, KDKG5 = ?, KNAZK = ?, KNRZA = ?, KONZS = ?, KTOCD = ?, KTOKD = ?,
> > > KUKLA = ?, LAND1 = ?, LIFNR = ?, LIFSD = ?, LOCCO = ?, LOEVM = ?, LZONE
> > > = ?, MCOD1 = ?, MCOD2 = ?, MCOD3 = ?, MILVE = ?, NAME1 = ?, NAME2 = ?,
> > > NAME3 = ?, NAME4 = ?, NIELS = ?, ORT01 = ?, ORT02 = ?, PERIV = ?, PFACH
> > > = ?, PFORT = ?, PSTL2 = ?, PSTLZ = ?, REGIO = ?, RESTRICT_CD = ?, RPMKR
> > > = ?, SAP_TS = ?, SHAD_UPDATE_IND = ?, SHAD_UPDATE_TS = ?, SORTL = ?,
> > SPERR
> > > = ?, SPERZ = ?, SPRAS = ?, STCD1 = ?, STCD2 = ?, STCEG = ?, STKZA = ?,
> > > STKZN = ?, STKZU = ?, STRAS = ?, WERKS = ? [params=(String) 030,
> > (String) ,
> > > (String) , (String) , (String) IN, (String) , (String) , (String)
> > 0000000,
> > > (String) 00000, (String) US, (String) FA, (String) , (String) ,
> > (String) ,
> > > (String) , (String) 04, (String) 0, (String) , (String)  , (String) ,
> > > (String) 1, (String) , (String)  , (String)  , (String)  , (String)  ,
> > > (String)  , (String)  , (String) , (String)  , (String) , (String)
> > > 20070920, (String) CCE_BP_USER, (String) , (String)  , (String) ,
> > > (String) , (String) , (String) 00, (String)  , (String)  , (String)
> 0000,
> > > (String) 000000, (String) , (String) , (String) , (String) 9,
> (String) ,
> > > (String) , (String) 897, (String) , (String) , (String) , (String) ,
> > > (String) , (String) , (String) , (String) , (String) , (String) ,
> > > (String) , (String) , (String) ZS01, (String) 11, (String) US,
> (String) ,
> > > (String) CE, (String) , (String)  , (String) Z000000001, (String)
> > > ORG20070803, (String) , (String) CITYYY, (String)  , (String)
> > org20070803,
> > > (String) , (String) sitename3, (String) , (String) , (String) cityyy,
> > > (String) , (String) , (String) , (String) , (String) , (String) 33487,
> > > (String) FL, (String)    , (String) , (Timestamp) 2007-12-13
> 14:16:15.0,
> > > (String) U, (Timestamp) 2007-12-13 14:16:15.0, (String) org2007080,
> > > (String)  , (String)  , (String) E, (String) , (String) A000,
> (String) ,
> > > (String)  , (String)  , (String)  , (String) streete, (null) null]
> > > 44969  RDCBusinessComponent  TRACE  [P=621171:O=0:CT] openjpa.jdbc.SQL
> -
> > <t
> > > 1181369962, conn 1860595430> [265 ms] spent
> > > KNA1_Listener.postUpdate()
> > > KNVV_Listener.postUpdate()
> > > <openjpa-1.2.2-r422266:898935 fatal store error>
> > > org.apache.openjpa.persistence.RollbackException: AN UPDATE, INSERT, OR
> > SET
> > > VALUE IS NULL, BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES.
> > > SQLCODE=-407, SQLSTATE=23502, DRIVER=3.58.81
> > >        at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> > > EntityManagerImpl.java:523)
> > >        at com.ibm.rdc.business.sapr3.manager.KnvvManager.updateKnvv(
> > > KnvvManager.java:133)
> > >        at com.ibm.rdc.business.rdaccess.impl.UserRoles.updateRole(
> > > UserRoles.java:417)
> > >        at com.ibm.rdc.business.rdaccess.impl.UserRoles.main(
> > > UserRoles.java:296)
> > > Caused by: <openjpa-1.2.2-r422266:898935 nonfatal general error>
> > > org.apache.openjpa.persistence.PersistenceException: AN UPDATE, INSERT,
> > OR
> > > SET VALUE IS NULL, BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES.
> > > SQLCODE=-407, SQLSTATE=23502, DRIVER=3.58.81
> > > FailedObject: prepstmnt 1761372412 UPDATE SAPR3.KNA1 SET MANDT = ?,
> ABRVW
> > > = ?, ADRNR = ?, ANRED = ?, AUFSD = ?, BAHNE = ?, BAHNS = ?, BBBNR = ?,
> > > BBSNR = ?, BEGRU = ?, BRAN1 = ?, BRAN2 = ?, BRAN3 = ?, BRAN4 = ?, BRAN5
> > > = ?, BRSCH = ?, BUBKZ = ?, CITYC = ?, CIVVE = ?, COUNC = ?,
> > CREATE_OPT_NUM
> > > = ?, DATLT = ?, DEAR1 = ?, DEAR2 = ?, DEAR3 = ?, DEAR4 = ?, DEAR5 = ?,
> > > DTAMS = ?, DTAWS = ?, DUEFL = ?, EKONT = ?, ERDAT = ?, ERNAM = ?, ETIKG
> > > = ?, EXABL = ?, FAKSD = ?, FISKN = ?, GFORM = ?, HZUOR = ?, INSPATDEBI
> > = ?,
> > > INSPBYDEBI = ?, JMJAH = ?, JMZAH = ?, KATR1 = ?, KATR10 = ?, KATR2 = ?,
> > > KATR3 = ?, KATR4 = ?, KATR5 = ?, KATR6 = ?, KATR7 = ?, KATR8 = ?, KATR9
> > > = ?, KDKG1 = ?, KDKG2 = ?, KDKG3 = ?, KDKG4 = ?, KDKG5 = ?, KNAZK = ?,
> > > KNRZA = ?, KONZS = ?, KTOCD = ?, KTOKD = ?, KUKLA = ?, LAND1 = ?, LIFNR
> > > = ?, LIFSD = ?, LOCCO = ?, LOEVM = ?, LZONE = ?, MCOD1 = ?, MCOD2 = ?,
> > > MCOD3 = ?, MILVE = ?, NAME1 = ?, NAME2 = ?, NAME3 = ?, NAME4 = ?, NIELS
> > > = ?, ORT01 = ?, ORT02 = ?, PERIV = ?, PFACH = ?, PFORT = ?, PSTL2 = ?,
> > > PSTLZ = ?, REGIO = ?, RESTRICT_CD = ?, RPMKR = ?, SAP_TS = ?,
> > > SHAD_UPDATE_IND = ?, SHAD_UPDATE_TS = ?, SORTL = ?, SPERR = ?, SPERZ
> = ?,
> > > SPRAS = ?, STCD1 = ?, STCD2 = ?, STCEG = ?, STKZA = ?, STKZN = ?, STKZU
> > > = ?, STRAS = ?, WERKS = ?
> > [org.apache.openjpa.jdbc.kernel.JDBCStoreManager
> > > $CancelPreparedStatement]
> > >        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(
> > > DBDictionary.java:4246)
> > >        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(
> > > DBDictionary.java:4211)
> > >        at org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(
> > > DB2Dictionary.java:504)
> > >        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> > > SQLExceptions.java:102)
> > >        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(
> > > SQLExceptions.java:72)
> > >        at
> > > com.ibm.ws.persistence.jdbc.kernel.PreparedStatementManagerImpl.flush(
> > > PreparedStatementManagerImpl.java:170)
> > >        at
> > org.apache.openjpa.jdbc.kernel.OperationOrderUpdateManager.flush(
> > > OperationOrderUpdateManager.java:105)
> > >        at
> > > com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.flush(
> > > OperationOrderUpdateManager.java:93)
> > >        at
> > > com.ibm.ws.persistence.jdbc.kernel.OperationOrderUpdateManager.flush(
> > > OperationOrderUpdateManager.java:75)
> > >        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(
> > > JDBCStoreManager.java:721)
> > >        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(
> > > DelegatingStoreManager.java:130)
> > >        at org.apache.openjpa.kernel.BrokerImpl.flush
> > (BrokerImpl.java:2029)
> > >        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(
> > > BrokerImpl.java:1927)
> > >        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(
> > > BrokerImpl.java:1845)
> > >        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(
> > > LocalManagedRuntime.java:81)
> > >        at org.apache.openjpa.kernel.BrokerImpl.commit
> > (BrokerImpl.java:1369)
> > >        at org.apache.openjpa.kernel.DelegatingBroker.commit(
> > > DelegatingBroker.java:877)
> > >        at org.apache.openjpa.persistence.EntityManagerImpl.commit(
> > > EntityManagerImpl.java:512)
> > >        ... 3 more
> > > Caused by: com.ibm.db2.jcc.am.oo: AN UPDATE, INSERT, OR SET VALUE IS
> > NULL,
> > > BUT THE OBJECT COLUMN  CANNOT CONTAIN NULL VALUES. SQLCODE=-407,
> > > SQLSTATE=23502, DRIVER=3.58.81
> > >        at com.ibm.db2.jcc.am.ed.a(ed.java:672)
> > >        at com.ibm.db2.jcc.am.ed.a(ed.java:60)
> > >        at com.ibm.db2.jcc.am.ed.a(ed.java:127)
> > >        at com.ibm.db2.jcc.am.tm.b(tm.java:2192)
> > >        at com.ibm.db2.jcc.am.tm.c(tm.java:2175)
> > >        at com.ibm.db2.jcc.t4.fb.k(fb.java:355)
> > >        at com.ibm.db2.jcc.t4.fb.a(fb.java:61)
> > >        at com.ibm.db2.jcc.t4.t.a(t.java:50)
> > >        at com.ibm.db2.jcc.t4.vb.b(vb.java:218)
> > >        at com.ibm.db2.jcc.am.um.jc(um.java:2860)
> > >        at com.ibm.db2.jcc.am.um.b(um.java:3795)
> > >        at com.ibm.db2.jcc.am.um.ac(um.java:709)
> > >        at com.ibm.db2.jcc.am.um.executeUpdate(um.java:692)
> > >        at
> > > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(
> > > DelegatingPreparedStatement.java:269)
> > >        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
> > > $LoggingConnection$LoggingPreparedStatement.executeUpdate(
> > > LoggingConnectionDecorator.java:864)
> > >        at
> > > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(
> > > DelegatingPreparedStatement.java:269)
> > >        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager
> > > $CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1590)
> > >        at
> > > com.ibm.ws.persistence.jdbc.kernel.PreparedStatementManagerImpl.flush(
> > > PreparedStatementManagerImpl.java:112)
> > >        ... 15 more
> > >
> > >
> >
> >
>
> ======================================================================================
>
> >
> > >
> > >
> > > Thanks & Regards,
> > > Prabhat Sharma
> > >
> > >
> > >
> > >
> > > From:   Kevin Sutter <kwsutter@gmail.com>
> > > To:     dev@openjpa.apache.org
> > > Date:   03/07/2012 11:44 AM
> > > Subject:        Re: Critical issue (Blocker): missing fields in update
> > >             statement
> > >
> > >
> > >
> > > Hi,
> > > None of your attachments came through, so I can't comment directly.
> But,
> > I
> > > have a couple of observations...
> > >
> > > You mention one Entity with 66 fields and 46 relationships.  And,
> another
> > > Entity definition has 141 fields.  Really?  Are you trying to map to an
> > > existing database schema?  If not, I would reconsider your object model
> > > since these numbers sound a bit excessive.  Even if you are working
> with
> > an
> > > existing schema, is there any possibility of modifying the schema?  I'm
> > not
> > > saying that the number of attributes/relationships per Entity is the
> > cause
> > > of your issue.  But, I would say that complicated Entities like this
> will
> > > also complicate your application development and test cycle.
> > >
> > > I also have to ask whether you are using the EM.merge() method
> correctly?
> > > Are the entities (Knw) detached from the persistence context?  And,
> > that's
> > > why you are merging them in?  FYI, normal updating of Entities while
> > being
> > > managed by an EntityManager (ie. persistence context) do not have to be
> > > merged.  The changes just need to be committed to the database.  I just
> > > wanted to clarify the proper, expected usage of the JPA programming
> > model.
> > >
> > > As far as why not all of the attributes are being processed, I have no
> > > idea.  I would suggest turning on Trace and seeing if there any clues
> as
> > to
> > > why the processing is not completing as expected.
> > >
> > > Good luck,
> > > Kevin
> > >
> > > On Mon, Mar 5, 2012 at 7:09 PM, Prabhat Sharma2
> > > <prabhatsharma@in.ibm.com>wrote:
> > >
> > > >
> > > > Environment:
> > > >
> > > > OS: Windows XP
> > > > IDE:  IBM Rational® Software Architect for WebSphere Software
> (Version:
> > > > 8.0.3)
> > > > WAS: 6.1
> > > > OpenJPA:  1.2.2
> > > >
> > > >
> > > > Thanks & Regards,
> > > > Prabhat Sharma
> > > >
> > > >
> > > >
> > > >
> > > > From:   Prabhat Sharma2/India/IBM
> > > > To:     dev@openjpa.apache.org, dev-help@openjpa.apache.org
> > > > Cc:     Umamaheswari Subramanian/India/IBM, Vasudevan
> > > >            Mogan/India/IBM@IBMIN, Ashish Nema1/India/IBM@IBMIN, Peri
> > > >            Sujata/India/IBM@IBMIN, Hariom Soni1/India/IBM@IBMIN
> > > > Date:   03/05/2012 08:07 PM
> > > > Subject:        Critical issue (Blocker): missing fields in update
> > > > statement
> > > >
> > > >
> > > > Hello Team,
> > > >
> > > > We have some problem while updating an entity via entityManager's
> > update
> > > > method (generated by RSA8.0.3).
> > > >
> > > > Environment:
> > > > OS: Windows XP
> > > > IDE:  IBM Rational® Software Architect for WebSphere Software
> (Version:
> > > > 8.0.3)
> > > > WAS: 6.1
> > > >
> > > >
> > > > This entity has around 66 fields and  42  ManyToOne  & 4 OneToMany.
> > > > relationships. While update, it is calling update for all relational
> > > > entities.
> > > >
> > > > For one of the oneToMany relationship table KNA1  (attaching the
> > entity),
> > > > the update is not appending all fields of the entity and last field
> > field
> > > > value is appearing like  " (null) null]". This entity has around 141
> > > > fields.
> > > > Attaching the main entity (Knvv) which I am updating.
> > > >
> > > > [attachment "Knvv.java" deleted by Prabhat Sharma2/India/IBM]
> > > > [attachment "KnvvPK.java" deleted by Prabhat Sharma2/India/IBM]
> > > >
> > > > Here is the entity which has OneToMany relationship.
> > > >
> > > >
> > > >
> > > > [attachment "Kna1.java" deleted by Prabhat Sharma2/India/IBM]
> > > > [attachment "Kna1PK.java" deleted by Prabhat Sharma2/India/IBM]
> > > >
> > > >
> > > > Attaching the error log.
> > > >
> > > > [attachment "ErrorLog.txt" deleted by Prabhat Sharma2/India/IBM]
> > > >
> > > > Attaching persistence.xml also.
> > > >
> > > > [attachment "persistence.xml" deleted by Prabhat Sharma2/India/IBM]
> > > >
> > > > Please help me resolving the issue.
> > > >
> > > >
> > > > I am updating an entity by using the below entityManager:
> > > >
> > > > @Action(Action.ACTION_TYPE.UPDATE)
> > > >        public String updateKnvv(Knvv knvv) throws Exception {
> > > >                EntityManager em = getEntityManager();
> > > >                try {
> > > >                        em.getTransaction().begin();
> > > >                        knvv = em.merge(knvv);
> > > >                        em.getTransaction().commit();
> > > >                } catch (Exception ex) {
> > > >                        try {
> > > >                                if (em.getTransaction().isActive()) {
> > > >                                        em.getTransaction().rollback
> ();
> > > >                                }
> > > >                        } catch (Exception e) {
> > > >                                ex.printStackTrace();
> > > >                                throw e;
> > > >                        }
> > > >                        throw ex;
> > > >                } finally {
> > > >                        em.close();
> > > >                }
> > > >                return "";
> > > >        }
> > > >
> > > >
> > > > Thanks & Regards,
> > > > Prabhat Sharma
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message