[wildfly-dev] WildFly call to sp_reset_connection on SQL Server 2008 R2

[Jorge Solórzano]

Hi,

I'm using Microsoft SQL Server JDBC Driver 4.2 with WildFly 10, and looking
at https://msdn.microsoft.com/en-us/library/ms378484.aspx there is a note
about connection pooling:

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.
>

*​*I
​ ​
create a trace
​ ​
and
​ ​
that sp is not executed
​ ​
when the connection is returned to the pool,
​ this should be called explicitly in my app or the Application Server
should do it?​
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/wildfly-dev/attachments/20160608/646c7812/attachment.html