ObjectDB Database Search

((r.fromExtension BETWEEN '2010' AND '2099') OR (r.fromExtension BETWEEN '2001' AND '2002'))) ORDER ... ' AND '2099')) OR ((r.fromExtension BETWEEN '2010' AND '2099'))) ORDER BY r.startDate DESC, r.startTime ... Andonov We have to reproduce this in order to understand the bug and fix it. Could you share

management changes - on order to verify that the new problems are caused by the new changes. support ... the same order as in our software that lead to Exception. I can't however reproduce this part of exception ... may be queries that return a lot of data, as well as queries that use GROUP BY and ORDER BY, in

;  jshaffstall Jay Shaffstall The easiest solution is to order the results by date in descending order :     SELECT FROM MyEntity e WHERE ... ORDER BY e.date DESC Then you can run

; if (isAscending) {     q = "select prod from Product prod order by prod." + sortColumn + " ASC";    } else {     q = "select prod from Product prod order by prod ... with paging order in given way. Now, when running this query with sort column set to 'id', it takes

query processing is required also for all the result objects before the first result (in order ... order value. For example, if your query returns results ordered by the primary key, use the value

a difference ? If so, in order to perform a truly scientifically clean comparison, I might be able ... internal ObjectDB system property that you can set (on your web application) in order to write enhanced ... that you can set (on your web application) in order to write enhanced classes  to files: -Dobjectdb.code

"); In order to be able to get the same error, I have attached a simple netbeans project with an example. I have also attached the server and node packages of JPPF. In order to run the example in ... to the objectdb.jar file. It is invoked in order to set the log file path, but indeed, the problem

the next build an option to disable this zero writing in order to see if it helps. If we disable ... that would be really helpful in order to limit the impact of this issue is to have a per-client ... that would be really helpful in order to limit the impact of this issue is to have a per-client

; " ORDER BY item.sku DESC"        ,ProductData.class)   ... id WHERE item.sku = :key OR id = :id ORDER BY item.sku DESC You may also try this (not valid JPQL ... .apiId.identifier = :id ORDER BY item.sku DESC support Support

" + " from Vtm vtm " + " where vtm.retired=:ret " + " order by vtm.name"; When I try to run ... " + " where vtm.retired=:ret " + " order by vtm.name"; System.out.println("JPQL: " + jpql); Map m

Hi, Query 1: SELECT DISTINCT $1, $2.lastName AS $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 ORDER BY UPPER($2.lastName) Correctly returns ... $O0 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 LEFT JOIN $1.profile $2 ORDER BY

has been modified. Still, you will have to manage the object IDs in order to merge a graph of objects that use ... together and they get persisted to the database in the wrong order causing a period of time where the current set

We have a big entity object tree in our project. If I use the entityManager.remove(childEntity) method to remove a child entity a entityManager.refresh(parentEntity) is necessary in order ... order to understand the problem, could you please explain in which way data in memory is not up to date

, how to define a priory order for visiting a slave than a master? For the reading balance, one may want ... using composite urls the order of the urls defines the connection priority. No need to restart

When I use @OrderBy and supply multiple order fields I get and error when ObjectDB Explorer expands a instance of the entity. Example code: @Entity @Table(name="Defects", schema = "myDB") public ... owner.defect inverse WHERE inverse = ?1 ORDER BY owner.seqRel, == noteSeq

than String UID primary keys. The main reasons for this ( ordered from the most important): Automatic ... of objects are organised and stored under that order , indexes are usually smaller. Back to primary

ORDER BY lastName, firstName, department.name, paygrade.rate"; return (ArrayList ) Main.employeeDB ... ("SELECT FROM Paygrade ORDER BY rate", Paygrade.class); TypedQuery modifyTo = Main.paygradeDB

?) in order for the update to take effect. It would be simpler to use the managed entity objects as ... , in order to close the database file properly. In an ordinary application you may consider setting a shutdown hook for this purpose. support Support

schema. support Support I followed these steps in the prescribed order . Stop old client application ... , and the final goal is to support schema changes with no need to restart at all. In order to investigate

). This is due to the execution order of query components, according to Explorer it retrieves all organisations twice ... ObjectDB. Is there any other way to specify execution order of query components for a complex query like

