[#GPQUARTZ-49] HibernateException if objects are updated in jobs - Grails JIRA

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 0.4.1
Fix Version/s: 0.4.2
Component/s: None
Labels:
None
Environment:
Java 1.6.0_17
Grails 1.2.0 and 1.2.1
Grails-Quartz 0.4.1
PostgreSQL 8.4.2 or HSQLDB 1.8.0.10

Description

When I attempt to update domain class objects in job execute method HiberanteException is threw. Only when I attempt to update objects. When I select or create and save objects HibernateException isn't threw.

2009-12-28 23:54:50,015 [quartzScheduler_Worker-1] ERROR events.PatchedDefaultFlushEventListener - Could not synchronize database state with session
org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here
at org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:63)
at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:574)
at org.codehaus.groovy.grails.orm.hibernate.validation.HibernateDomainClassValidator.validate(HibernateDomainClassValidator.java:70)
at org.codehaus.groovy.grails.validation.GrailsDomainClassValidator.validate(GrailsDomainClassValidator.java:144)
at org.codehaus.groovy.grails.orm.hibernate.metaclass.ValidatePersistentMethod.doInvokeInternal(ValidatePersistentMethod.java:101)
at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractDynamicPersistentMethod.invoke(AbstractDynamicPersistentMethod.java:62)
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.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:188)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_addValidationMethods_closure19.doCall(HibernatePluginSupport.groovy:496)
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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaMethod.invoke(ClosureMetaMethod.java:81)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoMetaMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:307)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.call(PogoMetaMethodSite.java:63)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
at org.codehaus.groovy.grails.orm.hibernate.support.ClosureEventTriggeringInterceptor.onPreUpdate(ClosureEventTriggeringInterceptor.groovy:160)
at org.hibernate.action.EntityUpdateAction.preUpdate(EntityUpdateAction.java:237)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:88)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.codehaus.groovy.grails.orm.hibernate.events.PatchedDefaultFlushEventListener.performExecutions(PatchedDefaultFlushEventListener.java:44)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.codehaus.groovy.grails.plugins.quartz.listeners.SessionBinderJobListener.jobWasExecuted(SessionBinderJobListener.java:58)
at org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzScheduler.java:1910)
at org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java:355)
at org.quartz.core.JobRunShell.run(JobRunShell.java:226)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
2009-12-28 23:54:50,031 [quartzScheduler_Worker-1] ERROR core.ErrorLogger - Unable to notify JobListener(s) of Job that was executed: (error will be ignored). trigger= GRAILS_JOBS.simpleTrigger job= GRAILS_JOBS.ru.perm.kefir.MyJob
org.quartz.SchedulerException: JobListener 'sessionBinderListener' threw exception: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here [See nested exception: org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here]
at org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzScheduler.java:1912)
at org.quartz.core.JobRunShell.notifyJobListenersComplete(JobRunShell.java:355)
at org.quartz.core.JobRunShell.run(JobRunShell.java:226)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: org.hibernate.HibernateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here
at org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:63)
at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:574)
at org.codehaus.groovy.grails.orm.hibernate.validation.HibernateDomainClassValidator.validate(HibernateDomainClassValidator.java:70)
at org.codehaus.groovy.grails.validation.GrailsDomainClassValidator.validate(GrailsDomainClassValidator.java:144)
at org.codehaus.groovy.grails.orm.hibernate.metaclass.ValidatePersistentMethod.doInvokeInternal(ValidatePersistentMethod.java:101)
at org.codehaus.groovy.grails.orm.hibernate.metaclass.AbstractDynamicPersistentMethod.invoke(AbstractDynamicPersistentMethod.java:62)
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.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:188)
at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
at org.codehaus.groovy.grails.plugins.orm.hibernate.HibernatePluginSupport$_addValidationMethods_closure19.doCall(HibernatePluginSupport.groovy:496)
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.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:86)
at org.codehaus.groovy.runtime.metaclass.ClosureMetaMethod.invoke(ClosureMetaMethod.java:81)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite$PogoMetaMethodSiteNoUnwrapNoCoerce.invoke(PogoMetaMethodSite.java:307)
at org.codehaus.groovy.runtime.callsite.PogoMetaMethodSite.call(PogoMetaMethodSite.java:63)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
at org.codehaus.groovy.grails.orm.hibernate.support.ClosureEventTriggeringInterceptor.onPreUpdate(ClosureEventTriggeringInterceptor.groovy:160)
at org.hibernate.action.EntityUpdateAction.preUpdate(EntityUpdateAction.java:237)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:88)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.codehaus.groovy.grails.orm.hibernate.events.PatchedDefaultFlushEventListener.performExecutions(PatchedDefaultFlushEventListener.java:44)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.codehaus.groovy.grails.plugins.quartz.listeners.SessionBinderJobListener.jobWasExecuted(SessionBinderJobListener.java:58)
at org.quartz.core.QuartzScheduler.notifyJobListenersWasExecuted(QuartzScheduler.java:1910)
... 3 more

More Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Download All

Attachments

$i18n.getText("admin.common.words.hide")
grails-quartz.zip

28/Dec/09 1:07 PM

417 kB

