 21 | Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example:
em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception:
Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM |
21 | Hello. I have a query
UPDATE Look l SET l.partlySold = FALSE
WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this? Thanks. Nested queries (issue #11) is currently not supported |
21 | When I run the following code:
EntityManager em = getEm();
Customer result = null;
try {
logger.debug("Ident: "+ident);
result = em.createQuery("Select c from Customer c where c.identifier=:id", Customer.class).setParameter("id", ident).getSingleResult();
} catch (javax.persistence |
21 | has around 30.000 rows) Example query looks like :
String strSelect = "SELECT e FROM TestEntity |
21 | we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error:
UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC |
20 | Class fields selection to store |
20 | Selective merge/cascade of detatched entity |
20 | E-select.png |
20 | select-run-config.png |
20 | identification variables and SELECT result variables. Parameters - when instances of these classes are assigned ... through a NULL value The following query retrieves country names with their capital city names:
SELECT ... of all the entity objects in the database, excluding Country entity objects:
SELECT COUNT(e) FROM |