<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
pre
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span class=postbody><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Hello, </span></font></span><br>
<span class=postbody>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. </span><br>
<span class=postbody>In <b><span style='font-weight:bold'>portal-sqlserver-ds.xml</span></b>
i locate this code: </span><o:p></o:p></p>
<div align=center>
<table class=MsoNormalTable border=0 cellspacing=1 cellpadding=0 width="90%"
style='width:90.0%'>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'>
<p class=MsoNormal><span class=genmed><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Code:</span></font></b></span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:2.25pt 2.25pt 2.25pt 2.25pt'><pre><font size=2
face="Courier New"><span style='font-size:10.0pt'> <max-pool-size>200</max-pool-size><o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> <min-pool-size>1</min-pool-size><o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> <idle-timeout-minutes>100</idle-timeout-minutes><o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>but yet i see this exception:<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>javax.servlet.ServletException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, <o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>GlobalId=portalserver/4717, BranchQual=, localId=4717]<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:214)<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> javax.servlet.http.HttpServlet.service(HttpServlet.java:697)<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> javax.servlet.http.HttpServlet.service(HttpServlet.java:810)<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'><o:p> </o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>If you have solution for this problem please help me.<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'>thanks<o:p></o:p></span></font></pre><pre><font
size=2 face="Courier New"><span style='font-size:10.0pt'> <o:p></o:p></span></font></pre></td>
</tr>
</table>
</div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>