ObjectDB ObjectDB

Internal Website Search

31-40 of 200 resultsRefresh
100

Embedded Entity in EmbeddedId not persisted. Error 631 at select.

annotated.  *   *         issue: In case 1 transaction is committed, but select fails ... ();         out.println(em.createQuery("select a from A a", A.class).getResultList());     }     @Entity     public
100

A nested SELECT

Hello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this? Thanks. Vladiator Vlad Myachikov Nested queries (issue #11
99

Performance in SELECT statement

has around 30.000 rows) Example query looks like : String strSelect = "SELECT e FROM TestEntity
99

Unexpected query token 'delete' (SELECT is expected) (error 752)

simple codes(see attachment), failed. gzdillon Lai Yang DELETE queries should not be run with getSingleResult (which is for SELECT queries). Use executeUpdate instead. See this manual page. support Support
95

select query for a HashMap field of an entity.

select query for a HashMap field of an entity.
20

Using SELECT BETWEEN with LocalDate

I am trying to query all entities whose date is between today and today + X days. The date inside the entity is a LocalDate. To do so I created the following query: .createQuery( "SELECT e FROM ... the SELECT a Date is used and not a LocalDate, so I ignored this error. Now I tried a LocalDate
20

Deletion of an entry via the table window always deletes the last entry not the selected one

If I open a class in the explorer via the "Open Table Window" button, select a row by its index and prex "Del" or use right click "Delete" the last entry of the table is removed and not the selected one. If I try the same using the "Open Tree Window" it works as expected. Kevin Kevin Pfaff Thank
19

JPA Query Structure (JPQL / Criteria)

and easier to use in Java. JPQL Query Structure As with SQL, a JPQL SELECT query also consists of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ...] The first two clauses, SELECT and FROM are required in every retrieval query
19

NullpointerException at a normal select

When I run the following code: EntityManager em = getEm(); Customer result = null; try {     logger.debug("Ident: "+ident);     result = em.createQuery("Select c from Customer c where c.identifier=:id", Customer.class).setParameter("id", ident).getSingleResult(); } catch (javax.persistence
19

selective update not working

we try to optimize for our queries and tried a selective update, but in explorer it just shows query execution error: UPDATE ObjectNode o SET o.state = 5 where o.classIdentifier = '(MA)' and o.objectNameUpper = 'DMU200P2' and o.state = 0 and o.type = 1 and o.parentNode.classIdentifier = '(NC

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