Home » Search

About SELECT

31-40 of 200Refresh
Tutorial
20

Spring MVC JPA Tutorial - IntelliJ Project

: Spring MVC JPA - Maven Project (7KB). Open the project in IntelliJ IDEA: Select File > Open Project.... Select the guestbook-spring directory and click OK. Define the Server: Select File > Settings ... ). Define Run Configuration: Select Run > Edit Configurations, click the + icon and select Tomcat
Forum
20

selecting objects that have a particular key/value in persistant HashMap

a JPA query that selects such objects?  Something like the following (but clearly does not work) :  SELECT p FROM Person p where p.pMap['location']='California' Any thoughts?  Thanks, -Adam   Please try the following query: SELECT p FROM Person p WHERE p.pMap.get('location') = 'California
Forum
20

Wrong select results

Hello, I got a realy strange SELECT problem. In explorer query "select p  from Player p where p.confirmed==false", given me some results with p.confirmed==TRUE. And when I try to do (see image) "select p, p.confirmed  from Player p where p.confirmed==false", I getting p->confirmed->true and p
Forum
19

A nested SELECT

Hello. I have a query UPDATE Look l SET l.partlySold = FALSE WHERE (SELECT count(a) FROM l.things a WHERE a.thing.status != :status) <= 1 which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this? Thanks. Nested queries (issue #11) is currently not supported
Forum
19

Conditional Selection

so when I use... SELECT firstName + " " + middleName + " " + lastName FROM Employee     ORDER BY ... an additional field. e.g. displayName. Use a method in the SELECT clause. It could be a static method
Forum
19

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
19

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
19

Performance in SELECT statement

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

BIRT/ODA ObjectDB Driver

extension. To install it: Open the [Install] dialog box by selecting Help > Install New Software... In ... ENTER. Select the ObjectDB Birt/ODA feature. Complete the installation by clicking Next twice, accepting ... and selecting New Data Source. Select ObjectDB Data Source from the list of available data source types
Manual
19

JPA Named Queries

="SELECT c FROM Country c") The @NamedQuery annotation contains four elements ... class. But since the scope of named queries is the entire persistence unit, names should be selected ... ", query="SELECT c FROM Country c") public class Country { ... } Attaching multiple named