ObjectDB ObjectDB

Internal Website Search

91-100 of 140 resultsRefresh
9

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
9

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
6

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
6

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
6

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
6

String Contains Query Result - Possible?

; } Is there a more optimal way to do this? DragonRulerX Jared Hinze You can use JPQL Locate: SELECT
1

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
1

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
1

ObjectDB 2.3.7

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

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