About in

forum_thread

Using aliases in WHERE clause

Hi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i.status IS NOT NULL Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE  ==> i <== .status IS NOT NULL   ... Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected ... When i change 'i' to 'ppi.inquiries' in my WHERE statement, query runs correctly : SELECT DISTINCT ...

 
forum_thread

Externalising persistence.xml properties in Glassfish?

Hi, ... Why dont you create multiple  presistance units in the persistance.xml and that way you can externalize the persistance unit ... up if you give the place holder. I know I have tried this in the application.xml  and I dont see why it wont work for the persitance ...

 
forum_thread

How to change properties in urls2.xml?

Hello, I am using objectdb in an embedded case with network private access to each database. I see it exists a file name "urls2.xml". <url><main>/var/lib/tomcat7/db/myDb.odb;user=admin;password=admin</main><alt>objectdb://127.0.0.1:38059/;user=$code;password=a2e54ea3-d889-41a7-953c-dabc42877742</alt></url> This file is autogenerated by objectdb. And it describes the locals databases url and their port / user / password properties. ... Hello, I am using objectdb in an embedded case with network private access to each database. I see it ... 17:44 The solution in #2 is for hiding sensitive information, in case you have a problem with ...

 
forum_thread

Password in Embedded Mode?

Is there a way to setup a database file that will be accessed in embedded mode, such that it is locked with a password.  Thereby making it impossible to use ObjectDB to access the contents of the file without providing the correct password when obtaining a connection.  In my case, I'm interested in obtaining a JPA connection:... there a way to setup a database file that will be accessed in embedded mode, such that it is locked with a password.  Thereby making ... the correct password when obtaining a connection.  In my case, I'm interested in obtaining a JPA connection: Map<String, ...

 
forum_thread

Project runs in Eclipse but not when exported to runnable jar

I have a simple project that performs some stability calculations and displays a scale drawing of a model glider. I decided to use objectdb as a way to persist the values for later retrieval. The project works perfectly well when run from eclipse but nothing opens when I export to a runnable jar and execute that. No windows open, there are no eror dialogs etc. Commenting out all the code related to object db resolves the issue and the project runs, so I'm fairly sure it is something I've done relating to objectdb. ... and objectdb.jar are included in the build path, and are present in the compiled file, as is the test GliderCalcs.odb file created by running ... this is a hobby project, please excuse any travesties in my code. Many thanks in advance, Mark ...

 
forum_thread

Query to search for common elements in two separate collections.

I'm trying to work out the most efficient way to build a query that can compare two collections for identical members. Something like: "SELECT o FROM Object o WHERE o.someCollection CONTAINS MEMBER OF :someCollection" Is something like this possible in the JPA spec? ... :someCollection Is something like this possible in the JPA spec? edit ... The hash code of every stored collection should be stored in an indexed field, possibly in a new entity or embeddable class that would ...

 
forum_thread

Reading 1.x odb files in ObjectDB 2.x without upgrading

Hi, We have a problem in the backward compatibilty in our software as once we have migrated object db odb file from version 1.x to 2.x, user is unable to open the odb files in the application which is having object db 1.x installed. Is there any way to read odb files from 1.x in object db 2.x without upgrading it ? Or user can see the content in read only mode without upgrading it ? Thanks ... Hi, We have a problem in the backward compatibilty in our software as once we have migrated object db odb file from version 1.x to ...

 
forum_thread

Empty temporary dat files in the temp folder

Hello, We have questions regarding the pagesX.dat files in the temp directory. We detected a problem on a machine with ‘only’ 2GB free memory on disc drive C:/ because during using our Product the %temp%/objectdb_123... folder growth up to 2GB. And then we run into some following errors due to lack of memory. ... We have questions regarding the pagesX.dat files in the temp directory. We detected a problem on a machine with ... stuff (find, persist, remove …) and then commit or in the case of errors rollback the transaction and closing the EntityManager. ...

 
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

Running doctor.jar with entity classes in classhpath

Hi, I am wondering how to populate new entity classes to database file, so that I could add new instances of these entities to database through explorer. I tried to run com.objectdb.Doctor with model.jar (my entity classes in it) in classpath but it doesn't work (new entities still dont show up in explorer). Could it be possible to add that kind of feature in next relase ?   I run doctor by executing cmd like : java -cp bin\objectdb.jar;_my_model_.jar com.objectdb.Doctor old_db.db new_db.db ... run com.objectdb.Doctor with model.jar (my entity classes in it) in classpath but it doesn't work (new entities still dont show up in explorer). Could it be possible to add that kind of feature in next relase ...