Devart Forums

Are the MyDAC components thread safe?

"I can´t send you a small program to reproduce that error but what can go wrong to get this error?"

I open a table, when I use fetchall:=true - I can close it without any error.
When I set fetchall:=false I get a EMySQLException "Lost connection to mysql server during query".
I can´t send you a small program to reproduce that error but what can go wrong to get this error?

No one has a solution for me?

I just implemented the code as described. When the MySQL Connection is lost (due to network problems), the program tries to reconnect whicht works fine.
Unfortunately the program opens a windows informing the user that the connection was lost.
Is it possible to suppress this error message?
"Lost connectio to MySQL server during query"

I declare the parameters like this:
Verbindung.Params.CreateParam(ftInteger, 'Lagernummer', ptOutput);
Why is the ptoutput type ignored?
Only the type of the last parameter ist set correctly...

Now I use the dbMonitor and got this result which leads to the described error when I execute the batch insert.
when the error occurs the out value is missing


this is how it looks like, when the update is successful

That is correct - but do you remember that I already found two bugs?

The problem started, when you released the speed fix for the batch updates... Any help? I get this error every single day...

This error started, when you "speed up" batch inserts. Could you provide an option to use the old (slower) version? Maybe one could use a parameter to switch between the two versions. I get the error every single day - this is very disappointing to me.
Often I get an error : commands out of sync.

Sorry - the problem still exists - today I got the error again ...

I am now using the latest update (11.0.1) the problem is gone. Magic?

What should I say? I did not change a single line of my code, but after updating from 10.4.1 to 10.4.3 I have this problem...
Ok thanks for your help.

The problems with the batch updates started when you "optimised" the code to speed up the uploads. Maybe you can have a look at this part of the code. It ssems like there are access violations in the array.

Last time I reported bugs you could not reproduce the error either. And I was the only one who had this issue. But the problem is real... I can´t help you out whith a sample app.