ObjectDB ObjectDB

Internal Website Search

181-190 of 200 resultsRefresh

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java ... - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146 ... ();             TypedQuery<BenchEnt> query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class

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

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

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

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

Is named-query supported in orm.xml

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: <named-query name= "DataValue.deleteByCapabilityAndCreationtime"> <query>delete from DataValue d where d.capabilityId = :capabilityId

Debuging query before execution

Hi, Is is possible in any way to get string representation of a query right before execution, after setting parameters? Of course it's easy to print out query string when we build it by concatenating ... implementation. What exactly do you suggest? The query string with parameter values embedded, replacing

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

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