About retrieve

faq

What is ObjectDB?

ObjectDB is an object oriented database management system (ODBMS). It provides all the standard database management services (storage and retrieval, transactions, lock management, query processing, etc.), but it uses an object oriented model to store an ...

 
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: ... The following example demonstrates using this ability to retrieve cities in a specific radius from Paris: import java. util ...

 
forum_thread

Database absolute filepath

Is there a line of code that can be used to print out my databases absolute path? I have set it as follows: EntityManagerFactory emf = Persistence.createEntityManagerFactory("$objectdb/database/people.odb"); However, the data being shown in *\lib\objectdb\database\people.odb* is different than what is being used in the rest of the application so I think there might be more than one database somehow.... ObjectDB 2.5.7 adds the ability to retrieve connection details. Please try the following test program ...

 
forum_thread

Can a Set<E> be a foreign key?

I have two classes, Cell and Character.  Basically, the cell is like a room, and contains a variable (private Set<Long> cellHeldCharacters;) which holds the IDs of the characters within the cell (The IDs are Primary Keys).  Can I use the Foreign Key annotation for the variable, or is it illegal/unrecommended to do it for a Set? For a better picture, I have: ... And I want to know if I can do this safely and retrieve it nicely later on: @ Entity public class ...

 
forum_thread

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1.parentOrgId='news') OR (($1.parentOrgId=$2.organisationId) AND ($2.parentOrgId='news'))) OR ((($1.parentOrgId=$3.organisationId) AND ($3.parentOrgId=$2.organisationId)) AND ($2.parentOrgId='news')))) I've also tried running the CDI query first and passing the results into the organisation query as follows: #1 2012-02-16 09:16 Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINC ...

 
doc

initCause(cause)

Initializes the cause of this throwable to the specified value.(Method of java.lang.Throwable)

 
forum_thread

Multiple joins did not return expected result

Hello, I have 3 entity classes: Event - String title Calendar - List<Event> @OneToMany SharedCalendar extends Calendar - Calendar original Now I want to retrieve all events from a specific calendar by its id like: ... Calendar - Calendar original Now I want to retrieve all events from a specific calendar by its id like: SELECT ...

 
forum_thread

Spring Transactions (@Transactional) within ObjectDB

Hi, We are using OBD with Spring and transactions are managed by Spring. Our spring service interfaces take list of objects and persist them and the interface service is marked as @Transactional. We iterate through the list apply business validations and persist them one by one in a loop. ( Using Spring Data) We have noticed that in a loop 1st object is persisted and then we if lookup the same object we don't get it back on lookup. ... This is with transactions we are not able to retrieve the persisted object within the same transaction. It is only available ...

 
forum_thread

Get activation code for a server with no Internet connection

Hello, We bought a license, but the server is not connected to the Internet. How do we get the activation code? Dmitry Zakharov ... computer that is connected to the Internet, in order to retrieve the activation code. Add the activation code that is ...

 
api-jdo

storeBooleanField(fieldNumber, value)

Store one field into the field manager.(Method of javax.jdo.spi.PersistenceCapable.ObjectIdFieldConsumer)