Hello,
I have a portlet that connection to MsSql server via hibernate but time of this query is very long and at last i see exception on my page.
In portal-sqlserver-ds.xml i locate this code:

Code:

         <max-pool-size>200</max-pool-size>
         <min-pool-size>1</min-pool-size>
         <idle-timeout-minutes>100</idle-timeout-minutes>
but yet i see this exception:
javax.servlet.ServletException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, 
GlobalId=portalserver/4717, BranchQual=, localId=4717]
        org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:214)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
 
If you have solution for this problem please help me.
thanks