About query

issue

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(((com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment) $1.qubletFRAGMENTMAP.get('com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment')).debitorAccount.bankAccounts.routingNumber) LIKE UPPER('%28%') results in the error ... Please find the attached database. Doing a simple query with casting SELECT COUNT ( DISTINCT $1 ) ... '%28%' ) results in the error Query Execution Error ===================== Unexpected query token ...

 
release

2.6.5

... database page objects . Improved release of query resources. Improved memory management in multi flush ... a bug in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded ...

 
api-jpa

JPA Reference (JavaDoc)

Java/JPA API Reference (based on the JPA 3 JavaDoc) This reference contains the API documentation (similar to JavaDoc) of the Java Persistence API (JPA) 2.0. The content is derived from the original JPA documentation (in the EclipseLink JPA 2 RI) with some additions and notes. The four most ba ...

 
release

2.6.3

... 2.6.3 Added an option to disable some query execution optimizations. Added an option to exclude ... temporary workaround for NullPointerException  on query after flush ( issue #249 ). Improved title of query ...

 
release

2.5.6

... Fixed a NullPointerException in query compilation. Fixed a memory leak (Negative snapshot user ... issue #225 ). Fixed "objectdb activation" query to work properly in client-server mode. Fixed enhancing ...

 
release

2.6.2

... temporary workaround for NullPointerException  on query after flush ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to ...

 
release

2.5.7

... types. Fixed the result type of a sum query on a single value. Version 2.5.6 Changed ... Fixed a NullPointerException in query compilation. Fixed a memory leak (Negative snapshot user ...

 
release

2.6.4

... database page objects . Improved release of query resources. Improved memory management in multi flush ... a bug in handling large objects with long primary keys as query results ( issue #260 ). Fixed detachment of embedded ...

 
release

2.7.1

... using nested embedded objects. Fixed a query cache InternalException. Fixed JDO ... view. Fixed a bug in caching Criteria query programs with IN operator. Fixed a bug in handling embedded ...

 
forum_thread

InternalError on query of empty database

Hi, I have reasons for sometimes trying to query the database before anything has been created. The problem is the database throws a InternalException when that happens. Is it possible to throw something that identifies that that is the issue, say something like "MissingSchemaException", ie something that clearly shows its because no data of that type has been added? This just makes the exception catching cleaner. Thought thinking about it, it probably needs to be a JPA exception, maybe something like javax.persistence.EntityNotFoundException? ... Hi, I have reasons for sometimes trying to query the database before anything has been created. The problem is the ... Either that, or is there some way to query the database about its current schema? Thanks P. ... 07:48 Hi, Query I'm running is: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.attributeList ...