ObjectDB Database Search

; for operator IS EMPTY (error 756) Thanks. Note: It doesn' t work with SIZE (): SELECT e FROM MyEntity e WHERE SIZE (e.collection-valued)=0   eurojet P. F. Martinez Please follow the posting instructions ... ;    System.out.println(query.getResultList(). size ());      

the page cache (which has a size of 64MB per database by default ). Have you changed the cache size ... open databases with page cache size of 128MB (each) then this explains your numbers. The cache

the initial database size ). support Support If no conf file is found or provided ... in 500mb files.  do i need to specify the size in kbs? dansmith Daniel Smith The initial size

, if you know the maximum database target size , you may start with that size as an initial database size

connections are created but not closed. It may also be the result of limited heap size and out of memory ... . We increased hype size to 6GB and since that we haven’t have any crashes of JBOSS. Important to note is that JBOSS is not on the same server as ObjectDB. After we increased heap size and number

void likeTest() { StringHolder entry = new StringHolder("foobar"); assertEquals(0, getAll(). size ... (); assertEquals(1, getAll(). size ()); //Save was successful final String queryString = "SELECT holder FROM ... (); assertEquals(1, results. size ()); } private List getAll() { CriteriaBuilder builder = em.getCriteriaBuilder

: " + query.toString());         System.out.println("Result Size : " + resultList. size ());                 ... Query: SELECT $1 FROM MyDateEntity $1 WHERE $1.date=:$$cmlp1 Result Size : 1 The Predicate's toString

work with ObjectDb databases which may have size more than 5Gb and opening database time ... for a database. Opening time is not affected by the size of the database (since during opening ObjectDB just ... of a second to open a database of any size . Please provide more details. If you can make this specific

by objectdb is much less than we would expect. The database file has around 25 GByte of size ... ") It seems that when the heap dump was taken the size of the database page cache was about 1.4GB ... % of the maximum size is normal. In addition to this cache, the OS manages its own cache and can use

general. You can limit the size of the connection pool (the default in ObjectDB is currently 50), by ... the size of the connection pool (the default in ObjectDB is currently 50), by using the JDO method  ... ;setMaxPool? thamal Tomas Hamal You can specify the max pool size when you initialize

. size ()); } catch (Exception e) { System.out.println("Error executing query: " + e.getMessage()); ts ... "); } else { System.out.println("Items list size : " + items. size ()); for (Vtm item : items) { System.out.println("Vtm

- maybe you can clarify some of them: Database file page size : the default is 2kb ... better with bigger page sizes (e.g. if an Entity has 'a lot' of member fields)? Order in WHERE clause ... your questions: The page size may have some effect, but probably minor, so this is probably not the cause

Side) You should be able to set the connection pool size by a property in persistence.xml :      ... . Currently the default pool size is 50. support Support This is very useful information. I

, the children field of all my retrieved nodes are of size zero When I declare the FetchType as Eager ... might look empty - but as soon as your application accesses its content (e.g. by invocation of the size

Hi, Is there any way to check, if 2 level cache is in use? Right now I've done two things: 1. objectdb.conf with cache size is placed in WEB-INF directory of my web application. 2. persistence.xml ...  by setting its size to 0. The main problem with the default implementation is that the server

.getName()));     criteria.where(predicates.toArray(new Predicate[predicates. size ... Predicate[predicates. size ()])); return em.createQuery(criteria).getSingleResult();   String queryStr

side in C/S mode) still keeps the changes in memory until commit. As a result, the transaction size is limited by the available JVM heap size . Actually to be able to store 1GB of data in a single

that is added to my application that currently has 15 eclipse plugins. The size of objectdb.jar is 1.29 MB ( times 15 = 19.35Mb!) - a significant increase in size . With a single eclipse plugin I

for this example, but if you look at logs: Store: 4, size : 10 Offer: Offer for product: 94, store: 4 ... ; lwalkowski Lukasz Walkowski Running the new test with enhancement enabled produces: Store: 4, size : 9

Support As you said, the ObjectDB clustering can not support a database whose size is beyond the size

transactions are limited to the heap size , so this test that deletes and updates more than 500MB of data in one transaction requires a larger heap size . This limitation may be removed in future releases

;       System.out.println(results. size ());       ... ;     System.out.println(results. size ());        

