26 | JPA Query Expressions (JPQL / Criteria), sqrt). String expressions (like, length, locate, lower, upper, concat, substring, ...). Data |
26 | ObjectDB Object Database Features & functions (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER |
26 | JPA Criteria API Queries, quot, mod, abs, neg, sqrt). String expressions (like, length, locate, lower, upper, concat, substring |
18 | 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 |
13 | Database size is much larger than expected (x2) Uris(); String sLine; sLine = sss.substring(rd.nextInt(100)); uri.setsUrl(sLine); int |
13 | Partial IndexingI have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA gzdillon Lai Yang Currently ObjectDB supports |
3 | combined index not usedcombined index not used |
2 | com.objectdb.o.InternalException: null ParseException { String dateOfBirthStr = personalNumber.substring(0, 8 |
