ObjectDB ObjectDB

Internal Website Search

21-30 of 200 resultsRefresh
108

ClassCastException on SELECT NEW ... after UPDATE over Java RMI

internally runs SELECT NEW ... queries. For example: SELECT NEW com.arunta.base.db.FileNameDTO(r.id, r.fileName) FROM RecordingMetaData AS r WHERE ... A remote RMI client runs SELECT (but not SELECT ... is that once we UPDATE a record from the client (via the RMI interface), all SELECT NEW ... queries
104

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

));                 em.getTransaction().commit();                         String q1 = "select ... ();                 q1 = "select distinct s.location "             + "from Street s ... , Location.class).getResultList();                 String q2 = "select distinct s.location
104

Multi selection and distinct in a criteria query

hi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection) so that I could do something like criteria
103

Is there any faster select method?

SELECT: TypedQuery<Point> query = em.createQuery(     "SELECT p FROM Point p WHERE p.id ... ); ** the Point class is of the tutorial. I found the above select method is ten times slower ... . Is there any faster method of select? TIA pikotenta pikotenta Entity objects can be retrieved by
101

selecting objects that have a particular key/value in persistant HashMap

query that selects such objects? Something like the following (but clearly does not work) : SELECT p ... Please try the following query: SELECT p FROM Person p WHERE p.pMap.get('location') = 'California
101

Wrong select results

Hello, I got a realy strange SELECT problem. In explorer query "select p from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed from Player p where p.confirmed==false", I getting p->confirmed->true and p
100

Selecting random rows

Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM
100

Conditional Selection

so when I use... SELECT firstName + " " + middleName + " " + lastName FROM Employee     ORDER BY ... the query results. Maintain an additional field. e.g. displayName. Use a method in the SELECT clause
22

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is essential in any JPQL query that retrieves selective objects from the database. Out of the four optional clauses ... The following query retrieves only countries with a population size above a population size p: SELECT c
21

Issue with DISTINCT Select

It is getting more and more frustrating :( We've introduced distinct select instead of regular selection in our code (no changes else) and suddenly receive invalid identifiers in queries exceptions ... identifier (namely, $1) multiple times for different selections in the same 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