Hi Maxime,

Please provide more details on the perceived problem, or test case ideally …

As development don’t see the problem indicating that basically, the 
isCriticalError() is used for checking Connection exceptions, if exception is 
critical the connection is closed and removed from pool immediatelly, but all 
other connections in the pool are checked with a "select 1” query. Thus if a 
connection was corrupted, it will not be reused from pool and will be closed 
after checking with query "select 1”.

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/ 
<http://www.openlinksw.com/>
Weblog   -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/>
LinkedIn -- http://www.linkedin.com/company/openlink-software/ 
<http://www.linkedin.com/company/openlink-software/>
Twitter  -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
Google+  -- http://plus.google.com/100570109519069333827/ 
<http://plus.google.com/100570109519069333827/>
Facebook -- http://www.facebook.com/OpenLinkSoftware 
<http://www.facebook.com/OpenLinkSoftware>
Universal Data Access, Integration, and Management Technology Providers



> On 8 Jan 2016, at 14:38, Maxime Poitevineau-Millin 
> <maxime.poitevin...@webdrone.fr <mailto:maxime.poitevin...@webdrone.fr>> 
> wrote:
> 
> Hello,
>  
> We have a problem with the virtuoso JDBC driver.
> I think there is an issue in the connection pool (in the virtuoso driver). He 
> try to reuse indefinitely a corrupt connection.
>  
> In the source code : He use an SQLstate and an ErrorCode to determine if an 
> exception is critical and need to be send to the pool to close the connection.
> isCriticalError : 
> https://github.com/openlink/virtuoso-opensource/blob/69f9b53954397f74840f7ca6fe486f9fb9d7c711/libsrc/JDBCDriverType4/virtuoso/jdbc2/VirtuosoConnection.java
>  
> <https://github.com/openlink/virtuoso-opensource/blob/69f9b53954397f74840f7ca6fe486f9fb9d7c711/libsrc/JDBCDriverType4/virtuoso/jdbc2/VirtuosoConnection.java>
>  
> Regards,
>  
> Maxime
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net 
> <mailto:Virtuoso-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users 
> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to