ObjectDB ObjectDB

Internal Website Search

131-140 of 200 resultsRefresh

JPA Query language support in OBjectDB / Sub query or nested Query

have given a sample typed query below which fails to work with ObjectDB and it runs very well with the Hibernate/MySQL JPA. We are using Spring Data here. It looks like a problem with Sub query or nested queries where I am using IN clause like below. @Query("SELECT product FROM Product product

Database Explorer

to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases ... the database and their persistent fields and indexes. The [Query] window enables running JPQL and JDOQL queries, as discussed below. Closing a Database Connection Use the File > Close menu command


javax.persistence Interface TypedQuery<X> Superinterfaces: Query Interface used to control the execution of typed queries. Since: JPA 2.0 See Also: Query Parameter Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA manual. int executeUpdate() Execute an update or delete


> The CriteriaQuery interface defines functionality that is specific to top-level queries. Since: JPA 2.0 Learn how to define queries using the criteria API in Chapter 4 of the ObjectDB/JPA manual. AbstractQuery<T> distinct(boolean distinct) Specify whether duplicate query results will be eliminated. Specify

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

, the inability to robustly query relationship fields in a web application renders the ObjectDB ... showing the query result in indexTest.xhtml. The problems is illustrated by running the attached JavaEE ... . For a number of different List fields, a query performed immediately after creating and persisting

JPA Entity Fields

the database, but is still available after retrieval by a special automatic query. Note: Navigation ... , since it requires running queries. Inverse fields are essential for collection fields when using ORM JPA ... the database. ObjectDB accomplishes this by effectively running the following query (where :d represents

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1 ... Query Execution Error ===================== Unexpected query token 'com.quasado.foundation.warehouse ... %') but the query still fails - now on navigation to routingNumber. Another casting will not help

Step 4: Create an ObjectDB Data Set

Queries against the database are represented in BIRT as data sets. To create the data set: Open ... contains Point entity objects. We will use a simple JPQL query that retrieves points with x value in ... and paste to enter the above query and click Finish. When the data set is created successfully - a new


: IllegalArgumentException - if not an entity Since: JPA 1.0 Query createNamedQuery(String name) Create an instance of Query for executing a named query (in the Java Persistence query language or in native SQL). Create an instance of Query for executing a named query (in the Java Persistence query language or in

[ODB1] Chapter 6 - Persistent Objects

or queried directly (an embedded object can only be retrieved using a reference from its containing ... the database one by one. If more selective retrieval is needed, a Query can be used to retrieve ... (the commented line in the code above). Retrieval by Query The most advanced method for retrieving objects

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