arjangch opened a new issue, #14333:
URL: https://github.com/apache/grails-core/issues/14333

   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 
   - https://github.com/grails/grails-core/issues/10556
   - https://github.com/grails/grails-core/issues/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
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to