use transaction in concurent mode for insert data in a table mysql embedded

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
claudia_vazdoaga
Posts: 5
Joined: Wed 31 Oct 2007 09:31

use transaction in concurent mode for insert data in a table mysql embedded

Post by claudia_vazdoaga » Wed 31 Oct 2007 09:58

hi,

I have 2 threads for insert data in a table mysql embedded and sometimes i have his error: Access violation at address 7C918FEA in module 'ntdll.dll'

I use to connections TMyEmbConnection for each thread

What can i do?

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 31 Oct 2007 14:44

Please specify the following information:
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of your IDE;
- exact version of MySQL Embedded server.

claudia_vazdoaga
Posts: 5
Joined: Wed 31 Oct 2007 09:31

Post by claudia_vazdoaga » Thu 01 Nov 2007 07:31

Hello,

I used MyDac version 5.20.0.11 for Dephi 7, IDE: Delphi 7
I try to run program with MySql Embedded 4.1.8-embeded and with 5.1.22.rc-embedded and with both i get the same error

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 01 Nov 2007 16:25

Thank you for information. We have reproduced the problem with access violation. The investigation of the problem is in progress. As soon as we solve the problem or we need more information, we will let you know.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 05 Nov 2007 09:58

Could you send us a small test sample to make sure that the problem you reported is completely fixed? Also include the database for your test. You can send them both to mydac*crlab*com.

claudia_vazdoaga
Posts: 5
Joined: Wed 31 Oct 2007 09:31

Post by claudia_vazdoaga » Mon 05 Nov 2007 14:59

Hi,

I'm sorry, but i can't provide any test programm becouse our data is confidential.
It would be best if you sent me the new library for me to test. I also mention that we have allready bought the component MyDAC and wold like to see this working.

Best regards.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 06 Nov 2007 14:11

We have not completed investigation of this problem yet, so we cannot provide you with the fix.
You can reproduce this problem in a small test sample and alter your confidential information with a nonsense data. You sample would help us very much.

claudia_vazdoaga
Posts: 5
Joined: Wed 31 Oct 2007 09:31

Post by claudia_vazdoaga » Tue 06 Nov 2007 15:55

Hello,

I sended a mail to you to this adderss: mydac*crlab*com

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 07 Nov 2007 16:06

We haven't received your sample yet. Please send it once again. You can also try to send it to evgeniyd*crlab*com.

claudia_vazdoaga
Posts: 5
Joined: Wed 31 Oct 2007 09:31

Post by claudia_vazdoaga » Thu 08 Nov 2007 13:49

Hello,

I send again e-mail with test programm

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 13 Nov 2007 09:23

We still did not receive your example.
Please specify, what is the size of the attachment.

pimentel_flores
Posts: 31
Joined: Wed 15 Aug 2007 16:30
Location: mexico

i have the same problem

Post by pimentel_flores » Wed 23 Jul 2008 06:08

Hi i have this problem too, did you find the solution?

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 24 Jul 2008 08:28

Please make sure that you have the latest version of MyDAC.
If this does not solve the problem, please send a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.

Also supply us the following information:
- exact version of your IDE;
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of MySQL Embedded server.

Post Reply