Checking database state

[alvaro893]

Hi, I am experimenting with this library and javarx, so far I didn't find a method to check whether Database objects are connected or not (for example: no internet connection, db server is down, etc). I guess it can handled with this observable pattern somehow.

Also, besides the README, is there any other document or guide I could use?

[thomasnield]

@alvaro893 doesn't a connection pool like HikariCP (which this library supports) abstract all of that away and take care of that stuff for you? Typically you configure the timeout and other parameters on the HikariCP end if needed, and it will even dispose dead connections and replace with new ones.

Regarding the guide, there is none yet. I may write one for this library like I did with RxJavaFX, especially since I have coworkers that need it.

https://www.gitbook.com/book/thomasnield/rxjavafx-guide/details

I'll let you know when I get around to writing it.

[alvaro893]

@thomasnield thank you for you response, I wasn't familiar with this HikariCP but I noticed that it was commented in other issues, I going to give it a shot. Very interesting book by the way, may be that I will use it in the future and It will be more than welcomed if do other for this library.

[thomasnield]

@alvaro893 for sure, anytime. Just add HikariCP as a dependency and specify the pool() as shown in the README. And I'll do my best to start the eBook on this library in the next 2-3 weeks. Shouldn't be too much work but I'd like it to be thorough.