Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Rejected
    • Affects versions: None
    • Fix versions: None
    • Labels:
      None
    • Environment:
      Oracle 11
      Spring boot 1.3.3 and 1.4.1
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      Hello,

      I have this scenario: a table on DBMS Oracle 11 whit a column defined as CYR NVARCHAR2(255 CHAR) necessary to store cyrillic characters (ex š).

      The classe and the interface defined as:

      public class Dummy extends EntityWithCreationUpdateTime implements Serializable {
      
      @Nationalized
      @Column(columnDefinition = "NVARCHAR2(255)")
      private String cyr;
      
      // setter and getter
      
      }
      
      
      public interface DummyRepository extends JpaRepository<Dummy, Long>, JpaSpecificationExecutor<Dummy> {
      	Dummy findByCyr(String cyr);
      	Dummy findByCyrIgnoreCase(String cyr);
      }
      

      when finding with findByCyr("charšandother"); the object is returned, instead the findByCyrIgnoreCase("charšandother") returns null.

      From the log I can see that with findByCyr binding is done with NVARCHAR:
      o.h.type.descriptor.sql.BasicBinder binding parameter [1] as [NVARCHAR] - [charšandother]

      When using findByCyrIgnoreCase binding is done with VARCHAR:
      o.h.type.descriptor.sql.BasicBinder binding parameter [1] as [VARCHAR] - [charšandother]

      By now the value in the database is lower case "charšandother", in other fields defined as VARCHAR2 everything works fine, the binding is done correctly and the object is returned by the IgnoreCase method.

        Attachments

          Issue links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: