About execute

forum_thread

Listing large number of complicated objects with paging.

Hi, For last few hours I was working on a problem with bad performance and memory problems with such a simple query: select prod from Product prod order by prod.id ASC Right now I have 55541 'Product' (attached to this post) entities in database and I'm trying to speed listing them with paging. The problem is, that running code that looks like this: #1 2011-11-15 18:32 Hi, For last few hours I was working on a problem with bad performance and memory problems with such a si ...

 
forum_thread

JBoss 7 startup fails

Hi, I was having a go with entity beans 3.x jboss 7, objectdb and the guestbook web application but cannot come out of the swamp. I use eclipse indigo as IDE The "src" folder contains the pachake guest and within the classes: Guest.java, GuestListener.java and GuestServlet.java The WebContent/META-INF dir contains: context.xml #1 2011-09-21 11:50 Hi, I was having a go with entity beans 3.x jboss 7, objectdb and the guestbook web application but cannot come o ...

 
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: ... at com.objectdb.jdo.JdoQuery.execute(JdoQuery.java:720) Thanks. ... = ( Object [ ] ) query. execute ( ) ;   Integer minId = ( Integer ...

 
issue

Error 990 when querying a class with persistence-capable-superclass

[ObjectDB 2.4.7_07] Unexpected exception (Error 990) Generated by Java HotSpot(TM) Server VM 1.7.0_10 (on Linux 3.2.0-39-generic-pae). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.InternalException.f(InternalException.java:236) at com.objectdb.o.STA.K(STA.java:339) at com.objectdb.o.ENT.D(ENT.java:533) at com.objectdb.o.ENT.M(ENT.java:681) at com.objectdb.o.LDR.F(LDR.java:589) at com.objectdb.o.LDR.E(LDR.java:466) ... at com.objectdb.jdo.JdoQuery.execute(JdoQuery.java:720) at ... ) ; return ( Long ) query. execute ( ) ; All queries (eg ones with parameters) ...

 
forum_thread

Join performance in Objectdb

select count(e) from Meta e, ImageNet i, Page p where e.idImage=i.id and e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA #1 2011-08-27 08:37 SELECT count ( e ) FROM Meta e , ImageNet i , Page p WHERE e . idImage = i . ...

 
manual

JPA / JDO Class Enhancer

The Enhancer is a post compilation tool that improves performance by modifying the byte code of compiled classes after compilation. ObjectDB Enhancer is a post compilation tool that improves performance by modifying the byte code of compiled classes after compilation. Enhancement is mainly for user-defined persistable classes ( entity classes , embeddable classes and mapp ...

 
forum_thread

Remove an entity which attributes were changed - OptimisticLockException

We use an OSGi environment and we have three OSGi plugins.   In plugin A an entity is loaded and the entity is passed to plugin B. Plugin B changes an attribute on the entity. Plugin C removes the entity from the database. After commit the transaction an exception is caused with optimistic lock exception of the removed entity. If this operations on the entity are executed in only one plugin, it works well. ... with plugins com.btc.ep.base.dal.tests.it and main.You can execute the unit test OptimisticLockTest as a JUnit Plugin Test. The test ... 19:05 Please execute the unit test OptimisticLockTest as a JUnit Plugin Test. ...

 
forum_thread

how explorer queries work

i'm curious as to how the explorer is able to execute queries when its obviously not aware of the object model that i built. the reason is because i have an application where i want to be able to execute somewhat generalized queries and i won't know what classes are in the object model ahead of time. this is especially curious to me in client-server mode since the .jar with the object model classes is on the server side, not the client side where explorer is running. ... i'm curious as to how the explorer is able to execute queries when its obviously not aware of the object model that i built. ... because i have an application where i want to be able to execute somewhat generalized queries and i won't know what classes are in ...

 
forum_thread

order by string with numbers

Hi Anyone could help me I need ordered a string  for example user1, user2, ..., user1000 I found sql solution but I would like to use criteria builder I don´t if exist CAST and AS UNSIGNED ORDER BY CAST(SUBSTR(usernameFROM 2) AS UNSIGNED) ASC If you have other alternative for JPA CriteriaBuilder please let me know. Thanks   #1 2014-08-16 21:29 Hi Anyone could help me I need to order a string  for example user1, user2, ..., user1000 I ...

 
api-jdo

setResultClass(cls)

Specify the type of object in which to return each element of the result of invoking execute or one of its siblings.(Method of javax.jdo.Query)