ObjectDB ObjectDB
Home » Forum » JPA-Query does not lead to any result

JPA-Query does not lead to any result

#1
skolbskolb
Joined on 2012-05-04

Hi,

we have a database with a Entitiy inside which we want to fetch with a query. Normally that works without a problem, but in case of this database that query does not have any results. Can anyome help us what the problem is? 

SELECT FROM UserModelData usr WHERE usr.userName = 'admin'

Attached are two databases, one where the query has a result and one where the query does not has any results.

✂
edit
delete
#2
supportsupport
Joined on 2010-05-03

The query is executed using an index on field userName.

In not-working.odb, the index looks: 

0 -> UserModelData:"admin"
"system" -> UserModelData:"system"

It is unclear why the first index entry contains a number (0) rather than a string ("admin").

If you have more information about this specific file it may help.

You should be able to fix indexes by running the ObjectDB Doctor.

ObjectDB Support
✂
edit
delete

Reply

To post on this website please sign in.

ObjectDB Database Getting Started Support
DBMS Features Quick Tour with JPA ObjectDB FAQ
Editions and Prices JPA Console Tutorial ObjectDB Manual
Licence Web App Tutorial Forum
Attributions Java EE JPA Tutorial Issue Tracking
Privacy Spring MVC JPA Tutorial Website Search
Terms of Use Download ObjectDB Contact Us

Which JPA is Faster?

 

See a comparison of Hibernate, EclipseLink, OpenJPA, DataNucleus, MySQL, PostgreSQL, Derby, HSQLDB, DB4O by Versant, H2 Database, SQLite and ObjectDB

in the JPA Benchmark.

Copyright © 2003, 2010, 2024  ObjectDB Software, all rights reserved. The JPA API Reference Documentation (JavaDoc) on this website is derived with some adjustments from the open source JPA 2 RI (EclipseLink) and is available under the terms of the Eclipse Public License, v. 1.0 and Eclipse Distribution License, v. 1.0. The JDO API Reference Documentation (JavaDoc) on this website is derived with some adjustments from the JDO 2.2 API and is available under the terms of the Apache License, v. 2.0. Images on this website are available under these licecnes. Documentation on this website explains how to use JPA in the context of the ObjectDB Object Database but mostly relevant also for ORM JPA implementations, such as Hibernate (and HQL), EclipseLink, TopLink, OpenJPA and DataNucleus. ObjectDB is not an ORM JPA implementation but an Object Database (ODBMS) for Java with built in JPA 2 support.