About MINUTE

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... extracting the YEAR , MONTH , DAY , HOUR , MINUTE and SECOND . For example: YEAR({d ... is evaluated to 23 . MINUTE({t '23:59:00'}) is evaluated to 59 . ... See JavaDoc Reference Page... <Integer> minute = cb. function function(name, type, args) ...

 
forum_thread

How to add minutes to a Date with JPA2

Hi,  I have to sum to a date of minutes, and check the date obtained is greater than the current date. My idea is as follows: Calendar currentTime = Calendar.getInstance(); Date currenteDate = currentTime.getTime(); Expression<Date> dateCapture = root.get(Counter_.dateCapture); Expression<Integer> samplingPeriod = root.get(Counter_.samplingPeriod); Expression<Integer> delayMinutes  = cb.prod(samplingPeriod,3); //minutes to be added #1 2012-06-22 09:31 Hi,  I have to sum to a date of minutes, and check the date obtained is greater than the current dat ...

 
forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System #1 2013-08-05 05:44 Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. ...

 
forum_thread

java.sql.Time field off by 30 minutes

Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On writing and readback, the field is found to be 30 minutes off. It is observed on objectdb explorer as well. Timestamp works perfectly fine. Ps. dont think its a UTC issue. My system is set at far off UTC+30min time.   #1 2012-03-07 01:28 Hihi, I'm wondering if this is a bug. I have a simple entity with java.sql.Time field. On wri ...

 
forum_thread

Master database switching to read-only mode, possibly caused by slave failure

We had a database failure causing a production outage. Both master and slave databases have failed, slave became unresponsive and the master switched to read-only mode. By the look of it the slave database failed first and possibly caused the master to switch to read-only mode. The sequence of events was: ... was: 13:20 - our monitoring reported GC time per minute on the SLAVE instance over 30 seconds. The GC time on the slave ... continued to grow rapidly until it reached almost 1 minute per minute, at which point the process is essentially hanging - see ...

 
forum_thread

JPA - ExceptionInInitializerError when creating EntityManager

EntityFactoryManager(emf) is successfully received but error at emf.createEntityManager Please see my code of fragment from my project. public class Main {        final private static Properties EMAIL_PROPS;      final private static String EMAIL_FROM;            static {  EntityManagerFactory emf = javax.persistence.Persistence.createEntityManagerFactory("tmpCLMSPU");  #1 2014-12-09 04:14 EntityFactoryManager(emf) is successfully received but error at emf.createEntityManager Please see my code of ...

 
forum_thread

TemporalType injection with Calendar using JPA

I have ObjectDB  JPA  comsummed by a RESTful web service deployed on Tomcat. I am using an embedded object as a primary key, which has time fields which I have annotated with TemporalType.TIMESTAMP When I use a java.util.Date as a field on this object there is no problem. However, if I use a java.util.Calendar it encounters an exception.   Calendar is what I need.  Is there something obvious here that I am failing to see?   ... ... ]) as a ... ... ]) as a ...

 
forum_thread

Occasionally slow requests in load testing

We are running load testing against objectdb version 2.3.7_18. The performance is generally OK, however there are quite a few "spikes" in the performance where we are getting a lot of very slow response times from the DB, around 10 - 15 seconds. Looking at the DB server process with AppDynamics we can see that most of the requests get stuck in one of 2 places: com.objectdb.o.PGC:w: line number 232 com.objectdb.o.LFL:U: line number 1068 Please see the attached callgraph examples for full stack trace examples. ... quite a high load - around 25000 calls to the db per minute. This includes variety of read and update queries.  Could ... load we are running - the load is 120000 call per minute, counting every call to com.objectdb.o.SHN:K method.   ...

 
forum_thread

Grouping by date()

Hi, For some time now we can use date and time function in queries to extract part of date time (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31'}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t '23:59:00'}) is evaluated to 59. SECOND({t '23:59:00'}) is evaluated to 0. ... HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t '23:59:00'}) is evaluated to 59. SECOND({t ... TIME(ts) - Extracts the time part (hour, minute, second, millisecond) as a Date instance. Please try ...

 
issue

stress test -> com.objectdb.o.InternalException: null

I am running a stress test with 2 users, each making a request to the JSON API (which uses as storage ObjectDB) each 50 milliseconds. An API call might have between 1-4 db calls, but they are relatively light, and the db has just a few MB at the moment. After a few minutes I got this exception. If I decrease the load, it doesn't happen. If I increase it, I get it very often. Any solution/fix? A sample project is very hard, if not impossible, to create, because it uses all the system. Bug Version: 2.5.5 Priority: Critical Status: Fixed Replies: 19 Type:  Bug ...