About execute

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)

 
doc

java.lang.Throwable

The Throwable class is the superclass of all errors and exceptions in the Java language.(Class of java.langClass Throwable)

 
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) ...

 
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

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

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 . ...

 
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

Working with a cleared cache

I'm working on trying to improve the performance of our database processing class and I'm attempting to keep the L1 cache within the PersistenceManager cleared in an effort to reduce its memory footprint. The code snippet below is part of a Callable task that is run repeatedly with a given list of commands. When I run the code as written I start getting the stack traces that are listed.  However, if I comment out the calls to makeTransactionalAll() and evictAll() everything works.... toDelete = ( Collection ) query. execute ( ) ; m_persistenceManager. ...