Bug in WLS 8.1 sp2 <include-updates> ? - Weblogic

This is a discussion on Bug in WLS 8.1 sp2 <include-updates> ? - Weblogic ; I am running WLS 8.1 sp2 on Windows XP &amp; Windows Server. Using CMP 2.0 to access an Oracle 8.1.7 Database using the Thin Driver from OJDBC14.jar. I have set the tag on our control tables to "Exclusive" which according ...

+ Reply to Thread
Results 1 to 6 of 6

Thread: Bug in WLS 8.1 sp2 <include-updates> ?

  1. Bug in WLS 8.1 sp2 <include-updates> ?


    I am running WLS 8.1 sp2 on Windows XP & Windows Server. Using CMP 2.0 to access
    an Oracle 8.1.7 Database using the Thin Driver from OJDBC14.jar.

    I have set the tag on our control tables to "Exclusive"
    which according to the documentation makes the default to true.

    We create a control table of 8,000+ rows. The findByPrimary does not find all
    of the rows added the database.

    However if I replace all the findByPrimaryKey with a "custom" finder i.e.

    findByKey1Key2Key3 and have a;

    SELECT OBJECT(c) FROM TableC AS c WHERE k1 = ?1 AND k2 = ?2 AND k3 = ?3 in weblogic-ejb-jar.xml

    It works! Any ideas?



  2. Re: Bug in WLS 8.1 sp2 <include-updates> ?

    "Roger Lee" wrote in message news:409a3bb6@newsgroups.bea.com...
    > I am running WLS 8.1 sp2 on Windows XP & Windows Server. Using CMP 2.0 to access
    > an Oracle 8.1.7 Database using the Thin Driver from OJDBC14.jar.
    >
    > I have set the tag on our control tables to "Exclusive"
    > which according to the documentation makes the default to true.
    >
    > We create a control table of 8,000+ rows. The findByPrimary does not find all
    > of the rows added the database.
    >
    > However if I replace all the findByPrimaryKey with a "custom" finder i.e.
    >
    > findByKey1Key2Key3 and have a;
    >
    > SELECT OBJECT(c) FROM TableC AS c WHERE k1 = ?1 AND k2 = ?2 AND k3 = ?3 in weblogic-ejb-jar.xml
    >
    > It works! Any ideas?



    Show us your compound PK.

    Regards,

    Slava Imeshev



  3. Re: Bug in WLS 8.1 sp2 <include-updates> ?

    Verify that the "correct" sql is generated. To see the sql statements
    add the following system property:
    -Dweblogic.ejb20.cmp.rdbms.codegen.verbose=true

    Best regards...

    Roger Lee wrote:
    > I am running WLS 8.1 sp2 on Windows XP & Windows Server. Using CMP 2.0 to access
    > an Oracle 8.1.7 Database using the Thin Driver from OJDBC14.jar.
    >
    > I have set the tag on our control tables to "Exclusive"
    > which according to the documentation makes the default to true.
    >
    > We create a control table of 8,000+ rows. The findByPrimary does not find all
    > of the rows added the database.
    >
    > However if I replace all the findByPrimaryKey with a "custom" finder i.e.
    >
    > findByKey1Key2Key3 and have a;
    >
    > SELECT OBJECT(c) FROM TableC AS c WHERE k1 = ?1 AND k2 = ?2 AND k3 = ?3 in weblogic-ejb-jar.xml
    >
    > It works! Any ideas?
    >
    >


  4. Re: Bug in WLS 8.1 sp2 <include-updates> ?


    It works in unit test when 200-300 rows are retrieved to add to our control table.
    Problem only started when it went into system test and 8,000+ rows are retrieved.


    Moe wrote:
    >Verify that the "correct" sql is generated. To see the sql statements
    >
    >add the following system property:
    >-Dweblogic.ejb20.cmp.rdbms.codegen.verbose=true
    >
    >Best regards...
    >
    >Roger Lee wrote:
    >> I am running WLS 8.1 sp2 on Windows XP & Windows Server. Using CMP

    >2.0 to access
    >> an Oracle 8.1.7 Database using the Thin Driver from OJDBC14.jar.
    >>
    >> I have set the tag on our control tables to

    >"Exclusive"
    >> which according to the documentation makes the default

    >to true.
    >>
    >> We create a control table of 8,000+ rows. The findByPrimary does not

    >find all
    >> of the rows added the database.
    >>
    >> However if I replace all the findByPrimaryKey with a "custom" finder

    >i.e.
    >>
    >> findByKey1Key2Key3 and have a;
    >>
    >> SELECT OBJECT(c) FROM TableC AS c WHERE k1 = ?1 AND k2 = ?2 AND k3

    >= ?3 in weblogic-ejb-jar.xml
    >>
    >> It works! Any ideas?
    >>
    >>



  5. Re: Bug in WLS 8.1 sp2 <include-updates> ?


    "Roger Lee" wrote:
    >
    >It works in unit test when 200-300 rows are retrieved to add to our control
    >table.
    >Problem only started when it went into system test and 8,000+ rows are
    >retrieved.
    >
    >


    So there's one table 'A' that has rows inserted into it, and findByPrimary is
    being used to query that table 'A" to get the data and insert it into the 'control
    table'. Is this happening in parallel, that is, is table 'A' being populated
    while the 'control table' is being worked on ? If so, maybe the 'control table'
    logic is outrunning the insertion of rows into table 'A'

    -thorick


  6. Re: Bug in WLS 8.1 sp2 <include-updates> ?


    I read a table and extract x number of row from a Report Requests table. The 3
    Primary keys of the Report Requests table are used to create a row in our Control
    table.

    I then process the x Report Requests and update the Control table with quantities,
    dates, times etc.

    It is as I process these reports and do a findByPrimaryKey on the Control table
    I get the finderExceptions. All the rows in the Control table have now been created.

    The problem does not happen when I extract up to 300 report requests. It only
    started when the report requests total was 8,000.

    I have rewritten the findByPrimary key as a custom finder and it works fine on
    the 8,000 report requests.

    It is as though findByPrimaryKey does not use even though it
    is the default.

    Thanks.


    "thorick" wrote:
    >
    >"Roger Lee" wrote:
    >>
    >>It works in unit test when 200-300 rows are retrieved to add to our

    >control
    >>table.
    >>Problem only started when it went into system test and 8,000+ rows are
    >>retrieved.
    >>
    >>

    >
    >So there's one table 'A' that has rows inserted into it, and findByPrimary
    >is
    >being used to query that table 'A" to get the data and insert it into
    >the 'control
    >table'. Is this happening in parallel, that is, is table 'A' being
    >populated
    >while the 'control table' is being worked on ? If so, maybe the 'control
    >table'
    >logic is outrunning the insertion of rows into table 'A'
    >
    >-thorick
    >



+ Reply to Thread