MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

Re: MySQL Connector/J 5.1: NPE when executing SQL with QueryTimeout>0 on fabric connection
Posted by: Alex Paul
Date: July 22, 2023 11:35PM

It appears that when executing SQL with QueryTimeout settings, the getProperties() method in the FabricMySQLConnectionProxy class returns NULL, leading to a NullPointerException (NPE) when constructing the CancelTask. As a consequence, the connection availability detection using SQL with QueryTimeout, which is commonly employed in connection pools like Tomcat and Druid, might fail, potentially causing unexpected behaviors such as connection pools abandoning available connections.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL Connector/J 5.1: NPE when executing SQL with QueryTimeout>0 on fabric connection
Chengdong He
January 30, 2023 02:08AM
Re: MySQL Connector/J 5.1: NPE when executing SQL with QueryTimeout>0 on fabric connection
Filipe Silva
January 31, 2023 05:00AM
Re: MySQL Connector/J 5.1: NPE when executing SQL with QueryTimeout>0 on fabric connection
Alex Paul
July 22, 2023 11:35PM
Re: MySQL Connector/J 5.1: NPE when executing SQL with QueryTimeout>0 on fabric connection
Filipe Silva
July 24, 2023 04:13AM


Sorry, only registered users may post in this forum.
Click here to login

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.