ObjectDB Database Search

1-50 of 64 results

Strings in JPQL and Criteria Queries

) represents a real % character. 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 ('China') is evaluated to 5. LOCATE - Locating Substrings The LOCATE

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 ... , HAVING, IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH , LIKE,LOCATE, LOWER, MAX, MEMBER, MIN

@Column length is not working.

(unique = true, nullable = false, length = 16)  but when i m trying to insert a string ... so its very difficult to validate the column string length . Please find the below project ... . For other constraints, such as non null and length - consider checking relevant fields in

CriteriaBuilder.length(x) - JPA Method

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

javax.persistence.Column.length

JPA Annotation Attribute in javax.persistence.Column int length default 255 (Optional) The column length . (Applies only if a string-valued column is used.) Since: JPA 1.0

javax.persistence.DiscriminatorColumn.length

JPA Annotation Attribute in javax.persistence.DiscriminatorColumn int length default 31 (Optional) The column length for String-based discriminator types. Ignored for other discriminator types. Since: JPA 1.0

javax.persistence.MapKeyColumn.length

JPA Annotation Attribute in javax.persistence.MapKeyColumn int length default 255 (Optional) The column length . (Applies only if a string-valued column is used.) Since: JPA 2.0

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

wrapper. Multi part paths in a composite index must have the same length . Therefore, the following ... with components of different lengths is forbidden because it may cause difficulties when the components

Index Definition

a composite index must have the same length . Therefore, the following index definition is invalid ... because the index uses the lexicographic order of the words and is not ordered by the length of the words

JPA Query Expressions (JPQL / Criteria)

, quot , mod , abs , neg , sqrt ). String expressions ( like , length , locate , lower , upper , concat

SELECT clause (JPQL / Criteria API)

The result list of this query contains Object[] elements, one per result. The length of each result

Numbers in JPQL and Criteria Queries

value is numeric, e.g. LOCATE, LENGTH . as composite arithmetic expressions that use operators

GROUP BY and HAVING clauses

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

JPA Criteria API Queries

, neg , sqrt ). String expressions ( like , length , locate , lower , upper , concat , substring

javax.persistence.criteria.CriteriaBuilder

: least expression Since: JPA 2.0 Expression length ( Expression  x) Create expression to return length of a string. Parameters: x - string expression Return: length expression Since: JPA 2.0 ... of given length starting at the specified position. First position is 1. Parameters: x - string expression

member visiting in jpql

baURI is a byte[]; JP QL select e.baURI. length from URI e where id=82778 JP QL [ObjectDB 2.2.9_04] javax.persistence.PersistenceException Navigation from 'byte[]' through ' length ' is invalid (error ... .java:43) at util.JPQLcmd.main(JPQLcmd.java:28) Why I can not visit the length attribute? TIA

Failed to read DB file while online backup is running

this and how to avoid it ?   Stacktrace 1: pos = 2925893632 length = 2048 Caused by: com.objectdb.o ... .objectdb.jpa.EMImpl.commit(EMImpl.java:299) ... 9 more Stacktrace 2: pos = 3003074560 length = 2048 Caused ... with the previous fix.   Stacktrace 1: pos = 4107765760 length = 2048 Failed to read from file '/path_to_db

javax.jdo.annotations.Column.length

JDO Annotation Attribute in javax.jdo.annotations.Column int length default -1 Maximum length of data stored in this column. Since: JDO 2.1

javax.persistence.Column

values apply. Example 1: @Column(name="DESC", nullable=false, length =512) public String getDescription ... length default 255 (Optional) The column length . (Applies only if a string-valued column is used

javax.persistence.DiscriminatorColumn

") @Inheritance(strategy=SINGLE_TABLE) @DiscriminatorColumn(name="DISC", discriminatorType=STRING, length ... to use as a class discriminator. Defaults to DiscriminatorType.STRING . Since: JPA 1.0 int length default 31 (Optional) The column length for String-based discriminator types. Ignored

javax.persistence.MapKeyColumn

statements generated by the persistence provider. Since: JPA 2.0 int length default 255 (Optional) The column length . (Applies only if a string-valued column is used.) Since: JPA 2.0 String name default

javax.persistence.Tuple

- if i exceeds length of result tuple Since: JPA 2.0 X get (int i, Class  type ... Throws: IllegalArgumentException - if i exceeds length of result tuple or element

CriteriaBuilder.substring(x,from,len) - JPA Method

) Create an expression for substring extraction. Extracts a substring of given length starting ... expression len - length expression Return: expression corresponding to substring extraction Since: JPA 2.0

CriteriaBuilder.substring(x,from,len) - JPA Method

an expression for substring extraction. Extracts a substring of given length starting at the specified position. First position is 1. Parameters: x - string expression from - start position len - length Return

javax.persistence.CollectionTable

) @Column(name="name", length =50) protected Set nickNames = new HashSet(); ... } @Entity public class

javax.persistence.DiscriminatorValue

(name="DISC", discriminatorType=STRING, length =20) @DiscriminatorValue("CUSTOMER") public class

Tuple.get(i,type) - JPA Method

