fromgate / dblib Goto Github PK

more details at here

Fixed Bitte: > Caused by: com.mysql.cj.exceptions.CJCommunicationsException: The last packet successfully received from the server was 6,471,540 milliseconds ago. The last packet sent successfully to the server was 6,471,540 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

If i load my plugin with DbLib 0.1.0 as Library and load the DbExample plugin using DbLib 0.1.1 and load DbLib 0.1.0 or 0.1.1 as a Plugin, my plugin's MySQL loading will work. But if i disable DbExample, the loading on my plugin won't work. If i change the DbExample DbLib's Library version to 0.1.0, the loading won't work either. In conclusion, i need to load DbLib 0.1.0 and 0.1.1 as Library and load the DbLib plugin either to get my code below works.
Code:

Connection connect = DbLib.getMySqlConnection(
                (String) mysql.get("host"),
                (Integer) mysql.get("port"),
                (String) mysql.get("database"),
                (String) mysql.get("user"),
                (String) mysql.get("password")
        );

Also if i don't use the dual-library like that, this warning will come:

> Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The dri
ver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

I don't know why, but DBLib ignores all exception than its hard to find the reason why it doesn't connect to the database.

Any time when i close server, all from database is losted.