About ENABLE_SELECTIVE

51-60 of 200Refresh
Forum
6

selecting objects that have a particular key/value in persistant HashMap

a JPA query that selects such objects?  Something like the following (but clearly does not work) :  SELECT p FROM Person p where p.pMap['location']='California' Any thoughts?  Thanks, -Adam   Please try the following query: SELECT p FROM Person p WHERE p.pMap.get('location') = 'California
Forum
6

A nested SELECT

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
Forum
6

Conditional Selection

so when I use... SELECT firstName + " " + middleName + " " + lastName FROM Employee     ORDER BY ... an additional field. e.g. displayName. Use a method in the SELECT clause. It could be a static method
Forum
6

Selecting random rows

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
Issue
6

NullpointerException at a normal select

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
Forum
6

Performance in SELECT statement

has around 30.000 rows) Example query looks like : String strSelect = "SELECT e FROM TestEntity
Forum
5

Class fields selection to store

Class fields selection to store
Forum
5

Selective merge/cascade of detatched entity

Selective merge/cascade of detatched entity
Manual
5

CRUD Database Operations with JPA

objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); The query string ("SELECT ... of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
Manual
5

BIRT/ODA ObjectDB Driver

extension. To install it: Open the [Install] dialog box by selecting Help > Install New Software... In ... ENTER. Select the ObjectDB Birt/ODA feature. Complete the installation by clicking Next twice, accepting ... and selecting New Data Source. Select ObjectDB Data Source from the list of available data source types