Home » Search

About SELECT

41-50 of 200Refresh
Forum
18

Selecting random rows

Hello is there way to get random rows? Functions like rand(), random(), newid() doesn't work ;/ for example: em.createQuery("SELECT s FROM StawkaVat s ORDER BY rand()").setMaxResults(5).getResultList(); gives exception: Exception in thread "AWT-EventQueue-0" [ObjectDB 2.5.6_02] SELECT s FROM
Issue
18

NullpointerException at a normal select

When I run the following code: EntityManager em = getEm(); Customer result = null; try {     logger.debug("Ident: "+ident);     result = em.createQuery("Select c from Customer c where c.identifier=:id", Customer.class).setParameter("id", ident).getSingleResult(); } catch (javax.persistence
Forum
18

Performance in SELECT statement

has around 30.000 rows) Example query looks like : String strSelect = "SELECT e FROM TestEntity
Forum
17

Class fields selection to store

Class fields selection to store
Forum
17

Selective merge/cascade of detatched entity

Selective merge/cascade of detatched entity
Tutorial
16

Getting Started with JPA - Eclipse Project

: Select File > Import... > Maven > Existing Maven Projects and click Next. Select the points-console directory as Root Directory and press ENTER. Select the project and click Finish. Run the project in Eclipse: Right click the project node and select Run As > Java Application. Select Main - point and click OK.
Manual
16

Paths and Types in JPQL and Criteria API

identification variables and SELECT result variables. Parameters - when instances of these classes are assigned ... through a NULL value The following query retrieves country names with their capital city names: SELECT ... of all the entity objects in the database, excluding Country entity objects: SELECT COUNT(e) FROM
Tutorial
16

Step 1: Install BIRT and ObjectDB Driver

 Eclipse IDE for Java EE Developers environment: Open the [Install] dialog box by selecting Help ... Neon, Oxygen) and press ENTER. Click the Select All button to select all the BIRT features. Complete ... To install the ObjectDB data source driver for BIRT: Open the [Install] dialog box by selecting Help
Manual
15

DELETE Queries in JPA/JPQL

an alternative way for deleting entity objects. Unlike SELECT queries, which are used to retrieve data from ... returns the number of objects that have been deleted by the query. Selective Deletion The structure of DELETE queries is very simple relative to the structure of SELECT queries. DELETE queries
Tutorial
15

Getting Started with JPA - IntelliJ Project

: Select File > Open Project.... Select the points-console directory and click Open Project. Run the project in IntelliJ IDEA: Select Run > Run Main Project... (or F6). Click Select Main Class.