Home » Search

About length

1-10 of 108Refresh
Manual
107

Strings in JPQL and Criteria Queries

. LENGTH - Counting Characters in a String The LENGTH(str) function returns the number of characters in the argument string as an int. For example: LENGTH('United States') is evaluated to 13. LENGTH ... - Getting a Portion of a String The SUBSTRING(str, pos [, length]) function returns a substring
JDO Doc
88

Column.length

Annotation Element javax.jdo.annotations.Column int length Maximum length of data stored in this column. Returns: the maximum length of data stored in this column Default value: -1 Since: JDO 2.1
JPA Doc
88

length(x)

Method javax.persistence.criteria.CriteriaBuilder Expression length(   Expression x ) Create expression to return length of a string. Parameters: x - string expression Returns: length expression Since: JPA 2.0
JPA Doc
86

Column.length

Annotation Element javax.persistence.Column int length (Optional) The column length. (Applies only if a string-valued column is used.) Default value: 255 Since: JPA 1.0
JPA Doc
86

DiscriminatorColumn.length

Annotation Element javax.persistence.DiscriminatorColumn int length (Optional) The column length for String-based discriminator types. Ignored for other discriminator types. Default value: 31 Since: JPA 1.0
JPA Doc
86

MapKeyColumn.length

Annotation Element javax.persistence.MapKeyColumn int length (Optional) The column length. (Applies only if a string-valued column is used.) Default value: 255 Since: JPA 2.0
Manual
30

FROM clause (JPQL / Criteria API)

but cannot be one of the following reserved words: ABS, ALL, AND, ANY, AS, ASC, AVG, BETWEEN, BIT_LENGTH, BOTH, BY, CASE, CHAR_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT, CURRENT_DATE, CURRENT_TIME, CURRENT ... , IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD
Forum
28

Multi part paths in a composite index must have the same length

must have the same length. Therefore, the following index definition is invalid: @Entity @Index(members ... issue with enabling such an index. A composite index with components of different lengths is forbidden
Manual
26

Index Definition

for every entity. Multi part paths in a composite index must have the same length. Therefore, the following ... for executing the following query: SELECT d FROM Document d JOIN d.words w WHERE LENGTH(w) >= 10 ... of the words and is not ordered by the length of the words. The bottom line is that if there is an index
Manual
15

GROUP BY and HAVING clauses

SUBSTRING(c.name, 1, 1); The query returns Object[] arrays of length 3, in which the first cell