of the tuple element Throws: IllegalArgumentException - if i exceeds length of result tuple or element cannot be assigned to the specified type Since: JPA 2.0

Tuple.get(i) - JPA Method

JPA Method in javax.persistence.Tuple Object get (   int i ) Get the value of the element at the specified position in the result tuple. The first position is 0. Parameters: i - position in result tuple Return: value of the tuple element Throws: IllegalArgumentException - if i exceeds length of result tuple Since: JPA 2.0

Criteria query error: Unexpected query token

BaseEntityTest() { super(); } @Column( length = 16) private String testColumn; public String getTestColumn

Multithreading Test and Deadlock

threads are slower because of higher memory usage (4 x 10,000 x 100 strings x attribute length = many

how to persist an object twice into two diff. collections of two diff. classes

selectedSquads = new ArrayList (); if (tableSquads.getSelectedRows(). length 0) { int[] rows

Bug: ClassCastException by retrieval

.toCharArray();   int iLen = ca. length ;   Character[] la = new Character[iLen];   for (int ii = 0; ii

Page dividing support in Objectdb

In Mysql, one can divide records by select * from ttt limit x, length . Then how to do it in Objectdb? gzdillon Lai Yang This is explained in the manual . support Support

Object explorer cannot open odb file. ObjectDB many-to-many relationship

.getAssignements()); int countProjectsAssignedToU1 = u1.getAssignements().keySet().toArray(). length

Speeding up reporting queries with size() on list

Hi, I'm working on some reporting stuff in our application. One of few different reports should include activity on last modified objects. The query for now looks like this: select date(insp.lastModificationDate), insp.modifiedBy, insp.description. length (), insp.products.size(), insp.picture from

Optimization of Map Queries

will be invoked once).   About the query length - you may try setting shorter entity names (in @Entity

Query in JPA2 with LEFT JOIN on INNER JOIN

[] selections = new Selection[profiles. length +1]; Selection actionDescriptionSelection

Need disk usage and delete some old files

    Hello , is it possible to get disk usage of database ? If disk usage becomes too high , delete old date files from database. And recalculate disk usage back ?   kadirbasol Kadir BASOL Since an ObjectDB database is a single file you can simply check its size using the length

Broken @ManyToOne reference

Hi, I have objects of type A belonging to objects of type B, defined as follows: @MappedSuperclass public abstract class A { @Id @ManyToOne(fetch = FetchType.EAGER, cascade=CascadeType.ALL, optional=false) private B b; @Id @Column( length = 36) private String stringId; } @MappedSuperclass public

com.objectdb.o.NLV cannot be cast to com.objectdb.o.RSV

static final long serialVersionUID = 1L; @Column( length =1024) private String text; @Embedded private

[ODB1] Chapter 2 - A Quick Tour

) { 9 10 // Check the arguments: 11 if (args. length != 3) 12 { 13 System.out.println( 14 "Usage

[ODB1] Chapter 9 - ObjectDB Explorer

specifying an array length . Click the "OK" button to construct the new persistent objects

Unexpected exception (Error 990) on find

all values at a length of 256, there seams to come no exception. It seams that there had to be some ... ? Is it String? What is the length of these strings? You mentioned long strings as map values, but in ... on Monday. Probably its the combination of Key- and Value- Length . Stefan Stefan Mair Hi, the ObjectDB

ObjectDB can't be activated

; System.out.printf("%d %d %s\n", s1. length (), s2. length (), s2);        ... ; System.out.printf(indent(indent) + "hardwareAddress = %d %d %s\n", s1. length (), s2. length (), s2);  

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

][project=TEST: project 1][id=46][name=deep float quantity ( length )], [class=IntegerQuantity ... ( length )]) INFO: ConfigBean []: testQuery: element.ownedElement([class=IntegerQuantity][project=TEST

Page cache File handling produced an java.io.IOException: Negative seek offset

we get following exception when we execute a find() in a scenario, we can not readjust with an example.   Before the exception throws we get two outputs on std error: pos = -8192 length = 8192 ... .java) pos = -8192 length = 8192 [ObjectDB 2.6.7] javax.persistence.PersistenceException Failed

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

.ArrayIndexOutOfBoundsException: Index 5 out of bounds for length 0 java.lang.ArrayIndexOutOfBoundsException: Index 5 out of bounds for length 0 at com.objectdb.o.UTY.L(UTY.java:1440) at com.objectdb.o.ENH.d(ENH

NullPointerException using with "refresh" method

Buster) and had some trouble with zero length files using atomic moves, and after a power loss ... -and-the-zero- length -file-problem/ - https://en.wikipedia.org/wiki/Ext4#Delayed_allocation

[ObjectDB 2.2.6_02] Unexpected exception (Error 990) at com.objectdb.o.OBC.aJ(OBC.java:961)

.getLocalizedMessage(); if (msg == null || msg. length () == 0) { TimePeriod id = chart.getId(); if (findChart(id

javax.jdo.annotations.Column

"" JDBC Type for this column. Since: JDO 2.1 int length default -1 Maximum length of data stored in