Grails7 - Multi DB withSession does not work

[arjangch]

When i try to use withSession with second DataSource throws No Session found for current thread exception.

I created a example project

• https://github.com/arjangch/grails7multidb

Also see older similar issues

• 'HibernateException: No Session found for current thread' for readOnly dataSource #10556
• Grails 3.2.4: multiple Datasources "No Session found for current thread" exception when accessing secondary datasource #10383

Exception throw is almost the same as older issues.

2025-02-04T07:14:25.041-05:00 ERROR 45417 --- [nio-8080-exec-4] o.g.web.errors.GrailsExceptionResolver   : HibernateException occurred when processing request: [GET] /students/usingSession
No Session found for current thread. Stacktrace follows:

java.lang.reflect.InvocationTargetException: null
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at org.grails.core.DefaultGrailsControllerClass$ReflectionInvoker.invoke(DefaultGrailsControllerClass.java:211)
        at org.grails.core.DefaultGrailsControllerClass.invoke(DefaultGrailsControllerClass.java:188)
        at org.grails.web.mapping.mvc.UrlMappingsInfoHandlerAdapter.handle(UrlMappingsInfoHandlerAdapter.groovy:105)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1088)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:978)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
        at org.grails.web.servlet.mvc.GrailsWebRequestFilter.doFilterInternal(GrailsWebRequestFilter.java:77)
        at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.bufferAndPostProcess(ContentBufferingFilter.java:201)
        at org.sitemesh.webapp.contentfilter.ContentBufferingFilter.doFilter(ContentBufferingFilter.java:158)
        at org.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:144)
        at org.grails.web.filters.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:67)
        at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: org.springframework.dao.DataAccessResourceFailureException: Could not obtain current Hibernate Session
        at org.grails.orm.hibernate.GrailsHibernateTemplate.getSession(GrailsHibernateTemplate.java:335)
        at org.grails.orm.hibernate.GrailsHibernateTemplate.doExecute(GrailsHibernateTemplate.java:284)
        at org.grails.orm.hibernate.GrailsHibernateTemplate.execute(GrailsHibernateTemplate.java:241)
        at org.grails.orm.hibernate.GrailsHibernateTemplate.execute(GrailsHibernateTemplate.java:120)
        at org.grails.orm.hibernate.AbstractHibernateDatastore.withSession(AbstractHibernateDatastore.java:355)
        at org.grails.orm.hibernate.AbstractHibernateGormStaticApi.withSession(AbstractHibernateGormStaticApi.groovy:84)
        at org.grails.datastore.gorm.GormEntity$Trait$Helper.withSession(GormEntity.groovy:917)
        at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321)
        at com.arjang.HelpersService.usingSession(HelpersService.groovy:38)
        at org.codehaus.groovy.vmplugin.v8.IndyInterface.fromCache(IndyInterface.java:321)
        at com.arjang.StudentsController.usingSession(StudentsController.groovy:29)
        ... 16 common frames omitted
Caused by: org.hibernate.HibernateException: No Session found for current thread
        at org.grails.orm.hibernate.GrailsSessionContext.currentSession(GrailsSessionContext.java:112)
        at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:508)
        at org.grails.orm.hibernate.GrailsHibernateTemplate.getSession(GrailsHibernateTemplate.java:333)
        ... 26 common frames omitted

[arjangch]

I just tested this. Hopefully helps.
If i call Employee (the object in second dataSource) from Quartz.job then i won't need @transactional annotation nor put code in any enclosure withTransaction {} norwithNewSession {)nor withSession {}

[arjangch]

Geb Test also fails but I am not sure if it is related. Added error to example project.
https://github.com/arjangch/grails7multidb

[jdaugherty]

@arjangch Is this a regression from 6 or does it exist there too?