ObjectDB ObjectDB

Internal Website Search

181-190 of 200 resultsRefresh

Performance issue in a query due to compareTo calls

Hello, we have a question again regarding query performance. The query: SELECT v FROM Values v WHERE v.step.stepNumber = ? is very slow in comparing to the query: SELECT v FROM Values v WHERE v.stepNumber = ? Can you explain why the first query needs so much time or do you have a hint

Duplicate Entity class names causes Exception in Query

of one of these entities. If I execute that query I get an exception; Caused by: com.objectdb.o ... ) ... 64 more Here is the class doing the query on objdbTest.Item package objdbTest; import .... @Entity @NamedQueries({ @NamedQuery(name = "objdbTest.Singleton.getItem", query = "SELECT o

Unable to execute update query

Hello! I'm trying to do an update query via the explorer to set a new field value for around 400k ... reading a temporary file that is used in an update query, but the cause is unclear, and according ... and temporary files): import javax.persistence.*; import javax.persistence.Query; public class

Entity has be persistended,but query not fetched?

I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities.But then the newT is not contain in the query result. Why? code order: query.setFlushMode(FlushModeType.AUTO); query.getResultList(); maozf maozf The following example demonstrates

Calendar in Criteria Querys

Hi, i am having troubles creating criteria querys for Calendar objects. As far as I ... got such methods, but i dont know how to use those in my query. suez Tobias JPA supports 3 temporal ... limitations. Anyway, the following example demonstrates criteria queries with Calendar. The usual comparison

Criteria Query results in a NoResultException instead of returning object

(criteria).getSingleResult(); which evaluates to the query: SELECT $1 FROM IdentityObject $1 ... ._NoResultException: No matching results for a unique query at org.jboss.seam.security.IdentityImpl ... by: com.objectdb.o._NoResultException: No matching results for a unique query at com.objectdb.o.JPE

Query execution time issue

Hi, I have a query similar to this one: select person.name, person.surname, ... ... from ... of this query (running with ObjectDB) takes about 10-12 seconds. If i remove ANY 5 left joins, query execution time drops to about 50 milliseconds. Adding a new left join on remaining 8 slows down query

unclear syntax for update query

. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error ===================== Unexpected query token 'a' Update Action Set transferred = 0

Different behavior for two equal queries

Hi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation ... if that helps: First query (which works): Query Plan Description ====================== Step 1: Process ... query (which fails): Query Plan Description ====================== Step 1: Process

Unexpected exception when execute query without enhanced entities

ObjectDB 2.8.7.b08 Our entities are not enhanced and we execute a query "select max(uid) from ... of the query: Caused by: com.objectdb.o.UserException: Unexpected query token 'uid' at com ... ..." instead of the UserException: Unexpected query token 'uid'. If the entities are enhanced then the query

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