Re: ERPrototypes + intBoolean + INTEGER + boolean qualifier = fail
Re: ERPrototypes + intBoolean + INTEGER + boolean qualifier = fail
- Subject: Re: ERPrototypes + intBoolean + INTEGER + boolean qualifier = fail
- From: Lachlan Deck <email@hidden>
- Date: Fri, 12 Dec 2008 12:11:51 +1100
Hmm - this seems strange. Double check it's definitely valueType = c,
Class = Boolean
Possibly a frontbase adaptor issue?
On 12/12/2008, at 7:16 AM, Lists wrote:
Man, this is a struggle. You can't pass an integer to the ERXKey
involved as the types will class. It seems I'm either going to have
to bag the boolean prototype or do an in-memory qualifier.
Any thoughts?
Jon
Lists wrote:
I have a column ACTIVE defined as INTEGER in a Frontbase DB. The
model defines the attribute as:
Prototype: intBoolean
External Type: INTEGER
Data Type: Boolean - boolean c
I'm running into problems with this code:
EOQualifier qualifier = Client.ACTIVE.is(Boolean.TRUE);
Client client = Client.fetchClient(ec, qualifier);
It generates:
...WHERE ("T0"."ACTIVE"=TRUE)
Which throws:
Semantic error 217. Datatypes are not comparable or don't match.at
com
.frontbase
.jdbc.FBJErrorMetaData.errorMessageAtIndex(FBJErrorMetaData.java:
162) at
com
.frontbase
.jdbc.FBJErrorMetaData.getExceptionChain(FBJErrorMetaData.java:194)
at com.frontbase.jdbc.FBJStatement.checkMetaData(FBJStatement.java:
472) at com.frontbase.jdbc.FBJStatement.execute(FBJStatement.java:
175) at
com
.webobjects
.jdbcadaptor
.JDBCChannel
._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272) at
Clearly I could change my qualifier to use an integer value of one
but I suspect there's a way to make this work. Any help is
appreciated.
Thanks,
Jon
WO 5.4.3
WOLips 3.3.5514
Wonder 10/15/2008
Mac OS X 10.5.5
_______________________________________________
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
with regards,
--
Lachlan Deck
_______________________________________________
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