| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| package org.apache.openjpa.persistence.temporal; |
| |
| import java.text.SimpleDateFormat; |
| import java.util.Date; |
| import java.util.List; |
| |
| import javax.persistence.EntityManager; |
| import javax.persistence.TypedQuery; |
| import javax.persistence.criteria.CriteriaQuery; |
| |
| import org.apache.openjpa.jdbc.conf.JDBCConfiguration; |
| import org.apache.openjpa.jdbc.sql.DBDictionary; |
| import org.apache.openjpa.persistence.OpenJPAEntityManager; |
| import org.apache.openjpa.persistence.test.SQLListenerTestCase; |
| |
| public class TestTemporalTimestamp extends SQLListenerTestCase { |
| private OpenJPAEntityManager em; |
| final SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS"); |
| |
| @Override |
| public void setUp() { |
| setSupportedDatabases( |
| org.apache.openjpa.jdbc.sql.DerbyDictionary.class, |
| org.apache.openjpa.jdbc.sql.DB2Dictionary.class); |
| if (isTestsDisabled()) { |
| return; |
| } |
| |
| setUp(CLEAR_TABLES, TemporalEntity.class, "openjpa.jdbc.DBDictionary", |
| "DateMillisecondBehavior=" + DBDictionary.DateMillisecondBehaviors.DROP, |
| "openjpa.Log", "SQL=TRACE,Tests=TRACE", "openjpa.ConnectionFactoryProperties" |
| ,"PrintParameters=true"); |
| assertNotNull(emf); |
| // noRound: |
| // expected:<253402322399000> but was:<253402325999000> |
| /* Date got = new Date(253402322399000L); |
| Date exp = new Date(253402325999000L); |
| System.out.println("NoRounding"); |
| System.out.println("Got = " + sdf.format(got).toString()); |
| System.out.println("Exp = " + sdf.format(exp).toString()); |
| */ |
| //testNoRoundingNoMillisecondLoss |
| //expected:<253402322399999> but was:<253402325999999> |
| /* got = new Date(253402322399999L); |
| exp = new Date(253402325999999L); |
| System.out.println("testNoRoundingNoMillisecondLoss"); |
| System.out.println("Got = " + sdf.format(got).toString()); |
| System.out.println("Exp = " + sdf.format(exp).toString()); |
| */ |
| //expected:<253402322400000> but was:<253402326000000> |
| /* got = new Date(253402322400000L); |
| exp = new Date(253402326000000L); |
| System.out.println("testRounding"); |
| System.out.println("Got = " + sdf.format(got).toString()); |
| System.out.println("Exp = " + sdf.format(exp).toString()); |
| */ |
| |
| loadDB(); |
| } |
| |
| public void testNoRounding() { |
| em = emf.createEntityManager(); |
| final List<TemporalEntity> temporalEntityList = findAll(em); |
| assertNotNull(temporalEntityList); |
| assertNotEquals(temporalEntityList.size(), 0); |
| for (final TemporalEntity temporalEntity : temporalEntityList) { |
| Date testDate = temporalEntity.getTestDate(); |
| assertEquals(testDate.getDay(), 5); |
| assertEquals(testDate.getMonth(), 11); |
| assertEquals(testDate.getDate(), 31); |
| assertEquals(testDate.getHours(), 23); |
| assertEquals(testDate.getMinutes(), 59); |
| assertEquals(testDate.getSeconds(), 59); |
| assertEquals(testDate.getYear(), 8099); |
| assertTrue(sdf.format(testDate).toString().endsWith(".000")); |
| } |
| em.close(); |
| } |
| |
| public void testNoRoundingNoMillisecondLoss() { |
| JDBCConfiguration conf = (JDBCConfiguration) emf.getConfiguration(); |
| DBDictionary dict = conf.getDBDictionaryInstance(); |
| dict.setDateMillisecondBehavior(DBDictionary.DateMillisecondBehaviors.RETAIN.toString()); |
| |
| em = emf.createEntityManager(); |
| final List<TemporalEntity> temporalEntityList = findAll(em); |
| assertNotNull(temporalEntityList); |
| assertNotEquals(temporalEntityList.size(), 0); |
| for (final TemporalEntity temporalEntity : temporalEntityList) { |
| Date testDate = temporalEntity.getTestDate(); |
| assertEquals(testDate.getDay(), 5); |
| assertEquals(testDate.getMonth(), 11); |
| assertEquals(testDate.getDate(), 31); |
| assertEquals(testDate.getHours(), 23); |
| assertEquals(testDate.getMinutes(), 59); |
| assertEquals(testDate.getSeconds(), 59); |
| assertEquals(testDate.getYear(), 8099); |
| assertTrue(sdf.format(testDate).toString().endsWith(".999")); |
| System.out.println("sdf.format(testDate).toString() = " + |
| sdf.format(testDate).toString()); |
| } |
| em.close(); |
| } |
| |
| public void testRounding() { |
| JDBCConfiguration conf = (JDBCConfiguration) emf.getConfiguration(); |
| DBDictionary dict = conf.getDBDictionaryInstance(); |
| // set value back to default |
| dict.setDateMillisecondBehavior(DBDictionary.DateMillisecondBehaviors.ROUND.toString()); |
| |
| em = emf.createEntityManager(); |
| final List<TemporalEntity> temporalEntityList = findAll(em); |
| assertNotNull(temporalEntityList); |
| assertNotEquals(temporalEntityList.size(), 0); |
| for (final TemporalEntity temporalEntity : temporalEntityList) { |
| Date testDate = temporalEntity.getTestDate(); |
| assertEquals(testDate.getDay(), 6); |
| assertEquals(testDate.getMonth(), 0); |
| assertEquals(testDate.getDate(), 1); |
| assertEquals(testDate.getHours(), 0); |
| assertEquals(testDate.getMinutes(), 0); |
| assertEquals(testDate.getSeconds(), 0); |
| assertEquals(testDate.getYear(), 8100); |
| // assertEquals(testDate.getTime(), 253402326000000L); |
| assertTrue(sdf.format(testDate).toString().endsWith(".000")); |
| } |
| em.close(); |
| } |
| |
| public List<TemporalEntity> findAll(EntityManager em) { |
| final CriteriaQuery<TemporalEntity> critQuery = em.getCriteriaBuilder().createQuery(TemporalEntity.class); |
| critQuery.from(TemporalEntity.class); |
| final TypedQuery<TemporalEntity> typedQuery = em.createQuery(critQuery); |
| return typedQuery.getResultList(); |
| } |
| |
| private void loadDB() { |
| em = emf.createEntityManager(); |
| em.getTransaction().begin(); |
| String sql = "INSERT INTO TemporalEntity (Id, testDate) VALUES (1, '9999-12-31 23:59:59.9999')"; |
| em.createNativeQuery(sql).executeUpdate(); |
| sql = "INSERT INTO TemporalEntity (Id, testDate) VALUES (2, '9999-12-31 23:59:59.9996')"; |
| em.createNativeQuery(sql).executeUpdate(); |
| em.getTransaction().commit(); |
| em.close(); |
| } |
| |
| } |