<div dir="ltr"><div class="gmail_default"><span style="font-family:verdana,sans-serif">Hi,<br><br></span></div><div class="gmail_default"><span style="font-family:verdana,sans-serif">I'm using Microsoft SQL Server JDBC Driver 4.2 with WildFly 10, and looking at <a href="https://msdn.microsoft.com/en-us/library/ms378484.aspx">https://msdn.microsoft.com/en-us/library/ms378484.aspx</a> there is a note about connection pooling:<br><br></span><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><span style="font-family:verdana,sans-serif">
The JDBC driver does not currently call the sp_reset_connection stored
procedure when it returns the connection to the pool. Instead, the
driver relies on third-party Java Application Servers to return the
connections back to their original states.<br clear="all"></span></blockquote></div><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><span style="font-family:verdana,sans-serif"><b><div class="gmail_default" style="display:inline"><br></div></b>I</span><div class="gmail_default" style="display:inline"><span style="font-family:verdana,sans-serif"> </span></div><span style="font-family:verdana,sans-serif">create a trace</span><div class="gmail_default" style="display:inline"><span style="font-family:verdana,sans-serif"> </span></div><span style="font-family:verdana,sans-serif">and</span><div class="gmail_default" style="display:inline"><span style="font-family:verdana,sans-serif"> </span></div><span style="font-family:verdana,sans-serif">that sp is not executed</span><div class="gmail_default" style="display:inline"><span style="font-family:verdana,sans-serif"> </span></div><span style="font-family:verdana,sans-serif">when the connection is returned to the pool,<div class="gmail_default" style="font-family:verdana,sans-serif;display:inline"> this should be called explicitly in my app or the Application Server should do it?</div></span></div></div></div></div></div></div>
</div>