glassfish
  1. glassfish
  2. GLASSFISH-13673

SQL NOT EQUAL operator support for Symfoware

    Details

    • Type: Task Task
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 3.1
    • Fix Version/s: V3
    • Component/s: cmp
    • Labels:
      None
    • Environment:

      Operating System: Windows XP
      Platform: All

    • Issuezilla Id:
      13,673

      Description

      Previously, the NOT EQUAL operator was hardcoded as "!=", so the SQL statement
      generated for a query containing NOT EQUAL had the "!=" operator. Unfortunately
      Symfoware database does not support the "!=" operator. The attached patch fixes
      this issue by removing the hardcoded "!=" and doing a getNotEqual() which
      returns "<>" for Symfoware and "!=" for other databases. This issue was
      discovered when running cmp CTS tests. The patch fix has been tested on both
      Symfoware and Derby successfully.

        Activity

        Hide
        anoman added a comment -

        Created an attachment (id=4992)
        Patch to add support for NOT EQUAL operator for Symfoware

        Show
        anoman added a comment - Created an attachment (id=4992) Patch to add support for NOT EQUAL operator for Symfoware
        Hide
        Dies Koper added a comment -

        Applied Noman's patch:

        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\Bundle.properties
        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\Bundle_ja.properties
        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\DBVendorType.java
        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\SQL92.properties
        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\SYMFOWARE.propertie
        s
        Sending
        persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\sql\generator\Statement.java

        Sending
        persistence\common\src\main\resources\org\glassfish\persistence\common\VendorNameToTypeMapping.properties
        Transmitting file data .......
        Committed revision 41262.

        Show
        Dies Koper added a comment - Applied Noman's patch: Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\Bundle.properties Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\Bundle_ja.properties Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\DBVendorType.java Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\SQL92.properties Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\database\SYMFOWARE.propertie s Sending persistence\cmp\support-sqlstore\src\main\java\com\sun\jdo\spi\persistence\support\sqlstore\sql\generator\Statement.java Sending persistence\common\src\main\resources\org\glassfish\persistence\common\VendorNameToTypeMapping.properties Transmitting file data ....... Committed revision 41262.

          People

          • Assignee:
            Mitesh Meswani
            Reporter:
            anoman
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: