About SELECT

issue

Query Execution Error

This query ... This query SELECT DISTINCT $1 FROM com . lexware . vereinsverwaltung . ... more simple query (no collection and the such) SELECT DISTINCT $1 FROM com . lexware . vereinsverwaltung . ...

 
issue

Different behavior for two equal queries

Hi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation.communication.contact.individual.IndividualContact $1 WHERE (($1.organisation.name LIKE '%Q%')) This correctly returns one entry from my database ... two equal queries though they behave differently: SELECT FROM com . quasado . foundation . communication . contact ... This correctly returns one entry from my database SELECT FROM com . quasado . foundation . communication . contact ...

 
manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries. Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12-31'} , {t '23:59:59'} . as parameters - when date and time values are assigned as arguments. ...

 
forum_thread

JPQL JOIN FETCH Error

Hello I get an error when executing the following JPQL query: ... an error when executing the following JPQL query: SELECT doi FROM Doi doi LEFT JOIN FETCH doi . metadata ... / HQL as an extension to JPQL). Try: SELECT doi FROM Doi doi LEFT JOIN doi . metadata metadata ...

 
forum_thread

possible index required for improving query performance

Hi,   I have the following entity class:   @Entity @Table @Indices({ @Index(members={"relationshipType", "party"}), @Index(members={"relationshipType", "otherParty"}),     @Index(members={"relationshipType"}) }) @XmlRootElement public class Relationship implements Comparable<Relationship> { ... = em ( ) . createQuery ( "SELECT r.party FROM Relationship r WHERE r.otherParty = :otherParty_id AND ... to a couple of questions: 1. How does objectdb select which index to use when there are multiple indexes? In this scenario we ...

 
issue

ClassCastException thrown when running count query

Hello! Attached you find a full stacktrace. The query was: ... you find a full stacktrace. The query was: SELECT COUNT ( t ) FROM Position t WHERE ( ( t. ... it will crash with the exception in crash.txt. SELECT p FROM Position p WHERE p . unit . unitID = :id ...

 
manual

Paths and Types in JPQL and Criteria API

Explains how to use object expressions (path navigation, type) in JPA/JPQL.... Variables - FROM identification variables and SELECT result variables. Parameters - when instances of these ... country names with their capital city names: SELECT c . name , c . capital . name FROM Country c The ...

 
forum_thread

Query to search for common elements in two separate collections.

I'm trying to work out the most efficient way to build a query that can compare two collections for identical members. Something like: "SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER OF :someCollection" Is something like this possible in the JPA spec? ... for identical members. Something like: SELECT o FROM Object o WHERE o . someCollection CONTAINS MEMBER OF ... in the JPA that allowed me to put this into the query ie "select FROM Object o WHERE (Iterate through :collection) IN o.collection", ...

 
forum_thread

LazyInitialization / join fetch

I have a survey that carries the tabla Items . A company has several items , a user charge and technical user also . A specialty has several technical users . Area A has a charge . What happens : When I click the Items table hibernate does all these other queries without me asking . I have a survey that carries the tabla Items . Being a company that has multiple items , a user charge and technical user also . A specialty has several technical users . Area A has a charge . What happens : ... queries without me asking . `` ` Hibernate : select the item0_.codigo codigo1_3_ , item0_.aplicavel the aplicave2_3_ , ... total10_3_ from the item item0_ limit ? Hibernate : select the empresa0_.codigo codigo1_1_0_ , empresa0_.cnpj the cnpj2_1_0_ , ...

 
forum_thread

DB Doctor sets type to "unknown" for new fields

Hi, we are using ObjectDB 2.5.4_04 on Linux. We added two new Boolean fields to a persistable type and run DB Doctor on the exiting DB file in order to update the schema. The fields are added to the schema as expected, however their type is set to unknown - we were expecting Boolean. The attached DB file is what was produced by DB Doctor after adding the emergency and broadcast fields. If you run in DB Explorer ... and broadcast fields. If you run in DB Explorer SELECT r . emergency FROM RecordingMetaData AS r you will ... in other cases the type is shown, for example: SELECT r . emergency , r . emergency FROM RecordingMetaData AS ...