MySQL - An error happened while accessing the server

Classic Servoy
1

I’m using Servoy 4.1 and a small MySQL 5.1 database
In general it works fine but I am getting an error message, then click ok and it just continue working. The error will show later.
Error Message: An error happened while accessing the server, please try again.

Using MS SQL or Oracle I do not see the error

Is there any recommendation on how to work with MySql and Servoy
I’m using the driver: mysql-connector-java-5.1.7-bin

2

Hi Javier,

What is your query validation type set to in the connection settings?
For MySQL it’s recommended to use query validation with a validation query “select 1;”

3

Hi Javier,
have a look at the HowTo I wrote about using MySQL with Servoy, you can download it from my website.

4

I downgrade from MySql 5.1 to 5.0, I can’t not use 4 views are not support on it.
The error has reduced the frequency but it is still there from time to time

Wondering if the issue is just related to MySql I decided to move the database to SQL Server 2005 and the error rarely happens but there is still there
Then I decided to use to Servoy web site and navigate around I after a while I also get the error so it seems it is not just me
Is this a know issue or do you have any advice to reduce or eliminate this of happening?
Thanks very much for any information you can provide

I’ve noticed I’m not alone with this error I am experiencing, it is happening to Servoy site too

[attachment=0]An error happened while accessing the server.JPG[/attachment]

[attachment=1]An error happened while accessing the server 2.JPG[/attachment]

An error happened while accessing the server.JPG
An error happened while accessing the server.JPG727×668 58.4 KB

An error happened while accessing the server 2.JPG
An error happened while accessing the server 2.JPG647×442 27.1 KB

5

this error seems to popup for some, i guess for some browsers. What browsers do you use when you see this? IE?
(thats what i see in the picture)

I changes the behavior a bit so that it doesnt popup a dialog anymore. But will show the error in the “loading…” label and that label will revert itself, without user action, when it can connect again.

This behavior shouldnt have anything to do with a database (driver), it is just displayed when there is an error between the client/browser and the server

6

Thanks for your feedback

How can I applied the fix you have to my installation?

Thanks again,
Javier

7

the fix will be in 4.1.2 which will be released soon.