About Data Source

issue

Strange Error with Criteria API and Sorting

We're creating a simple selection (distinct) including an order clause. When watching the created criteria in debugger we get the correct expression: SELECT DISTINCT $1 FROM MyEntity $1 WHERE ((TYPE($1)=class test.MyEntity)) ORDER BY UPPER($1.name) DESC You can see that in the order by there's correctly a "$1" var. Running this (without the type thing before) in the explorer correctly returns the sorted results. However, running this with the criteria API produces this error: ... ( ) ;   // Add some data em. getTransaction ( ) . begin ( ) ; ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Removing an entity throws exception

Hi all, I'm testing ObjectDB for my project, but I have troubles with it. At this time I'm not able to remove customer entity, when it's read by a query (it's attached), it throws this exception: Exception in thread "AWT-EventQueue-0" java.lang.RuntimeException: com.objectdb.o._RollbackException: Failed to commit transaction: 51 ... ... has not found an error. Clearing the old database from all data helps, now it works. Michael ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Problems down-casting in WHERE clause

I have a family of related types, like this: @Entity class Base { String val1; String val2; }; @Entity class Derived1 extends Base { String val3; }; @Entity class Derived2 extends Base { String val4; };  I'm trying to implement a query which will return all Base objects which have a given string within any of their String-typed fields.  The query I'm using looks somewhat like this: ... attaching the database here because it contains sensitive data). edit ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

mapping file is not being loaded

Hi, I am evaluating ObjectDB by using it with an in-house developed library in order to prototype its capabilities / performance. I am having a problem in that the in-house library in question reads a simple configuration file to determine available persistence units, and then bootstraps them using the JPA Persistance.createEntityManagerFactory() method and passing in the persistence unit name (again, obtained from the configuration file ). ... it.  After running the unit test, the Metamodel data for any other entity class that was reachable from the one I persisted was ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

performance limit

Hi, can someone share expirience with performance limits of ObjectDB especialy when quering tables with large records sets. Our issue is with tables with 100.000+ records. Everything was OK when we had few thousand records. We have a simple SELECT statement which selects from a table with 100.000+ records by UserID atribute, tables have from 5 to 20 atributes. Usualy the results range from few hundred to few thousand records. This query takes up to 12 seconds. Is this normal, what when we will have few milion records, how to handle this. ... faster in the Explorer (because in the Explorer result data is always loaded lazily). You may execute queries in the application with ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Modifying something with Explorer -> app JPQL with Enum doesn't work anymore

Hi! Scenario: Copy attached DB into localhost ObjectDB server (I'm running 2.5.1_03). Open attached project JavaEE Maven with NetBeans (7.4 beta in my case). Start ObjectDB on localhost as server. Run project on Apache Tomee 1.5.2 standard. Take a look at NetBeans' output to see how many entities are found with field type GOOD. There are 2 ways generate the bug: ... by the the NamedQuery does not correspond with the actual data present in the database. Query: "SELECT b FROM Bug b WHERE b.type = ?1" ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

significant performance decrease

we are using objected in embedded mode (on OS X and WINDOWS). The database increased now to around 400000 entities of one class (database file size around 1.5 GByte). The response time of standard queries increased with this database size to an unacceptable rate (several seconds compared to around 30% when the number of entities was just half of the current). We tried to optimize the cache settings, current objectdb.conf is: <!-- ObjectDB Configuration --> <objectdb> ... port = "6136" max = "100" /> <data path = "$objectdb/db" /> <!-- <replication ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Is it possible to remove parent/child entities without refresh?

We have a big object tree in our project. If I use the entityManage.remove method a entityManager.refresh is necessary in order to have an updated object tree in memory. But entityManager.refresh is too slow for our project. Do you know a possibilty to remove parent/child entities without entityManager.refresh after the entityManager.remove operation? I have searched for a solution with the following unit test (See testRemoveVariant2()). But my approach works correctly. Do you have an idea? ... the problem, could you please explain in which way data in memory is not up to date after remove and how exactly  ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ... Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments . ...

 
forum_thread

Queries are slow on a large database

Hi, I have a 12GB database with 787603 entries. It is much larger than usual and there are performances issues. I am doing small queries and they take much longer than I expect, i.e.: Get the total number of entries Get 25 consecutive entries (i.e. 0-25) Get one specific entry On average each query needs 4 to 5 minutes to return a result. I have been adviced to use indexes but they are already used through the JDO Metadata file. For instance I use this class: ... can be ordered by the index rather than by accessing the data. If you add a new index to an existing database use the Doctor to create a ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

500Mb ObjectDb database opening issue

Hi, I have observed that 500 Mb objectDb database opening time is very slow (~3 seconds) for following code m_EntityMgrFactory = Persistence.createEntityManagerFactory( "objectdb:" + aFilename ); m_EntityManager = m_EntityMgrFactory.createEntityManager(); Does exist any way to speed-up open time for big databases? Definitely, it's too long for 500 Mb database! ... & demo presentation which show problem with long data base open operation issue. Could you check from ObjectDb side which ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...