list = em.createNamedQuery("getById ")
.setParameter("idValue ", "IS")
I am passing parameter string value as a "IS" to the named query but my named query is not returning any list. If I pass with white spaces "IS " it is retrieving.
I don't want to pad with spaces, I would like to pass only "IS". Even I don't want to use Oracle trim function in my named query. trim (training from t.id) -- I don't want to use this (I know it works with this option)
If I execute sql query in database it works fine. Select * from Table where id = 'IS'; - it shows the rows
Why named query not retrieving the results, how to indicate namedquery to ignore char spaces while executing query?
How to get the result from naedquery without using these two above options. Could someone please help me with this issue?