ObjectDB ObjectDB

Internal Website Search

91-100 of 144 resultsRefresh

JPA does not seem to be db agnostic

)); return em.createQuery(query).getSingleResult(); } kasavbere kasav A valid JPQL query ... JPQL by supporting queries with no SELECT. support Support

String representation of a query

Hi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't have any method like "getQueryString" or "getDatabaseQuery", maybe it's going to be added in near future ... that information with JPQL string and parameters map to find and optimize the most ineffective cases. kborkowski

order by string with numbers

The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM ... is supported by ObjectDB in JPQL string queries. You may try using Integer.parseInt as a JPA criteria query function. support Support

native sql queries

. But since SQL and JPQL are very similar it could be possible in future releases to support "native SQL". But JPQL is preferred so this feature would be in a low priority. Anyway, the expected

Problems down-casting in WHERE clause

) ((Practice)e).messageList.message is an invalid expression in JPQL because messageList is a List ... expression. Apparently there is no support for your query in JPQL or ObjectDB

CriteriaQuery .where() for multiple conditions

, it looks fine. You may also check the result query string (JPQL) by toString() on the criteria query. support Support

UTF Error

I tested ObjectDB. When I write JPQL, I get this error. Caused by: com.objectdb.o.InternalException: Error reading UTF string at com.objectdb.o.BYR.U(BYR.java:1217) at com.objectdb.o.BYR.U(BYR.java:523) at com.objectdb.o.BYR.L(BYR.java:504) at com.objectdb.o.QJD.a(QJD.java:241

JPA Query Criteria API (JPA 2.0)

The JPA Criteria API supports dynamic definition of JPQL queries using CriteriaBuilder as a factory. ObjectDB supports dynamic definition of JPQL queries as strings. Support of the new JPA 2 Criteria API in expected in future versions. support Support Implementation of the JPA Criteria Query API

ObjectDB 2.5.1

) relationships. Fixed a bug in using IN expression in criteria queries. Fixed processing an IN(:param) expression in JPQL queries.

Strange Error with Criteria API and Sorting

the ORDER BY clause". This is not just an ObjectDB limitation but a known JPQL and also SQL limitation

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