About check

forum_thread

Grouping by date()

Hi, For some time now we can use date and time function in queries to extract part of date time (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31'}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t '23:59:00'}) is evaluated to 59. SECOND({t '23:59:00'}) is evaluated to 0. ... is normal Date() field return only hours from 0 to 11 (check attached screenshot).     ...

 
forum_thread

Query fails with numerical values > 2^31

Hi ! I'm trying to execute the following query (from Java-code, also tried ObjectDB Explorer) delete from DataRecord p where p.TimeOfDeletion < 4147483648 This fails with "invalid numerical literal". The field p.TimeOfDeletion is of type long. As far as I know, the maximum value greater than 2^31 (Oracle: "The long data type is a 64-bit two's complement integer.") ... as well and allow 4147483648. Anyway, please check if adding L suffix to the long number (4147483648L) solves the error. ...

 
forum_thread

Mapped By Fetch is very Slow

Well ! I think i pointed out a HUGE performance issue with mapped-by attribute (yeah again :( ). Here is the test case : 1- Create 100 000 entities with for each 1 entity with @OneToOne(mappedBy attribute) 2- Retrieve only 10 000 for testing 3- Wait ... On my AMD FX 8350, it took 60s Now, go the MyEntity class and remove "mapped-by". You obtain 1 second max of query fetch. ... Thank you for this report. Please check build 2.6.2_08 that should fix this issue. Some information ...

 
issue

An entityManager.flush() with many entities is not possible

  The following exception occures if we call entityManager.flush() where the corresponding JPA PersistenceContext has many entities and relations. What is the reason for the exception? entityManager.getTransaction().commit() instead of a entityManager.flush() works correctly. Unfortunately I have not found a simple example to reproduce this exception. The entity model of the flushed JPA PersistenceContext is too complex.  ... exception indicates a problem in using these files. Please check this forum thread . Maybe disabling deletion of temporary files could ...

 
forum_thread

How to package orm.xml when using EJB in WAR?

Hi, I have database utility classes in one project, the id's use sequences declared in an orm.xml file for example: ... 02:17 Please check the attached NetBeans project. It is based on the Java EE ...

 
forum_thread

Corrupted Database or error in ObjectDBExplorer?

Hello, we have problems when we open our Database file with the ObjectDB-Explorer (2.6.8_b8). Can you analyze the problem and tell us if its a problem of the explorer or a real problem in the Database-File? An analysis with the DB-Doctor found no problems.   We observe the error if we try to open the Tree or Table Window for com.btc.ep.analysis.test.bl.internal.dmos.RequirementBasedTestCaseImpl  (its the 9th entity)   ... This may fix the database. Please check and update. ObjectDB Support ObjectDB - ...

 
forum_thread

Using explorer with a live embedded db

I want to use ObjectDB explorer with a running embedded db. This issue:  http://www.objectdb.com/database/forum/617   shows a way to do it. I followed the instructions, but still received an error when trying to connect: "...database ... currently in use by another process" I used an explorer on the same machine, trying to connect in both embedded and client-server mode. I could connect when I stopped my program that embedded the db. ... using an ordinary disk rather than a ramdisk (just as a check)? ObjectDB Support ObjectDB - Fast Object ...

 
forum_thread

Error with org.springframework.data.jpa.domain.AbstractPersistable

I am working on a Spring Boot application. I want to integrate ObjectDB with Spring Data JPA. I refer to the http://www.objectdb.com/database/forum/860 to do the configuration. When I start up my application, I got below error. It seems like ObjectDB does not support a generic @ID in the super class. Is this a bug in the ObjectDB? It was totally fine when working with Hibernate or EclipseLink. ... type (although parameterized) as a primary key. We will check if this ability can be added easily. ObjectDB ...

 
forum_thread

How to open a running db in ObjectDB Explorer?

Hi! I've just discovered that I can't see the content of a database while it's in use. Is there any way in which I could do that? It's not nice at all to close the application, copy the db in another location, start the application then finally I could explore my data, but it will be just a copy of the data, not the live information. #1 2013-05-25 18:08 Hi! I've just discovered that I can't see the content of a database while it's in use. Is the ...

 
forum_thread

Internal exception in objectdb-2.4.4_17.jar

Trying to read from ODB we are experiencing the following Internal Exception.  Any ideas? ... after restarting the server? You should also check the database by running the ObjectDB Doctor, since this exception may ...