Connection Pooling
Posted: Fri 25 Feb 2005 04:00
Dear All,
Environment:
Kylix3
MyDAC 3.00.1.3
Mysql 4.0.21 / RH 9
I have read about some issues regarding multi threaded applications, and the solution as I understood was to create a seperate TMyConnection in each thread. To prevent unnecessary load on the server upon connecting / disconnecting the solution then was to use Connection Pooling. Sounds great, but I just can't get it work properly. I have Pooling set to True, protocol set to mpMemory and Direct set to False. (As I understood from this forum) When issuing MyConnection.Connect an exception arise---> "EAssertionFailed, Assertion failure (/home/Ikar/projects/Dac/Source/CRConnectionPool.pas, line 276)"
Anything more I'm missing here?
Thanks in advance for Your help.
Best regards,
Eivind
Environment:
Kylix3
MyDAC 3.00.1.3
Mysql 4.0.21 / RH 9
I have read about some issues regarding multi threaded applications, and the solution as I understood was to create a seperate TMyConnection in each thread. To prevent unnecessary load on the server upon connecting / disconnecting the solution then was to use Connection Pooling. Sounds great, but I just can't get it work properly. I have Pooling set to True, protocol set to mpMemory and Direct set to False. (As I understood from this forum) When issuing MyConnection.Connect an exception arise---> "EAssertionFailed, Assertion failure (/home/Ikar/projects/Dac/Source/CRConnectionPool.pas, line 276)"
Anything more I'm missing here?
Thanks in advance for Your help.
Best regards,
Eivind