Home » Search

About like

11-20 of 200Refresh
Forum
22

like operator (String)

i from User i where i.status = :status and (UPPER(i.email) like :value) Now we assume ... the example user. The like statment operates like "test%"  EclispeLink/OpenJPA/HibernateJPA handles the like stament like an exact search '='. This JPA impls returns an empty list. This behaviour isn't
Forum
21

Help: After upgrading from 2.2.8_02 to 2.2.8_04, can't perform LIKE query

Hi,   AFter the upgrade from 2.2.8_02 (not sure if it was build 03/04 as I skipped 03) - my LIKE ... FROM Company $1 WHERE ((($1.companyId LIKE :p1) AND ($1.conditionOne=true)) AND ((($1.conditionTwo ... it.    This release carries out the grouping and likes correctly.   Thanks!   Willks
Forum
21

Like fails if both underscore and percent are used

When using a like query that has both _ and % in it, ObjectDB seems to fail. Here is a unit test to demonstrate:   import org.junit.*; import javax.persistence.*; import javax.persistence ... FROM StringHolder holder WHERE holder.content LIKE :filter"; Query query = em.createQuery
Forum
21

Does ObjectDB has a similar feature like Oracle Database Change Notification ?

Hi, I am evaluating ObjectDB because its JPA/JDO features, I am wondering is there a similar feature like Oracle Database Change Notification( http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm ), with which multiple application servers can get notified when something changed in
Forum
20

Can you implement fastest Native JPA for MySQL by ClusterJ like?

Can you implement fastest Native JPA for MySQL by ClusterJ like?
Result
13

ObjectDB Object Database Features

could start using ObjectDB immediately. SQL-like (but object based) query language - familiar ... - JPQL and JDOQL. Query Languages JPQL - Java Persistence (JPA) Query Language - SQL like syntax. JDOQL - Java Data Objects (JDO) Query Language - Java/SQL like syntax. Query Definition and API Dynamic
Manual
9

JPA Query Expressions (JPQL / Criteria)

] MEMBER [OF] and the [NOT] LIKE operator. Logical operators: AND, OR, NOT. In addition, JPA queries ... , sqrt). String expressions (like, length, locate, lower, upper, concat, substring, ...). Data
Manual
9

Retrieving JPA Entity Objects

employee = em.getReference(Employee.class, 1); The getReference method works like the find method ... of the developer it looks like the entire graph of objects is present in memory. This illusion, which is based
Manual
9

SELECT clause (JPQL / Criteria API)

c WHERE c.name LIKE 'I%' Both Italy and Ireland (whose name starts with 'I') use Euro as ... WHERE c.name LIKE 'I%' The only difference between SELECT and SELECT DISTINCT is that the later
JPA Doc
8

javax.persistence.criteria.CriteriaBuilder

- expression y - expression Returns: less-than-or-equal predicate Since: JPA 2.0 Predicate like( Expression ... . Parameters: x - string expression pattern - string Returns: like predicate Since: JPA 2.0 Predicate like ... the given pattern. Parameters: x - string expression pattern - string expression Returns: like predicate