About number

manual

Numbers in JPQL and Criteria Queries

Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries.... absolute value, which is always a positive number or zero. For example: ABS(-5) is evaluated to ... function calculates the remainder of the division of one number by another, similar to the modulo operator ( % ) in Java (which is ...

 
faq

Is ObjectDB scalable? What are its limitation?

ObjectDB is highly scalable and can manage efficiently databases in a wide range of sizes, from a few Kilobytes to hundreds of Gigabytes and even Terabytes. ObjectDB can be used in small embedded single user applications as well as in heavy loaded mu ...

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions). Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists of JPQL / Criteria query expressions. ...

 
manual

Literals in JPQL and Criteria Queries

Describes literals in JPQL, including null, false, true, numbers, strings, dates enums and types. Literals in JPQL, as in Java, represent constant values. JPQL supports various types of literals including NULL , boolean literals ( TRUE and FALSE ), numeric literals (e.g. 100 ), string literals (e.g. 'abc' ), enum literals ( ...

 
api-jdo

javax.jdo.spi.StateManager

This interface is the point of contact between managed instances of PersistenceCapable classes and the JDO implementation.(Interface of JDO)

 
forum_thread

Number of current connections

Is there any way to find out the number of current connections to the DB server? ... Is there any way to find out the number of current connections to the DB server? ...

 
forum_thread

How to retrieve the ObjectDB version number?

Hi! We need  the ObjectDB version for debug purpose/logging. Our project supports also EclipseLink - http://stackoverflow.com/questions/3493495/getting-database-connection-in-pure-jpa-setup With the Connection object the Database name & version can be retrieved. For ObjectDB, which is the best (JPA) method to get the version number?   Peter       ... which is the best (JPA) method to get the version number?   Peter     ...

 
forum_thread

Listing large number of complicated objects with paging.

Hi, For last few hours I was working on a problem with bad performance and memory problems with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 'Product' (attached to this post) entities in database and I'm trying to speed listing them with paging. The problem is, that running code that looks like this: ... in every query execution ( setMaxResults ). Does that number affect? You may try running the query with a lazy fetch hint ...

 
forum_thread

large numbers of records

Hi, does anyone have experience with database with more than billion records (ie. more than 1000 million records) in one table. What is the limit of ObjectDB and is the database still fast. We are planing to do an application which handles document records and there metadata. #1 2016-04-11 15:52 Hi, does anyone have experience with database with more than billion records (ie. more than 1000 million records) ...

 
forum_thread

order by string with numbers

Hi Anyone could help me I need ordered a string  for example user1, user2, ..., user1000 I found sql solution but I would like to use criteria builder I don´t if exist CAST and AS UNSIGNED ORDER BY CAST(SUBSTR(usernameFROM 2) AS UNSIGNED) ASC If you have other alternative for JPA CriteriaBuilder please let me know. Thanks   #1 2014-08-16 21:29 Hi Anyone could help me I need to order a string  for example user1, user2, ..., user1000 I ...