ObjectDB ObjectDB

Internal Website Search

91-100 of 142 resultsRefresh

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

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

Help with 'not like/lower' query

William You are talking about criteria queries but your first query is a JPQL query. Is it the JPQL

How do I achieve a Deep Fetch using JOIN FETCH?

that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c.bList

Get the last occurence of a list attribut

"(" and the "LIMIT". Is it possible de make a sub request in a JPQL query ? dwighthaul Paul HUBERT Subqueries

ObjectDB data migration/extraction

Hi What is the way to extract data from ObjectDB to relational databases (Oracle). We need to feed an Oracle database with data for reporting/datawarehosing. Should JPQL be used or is there some tools to do it. Thanks. peric.emil Emil Perić Currently there is no such tool

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 BIRT Driver Update

The ObjectDB BIRT/ODA driver is an extension of the open source Business Intelligence and Reporting Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query language. In the current implementation ObjectDB is embedded in the driver. Any 2.x version of the driver

ObjectDB 2.3.7

and issue #634). Fixed a bug in using JPQL operations (e.g. UPPER) in DISTINCT results. Fixed an exception

ObjectDB 2.0.4

when using GWT/Jetty. Fixed a bug in using fields of embedded primary key in JPQL queries.

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