Re: Wonder FrontBasePlugIn Error?
Re: Wonder FrontBasePlugIn Error?
- Subject: Re: Wonder FrontBasePlugIn Error?
- From: John Bruce <email@hidden>
- Date: Thu, 19 Mar 2009 13:33:55 +0000
Hi Drew,
I've had this problem before I think. The problem was that the current
version of the Wonder FrontBase plugin expects your column name to be
in upper case in order to return the database type for the attribute,
otherwise it defaults to a varchar, hence the string '1'. As a work
around make sure the column name for 'externalGraphIDIn' is in upper
case and run the query again. I've posted a Jira issue about this as
well as a patch.
Hope this helps.
-John
On Wed, Mar 18, 2009 at 11:42 AM, Drew Thoeni <email@hidden> wrote:
> I downloaded the latest Wonder FrontBasePlugIn-5.0.0.9052 and the problem
> still existed.
> However, removing that and using only the frontbasejdbc.jar eliminates the
> problem.
> Is this a known bug in the Wonder FrontBasePlugIn?
> Drew
> On Mar 17, 2009, at 10:45 AM, Drew Thoeni wrote:
>
> I'm fetching a single object from Frontbase and the adapter is sending the
> binding as a string instead of an int.
> I'm using the WOnder Frontbase adapter 5.0.0.8987 and the recent build of
> WOLips (3.4.5694).
> I've confirmed the definition is correct in the EOModel and the FetchSpec
> seems correct.
> Here's the relevant code and result (note the ='1'; instead of =1;)
> I saw a similar problem on the list, and it suggested ensuring the latest
> WOnder adapter, which I think I have.
> Ideas?
> Best,
> Drew
>
> Integer aGraphID = new Integer(1);
> NSDictionary bindings = new NSDictionary( aGraphID, "externalGraphIDIn" );
> try {
> Graph g = (Graph)EOUtilities.objectWithFetchSpecificationAndBindings( ec,
> "Graph", "FetchSingleGraph", bindings);
> }
>
> Semantic error 485. Near: SELECT \"t0\".\"externalGraphID\", \"t0\".\"oid\",
> \"t0\".\"title\" FROM \"GRAPH\" AS \"t0\" WHERE
> \"t0\".\"externalGraphID\"='1';.
> _______________________________________________
> 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
>
_______________________________________________
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