About multiplication
Numbers in JPQL and Criteria Queries
Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries.... + (addition), - (subtraction), * (multiplication) and / (division). ObjectDB also supports the ... ) ; // number - expression // Multiplication (*) Expression javax.persistence.criteria.Expression ...
Problem with @OrderBy
When I use @OrderBy and supply multiple order fields I get and error when ObjectDB loads that entity. Example code: @Entity @Table(name="Problems", schema = myDB") public class Defects implements Serializable { ... ... @OneToMany(mappedBy="problem") @OrderBy("seqRel, noteSeq") Set<Notes> notes; ... ... } #1 2011-04-21 05:17 When I use @OrderBy and supply multiple order fields I get and error when ObjectDB Explorer expands a instance of ...
NullPointer running multiple client against server
Hi, I'm running objectdb in server mode, config as it comes out of the box. In this case the database is being used as a queue with multiple seperate processes, each with multiple threads, writing messages. The message is split into a lightweight metadata message to allow fast searching and a more heavy weight data message. The put methods are shown below. The message is made up of an id, insert-time, priority and the payload is a large string. Bug Version: 2.2.7 Priority: Normal Status: Fixed Replies: 2 Type: Bug ...
Using multiple databases
Is it possible for an ObjectDB PersistenceManger/EntityManager to connect to more than one database at a time? Also, can objects in one database reference objects in another database (e.g. through globally unique identifiers)? #1 2011-08-25 10:11 Is it possible for an ObjectDB PersistenceManger/EntityManager to connect to more than one database at a time?&nb ...
multiple LEFT JOINs do not work as expected
Hi, We have a hierarchical data set of organisations in the database, where each organisation stores a reference to it parent organisation. I'm trying to find all organisations 2 levels under a root organisation, e.g. where organisation.parentOrg is the root or organisation.parentOrg.parentOrg is the root. The query also contains a number of other predicates and it is built dynamically using Criteria API. It could be looking for other number of levels, 2 is just an example. The test query looks like this: #1 2011-12-16 05:41 Hi, We have a hierarchical data set of organisations in the database, where each organisation stores a re ...
InternalError on multiple AND and JOIN Query
Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4.valueAsString='Los Angeles')) AND (($6.name='areacode') AND ($6.valueAsString='310'))) Getting: #1 2011-07-22 01:36 Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1. ...
Issue with orphanRemoval and multiple EntityManagers
Hi, We have a problem where our database size grows over time more than expected. We've traced it down to the following issue: #1 2012-04-04 12:17 Hi, We have a problem where our database size grows over time more than expected. We've traced it dow ...
SELECT clause (JPQL / Criteria API)
Explains how to use the SELECT clause and projections in a JPA/JPQL query. The ability to retrieve managed entity objects is a major advantage of JPQL. For example, the following query returns Country objects that become managed by the EntityManager javax.persistence.EntityManager JPA interface Inte ...
javax.persistence.OneToMany
Defines a many-valued association with one-to-many multiplicity.(Annotation of JPA)
JPA Entity Fields
Explains how to define and use primary keys in JPA, including composite and embedded primary keys. Fields of persistable user defined classes (entity classes, embeddable classes and mapped superclasses) can be classified into the following five groups: Transient fields Persistent fields Inverse (Mapped By ...
