About query

161-170 of 200Refresh
Forum
13

First query takes 4+ minutes to complete

query that we run on the DB which contains about 320,000 records of a single type of object. SQLite ... to the query that we run). @Entity(name="RecordingMetaData") @SequenceGenerator( name ... the queries (JPQL SELECT statements) shown next.  Query We test with the following query: SELECT r from
Issue
13

InternalException when using MEMBER OF on a large list in a query

Hello, we get when executing a query with MEMBER OF on a large list the following InternalException ... ) (... more see attached Image) Our query looks like this: String recordClassName = CoverageRecordImpl.class.getName(); String propertyClassName = propertyClass.getName(); String query = "SELECT DISTINCT property.uid
Manual
13

Retrieving JPA Entity Objects

object. Retrieval by Query The most flexible method for retrieving objects from the database is to use queries. The official query language of JPA is JPQL (Java Persistence Query Language). It enables retrieval of objects from the database by using simple queries as well as complex, sophisticated ones
FAQ
13

Is ObjectDB a NoSQL Database?

of NoSQL technology, which are weak query capabilities and lack of ACID (atomicity, consistency, isolation, durability). Unlike other NoSQL solutions, ObjectDB provides full support of rich complex queries, using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO
Tutorial
13

Step 3: Add a Main Class [2011-02-11]

(); // Find the number of Point objects in the database: Query q1 = em.createQuery("SELECT COUNT(p ... ()); // Find the average X value: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p ... objects from the database: TypedQuery query = em.createQuery("SELECT p
Tutorial
13

Step 3: Add a Main Class [2018-10-20]

(); // Find the number of Point objects in the database: Query q1 = em.createQuery("SELECT COUNT(p ... ()); // Find the average X value: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p ... objects from the database: TypedQuery query = em.createQuery("SELECT p
Tutorial
13

Step 3: Add a Main Class [2011-02-11]

: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); // Find the average X value: Query q2 = em ... > query =  em.createQuery("SELECT p FROM Point p", Point.class); List results
Tutorial
13

Step 3: Add a Main Class

: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); // Find the average X value: Query q2 = em ... ()); // Retrieve all the Point objects from the database: TypedQuery query
Forum
13

Help with 'not like/lower' query

Hi all,   Honestly, I'm fairly new with JPA2 Criteria queries - but as far as code effort goes, it has saved me a bit of pain. I'm writing a dynamic query builder (only 1 level deep for basic entities) - but  even though I get most queries to work, I am getting the following error. This is using
Forum
13

possible index required for improving query performance

; } With the following query: TypedQuery query = em().createQuery( "SELECT r.party FROM Relationship r ... =RelationshipType."+type.toString(), BaseObject.class); query.setParameter("otherParty_id", otherParty); query.setParameter("pclass", partyClass); We have noticed that this query slows down in