OFBiz
  1. OFBiz
  2. OFBIZ-836

Bug in SqlJdbcUtil.java regarding outer join in oracle theta join mode

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: framework
    • Labels:
      None

      Description

      There is a problem in SqlJdbcUtil.java class regarding outer join in oracle, becase the sould be in the end of the Left/Right hand not in the first

      The following line (number: 344):
      if (isOracleStyle && viewLink.isRelOptional()) whereString.append(" ");

      Should be placed after the following lines:
      whereString.append(viewLink.getRelEntityAlias());
      whereString.append(".");
      whereString.append(filterColName(relLinkField.getColName()));

      as the patch in the attached file

      1. change.patch
        0.9 kB
        Mamdouh Kaadan

        Activity

        Hide
        Mamdouh Kaadan added a comment -

        Patch regarding SqlJdbcUtil.java

        Show
        Mamdouh Kaadan added a comment - Patch regarding SqlJdbcUtil.java
        Hide
        Jacopo Cappellato added a comment -

        Are we sure about this? We have some customers running OFBiz with Oracle and they have never reported this bug.
        Is there a quick way to recreate it?
        Which Oracle version and JDBC driver (and its version) are you using?

        Show
        Jacopo Cappellato added a comment - Are we sure about this? We have some customers running OFBiz with Oracle and they have never reported this bug. Is there a quick way to recreate it? Which Oracle version and JDBC driver (and its version) are you using?

          People

          • Assignee:
            Unassigned
            Reporter:
            Mamdouh Kaadan
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development