Home » Search

About step by step

131-140 of 200Refresh
Forum
2

order by string with numbers

  The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM Users u ORDER BY SUBSTRING(u.username,4)*1 ASC If you have other alternative for JPA CriteriaBuilder to do it as sql did please let me know. Thanks   It seems that this is not supported by JPA
Forum
2

Update is ignored by ObjectDB

! Automatic update following direct modification of fields is supported by ObjectDB if any ... must also be enhanced. It is a good practice (and actually required by JPA but not enforced by ObjectDB) to avoid ... of the desired class should be used (e.g. by using the get and set methods). If you follow this practice
Forum
2

Modifying something with Explorer -> app JPQL with Enum doesn't work anymore

with field "type" GOOD found by the the NamedQuery does not correspond with the actual data present ... application, but addressing this by our support team is expected to take much more time. Images in ... . That's it. Anyway...it's just a NamedQuery that is executed by an EntityManager. That's all. I would really appreciate a fix
Result
2

ObjectDB Object Database Features

Databases are also supported by ObjectDB. The combination of Object Database features ... . Up to 9,223,372,036,854,775,808 entity objects per database file. Unlimited database connections (limited only by operating system resources). Unlimited CPUs and cores. Reliability and Stability Recovery from failure by
Issue
2

Alias not used in ORDER BY

(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY TEST However what I actually get as query string is SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY UPPER($1
Forum
2

Extending model by "common entity"

] Caused by: java.lang.ClassNotFoundException: pl.hplxtool.model.BaseEntity at com.objectdb.o.TYM ... . This schema change should be handled by ObjectDB - so the exception is unexpected. Maybe you have to restart the server (I see that the stack trace is generated by the server). If it doesn't help
Forum
2

Group by date / time

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day ... stats WHERE YEAR(record_date) = 2009 GROUP BY YEAR(record_date), MONTH(record_date) or maybe something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE
Issue
2

JPQL support for mapped by (inverse) collections

, SIZE, MEMBER OF, IN) are currently not supported for mapped by (inverse) collections. These operations are supported for direct (not mapped by) collections. Navigation and JOIN is supported for both direct and mapped by collections. The following test case demonstrates a problematic query
Forum
2

Need help to analyse very high memory usage by objectdb (PRU, SEV, VAL[])

exceeded" exception. Nearly 90% of the memory are taken by com.objectdb.o.PRU (49%) com.objectdb.o.SEV ... Forum Thread Need help to analyse very high memory usage by objectdb objects (PRU, SEV, VAL[]) has been created. This may be caused by large insert / update transactions, with large amount of data
Forum
2

UserException: Package com.example.model is not found by the enhancer

get the exception: com.objectdb.o.UserException: Package com.example.model is not found by ... ?   It may be a class loader conflict, i.e. the Enhancer and your classes are loaded by different class loaders and the Enhancer do not have access to the classes. Enhancing by invoking the Enhancer from