About WHERE

forum_thread

Geospatial functions

Hi, is it possible to implement geospatial functions (e.g. calculating distance between too points given latitude/longitude) ?Normally you would calculate the distance like: ... "SELECT l FROM Location l " + "WHERE l.distance((double):latitude, (double):longitude) < :radius" , ...

 
issue

Error 990 when querying a class with persistence-capable-superclass

[ObjectDB 2.4.7_07] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Server VM 1.7.0_10 (on Linux 3.2.0-39-generic-pae). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.STA.K(STA.java:339) at com.objectdb.o.ENT.D(ENT.java:533) at com.objectdb.o.ENT.M(ENT.java:681) at com.objectdb.o.LDR.F(LDR.java:589) at com.objectdb.o.LDR.E(LDR.java:466) ... fails with the same error is a lot of work. Looking at where the exception is being thrown, can you give me any clues as to what is ...

 
release

2.5.5

... NullPointerException when using AND TRUE in WHERE clause (issue #201). Fixed an exception when accessing an ...

 
forum_thread

Activation Issue

Hi! We now reached the 10 class limit of ObjectDB. Our license is activated and if I run objectdb activation I get true back. When I start our webapp although I get the following error: ... Activation is required only where the database file (odb file) is managed, which is usually only the server ...

 
forum_thread

Transaction isolation support?

I am looking at using ObjectDB for our new project, and its looking good so far. But I have been unable to find any documentation about how transaction isolation is handled. For example: What happens If I am reading data in transaction A, and then transaction B commits while A is reading. (Especially if using LAZY fetch sub object). Do I always just get the list of objects as it looks when the fetch start? Martin   ... explanation more easy). Now imagine the following where A and B are 2 different entity managers. (Which in our implementation ...

 
issue

Server out of memory exceptions

I've started to get memory exceptions on objectdb instances running as a server. The objectdb log reports this as: ... these limits but would like to get an understanding of where the memory is being used. In each exception case the server has typically ...

 
forum_thread

Duplicate Entity class names causes Exception in Query

I have two Entities which have the same class name but reside in different packages, only one of them is mentioned in the persistence.xml. I a NamedQuery I use the unqualified class name of one of these entities. If I execute that query I get an exception;   ... , query = "SELECT o FROM Item o WHERE o.cachedKey = :cachedKey" ) , @ NamedQuery ( ...

 
forum_thread

Left join fetch behaviour doesn't retrieve children?

Hello support, I'm a little bit confused about a left join fetch behaviour. In this test case, i try to fetch my 3 children using a left join fetch. But my collection is null after closing the em. It was expected to be fetched before closing the em, no ? In fact, that is the objective of the fetch purpose (i guess ?). ... some optimization disabled? This could help us understand where is the issue. ObjectDB Support ObjectDB - ... some optimization disabled? This could help us understand where is the issue. Yes, without index on the collection, all if fine, ...

 
forum_thread

Double persist of Entity field with Cascade.ALL

I am building a JavaEE application using Netbeans 7.0.1, Glassfish 3.1 and ObjectDB 2.3.3. I have a Book class with entity field Chapter which has a CascadeType.ALL property. The Book fields are as follows: @Id @GeneratedValue(strategy = GenerationType.AUTO) private Long id; private String bookTitle; @OneToMany(cascade= CascadeType.ALL, fetch= FetchType.EAGER) private List<Chapter> chapters; The Chapter fields are as follows: ... The following are modified for the working case where new Chapters are added ON THE SERVER SIDE.  ...

 
issue

Feature Request: Subclassed PersistenceException for Type Not Found in DB Schema

Hi,... DISTINCT(summary.store) from AbstractClientSummary summary WHERE summary.chain == :chain";         ...