FireDAC + EntityDAC + DataSnap
Re: FireDAC + EntityDAC + DataSnap
We have reproduced this behavior on the highest versions of RAD Studio and FireDAC. This code works on XE 5. We will investigate this behavior and let you know the results.
Re: FireDAC + EntityDAC + DataSnap
I am using Delphi XE7 Update 1
Re: FireDAC + EntityDAC + DataSnap
This behavior is due to a modification in FireDAC (starting from XE7). When setting the ConnectionDefName property first, and then - DriverName (similarly to the one specified in Connection Define), the driver name is not found in the TFDCustomConnection.SetDriverName method - and the set ConnectionDef is reset.
Code: Select all
FDConnection.ConnectionDefName := 'testMySQL';
FDConnection.DriverName := 'MySQL';// similarly to testMySQL Connection Define
ShowMessage(FDConnection.ConnectionDefName);//empty
Re: FireDAC + EntityDAC + DataSnap
Hi Alex,
thank you for the info. I've reproduced it too. So, could you fix it in the EntityDAC? Or will it stay "buggy" in the XE7?
Best regards!
thank you for the info. I've reproduced it too. So, could you fix it in the EntityDAC? Or will it stay "buggy" in the XE7?
Best regards!
Re: FireDAC + EntityDAC + DataSnap
We will try to avoid this behavior in our components, but you can also send a bugreport to embarcadero
Re: FireDAC + EntityDAC + DataSnap
Okay, thx, it would be great if you could fix it.
Last edited by elion on Tue 16 Aug 2016 16:12, edited 1 time in total.
Re: FireDAC + EntityDAC + DataSnap
In the doc of FireDAC this behaviour is as designed. Please see http://docwiki.embarcadero.com/Librarie ... DriverName
Re: FireDAC + EntityDAC + DataSnap
Hey Alex,
I don't want to be annoying... are there some news? I need this functionality ASAP. Thank you and sorry for the pressure!
Best regards!
I don't want to be annoying... are there some news? I need this functionality ASAP. Thank you and sorry for the pressure!
Best regards!
Re: FireDAC + EntityDAC + DataSnap
Currently, you can add the following changes to the EntityDAC.DataProvider.FireDAC file:
in the SetDialectName method add a check:
replace
with
then
in the SetDialectName method add a check:
replace
Code: Select all
if DialectName = UpperCase(SMySQLDialect) then
Code: Select all
if (DialectName = UpperCase(SMySQLDialect)) and (FFDConnection.DriverName <> SFDDriverMySQL)
Re: FireDAC + EntityDAC + DataSnap
Hi Alex,
it still doesn't work. Is there any release planned for this year to fix the firedac coonection pooling problem? It would be great!
Best regards!
it still doesn't work. Is there any release planned for this year to fix the firedac coonection pooling problem? It would be great!
Best regards!
Re: FireDAC + EntityDAC + DataSnap
We added the ConnectionDefName parameter in ConnectionString, now you do not have to set a dialect, it is enough to specify the ConnectionDef name.