About SELECT

forum_thread

EntityManager.refresh takes a long time

EntityManager.refresh takes a long time for entity object Person in this code: ... logger. log ( Level. INFO , "begin select for person " + new Date ( ) . toString ( ... personQuery = em. createQuery ( "SELECT m FROM Person m" , Person. class ) ; ...

 
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. ... ... 16 more even if it is just SELECT a FROM Apple a or SELECT Orange o , and even with some freaky class loading of bar.Apple ... lines (e.g. Java code , stack trace ) - select a style in the toolbar and then insert the text in the new created ...

 
forum_thread

Eclipse plugin problem (using ObjectDB as a separate bundle)

Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest in the 2.2.8.01 release of objectDb. However I still get this error.   Here is my scenario (Groovy 1.8 and Eclipse 3.6) used. I have a com.epimss.lab.data.toxicology.TherapeauticDrugScreenRqst. Nested in this class are the following two classes: com.epimss.lab.data.misc.OtherRqst and com.epimss.lab.data.misc.RequestDateAndNumber. ... >>Run Configurations...     Select _com.epimss.lab.product in the left list, then choose Plug-ins tab on ... once the update is done and eclipse restarted,  select the _com.epimss.lab plugin, right click, select "Configure" in the popup ...

 
forum_thread

Explorer in 2.3

First, the new Explorer in ObjectDB is fantastic! This is exactly what we've needed - an easy way to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive data and Strings. After playing with it for a while, here is a list of additional features I'd love to have: 1. Export of selected data: a. Simple - Select a range of cells or a column header and copy text to the clipboard or save to a file (csv, html, etc..). (There appear to be copy menu options, but I cannot get them to work.) ... 1. Export of selected data: a. Simple - Select a range of cells or a column header and copy text to the clipboard or ... options, but I cannot get them to work.) b. XML - Select some objects and serialize them to XML (using ids for circular ...

 
forum_thread

Performance in large transactions

Hello, we have a performance problem when we use a large transaction. Let's do exactly the same in several transactions the ObjectDB works much faster. In our use case, we create many new entities and between the creations we call a select query. The execution of the query becomes slower at each iteration. (In the query, we search for an item of type Entity2. However, there is only one entity.)   Pseudocode for the fast and the slow solution FAST: ... many new entities and between the creations we call a select query. The execution of the query becomes slower at each iteration. (In ... Query Entity2 x = //query (getSingleResult): "select e from Entity2 e where e.start <= "+i+" AND "+i+" <= vec.end" ...

 
forum_thread

@ElementCollection query returning extra result per element in collection

Hi, ... testFindByLikeLowerWildcardWithoutBranchWithOr: SELECT $1 FROM Company $1 WHERE ((LOWER($1.name) LIKE :p1) AND ...   testFindByLikeLowerWildcardWithBranchWithOr: SELECT $1 FROM Company $1 WHERE ((LOWER($1.name) LIKE :p1) AND ... as a workaround until a fix is released: query. select ( companyRoot ) . distinct ( true ) ; ...

 
api-jpa

JPA Queries

Reference (JavaDoc) of all the JPA query types, including Query, TypedQuery, CriteriaBuilder, CriteriaQuery, Tuple, Root, Expression, Order, etc.... and running string based JPQL queries (e.g. "SELECT c FROM Country" ). Criteria Query API Building dynamic ... are organized in this reference into three groups. SELECT and ORDER BY elements (including tuples): Criteria Query ...

 
manual

BIRT/ODA ObjectDB Driver

Explains how to use the ObjectDB/JPA data source BIRT driver.... and press ENTER. Select the ObjectDB Birt/ODA feature. ... and selecting  New Data Source . Select ObjectDB Data Source from the list of available data source types. ... window and selecting New Data Set . Select an ObjectDB data source (e.g. ObjectDB Points ).  ...

 
tutorial

Step 7: Run the Spring Web App

Shows how to run the NetBeans Spring MVC JPA web application.... from the main menu (or F6 ): You can select the server in the Run category of the project properties window (right click the project node and select Properties to open it). Alternatively you can run the web ... Jetty plugin: Right click the project node and select Custom > Goals... Enter  jetty:run in the Goals field and ...

 
forum_thread

Remove a modified entity cause an optimistic lock exception

Hello, the following examples load and modify an entity, and load and remove the same entity. The first example 'SetAndRemoveIssue.java' is a simple java program which executes without errors. The second example is an OSGi program which fails with an optimistic lock exception. Both examples are equivalent, please execute SetAndRemoveIssue.java (in the OSGi example as a plugin-test). Can you explain the optimistic lock exception? ... MyEntity e = (MyEntity)em.createQuery("select m from MyEntity m").getSingleResult(); ... e = (MyEntity)em.createQuery("select m from MyEntity m").getSingleResult(); ... lines (e.g. Java code , stack trace ) - select a style in the toolbar and then insert the text in the new created ...