About in

forum_thread

JDO @Index in JPA?

Hi! I have a project which has all entities as JPA entities. I would like to make use of indexing, which I know that it's not available in JPA, but ObjectDB works with JDO as well. Question1: will adding JDO @Index in a JPA entity have any effect or I have to switch that entity to JDO? Question2: switching entities from JPA to JDO can happen when there is already data in the database? Or do I have to delete the previous data and start with a fresh db? Thank you. ... use of indexing, which I know that it's not available in JPA, but ObjectDB works with JDO as well. Question1: will adding JDO @Index in a JPA entity have any effect or I have to switch that entity to JDO? ...

 
forum_thread

@ElementCollection query returning extra result per element in collection

Hi, ... narrowing down an issue that only became apparent with in the UI. The issue is that, I'm getting repeated results of the owning ... The entity returned is repeated for every element in the collection. Switching back to EclipseLink (with the same code) yields ...

 
forum_thread

@Entity saved in Tomcat session - problem

Hi, I have found a problem, when storing @Entity object in Tomcat session. When starting or stopping Tomcat, I get nasty exception - please check attached log. Strange thing is, that after this exception everything works perfectly fine. The problem appears after using Enhancer. The nasty solution is to create copy of @Entity class as normal POJO and use it to store in session. The problem is, that we need the same logic for temporary users (without storing in DB) and permanent users (stored in database). A separate POJO makes the whole logic quite complicated.... I have found a problem, when storing @Entity object in Tomcat session. When starting or stopping Tomcat, I get nasty exception - ... of @Entity class as normal POJO and use it to store in session. The problem is, that we need the same logic for temporary users ...

 
forum_thread

List of Enum Values in an entity

Hello, I'm new with ObjectDB and just tried out the example in the Eclipse/Glassfish tutorial (http://www.objectdb.com/tutorial/jpa/eclipse/ee). After testing was successful, I extended the Guest class with an ArrayList of Enums: private ArrayList<GuestFlag> flags; The flags are stored into the database without any problem. In the explorer I can see that it is stored as array of Strings. ... I'm new with ObjectDB and just tried out the example in the Eclipse/Glassfish tutorial ( ... flags are stored into the database without any problem. In the explorer I can see that it is stored as array of Strings. ... the entity is enhanced, you may see a  null value in the debugger before accessing the field, but when the field is accessed it ...

 
forum_thread

Visibility of changes in Transaction is not visible to a JPA QL Query

I have two simple Entities ( see attachment ) and a simple SLSB with container managed transactions which is called by a trivial servlet. Inside a UserTransaction I add a number of items then check to see that they have been added ...   The problem is that the items that I add in the transaction are not visible when I go to count them; ... EAR, and the persistence.xml is located where it is used in the EJB project ( this was the only way I could get things to work on ...

 
manual

Database Explorer

Explains how to run and use the ObjectDB object database Explorer to view and manage Java/JPA/JDO objects visually.... managing ObjectDB databases. It can be used to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of ... the Explorer The ObjectDB Explorer is contained in the explorer.jar executable jar file, which is located in the bin ...

 
manual

Database Explorer

Explains how to run and use the ObjectDB object database Explorer to view and manage Java/JPA/JDO objects visually.... managing ObjectDB databases. It can be used to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of ... the Explorer The ObjectDB Explorer is contained in the explorer.jar executable jar file, which is located in the bin ...

 
forum_thread

"where in" query

Is it possible to run a query selecting values that exist in a provided list? e.g. something like: SELECT u FROM User m WHERE u.username IN ('test_user','anotheruser') I've tried various combinations of this including passing the list as a named parameter but without any joy. The only similar examples I can find in the docs involve a join query - but my list isn't in the database - and the MEMBER OF operator doesn't seem to do what I want (although I may be using it incorrectly! ... Is it possible to run a query selecting values that exist in a provided list? e.g. something like: SELECT u FROM User m WHERE u . username IN ( 'test_user' , 'anotheruser' ) I've ...

 
forum_thread

ID format in objectdb 2.x for JDOHelper.getObjectId

Hi, I am trying to upgrade the objectdb from 1.x to 2.x. I installed and configured as per object db tuotrial. I am just wondering, in objectdb 1.x, when i am tring to get the object id for a persistable object, i am getting an integer as a result e.g Object obj = JDOHelper.getObjectId(logTestRunImpl) used to return suppose 1 obj.toString() = 1 but the same code when i am trying to execute for the same object in object db 2.x, i am getting ... configured as per object db tuotrial. I am just wondering, in objectdb 1.x, when i am tring to get the object id for a persistable object, ... same code when i am trying to execute for the same object in object db 2.x, i am getting Object obj = ... Can you please let me know if there is any change in the JDOHelper.getObjectId method from object db 1.x to 2.x. And how can i ...

 
forum_thread

using objectdb.jar in writing data to mariadb or mysql db

Hello All, ... or php for the web version but i want to code queries in native java and reduce the use of regular sql patterns. Can my application ... to write to mariadb or mysql using native java JPA API and in some cases JPQL or must i store to an Objectdb unique database? Moreso, does ...