About Explorer

forum_thread

dual access

Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but still works.  Is it possible to still have the SQL emitted from only the JAVA syntax?  If so is it also possible get each SQL statement before it is sent to the store?  Does objectdb only permit direct SQL coding? #1 2012-02-24 02:39 Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but s ...

 
forum_thread

Possible Bug in MEMBER OF

Hello! I maybe found another bug in version 2.3.3. I'll send you a test DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u.users Set user to TrackerUser#8 If i run this quey i get: Invalid operand type at.co.pjm.tracker.persistence.TrackerUser for operator MEMBER OF SELECT u FROM Unit u WHERE :user MEMBER OF u. ==> users <== In my opinion the result should be Unit#4004 ... DB via support ticket. Try the following query in explorer: SELECT u FROM Unit u WHERE :user MEMBER OF u . ...

 
tutorial

Step 4: Add a Controller Class

Explains how to add a servlet to an Eclipse Spring MVC JPA web application project.... by right clicking the guest package node (in the [Package Explorer] window) and selecting  New > Class . The package name ...

 
forum_thread

@ElementCollection of type enum

Hi! I have in an entity called User with the following field: @ElementCollection(fetch = FetchType.EAGER) private Set<UserPermission> permissions; package x.x.x.x public enum UserPermission { BASIC, COACH, ADMIN } Use case: there are users which contain the first 2 permissions (BASIC and COACH, so the first 2 entries). ... Mention: I have seen this bug by checking the values in DB explorer, but also by printing logs directly in the code. Desired ...

 
tutorial

Step 3: Define an EJB Session Bean

Explains how to define an EJB session bean in an Eclipse Java EE 6 web application.... by right clicking the guest package node (in the [Package Explorer] window) and selecting New > Class . The package name should ...

 
tutorial

Step 4: Create an ObjectDB Data Set

Explains how to create an ObjectDB data set for BIRT reports.... box by right clicking the Data Sets node in the [Data Explorer] window and selecting New Data Set . Select the data ...

 
forum_thread

How to configure where the ODB is stored?

Hi, The documentation is lacking in this respect. How do I configure where the ObjectDB database file is stored. I need to know where it is so I can inspect it with 'database explorer'. The docs say to set it to "$objectdb/db/points.odb" and that this defaults to "the installation directory of ObjectDB". BUT... I DIDN'T INSTALL OBJECTDB - my maven build downloaded it and embeded it. So, where is this file stored??? Also, the contents of the DB don't seem to be persisted between AppServer restarts.  ... to know where it is so I can inspect it with 'database explorer'. The docs say to set it to "$objectdb/db/points.odb" and ...

 
forum_thread

How do I Remove an entity from the Database ?

Hi I no longer want to use an Entity .. (in SQL terms the whole Table ) ... How do I delete it ?   Thanks Paul Newman ... removed but this only affects the list of classes in the Explorer. Removing of classes will be supported in the future. ...

 
forum_thread

multi thread application, id field sporadically null

We are testing objectDB with a multi thread application. Each thread has it's own entityManager created from a common factory. In one thread we receive sometimes an object from the database with the field that is declared as @Id having the value null (what is not correct, we checked that with the explorer). The class is declared like this: ... ... value null (what is not correct, we checked that with the explorer). The class is declared like this: ... @ Entity ...

 
issue

Critical error:: com.objectdb.o.InternalException: Unexpected internal exception with query

This is the query on the attached db (run in explorer): SELECT DISTINCT $1 FROM com.quasado.foundation.warehouse.payment.Payment $1 LEFT JOIN $1.receivable $2 WHERE (( ((($2 IS NOT NULL) AND ($2.receiver.qubletId=22))))) and this is the result: ... This is the query on the attached db (run in explorer): SELECT DISTINCT $1 FROM com . quasado . ...