ObjectDB ObjectDB

Internal Website Search

41-50 of 200 resultsRefresh

find repeated records by JPQL

#1 contains GROUP BY / HAVING. The outer query in #1 contains the IN operator. The query in #3 ... since in #3 there is no GROUP BY / HAVING. support Support ... (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use

Problem with distinct select, order by and equivalent alias/attribute path

is less restrictive, and will except the query above. However, in DISTINCT and GROUP BY queries ... when ordering the results of some projection when the order by expression is different (though logically ... "             + "order by s_location.id asc";         System.out.println("Working query

Blocked by find

, Object obj)" method which is synchronized and attempts to load an object by id using the EntityManager ... .ObjectDbInstanceContainer@9c71a4 owned by: DEV1-WSAgent-1-Existing/3 Total blocked: 190 Total waited: 69 ... : Name: uatsrtlonw342-WSAgent-1-New/4 State: BLOCKED on com.objectdb.o.LKM@254e85f4 owned by: ODB

Auto Generated Values

number generator is also used to generate numeric values for primary key fields annotated by ... ) and an allocation size (the default is 50). A sequence is global to the application and can be used by ... . To minimize round trips to the database server, IDs are allocated in groups. The number of IDs in each

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query consists of clauses - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY, and each clause consists ... of at least one atomic component. More complex query expressions are built by combining atomic

JPA 2 Annotations

JPA defines dozens of annotations that can be divided into the following groups: Annotations for JPA aware classes: Annotations for fields in JPA persistable classes: Annotations for additional JPA ... between a relational database and an object model and for direct SQL queries): These ORM annotations are silently ignored by ObjectDB.

Getting Started with JPA

to start by running a live sample application in your IDE, you should be able to follow this tutorial


: group - a comma-delimited list of expressions, optionally followed by the "having" keyword and a boolean ... with a PersistenceManager. Multiple queries might be executed simultaneously by different threads ... , import statements, ordering and grouping specifications, result and result class, the range


addFetchGroups( FetchGroup... groups) Add the FetchGroups to the set of active fetch groups. Add the FetchGroups to the set of active fetch groups. FetchGroups are made unmodifiable before being added ... , removeFetchGroups, getFetchGroups, and removeAllFetchGroups are internally serialized. Parameters: groups


javax.jdo.spi Interface PersistenceCapable A class that can be managed by a binary-compatible JDO ... environment. The Reference Enhancer also adds code to implement the methods defined by PersistenceCapable. The extra methods in the PersistenceCapable interface might be generated by pre-processing a .java

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