ObjectDB Database Search

Hi, I have a managed database for an Entity, "Program", containing a String field, "description", that is effectively a unique sub-string of a system generated description. Example: System: For Series Sales usage: 6014-Private Individual Swim Lessons  10-Pack Database: 6014-Private Individual

to mariadb or mysql using native java JPA API and in some cases JPQL or must i store to an Objectdb unique

Using JPA2, I can save entities now in JBoss, and also fetch them uniquely by id. However, if I try to fetch it by getting back all instances (e.g. findAll, I get the following error: org.jboss.arquillian.spi.ArquillianProxyException: com.objectdb.o._PersistenceException : Unexpected query token

dansmith Daniel Smith The combination of (type, ID) should identify entity objects uniquely

a persitance unit for every environment you want that has unique configuration and be sure to give it a name

way, by adding a 'name' field, which may be set as a primary key or as a unique index

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)? jonb Jon Brumfitt You can use as many databases as needed

2.4.6] javax.persistence.NoResultException" "No matching results for a unique query (error 782

for the database requests. * Probably, all persisted instances will be root objects with unique

, see this forum thread regarding setting a unique constraint when using ObjectDB. support Support

an error? The event variable is defined twice. You should use a unique name for every query variable

;     }     private @Index     @ Unique