i would like to ask few question here,since i try to configure this out for 1 week,i dont find any solution for my problem. T_T
I have develop my java web application in window Environment and now i have buy domain and hosting(linux) where i put my web system there.I deploy the project in WAR file and then i upload to my hosting. The problem come when my system won't be able to connect to database in pooling environment. i try follow some tutorial how to solve it.But thing still remain the same. In my laptop,everything work very well but thing doesnt go well in the real hosting. My humble request if any of you have any idea how to solve it?
here my code for connection:
and i have create connection pooling class..here the code
I have almost similar problem with you, I developed my web app in Windows environment and need to deploy it on Linux.
It has been 4 month since your post, have you solved your problem?
If not yet solved, maybe it was so late, I think you need to check your code below in context.xml in line: url="jdbc:mysql://localhost:3306/database_name?autoReconnect=true". Maybe you forgot to change "localhost:3306" with url database where you get the hosting. Make sure the username and password too.
subject: Connection Pooling problem connect with MYSQL