I would like to know if its possible to write a query that could be executed against the openfire database to find out for how long a specific xmpp user has been online.
Also, i would like to know if the openfire database stores the history of the xmpp user connections?
The reason why i wanted to know the duration for which the user is online is because we encountered BoshException while trying to initiate a client connection. I wanted to know why the client was retrying to initiate a connection when it was successfully able to establish a connection earlier.
Below is the link to the error that we encountered: