ObjectDB ObjectDB

Internal Website Search

191-200 of 200 resultsRefresh

Query in JPA2 with LEFT JOIN on INNER JOIN

How write a query in JPA2 with LEFT JOIN on INNER JOIN? select a.description, a.id, p1 ... your query may indicate that you model is not optimized for JPA. Instead of connecting objects using ids ... Support Hi, this is my critera query: CriteriaBuilder cb = entityManager.getCriteriaBuilder

Java FX tableview fill with an aggregated query

Dear ObjectDB, Can someone give me a tip, to make the aggregated query work. I am filling a tableview with a normal query "SELECT p From Recept p, with no problem. But when I trying to fill a tableview with an aggregated query : "SELECT SUM(getValue()) AS value ,getUnit() AS unit,getName() AS name

Query Method NullPointerException on List iteration

Hello, i'm new to ObjectDB and want to create a query which sums up the product categories ... categoryName Expected query outcome: SupplierName Category1_Count Category2_Count Supplier1 5 13 Supplier2 3 7 I tried to do this with a query method: select s.supplierName, s.countCategory("category1

Efficient query on EmbeddedId

understand that making a query just on entity.id.field1 is efficient. Of course, making a query ... is: what about making a query just on entity.id.field2? I suppose it will not be an efficient query ... can be part of user defined indexed. Accordingly queries on field1 (and on both fields) will be fast

Several parallel threads to speed up query on one DB

is the producer from DB (based on a query) and I would like to speed it up. I have tried using several entity ... . each query in a thread is running simultaneously - but it looks sometimes the "query threads ... it is coming from some ObjectDB low level I/O settings? Any help on how to speed up query by doing

JPQL query to get entities that does not have a child entity in their child entities

_Started        2105:12:10 14:00:00      004 From these 2 tables I have to query for Jobs having ... TomEE for deployment. I am using following queries. FINISHED Jobs between a time interval: @NamedQuery( name = "findFinishedJobsBetweenTimeIntervals", query = "SELECT J FROM JobEntity J, IN(J

Entity Type is not found (error 301) in Query

, EclipseLink For ObjectDB there is one query in following method, where the full qualified class ... :695) at at.sciencesoft.db.jpa.DAOjpa.query(DAOjpa.java:326) at at.sciencesoft.user.User ... - the query works with the simple class name. Breaking down the code for simple example would be little

NullPointer on query

> query = em.createQuery("SELECT m FROM ObjectDbMessagePayload m WHERE m.id = :id", ObjectDbMessagePayload.class); query.setParameter("id", msg.getId()); List<ObjectDbMessagePayload> loaded = query ... the exception is thrown from the find method rather than the query. The application is set to try find

Multiple MEMBER OF query

query gets no items: SELECT i FROM Item i WHERE :label1 MEMBER OF item.labels AND :label2 MEMBER OF item.labels Is it a bug or JPQL query is wrong? Best regards, Pablo. Pablo Berra Pablo Berra This seems to be the result of how JPQL queries are converted into SQL like syntax before executing. MEMBER

JQL-Update Queries fails with activated L2-Cache

When using JQL-Update Queries it is basically not working without calling entityManager.clear ... a container the updated Entities. Scenario 1: Disabled L2 Cache, updating elements using UPDATE-Query ... UPDATE-Query, calling entityManger.clear() and fetching Entities afterwards from database. Expected

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support