B4J Question ResultSet Freeze application with MySQL and MSSQL

Swissmade · Jun 22, 2017

Hi,
I have a app where I have a connection to a Server.
This application is making a Backup of the data in real-time.

Now the problem.
When I lose the connection to the server and the Application is busy with Backup the Resultset of the Server-connection is freeze the application.
Is there a option to fetch this as a error. This way I can handle this.
Try Catch Block is not helping the application is frozen.

I hope somebody has any idea for this.

Swissmade · Jun 24, 2017

Have Try you option KeirS but it is not working.
Last option connection Pool

Swissmade · Jun 24, 2017

Connectionpool is also not helping here.

Somehow this exception is not handle at all.

Swissmade · Jun 24, 2017

Hi all
It seems to work I have do it with the code from KeirS
Working on MSSQL and Mariadb(MySQL)

B4X:

Sub IsValidConnection(SQLConnection As SQL) As Boolean
Dim JO As JavaObject
Dim TimeoutSecs As Int = 0
JO = SQLConnection
JO = JO.GetFieldJO("connection")
Return JO.RunMethod("isValid", Array As Object (TimeoutSecs))
End Sub

Many thanks for all your help.

Swissmade · Jun 25, 2017

Problem SOLVED

After some more test I can say that this problem is not coming back for now.

B4J Question ResultSet Freeze application with MySQL and MSSQL

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Similar Threads

B4J Question ResultSet Freeze application with MySQL and MSSQL

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Swissmade

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency