Hello,
I have a domain class with a property having a org.joda.time.contrib.hibernate.PersistentDateTime mapping and I'm trying to run an HQL query with a Joda date on it.
Here is the mapping:
Code:
<property name="contactDateTime"
type="org.joda.time.contrib.hibernate.PersistentDateTime">
<column name="contact_datetime" />
</property>
Here is the domain class:
Code:
private DateTime contactDateTime;
public DateTime getContactDateTime() {
return this.contactDateTime;
}
public void setContactDateTime(DateTime contactDateTime) {
this.contactDateTime = contactDateTime;
}
Here is the Dao and its HQL statement:
Code:
Query query = getSession().createQuery("delete from Contact where contactDateTime is not null and contactDateTime >= ?");
query.setDate(0, sinceDate.toDate());
int count = query.executeUpdate();
Here is the test case:
Code:
public ContactDaoTest() {
contact0 = new Contact();
contact0.setContactDateTime(new DateTime());
contact0.setMessage("Hello Marc");
contact1 = new Contact();
contact1.setContactDateTime(new DateTime().plusDays(1));
contact1.setMessage("Hello Steph");
contact2 = new Contact();
contact2.setContactDateTime(new DateTime().plusDays(2));
contact2.setMessage("Hello Cyr");
}
public void testDeleteByDate() {
contact0 = contactDao.makePersistent(contact0);
contact1 = contactDao.makePersistent(contact1);
contact2 = contactDao.makePersistent(contact2);
DateTime sinceDate = new DateTime().plusDays(1);
logger.debug("The date sinceDate : " + sinceDate);
logger.debug("The date of contact0 : " + contact0.getContactDateTime());
logger.debug("The date of contact1 : " + contact1.getContactDateTime());
logger.debug("The date of contact2 : " + contact2.getContactDateTime());
long countDeleted = contactDao.deleteByDate(sinceDate);
assertEquals(2, countDeleted);
List<Contact> contacts = contactDao.findAll();
assertEquals(1, contacts.size());
}
And finally, the exception:
Quote:
2010-11-23 13:22:50,411 DEBUG [ContactDaoTest] The date sinceDate : 2010-11-24T13:22:50.411+01:00
2010-11-23 13:22:50,411 DEBUG [ContactDaoTest] The date of contact0 : 2010-11-23T13:22:50.382+01:00
2010-11-23 13:22:50,411 DEBUG [ContactDaoTest] The date of contact1 : 2010-11-24T13:22:50.382+01:00
2010-11-23 13:22:50,411 DEBUG [ContactDaoTest] The date of contact2 : 2010-11-25T13:22:50.382+01:00
2010-11-23 13:22:50,411 DEBUG [AnnotationTransactionAttributeSource] Adding transactional method [deleteByDate] with attribute [PROPAGATION_REQUIRED,ISOLATION_DEFAULT]
2010-11-23 13:22:50,411 DEBUG [TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bf8cd5] for key [org.hibernate.impl.SessionFactoryImpl@d28dfa] bound to thread [main]
2010-11-23 13:22:50,411 DEBUG [HibernateTransactionManager] Found thread-bound Session [org.hibernate.impl.SessionImpl@1a631c2] for Hibernate transaction
2010-11-23 13:22:50,411 DEBUG [TransactionSynchronizationManager] Retrieved value [org.springframework.jdbc.datasource.ConnectionHolder@1384ed5] for key [org.springframework.jdbc.datasource.DriverManagerDataSource@8be9ef] bound to thread [main]
2010-11-23 13:22:50,411 DEBUG [HibernateTransactionManager] Participating in existing transaction
2010-11-23 13:22:50,411 DEBUG [TransactionInterceptor] Getting transaction for [com.thalasoft.learnintouch.core.dao.ContactDao.deleteByDate]
2010-11-23 13:22:50,411 DEBUG [TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bf8cd5] for key [org.hibernate.impl.SessionFactoryImpl@d28dfa] bound to thread [main]
2010-11-23 13:22:50,411 DEBUG [TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bf8cd5] for key [org.hibernate.impl.SessionFactoryImpl@d28dfa] bound to thread [main]
2010-11-23 13:22:50,654 DEBUG [SQL]
delete
from
contact
where
(
contact_datetime is not null
)
and contact_datetime>=?
Hibernate:
delete
from
contact
where
(
contact_datetime is not null
)
and contact_datetime>=?
2010-11-23 13:22:50,655 DEBUG [DateType] binding '24 November 2010' to parameter: 1
2010-11-23 13:22:50,658 DEBUG [TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@1bf8cd5] for key [org.hibernate.impl.SessionFactoryImpl@d28dfa] bound to thread [main]
2010-11-23 13:22:50,658 DEBUG [TransactionInterceptor] Completing transaction for [com.thalasoft.learnintouch.core.dao.ContactDao.deleteByDate]
2010-11-23 13:22:50,659 DEBUG [SpringMethodRoadie] Test method [public void com.thalasoft.learnintouch.core.dao.ContactDaoTest.testDeleteByDate()] threw exception: null
2010-11-23 13:22:50,661 DEBUG [TestContextManager] afterTestMethod(): instance [com.thalasoft.learnintouch.core.dao.ContactDaoTest@14562c5], method [public void com.thalasoft.learnintouch.core.dao.ContactDaoTest.testDeleteByDate()], exception [null]
2010-11-23 13:22:50,661 DEBUG [TransactionalTestExecutionListener] Retrieved @TransactionConfiguration [null] for test class [class com.thalasoft.learnintouch.core.dao.ContactDaoTest]
2010-11-23 13:22:50,661 DEBUG [TransactionalTestExecutionListener] Retrieved TransactionConfigurationAttributes [[TransactionConfigurationAttributes@92eb86 transactionManagerName = 'transactionManager', defaultRollback = true]] for class [class com.thalasoft.learnintouch.core.dao.ContactDaoTest]
2010-11-23 13:22:50,661 DEBUG [TransactionalTestExecutionListener] No method-level @Rollback override: using default rollback [true] for test context [[TestContext@fec107 testClass = ContactDaoTest, locations = array<String>['classpath:spring-hibernate.xml', 'classpath:spring-hibernate-dao.xml', 'classpath:spring-data-source.xml'], testInstance = com.thalasoft.learnintouch.core.dao.ContactDaoTest@14562c5, testMethod = testDeleteByDate@ContactDaoTest, testException = [null]]]
2010-11-23 13:22:50,661 DEBUG [TransactionalTestExecutionListener] Ending transaction for test context [[TestContext@fec107 testClass = ContactDaoTest, locations = array<String>['classpath:spring-hibernate.xml', 'classpath:spring-hibernate-dao.xml', 'classpath:spring-data-source.xml'], testInstance = com.thalasoft.learnintouch.core.dao.ContactDaoTest@14562c5, testMethod = testDeleteByDate@ContactDaoTest, testException = [null]]]; transaction manager [org.springframework.transaction.support.DefaultTransactionStatus@1a4ea4f]; rollback [true]
2010-11-23 13:22:50,661 DEBUG [HibernateTransactionManager] Triggering beforeCompletion synchronization
2010-11-23 13:22:50,661 DEBUG [HibernateTransactionManager] Initiating transaction rollback
2010-11-23 13:22:50,661 DEBUG [HibernateTransactionManager] Rolling back Hibernate transaction on Session [org.hibernate.impl.SessionImpl@1a631c2]
2010-11-23 13:22:50,662 DEBUG [HibernateTransactionManager] Triggering afterCompletion synchronization
2010-11-23 13:22:50,662 DEBUG [TransactionSynchronizationManager] Clearing transaction synchronization
2010-11-23 13:22:50,662 DEBUG [TransactionSynchronizationManager] Removed value [org.springframework.orm.hibernate3.SessionHolder@1bf8cd5] for key [org.hibernate.impl.SessionFactoryImpl@d28dfa] from thread [main]
2010-11-23 13:22:50,662 DEBUG [TransactionSynchronizationManager] Removed value [org.springframework.jdbc.datasource.ConnectionHolder@1384ed5] for key [org.springframework.jdbc.datasource.DriverManagerDataSource@8be9ef] from thread [main]
2010-11-23 13:22:50,662 DEBUG [HibernateTransactionManager] Closing Hibernate Session [org.hibernate.impl.SessionImpl@1a631c2] after transaction
2010-11-23 13:22:50,662 DEBUG [SessionFactoryUtils] Closing Hibernate Session
2010-11-23 13:22:50,663 DEBUG [SessionFactoryUtils] Could not close Hibernate Session
org.hibernate.SessionException: Session was already closed
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:276)
at org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:791)
at org.springframework.orm.hibernate3.SessionFactoryUtils.closeSessionOrRegisterDeferredClose(SessionFactoryUtils.java:777)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCleanupAfterCompletion(HibernateTransactionManager.java:733)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.cleanupAfterCompletion(AbstractPlatformTransactionManager.java:989)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:855)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:800)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.endTransaction(TransactionalTestExecutionListener.java:501)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener.endTransaction(TransactionalTestExecutionListener.java:277)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:170)
at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:344)
at org.springframework.test.context.junit4.SpringMethodRoadie.runAfters(SpringMethodRoadie.java:307)
at org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:338)
at org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
at org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
at org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
2010-11-23 13:22:50,674 WARN [TestContextManager] Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1893efe] to process 'after' execution for test: method [public void com.thalasoft.learnintouch.core.dao.ContactDaoTest.testDeleteByDate()], instance [com.thalasoft.learnintouch.core.dao.ContactDaoTest@14562c5], exception [null]
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: Transaction not successfully started
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:677)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:823)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:800)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.endTransaction(TransactionalTestExecutionListener.java:501)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener.endTransaction(TransactionalTestExecutionListener.java:277)
at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:170)
at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:344)
at org.springframework.test.context.junit4.SpringMethodRoadie.runAfters(SpringMethodRoadie.java:307)
at org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:338)
at org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
at org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
at org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
at org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:51)
at org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:44)
at org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:27)
at org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:37)
at org.junit.internal.runners.JUnit4ClassRunner.run(JUnit4ClassRunner.java:42)
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:97)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
Caused by: org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:674)
... 28 more
2010-11-23 13:22:50,676 DEBUG [DirtiesContextTestExecutionListener] After test method: context [[TestContext@fec107 testClass = ContactDaoTest, locations = array<String>['classpath:spring-hibernate.xml', 'classpath:spring-hibernate-dao.xml', 'classpath:spring-data-source.xml'], testInstance = com.thalasoft.learnintouch.core.dao.ContactDaoTest@14562c5, testMethod = testDeleteByDate@ContactDaoTest, testException = [null]]], dirtiesContext [false].
Tests run: 8, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 9.15 sec <<< FAILURE!
Results :
Tests in error:
testDeleteByDate(com.thalasoft.learnintouch.core.dao.ContactDaoTest)
Tests run: 8, Failures: 0, Errors: 1, Skipped: 0
2010-11-23 13:22:50,725 INFO [GenericApplicationContext] Closing org.springframework.context.support.GenericApplicationContext@1adc30: display name [org.springframework.context.support.GenericApplicationContext@1adc30]; startup date [Tue Nov 23 13:22:44 CET 2010]; root of context hierarchy
2010-11-23 13:22:50,743 DEBUG [GenericApplicationContext] Publishing event in context [org.springframework.context.support.GenericApplicationContext@1adc30]: org.springframework.context.event.ContextClosedEvent[source=org.springframework.context.support.GenericApplicationContext@1adc30: display name [org.springframework.context.support.GenericApplicationContext@1adc30]; startup date [Tue Nov 23 13:22:44 CET 2010]; root of context hierarchy]
2010-11-23 13:22:50,743 INFO [DefaultListableBeanFactory] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@949f69: defining beans [sessionFactory,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,hibernateTemplate,org.springframework.beans.factory.annotation.RequiredAnnotationBeanPostProcessor#0,org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor#0,addressDao,adminDao,adminModuleDao,adminOptionDao,clientDao,contactDao,contactStatusDao,contactRefererDao,containerDao,contentImportDao,contentImportHistoryDao,documentCategoryDao,documentDao,flashDao,formDao,formItemDao,formItemValueDao,formValidDao,guestbookDao,linkCategoryDao,linkDao,mailCategoryDao,mailDao,userDao,preferenceDao,webpageDao,webpageDirectoryDao,dataSource,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor]; root of factory hierarchy
2010-11-23 13:22:50,744 DEBUG [DefaultListableBeanFactory] Retrieved dependent beans for bean 'contactRefererDao': [com.thalasoft.learnintouch.core.dao.ContactDaoTest]
2010-11-23 13:22:50,744 DEBUG [DisposableBeanAdapter] Invoking destroy() on bean with name 'sessionFactory'
2010-11-23 13:22:50,744 INFO [LocalSessionFactoryBean] Closing Hibernate SessionFactory
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] There are test failures.
Any clue ?
Login
FAQ
Search