; System.out.println(resultList. size ());         em.close();   ... (); System.out.println(resultList. size ()); em.close(); emf.close(); } private static Node persistTree(  

Hi, We have a problem where our database size grows over time more than expected. We've traced it down to the following issue: I have some entities that are using OneToMany relationship ... of addresses: "+res3. size ());         em.close();   

== null ? "null" : Integer.toString(flags. size ());   System.out.println("    ... output = name + " (signed on " + signingDate + ")";   if (flags != null && flags. size () 0

. that seems reasonable 1. Our server does (minimum) one database-file backup per day and the size may be in between 100 MB to 1GB (without documents) which means the size of the backup directory will increase

database. Their size and number of records are almost identical. When running production database in ... is different, possible due the size of the results (probably related to the number of related objects) First

. Is the enormous increase of database file size caused by the number of not-embedded objects in ObjectDB 2 opposed ...   JDO annotation ? Yes. 1. Is the enormous increase of database file size caused by the number

are per database. For example, the default cache size for database pages is 64GB per database, or 6.4GB per 100 databases, so it can easily exceeds your VPS RAM. If you must keep 100 databases open concurrently then you will have to reduce cache sizes , etc. support Support

(parentEntity);   Assert.assertEquals(4, parentEntity.getChildren(). size ());   entityManager ... , parentEntity.getChildren(). size ()); } }     wua Andreas Wurm This seems to be an old issue. The test passes with build 2.6.0_01. support Support

has no records either. However, looking at the DB- Size , it still has the same size ? The DB-Server

.createQuery("SELECT t FROM Transfer t").getResultList();     System.out.println(t. size ... ; System.out.println(t. size ());   }   pmbrierley Michael Brierley Both addObject and  addObjectw

has different members, but the same size .  List uid1_list = .. new Testclass(1,1), new Testclass(2,1 ... list the size of 3   To avoid this behavior (of the criteria builder.in method), you can set

system memory.  Is this size of database file supported in-memory on ObjectDB. We have a server ... supports pure memory database since version 2.6.4. There is no size limit, but it is a new feature, so if you experience issues let us know. support Support

Harman company requested to reduce ODB size as much as possible after database created and one of unliked solution was to use ZIP/UNZIP after/before use object DB database. Harman would like to ask ... ODB size up to 50 times. Additional info: https://www.objectdb.com/issue/23 Harman Alexander Golyshkin

.getResultList(); System.out.println(" size : " + result. size ()); We get an exception: [2016-11-14 10:48:56 #1

settings: The objectdb server process runs with -Xmx1g and the "consumer" runs with -Xmx2g. Message size ... also the servers, with different configuration (page cache size , query cache size ) for the metadata server

this on if you think it would be useful The current theory is that this may be related to the size ... at which point data sizes increased substantially. felixobjectdb Richard Szurgot Recording ... ) and is help as a string. The size is certainly larger than 2k and is likely to be in MB. The second

());             list.add("item-" + list. size ());   ... map.get("list"). size ();         }     } } support ... ("Expected one value, found: " + entity.list. size ());         em.close

Parent p join p.children c where c.age = 42", Parent.class).getResultList(). size ());    ... .children c where c.name = 'Foo'", Parent.class).getResultList(). size ());       ... .age = 42 and c.name = 'Foo'", Parent.class).getResultList(). size ());     

="debug") and logged to a file with limited size . We did not configure a log-archive (log-archive path="" retain="0"). That caused an exception when the log file reached its size limit ... Stocker Limiting the size of the log file without setting an archive directory is indeed considered

Due to the size of that collection the containing entity object exceeds the maximum supported size ... -server mode we had 650 smaller objects. None of them exceeded 2GB in size . So I don't

cached query result size . Since Java doesn't provide information on heap memory size of data

).getResultList();         System.out.println(" Size : " + resultList. size

when the operation has started). You cannot disable that cache since it has a minimum size even if you request zero size . In some situations (e.g. when using flush that is followed by other operations and then commit

As discussed and demonstrated in this forum thread , collection operators and methods (IS EMPTY, SIZE , MEMBER OF, IN) are currently not supported for mapped by (inverse) collections ... ; //System.out.println(query.getResultList(). size ());         // SELECT a FROM

in which ObjectDB does not have enough heap space. Please try to increase the size of the JVM heap or change the configuration to use less heap size . support Support

.objectdb.o.IVP.l(IVP.java:148) at com.objectdb.o.IVP.k(IVP.java:130) at com.objectdb.o.ISP. size (ISP ... .ISP. size (ISP.java:164) at com.objectdb.o.CLT.visitRefs(CLT.java:156) at com.objectdb.o.TVS.j(TVS.java

No idea what happened.  A simple getResultList() opearation. DB table affected size is ~ 26000 records, physical DB file size is ~ 8.5MB Thanks for any help ! Leon log file: ------------------------------------------------------------------------------------------------------------------------ [2016

.getResultList(); System.out.println(" size : " + result. size ()); We get an exception: [2016-11-14 12:48:56 #1