Vitalii Samolovskikh
grails-quartz/.classpath 0.7 kB

grails-quartz/.project 0.5 kB

grails-quartz/.../org.codehaus.groovy.eclipse.preferences.prefs 0.1 kB

grails-quartz/application.properties 0.2 kB

grails-quartz/.../BootStrap.groovy 0.2 kB

grails-quartz/.../BuildConfig.groovy 1 kB

grails-quartz/grails-app/.../Config.groovy 3 kB

grails-quartz/.../DataSource.groovy 0.6 kB

grails-quartz/.../resources.groovy 0.0 kB

grails-quartz/.../UrlMappings.groovy 0.2 kB

grails-quartz/.../EntityController.groovy 4 kB

grails-quartz/grails-app/.../Entity.groovy 0.1 kB

grails-quartz/.../messages.properties 3 kB

grails-quartz/.../messages_da.properties 3 kB

grails-quartz/.../messages_de.properties 4 kB

grails-quartz/.../messages_es.properties 3 kB

grails-quartz/.../messages_fr.properties 2 kB

grails-quartz/.../messages_it.properties 2 kB

grails-quartz/.../messages_ja.properties 2 kB

grails-quartz/.../messages_nl.properties 3 kB

grails-quartz/.../messages_pt_BR.properties 3 kB

grails-quartz/.../messages_pt_PT.properties 3 kB

grails-quartz/.../messages_ru.properties 4 kB

grails-quartz/.../messages_th.properties 5 kB

grails-quartz/.../messages_zh_CN.properties 2 kB

grails-quartz/grails-app/.../MyJob.groovy 0.4 kB

grails-quartz/grails-app/.../create.gsp 2 kB

grails-quartz/grails-app/.../entity/edit.gsp 3 kB

grails-quartz/grails-app/.../entity/list.gsp 2 kB

grails-quartz/grails-app/.../entity/show.gsp 3 kB

Showing 30 of 186 items Download Zip
$i18n.getText("admin.common.words.show")

grails-quartz.zip

28/Dec/09 1:07 PM

417 kB

Vitalii Samolovskikh
stdout.log

28/Dec/09 1:07 PM

9 kB

Vitalii Samolovskikh

Issue Links

This issue depends on:
GRAILS-5836	Hibernate session issues with non request bound threads

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Malte Huebner added a comment - 27/Jan/10 3:28 AM

Is there a workaround for this blocker?

Show

Malte Huebner added a comment - 27/Jan/10 3:28 AM Is there a workaround for this blocker?

Hide

Permalink

Vitalii Samolovskikh added a comment - 27/Jan/10 4:00 AM

Yes. You can insert string "sessionFactory.currentSession.flush()" after your actions in job:

class MyJob {
    static triggers = {
		simple name:'simpleTrigger', startDelay:5000, repeatInterval: 5000, repeatCount: 0
    }

    def sessionFactory

    def execute() {
    	Entity.list().each{
    		it.flag=true;
    		it.save();
    	}

    	// With this line exception has not throwed
    	sessionFactory.currentSession.flush()
    }
}

Show

Vitalii Samolovskikh added a comment - 27/Jan/10 4:00 AM Yes. You can insert string "sessionFactory.currentSession.flush()" after your actions in job:

class MyJob {
    static triggers = {
		simple name:'simpleTrigger', startDelay:5000, repeatInterval: 5000, repeatCount: 0
    }

    def sessionFactory

    def execute() {
    	Entity.list().each{
    		it.flag=true;
    		it.save();
    	}

    	// With this line exception has not throwed
    	sessionFactory.currentSession.flush()
    }
}

Hide

Permalink

Julien Faissolle added a comment - 27/Jan/10 4:36 AM

I am facing this problem and solved it with:

def execute() {
        Entity.withTransaction {
    	    Entity.list().each{
    		it.flag=true;
    		it.save();
    	    }
        }
    }

Show

Julien Faissolle added a comment - 27/Jan/10 4:36 AM I am facing this problem and solved it with:

def execute() {
        Entity.withTransaction {
    	    Entity.list().each{
    		it.flag=true;
    		it.save();
    	    }
        }
    }

Hide

Permalink

Malte Huebner added a comment - 27/Jan/10 9:36 AM

I decided to use withTransaction and that worked really well. Thank you!

Show

Malte Huebner added a comment - 27/Jan/10 9:36 AM I decided to use withTransaction and that worked really well. Thank you!

Hide

Permalink

Vitalii Samolovskikh added a comment - 01/Feb/10 1:36 PM

I upgrade my test application (in attachments) to grails 1.2.1 but exception is threw again.

Show

Vitalii Samolovskikh added a comment - 01/Feb/10 1:36 PM I upgrade my test application (in attachments) to grails 1.2.1 but exception is threw again.

People

Assignee:

Sergey Nebolsin

Reporter:

Vitalii Samolovskikh

Vote (10)

Watch (9)

Dates

Created:

28/Dec/09 1:07 PM

Updated:

25/Mar/11 2:00 AM

Resolved:

26/Feb/10 2:43 PM

Quartz Plugin

HibernateException if objects are updated in jobs

Details

Description

Attachments

Issue Links

Activity

People

Dates