I have installed openfire server 4.0.2 and we have developed chat application using it and we deployed to play store.
We have now more then 50k + users but we stucked with one db configuration of openfire server.
Sometime it gives error like below and we are not getting stored each message.
java.sql.SQLException: Couldn’t perform the operation prepareStatement: You can’t perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).
i am not sure how to deal with such error.
Some time it shows that active connection is more then available connection does it make any impact ?
please check above image for reference.
Could any one help me to suggest db connection properties in proper way.
Please help me we stucked with the process and we are helpless now.