Menu
I want to perform search for a particular string that is starting with a particular alphabet.
So, for example if the starting alphabet is 'A' then it should produce a result which will contain all the strings with alphabet 'A'.
How do I achieve this ?
My query is as shown below:
Query qry = session.createQuery("From RegistrationBean as rb where rb."+searchCriteria+" like %?%"); qry.setString(0,searchField); 
440
Well, LIKE operator is usually used with textual data i.e. with VARCHAR or CHAR columns, and you have numeric id column (INTEGER). Maybe you could try to map id field also as string and use that field in query. This may or may not work depending on your database engine.
Keywords like SELECT, FROM, and WHERE, etc., are not case sensitive, but properties like table and column names are case sensitive in HQL.
You can add the DISTINCT keyword to your query to tell Hibernate to return each Author entity only once. But as you can see in the following log messages, Hibernate also adds the DISTINCT keyword to the SQL query. This is often not intended and might result in an efficient database query.
Change your query to this:
Query qry = session.createQuery("From RegistrationBean as rb where rb."+searchCriteria+" like ?"); qry.setString(0, "%"+searchField+"%"); You can use criteria for using like
session = sessionFactory.openSession(); Criteria query = session.createCriteria(Pojo.class); query.add(Restrictions.like("column", "a", MatchMode.START)); It will give you the list of string which start by alpha-bate 'a'.
42
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
