#158 Connection won't restore when database going down and up again

[Mageddo]

The problem

Connection won't works

Reproduction

1. Open a new connection
2. Test a query (success)
3. Shutdown the database server(whatever)
4. Start the database server again
5. Test the same query on the same connection
6. The connection won't work

Expected

The connection reopen automatically because actually I need open a new connection and recover the last status, it takes a time and I work with hsqldb testing a framework so every time I run the application test, a new hsqldb instance is up and I need to open a new connection on orbada

[Andrzej Kałuża]

Hi,

Orbada is a universal tool. JDBC does not return clear information about the connection has been closed and the supported databases are many, and each would have to approach individually.

Have you tried in the "Connection" menu use the "Reconnect"?

Andrzej

[Mageddo]

Hey Andrzej, yes I did, not works the issue is the same. Is true that JDBC does not return a clear information, any way I had implemented a solution on this build that works for me at least .

---

By the way Andrzej in this project that I have created, I implement your project with gradle, when you run

gradle clean build

it will generate the release zip at buid/libs/. I had imported and tested it on Intellij 15

I am not sure how you build your tool but if have not a standalone build tool I will apreciate if you consider to use my suggestion

Thanks advice

Obs: is possible that My code version is not the right and that some changes that I've did not pleases you, of course you can put the source version that you want, in the structure that you want, my version is only a fork

My gradle version

------------------------------------------------------------
Gradle 2.13
------------------------------------------------------------

Build time:   2016-04-25 04:10:10 UTC
Build number: none
Revision:     3b427b1481e46232107303c90be7b05079b05b1c

Groovy:       2.4.4
Ant:          Apache Ant(TM) version 1.9.6 compiled on June 29 2015
JVM:          1.8.0_91 (Oracle Corporation 25.91-b14)
OS:           Linux 4.4.0-21-generic amd64

[Mageddo]

Update

Reconnect works on mysql but not on HSQLDB

My solution reconnect automatically(not need to click on "Connection" > "Reconnect"), tested on MySQL, PostGres, HSQLDB