About WHERE

forum_thread

EntityManager JPA or JDO impl and different behavior

Hi, I have an issue with the EntityManager. My persistance XML looks like: <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"> ...   In addition yesterday I had another case where I had an object holding another object which was holding a map of ... name="null" values="" id="10"/> where the equals method has been called, but the attributename appears to have ...

 
issue

OutOfMemoryError in a query with many variables

Just got this:   ... $1 WHERE (($1.organisation.name LIKE '%Q%') OR ...

 
manual

JPA Named Queries

Explains how to define and how to run JPA named queries.... Reference Page... = "SELECT c FROM Country c WHERE c.name = :name" ) , } ) public class ...

 
forum_thread

Handling deleted references

Hi support team, I have a problem when using DELETE query to delete Entity instances. We use the following hierarchy: ... should handle this. But we have several use cases where we cannot check for further references (e.g. if the same Profile instance ...

 
issue

Doctor bug?

Please see the attached .odb file. It was freshly created by my web application, and just very few entries have been posted to the database yet. But still the doctor reports a whole bunch of errors. My application seems to function properly though. I guess this is a bug in the doctor? Using version 2.4.1. I get  ... happens after my recent changes to the object hierarchy, where I inherit from a common superclass, which I annotated as you suggested ...

 
issue

Null pointer exception being thrown from within ObjectDB.

EXCEPTION/DESCRIPTION:... ; q. select ( r ) . where ( cb. and ( cb. equal ...

 
forum_thread

collection of embedded objects

1. In general, are there any restrictions of the use of @Embedded objects in collections, compared to @Entity? 2. If you have a large nested collection of @Embedded objects, and you remove the parent @Entity, does the remove cascade through the whole collection? 3. Is searching through collections of @Embedded objects more expensive (time) than searching through collections of @Entity? ... SELECT count ( a ) FROM A a WHERE a . setOfB . value = :value A is an Entity which has a ...

 
forum_thread

Can't modify @EmbeddedId in ObjectDB Explorer

Hi! There is entity Journal with @EmbeddedId JournalId. Id's content can't be seen/modified from ObjectDB Explorer from its class. Ok, I get this. It's an @EmbeddedId, so it should depend only on its parent. Problem: id's content can't be modified through its parent neither. Scenario: open db in ObjectDB Explorer, open entity Journal, expand the id, try to modify date/id, save, then refresh data / reopen db, and you'll see that it wasn't modified. Any solutions? ... just a small modification. It's a habit from RDBMS, where everything can be modified. ...

 
forum_thread

Error 363 - Failed to read value of inverse relationship

I've got two objects: @Entity public class EEvent { @Id @GeneratedValue(strategy = GenerationType.AUTO) private long id; @ManyToOne(optional=false) private ETown town; public ETown getTown() { return town; } public void setTown(ETown town) { this.town = town; } } And: ... ) . createQuery ( "SELECT p FROM Player p WHERE upper(p.playerName) = upper(:name)" , Player. class ) ; ... = db. createQuery ( "SELECT p FROM Player p WHERE upper(p.playerName) = upper(:name)" , Player. class ) ; ...

 
issue

com.objectdb.o.InternalException: java.lang.ArrayIndexOutOfBoundsException: 2

com.objectdb.o.InternalException: java.lang.ArrayIndexOutOfBoundsException: 2 java.lang.ArrayIndexOutOfBoundsException: 2 at com.objectdb.o.UTY.aG(UTY.java:1275) at com.objectdb.o.ENH.b(ENH.java:102) at com.objectdb.o.LDR.J(LDR.java:796) at com.objectdb.o.LDR.UW(LDR.java:1023) at com.objectdb.o.CST.ab(CST.java:478) at com.objectdb.o.CST.U4(CST.java:414) at com.objectdb.o.LDR.F(LDR.java:559) at com.objectdb.o.LDR.E(LDR.java:466) at com.objectdb.o.OBC.UJ(OBC.java:1073)... be great if you could catch these kind of  exceptions where the data model between client and server is different and log a more ...