Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 9.1pe
    • Fix Version/s: not determined
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      3,549
    • Status Whiteboard:
      Hide

      HIGH

      Show
      HIGH

      Description

      Hi,
      in my opinion it is not always necessary to cast a LIKE expression to
      VARCHAR(32672) when sending a query to an IBM AS400 DB2 database.
      This leads to a very hight cpu load compared to a regular prepared statement.

      Oracle TopLink Essentials - 2.0 (Build b58-rc1 (08/05/2007)
      JDBC JTOpen 6.0

        Activity

        Hide
        pkrogh added a comment -

        Priority lowered to P4 as this is unlikely for this release.

        It would be helpful if you could let me know when this cast is necessary and
        when it is not.

        Show
        pkrogh added a comment - Priority lowered to P4 as this is unlikely for this release. It would be helpful if you could let me know when this cast is necessary and when it is not.
        Hide
        vjordan added a comment -

        I dont know why this casting is necessary at all.

        I can not see any differences in the result with or without the casting.

        If the casting is necessary, the length could be determined by the length of the
        value by the setParameter method or by a length annotation of the field.

        Show
        vjordan added a comment - I dont know why this casting is necessary at all. I can not see any differences in the result with or without the casting. If the casting is necessary, the length could be determined by the length of the value by the setParameter method or by a length annotation of the field.
        Hide
        gfbugbridge added a comment -

        <BT6598450>

        Show
        gfbugbridge added a comment - <BT6598450>
        Hide
        Tom Mueller added a comment -

        Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

        Show
        Tom Mueller added a comment - Bulk change to set fix version to "not determined" where the issue is open but the value is for a released version.

          People

          • Assignee:
            tware
            Reporter:
            vjordan
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: