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
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
Forum
2

a second mapping-file is ignored in persistence.xml by enhancer

> We start the enhancer and the entities of orm.xml will be enhanced by following output: enhancer ... will be enhanced by following output, because the enhancer is apparently ignored the ormreq.xml
Forum
2

Bug: ClassCastException by retrieval

("find by retrieval : %s %n",tn3.getTa()); System.out.printf("Arrays : %s %n",Arrays.toString(tn3 ... , l, l, o, W, o, r, l, d, 2] find by retrieval : H Arrays : [H, e, l, l, o, W, o, r, l, d, 2