About null

issue

Issue with UPPER ?

Hi, Assuming those queries which are all the same except the UPPER calls: ... ( NOT ( ( $2 IS NOT NULL ) AND ( $2 . austritt IS NOT NULL ) AND ( $2 . austritt <= CURRENT_DATE ) ...

 
manual

Comparison in JPQL and Criteria API

Explains how comparison operators can be used in JPQL queries, including in comparing null values.... Comparison Operators Comparing NULL values IS [NOT] NULL Comparable Data Types [NOT] BETWEEN ...

 
manual

Literals in JPQL and Criteria Queries

Describes literals in JPQL, including null, false, true, numbers, strings, dates enums and types.... JPQL supports various types of literals including NULL , boolean literals ( TRUE and FALSE ), numeric literals (e.g. 100 ... page covers the following topics: The NULL literal Boolean Literals Numeric Literals ...

 
manual

Paths and Types in JPQL and Criteria API

Explains how to use object expressions (path navigation, type) in JPA/JPQL.... Path Expressions Navigation through a NULL value Entity Type Expressions Criteria Query ... (which is usually the case). Navigation through a NULL value The following query retrieves country names with their ...

 
manual

Logical Operators in JPQL and Criteria API

Explains how to use AND, OR and NOT in JPQL queries.... operator must be one of: TRUE, FALSE , and NULL . The following table shows how the AND operator is evaluated ... FALSE NULL TRUE ...

 
forum_thread

failure to enforce NOT NULL for java.lang.String

my test cases are indicating that @Basic(optional=false) and @Persistent(nullValue=NullValue.EXCEPTION) are not enforced in 2.3.7_08 or that i have failed to understand how to annotate. example: @Entity public class Request {   public Request() { }   @Id @GeneratedValue(strategy=GenerationType.IDENTITY)   private Long id; ... ( ) ; r. setUsername ( null ) ;   //try { tr. begin ( ) ... shows the Request object in the database with username=null. the target/ directory is wiped out by `mvn clean` so i am certain a ...

 
issue

Explorer bug ? Objects seem to be missing from database in Class view, but are present as references

objectdb-2.2.5_08 NetbeansID6.9.1+Glassfish3.01 I suspect the following is an Explorer bug. It is marked knowingly as CRITICAL by me because it makes the ObjectDB system unusable for a real project because it appears to be either database integrity corruption, or it just looks like it, which is just as bad. I attach a running project illustrating the problem, as well as screenshots. ... RequestBean []: Created: com.greensoft.entity.Project [null](TEST: project 1) INFO: RequestBean []: Persisted: ... RequestBean []: Created: com.greensoft.entity.Source [null](TEST: source) INFO: RequestBean []: Persisted: ... RequestBean []: Created: com.greensoft.entity.Project [null](TEST: project 2) INFO: RequestBean []: Persisted: ...

 
forum_thread

Null enums and IS (NOT) NULL: NullPointerException

Hello. I'm getting NullPointerException when adding %enum field% IS (NOT) NULL or == (!=) NULL in WHERE clause. The same exception using CriteriaQuery. ... NullPointerException when adding %enum field% IS (NOT) NULL or == (!=) NULL in WHERE clause. The same exception using CriteriaQuery. ... ( "SELECT e FROM TEntity e WHERE e.exampleEnum IS NULL" ) ; entities = query. getResultList ( ...

 
issue

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

I have marked this as CRITICAL because although there probably is no database integrity problem, the inability to robustly query relationship fields in a web application renders the ObjectDB system seemingly useless. objectdb-2.2.5_10 NetbeansIDE6.9.1 Glassfish3.01 client-server mode. odb file written to db-files/greendesk/greendesk.odb (see persistence.xml), copy of odb output attached. ... a served JSF page via a querying @EJB gives many fields null (and not even empty, I mean truly null). In the following explanation I will refer to the ... simple @OneToOne relationship fields that likewise become null: private List<Element> ownedElements = new ...

 
issue

com.objectdb.o.InternalException: null

After an error in a @PrePersist method in an Entity class, the database stopped working. Fortunately this was in development, but still worrying! The Entity class ... ) private Customer spouse = null ; private Date dateOfBirth = null ; private String firstName = null ; private ...