ObjectDB Database Search

101-143 of 143 results

Native ObjectDB Support for EnumSet ?

string) query for example: SELECT FROM MyEntity WHERE this.enumSet.contains(:arg) JPA/ JPQL  

Multi-Threading/Distributed-Database Questions...

Greetings ObjectDB team, All below questions assume a very large database (~1,000,000,000 objects): Q1: In what cases would ObjectDB utilize multi-threading ? how about in JOIN operations ? Q2: Is it true that two read-only JPQL queries accessing the same database file actually run 

JPA query of a Set of terms

standard JPQL and it would be less efficient since indexes cannot be used. support Support Thanks

migration path from JPA / Hibernate

Hibernate API / extensions (e.g. Session instead of EntityManager , queries with HQL syntax instead of JPQL

Criteria query error: Unexpected query token

may be valid in Hibernate HQL but not in JPQL and JPA Criteria API. support Support My apologies, in

Reporting Engine?

of JPQL / EJB QL is available for both Birt (using an external extension) and Jasper

ORDER BY problem, when String starts with language specific character

queries (as an extension to JPQL and JDOQL) you can use the Normalizer expression directly in the query

Modifier operations

", value); What do you guys think about it?   lwalkowski Lukasz Walkowski You can use a JPQL

ObjectDB version 2.3 has been released

ObjectDB 2.3 has been released and it includes important additions and fixes: Added the ability to edit databases in the Explorer ( issue #2 ). Added the ability to execute queries in the Explorer (issue #3 ). Other small Explorer improvements. Added support of IN operator in JPQL queries. Added

Is named-query supported in orm.xml

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: delete from DataValue d where d.capabilityId = :capabilityId and d.creationtime

Package name for persisted entities

that you can use: SELECT FROM Inspiration IMPORT homplex.model.dbobject.* and ObjectDB supports it also in JPQL

How to query for list of lists ?

You cannot select a list, so this is an invalid JPQL query. SELECT s FROM PulseDataWareHouse w JOIN w

Multi selection and distinct in a criteria query

I am afraid it is not supported neither in JPQL nor in criteria queries. But does it make sense

dual access

objectdb only permit direct SQL coding? cpanon CP ObjectDB doesn't support SQL but JDOQL and JPQL

how explorer queries work

well perhaps my choice of topic is what's incorrect. explorer executes a user's JPQL query and it certainly

Calculating age in query?

? thanks! Alex quasado Alexander Adam You can use a JPQL query with a simple date comparison: SELECT p

How to use JOIN FETCH?

The ObjectDB manual ( https://www.objectdb.com/java/jpa/query/ jpql /from ) gives an example of using JOIN FETCH to avoid excessive round trips to the database: SELECT c FROM Country c JOIN FETCH c.capital I've tried a few variants of the following example, and haven't been able to get this to work

How do I achieve a Deep Fetch using JOIN FETCH?

of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c.bList WHERE c.id=:id But when I attempt

Object comparation never matches

But what about: http://www.objectdb.com/java/jpa/query/ jpql /comparison Section "Comparable Data Types" Comparison

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

Entity with java.util.Date column gives ClassCastException in BIRT

Copied a straightforward entity class from my coleague. Using Eclipse Kepler (Reporting) and stored it in ObjectDB 2.5.3_02. After creating an ObjectDB BIRT DataSource and a DataSet, entered a simple JPQL query to select the fields. Entity looks like this: package entity; import java.util.Date

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

.get('location') = 'California' This is not a valid JPQL query but an extension that ObjectDB

com.objectdb.o.NLV cannot be cast to com.objectdb.o.CMV

We are using ObjectDB 2.5.1_04. The following JPQL query causes an internal exception: SELECT COUNT(r) FROM RecordingMetaData AS r WHERE ((r.mapFromCli LIKE '192.168.10.13%' ESCAPE '\')) The exception: Caused by: java.lang.IllegalStateException: com.objectdb.o.InternalException: Unexpected

Question about overriding default equals and hashcode

in a query (since ObjectDB supports user defined methods in queries as an extension to JPQL

CriteriaQuery .where() for multiple conditions

string ( JPQL ) by toString() on the criteria query. support Support

Spatial queries with ObjectDB

methods in queries to provide your own spatial extension to JPQL . Obviously this is not a complete

using objectdb.jar in writing data to mariadb or mysql db

to mariadb or mysql using native java JPA API and in some cases JPQL or must i store to an Objectdb unique

Navigation through Path to evaluate collection

id WHERE item.sku = :key OR id = :id ORDER BY item.sku DESC You may also try this (not valid JPQL

String Contains Query Result - Possible?

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

Query with FETCH JOIN returns multiple results instead of one.

? Is it something specific to ObjectDB? Is it a bug? This behavior appears with JPQL and with equivalent

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

Method not found on...

I've got this class... @Entity @Table(name = "language") public class Language implements Serializable{ ... private List aliases; ... public boolean hasAlias(List alai) { return ... ; } ... } When I try to make this JPQL query: SELECT g from Language g where g.hasAlias("espanol", "italian

Difference performance in ObjectDB Explorer and in java project

Hello, I am learning ObjectDB and i noticed that the queries that are executed in  ObjectDB Explorer are faster (about 5 ms) than queries in my project (~400 ms). Here is my JPQL query :  SELECT p FROM Point p WHERE p.x=0 I am using Point entity class from tutorial

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) at com.objectdb.o

ObjectDB 2.0.4

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

ObjectDB 2.2.5

Added support of navigation through collections  (as a JPQL extension). Added version display to the Server and Explorer About dialog boxes. Fixed an UPDATE/DELETE query bug in client-server mode. Fixed an ArrayIndexOutOfBoundsException in retrieval of large objects. Fixed Explorer display

ObjectDB 2.3.0

Added the ability to edit databases in the Explorer ( issue #2 ). Added the ability to execute queries in the Explorer (issue #3 ). Other small Explorer improvements. Added support of IN operator in JPQL queries. Added support of ";drop" database url parameter. Adjusted the Enhancer to the new

Different behavior for casting and not casting

. Since casting in not part of JPQL and rarely used I am afraid it might not be the last problem

ObjectDB 2.3.7

issue #632  and  issue #634 ). Fixed a bug in using JPQL operations (e.g. UPPER ) in

Update query bug

This UPDATE query is invalid because JPQL UPDATE queries are limited to setting values not

ObjectDB 2.5.1

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

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

Update query null error

, which are not allowed in JPQL Update queries. See discussions on this issue . ObjectDB should produce