. Everything works fine until packets arrive with a time difference in the order of microseconds. Every scala ... When the traffic comes in bursts (packets arrive with a time difference in the order of microseconds

; BaseObject . an index on party in Relationship (or switch the order of party and relationshipType ... third element, so the order of elements in a composite index makes a difference. support Support Hi, I've

, therefore any modification of the order alters all entities in the DB. Mention: I have seen this bug by ... ;@ElementCollection(fetch = FetchType.EAGER) containing enums should be order independent. Thanks. zmirc

for type ch.ethz.id.wai.doi.bo.Metadata John johnbrush John Brush More details are required in order to understand the problem. Is there a sample database that you can upload in order to show the 

Hello there, Just wanted to know what are the limits (128TB) for a single instance. is sharding/clustering possible to increase this limit also what is the best way to design a db (what order ... . also what is the best way to design a db (what order of following points)? Please be more specific and use

projects you will still need one class loader that can load all the entity classes in order to set ... that demonstrates the issue is needed in order to explore it. support Support I want to upload

mapped by) order is preserved by ObjectDB automatically with no need for an order field. support

Today, after years of hard work, ObjectDB 2.0 was released and is available for download. In addition, in order to make ObjectDB more affordable, the pricing model was changed: The prices ... for all 2.x versions. Private priority support will be sold separately in order to make ObjectDB

.customProperties cp WHERE KEY(cp) = :propertyName AND VALUE(cp) = :propertyValue ORDER BY td.createdTimeMillis I ... .get(:propertyName) = :propertyValue ORDER BY td.createdTimeMillis support Support Thanks

to the allocate method in order to reset the current value. It will work only if the ID is still a 32 ... ; posting instructions  and use separate threads for unrelated topics. This is essential in order

.field1 and entity.id.field2 form a composite index together, in the order in ... : All the objects of this entity class are stored in the database ordered by field1 , field2

pipeline that all our features built in the correct order . Example:  e depends on d;  c depends on b; d depends on a; b depends on a; Then the Build order is:  1) a    2) b

; Clinton Moore CAPdev CAP Dev Store handler threads are created on the ObjectDB server in order ... default) in order to release  StoreHandler instances that have been alloacted to EntityManager

Good morning! I am interested in ObjectDB for a client project I am currently working on. In order to evaluate your tool I would like to know if your product has the ability to failover from ... to the replicated database url, switching the master and slave roles (in order to replicate changes in

; Now I can use "instanceof" within a query in order to select only elements of the specific type ... to the specific type in order to use properties of the specific type ("t.value")? SELECT o FROM

Hi all, I have problems with builds 7 and 8 when trying to sort entities with mappedBy and my own method in query. This query "SELECT c FROM Customer c order by c.getNormalizedName()" returns List ... ( "SELECT c FROM Customer c order by c.getNormalizedName()"); List resultList = query.getResultList

instructions ) in order to demonstrate the problem. support Support Here's my console test app. I commented ... ;  // create new database connection in order to cause exception       

MyEntity e ORDER BY e.indexedAttr" and check the results. 4- Sure. But unfortunately ... your reports regarding JOIN FETCH. Obviously more extensive tests are required in order to cover this feature

' and 'ModalContext'.     btc_es BTC EmbeddedSystems Unfortunately we need thread dumps in order ... a different order , so that can cause a deadlock. Now that the issue is clear we hope to be able

ProjectPartInfo ppi WHERE  == i WHERE - GROUP BY - HAVING - SELECT - ORDER BY Accordingly, in WHERE you can use FROM variables but not SELECT aliases. SELECT aliases can be used only in the ORDER BY clause.  support Support

. But more information is needed in order to find out the cause. Currently there is no similar open issue ... ? Debug logging was added in version 2.7.5 in order to collect more information ... are mixed and not ordered by age, even though writing to the log file is synchronized by ObjectDB

.classIdentifier='(TC)')). [Step 1b] Order the results of step 1a by:   v$1. [Step 1c] Scan index com.agile ... )')). [Step 1d] Order the results of step 1c by:   v$1. [Step 1e] Merge the results of steps 1b

.Contact $1 ORDER BY $O0 (Use one of my previous dbs)   tested with _08 as this worked perfect previously.. alex quasado Alexander Adam Note: Without order by works perfectly: SELECT DISTINCT $1

of both indexes and merges the results, which is orders of magnitude slower (30-50 ms): SELECT p FROM ... that satisfy: (p.rackOID='826268'). [Step 3] Order the results of step 2 by: p. [Step 4] Merge

above. You are right that scanning all the children of "candidate parents" in order to filter by names again (in order to check ages) may be faster than a full scan of all the parents

the order : @Id         String b; @Id         String a; the code outputs: 2 What is wrong? I'm afraid that the order of @Id

indexes: SELECT m FROM Message m ORDER by priority DESC, createTime could even be faster if both sort ... the priority values, in a way that lower values are picked first using: SELECT m FROM Message m ORDER by priority, createTime support Support

and c.name = 'Foo' order by name", Parent.class).getResultList().size());      ... and c.name = 'Foo' order by p.name   support Support Checking this further, although using name

.date BETWEEN :startDate AND :endDate ORDER BY t.date"); query.setParameter("startDate", LocalDateTime ... compatibility card here, it is not quite working: In JPA you can use the @Convert annotation in order

, we will need a sample project (even large and with no source code) in order to reproduce and fix ... - #11 above) have been fixed in build 2.5.5_11. The cause was unexpected order of invocation