Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
RE: [dtp-dev] SQLEditor not finding PlanService

Thank you for your reply.
Yes, I have a recognize method in my DBConfiguration class, but it is not hitting it. In SQLToolsFacade.getCanonicalDatabaseVendorDefinitionId,
if the configuration is not null it skips the recognize call. The call to SQLDevToolsConfigRegistryImpl.getConfigurationByVendorIdentifier finds a valid configuration since it only compares up to the smaller of the two version numbers and returns with a configuration for the non-REAL version number. And because this is not null, SQLToolsFacade.getCanonicalDatabaseVendorDefinitionId  skips the call to recognize() and eventually returns back the original vendor ID with the REAL version number.  Since getCanonical found one from the registry, shouldn't it return IT as the vendorID?
I am still getting "No suitable plan parser found for database:"
Is there something else I am missing?

From: dtp-dev-bounces@xxxxxxxxxxx [mailto:dtp-dev-bounces@xxxxxxxxxxx] On Behalf Of Hui.Cao@xxxxxxxxxx
Sent: Monday, May 21, 2007 9:12 AM
To: DTP development mailing list
Subject: Re: [dtp-dev] SQLEditor not finding PlanService

Hi Francine,
        How did you implement your configuration's "recognize(String product, String version)" method? Did it return true for the "REAL" version of your server?

Best Regards!

Max (Hui) Cao
Sybase Shanghai RD

"Grimmer, Francine" <FG120874@xxxxxxx>
Sent by: dtp-dev-bounces@xxxxxxxxxxx

2007-05-21 23:42

Please respond to
DTP development mailing list <dtp-dev@xxxxxxxxxxx>

[dtp-dev] SQLEditor not finding PlanService

I am having a problem trying to load my PlanService in DTP 1.5 M6. I have implemented the classes for the planService extension point but when it comes time to initialize the PlanService from the sqleditor.plan.BaseExplainAction class it calls the SQLToolsFacade which is trying to use the full server version id or "REAL" version to find my service.  It eventually calls the ProfileUtil.getDatabaseVendorDefinitionId which returns a DatabaseDefinitionId using the full product version (server.version) number xx.xx.xx.xx (containing major, minor, release, and build values) instead of using the 2 digit vendor version xx.xx.

It looks like there is a problem in SQLToolsFacade.getCanonicalDatabaseVendorDefinitionId that, even though it finds a Configuration that matches the simple form xx.xx, it still returns the Vendor ID with the full number. And since we do not define our services based on the full server name (which would require us to include every maintanence release of our database in the plugin.xml definition of the service), our services are not getting loaded. We have noticed this problem was introduced in DTP 1.0.

Can someone respond and confirm if this is a bug or tell me how to work around this problem?

Thank you in advance,
dtp-dev mailing list

Back to the top