About like

91-100 of 200Refresh
Forum
1

Group by date / time

. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM ... something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE
Forum
1

How Should I Configure objectdb.conf to Obtain 256KB Disk IO Requests and Maximize Shared PersistenceManager Entity Cache?

persisted entity objects or fields of arbitrary objects (like key-value store)? Does ObjectDB access ... ?  Entire persisted entity objects?   Fields of arbitrary objects (like key-value store)?   To optimize ... a datastore pagefile cache page?  Entire persisted entity objects?   Fields of arbitrary objects (like
Forum
1

How to define database structure and insert some initial objects from scratch

need initial structure like tables, but how can we populate some "tables" with initial data from a script? In SQL world we have scripts like "insert into..." - Can we use main objectdb.jar library as jdbc driver for ETL software like Kettle? How about migrating data from another database
Forum
1

Is it possible get the All PrimKeys for a given entity class in the DB?

Hi, I would like to retrieve all the primKeys (user defined) by doing something like: TypedQuery query = em.createQuery("SELECT mif.primkey FROM MyClass mif ... - but sounds like it is double storage Thanks It should be possible using a JDO's method in the query
Forum
1

JBoss 7.1 and EAP 6 support

version by RedHat which is based on 7.1, has been released recently. I would really like to use ObjectDB ... this version of JBoss? I would also like to ask when but I know timeframes are not really known in advance ... product that runs rings around the competition and I would like to use your product. Thank
Forum
1

JPA 2.0 Criteria API: (When) Fully supported ?

_NAME) LIKE lower('value')". According to the exception message only "lower(FIELD_NAME) LIKE 'value ... ; but, of course, I would like to know: - When will the ObjectDB JPA 2.0 implementation fully support
Forum
1

JPQL JOIN FETCH Error

where LOWER( doi.doi ) LIKE LOWER( :doi ) The error is: Unexpected query token 'metadata' This query ... ) LIKE LOWER( :doi )   Thanks - the query is now being excepted by objectdb, however now I am getting ... WHERE LOWER( doi.doi ) LIKE LOWER( "10.000/test" ) ...I get the error: Invalid fetch path: .titles
Forum
1

No clue how to query with collection

Hi there! Actually, what I have is something like: @Embedable class Address {     String ... null). So I want something like this: SELECT c, a FROM Customer INNER JOIN c.addresses ORDER BY ... about is the ordering, not the selection itself... Alex Maybe something like: SELECT c, a FROM
Forum
1

Occasionally slow requests in load testing

like to understand better what you mean. Our tomcat processes are running on similar servers with 800 ... seconds wait on writing to disk. If you are referring to something else, I'd like to understand ... threads (e.g. database pages) is much more extensive so lock competition is more likely
Forum
1

Performance Questions...

performance ? Q2: Do LIKE operations have significant degradation on queries ? My last question is different ... . Even though ObjectDB implements LIKE very efficiently it still might be slower than other comparison operators. An index on the string field could help. LIKE against patterns that start with fixed characters