ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh
173

LIKE wildcard with single character "_" behaves like a "*"

Hi, I've been using pattern matching with wildcards, and encountered an issue when dealing with the underscore character. The issue is that if it is placed at the end of the string, the "_" behaves like a "*". For example, if I have a query SELECT * FROM table1 WHERE (col1.name LIKE "ke
128

Help with 'not like/lower' query

Criteria with a combination of LOWER/UPPER - NOT LIKE: SELECT COUNT($1.id) FROM User $1 WHERE ($1.owningCompany=:p1) AND LOWER($1.email) NOT LIKE :p2 So in essence, I'm trying to do a count ... .LIKE)){ predicate = criteriaBuilder.like(criteriaBuilder.lower(path), stringProp
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<T> x, Expression<T> pattern, char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression escapeChar - escape character Returns: like predicate Since: JPA 2.0
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<T> x, String pattern, Expression<T> escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character expression Returns: like predicate Since: JPA 2.0
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, String pattern, char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string escapeChar - escape character Returns: like predicate Since: JPA 2.0
74

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, String pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string Returns: like predicate Since: JPA 2.0
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, String pattern, Expression<Character> escapeChar ) Create a predicate for testing whether the expression ... character expression Returns: like predicate Since: JPA 2.0
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, Expression<String> pattern, char escapeChar ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression escapeChar - escape character Returns: like predicate Since: JPA 2.0
74

like(x, pattern)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, Expression<String> pattern ) Create a predicate for testing whether the expression satisfies the given pattern. Parameters: x - string expression pattern - string expression Returns: like predicate Since: JPA 2.0
74

like(x, pattern, escapeChar)

Method javax.persistence.criteria.CriteriaBuilder Predicate like( Expression<String> x, Expression<String> pattern, Expression<Character> escapeChar ) Create a predicate for testing ... escapeChar - escape character expression Returns: like predicate Since: JPA 2.0

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support