About ORDER BY

21-30 of 200Refresh
Forum
25

How the sort order (in queries) works for non english letters?

definition or the ORDER BY clause, so the sort uses the correct collation per defined locale. Thank ... (we are Czech company). How the sort order works for international (for us 'czech') letters? Does the ordering respects the national requirements? Thank you for clarification ...       ObjectDB uses
Manual
25

Index Definition

, the BTree is ordered by x values, so a range scan on x values is supported. On the other hand, if y is specified first, the BTree is ordered by y values, so a full BTree scan is required to find ... of the words and is not ordered by the length of the words. The bottom line is that if there is an index
Manual
23

Database Explorer [2011-09-21]

the order of the shown fields by using the Up and Down arrow buttons or the [Field Ordering] combo ... directory a path to it has to be specified. Alternatively, you can run the Explorer by double clicking explorer.jar or by running explorer.exe (on Windows) or explorer.sh (on Unix/Linux, after editing
Manual
23

Database Explorer

the order of the shown fields by using the Up and Down arrow buttons or the [Field Ordering] combo ... directory a path to it has to be specified. Alternatively, you can run the Explorer by double clicking explorer.jar or by running explorer.exe (on Windows) or explorer.sh (on Unix/Linux, after editing
Forum
22

Update is ignored by ObjectDB

Hi! Sorry for my bad english skills. When I execute fulfilOrder, only Order entity is updated in ... ; @PersistenceContext(unitName = "SMShop") private EntityManager shopdb; ... public Order fulfilOrder(Long orderID, Long userID, int itemID) { Order order = shopdb.find(Order.class, orderID); if (order
Forum
21

Pre-detach loading: retrieval by navigation not working in if statement

/questions/35359676/java-jpa-objectdb-pre-detach-loading-why-retrieval-by-navigation-and-access ... system a BooleanValue wrapper is ultimately an Element that can be referenced by ID, and meets ... boolean value is not the whole story.   By JVM optimizations I meant JIT Compiler optimizations and not
Forum
21

Should derived fields of an EmbeddedId be manually maintained by app code?

, of type ECompoundKeyMapItem, identified by their "key" within the EContainer class. The items ... "ECompoundKeyMapSubItem", identified by their keys. The embeddedId for the item class, ECompoundKeyMapItemId ... = parent; } [ObjectDB 2.3.0_01] Unexpected exception (Error 990) Generated by Java HotSpot(TM
Issue
21

Removed entities can be found by query in the same transaction

Hello, we opened a transaction, load an entity from database and removed this entity by em.remove(). Afterwards the entity can be load again by query although the resulted entity have an attribute ... : ObjectDB uses snapshots in order to isolate transactions, i.e. to hide uncommitted flush changes
Forum
21

Grouping by date()

), count(ov) from ObjectView ov group by hour(ov.created) order by hour(ov.created) ASC where ov ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... implementation. There is only one small problem with new version. When you group by date
Issue
21

Lazy loading of mapped by (inverse) singular references

ObjectDB ignores lazy setting of non collection mapped by (inverse) fields and loads them always eagerly. This is allowed by JPA since lazy is only hint but it is not efficient. The reason ... , at least as hollow objects. In order to instantiate referenced objects their exact type is needed