Re: import from an external DB
Re: import from an external DB
- Subject: Re: import from an external DB
- From: T Worman <email@hidden>
- Date: Tue, 23 Feb 2016 12:29:21 -0800
On Feb 23, 2016, at 12:21 PM, OC <email@hidden> wrote:
>
> Hello there,
>
> well, I have cleaned up the external DB model so that it loads all right. At launch, I am setting the connection dictionaries:
>
> - all my normal models get
> [URL:jdbc:FrontBase://localhost/DBA/user=USER/isolation=read_committed/locking=optimistic, password:, username:]
> - my import model gets [*]
> [URL:jdbc:FrontBase://localhost/DBTEST/user=USER/isolation=read_committed/locking=optimistic, password:, username:]
>
> Normal models work all right, no problems reported, I can see my data perfectly. The import model does not though.
>
> When about to import, my code looks like this (for start, I am not joining tables to be able to use hi-level services)
>
> ===
> def imodel=EOModelGroup.defaultGroup.modelNamed('IMPORT') // checked the result, it is the model; also imodel.connectionDictionary is [*]
> def entityName=... entity name ... // checked that model.entityNamed(entityName) returns proper entity, all right here
> def fs=new EOFetchSpecification(entityName,null,null)
> fs.fetchesRawRows=YES
> fs.rawRowKeyPaths=... list of desired attributes ... // again checked, it is all right
> def ec=new ERXEC()
> return ec.objectsWithFetchSpecification(fs)
> ===
>
> and the result of this attempt is
>
> "Unable to get the name of the class to instantiate for the adaptor framework JavaJCEBCAdaptor. The possible causes for this error are: the adaptor framework is not installed on your system, the adaptor framework is not linked into your application, or the info dictionary for this adaptor is corrupted.”
It looks like the adaptor is mis-spelled in your Properties. There’s no such thing as "JavaJCEBCAdaptor."
> Probably another of my dumb days, but what am I missing?
> - the adaptor framework is installed, after all, it works perfectly for normal models
> - it also is linked into the application, the same proof
> - the connexion dictionary of my import model differs in the database name only -- all the other stuff is same as the main model's, which works like a charm.
>
> I have even tried to use my main model instead of the import one, and (with local entity name and local attribute names) it works, as presumed. Why it does not with the import model?
>
> Will be grateful for any advice,
> OC
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden