chanders Posted March 18, 2018 Share Posted March 18, 2018 Greeting,When I execute sql query in a java servlet on Tomcat -- it returns a null pointer (code 500). It seem that this malfunction may be related to the recent servlet/tomcat configuration mishap that occurred on tommy. However, when this servlet is run locally (via my localhost) it works fine and successfully fetches table rows from mysql at tommy.Appreciate if you would please investigate whether any java/Jdbc connector libraries are missing, and/or suggest any workarounds to adjust to changes in configuration that I should explore. I suggest that viewing the servlet log might provide additional information -- my user account is: citisnet warm regards. Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 19, 2018 Share Posted March 19, 2018 Did it work before? Quote Link to comment Share on other sites More sharing options...
chanders Posted March 19, 2018 Author Share Posted March 19, 2018 yes! Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 19, 2018 Share Posted March 19, 2018 The only thing that changed on the server was java access and your servlet were removed, and then readded and redeployed. Did you change the servlet that you deployed? Quote Link to comment Share on other sites More sharing options...
chanders Posted March 19, 2018 Author Share Posted March 19, 2018 let's try redeploying servlet: cbook.warusername: citisnet Quote Link to comment Share on other sites More sharing options...
Krydos Posted March 20, 2018 Share Posted March 20, 2018 Have you deployed it at https://tommy.heliohost.org:2083/frontend/paper_lantern/java/index.live.php ? Quote Link to comment Share on other sites More sharing options...
chanders Posted March 21, 2018 Author Share Posted March 21, 2018 Greetings,After some analysis, I have confirmed that the reason for null pointer occurs because the jdbc connection pooling libraries are missing (or not loaded) in tomcat. This probably occurred after the crash and restore of tommy. Please check tomcat library directory for the missing connection pooling libraries and restore them. This should fix the null pointer issues for those who are using connection pooling in jdbc. please confirm this finding and restore the connection pooling library in tomcat. warm regards. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.